Query in fbl reports

[Former Member]

Hii experts, we have a gl named CENVAT (Purchase) Clearing Account.. in that document Re is processed when J1iex is done and some line items in that  are generated automatically... soo fbl reports.. specially for this a/c ... Purchase doc. is blank  for document Re... now i have changed the sort key from posting date to purchase document no..now the assignment fields comes blank or 0000 in document type re...please help to solve the issue

Regards,

Abhay

[ajaycwa1981 · Accepted solution]

Hi Abhi

We had this requirement for Auto clearing of CENVAT in F.13

PO Number was populated in CENVAT Account during MIGO and not populated during MIRO (Or vice versa)

We had to use substitution in OBBH using user exit to populate the PO Number in the "Purchase Order" field

Br. Ajay M

[Former Member · Accepted solution]

Hii Ajay sir, good morning... even mine is the same one ...i have the  conf. for autoclearing with assignment field as criteria... so if the field is blank... f.13 would not consider that doc... sooo can u tell me steps for substitution using user exit

[ajaycwa1981 · Accepted solution]

Hi Abhi

Write a substitution like this

Prerequisite:

BKPF-BUKRS = XXXX and BSEG-HKONT = 00YYYYYYYY (Ensure full 10 digit length)

Field to be substituted:

BSEG-EBELN (Using Exit ZGGBS000)

Br. Ajay M

PS: If BSEG-EBELN is not available for substitution, you need to modify the Table entry in GB01 for field EXCLUDE against BSEG-EBELN

[ajaycwa1981 · Accepted solution]

Hi

Refer the screen shot (SM30 - Table VWTYGB01)

Remove the tick against EXCLUDE field

Br. Ajay M

[Former Member · Accepted solution]

hey sir, i got the steps... i need to do in obbh right?? i know it work of abaper which i am not thats y asking u silly questions

[ajaycwa1981 · Accepted solution]

Yes Buddy, you are right!!

Br. Ajay M

[Former Member · Accepted solution]

hey sir, i removed the ticks then... it was showing a warning do make changes( sap entry)

[Former Member · Accepted solution]

hey sir,, the screen is like this.. wht should i do?

[ajaycwa1981 · Accepted solution]

Hi Abhay

Go to GGB1 > Financial Accounting and create a Substitution

Assign it to your comp code in OBBH

Br. Ajay M

[Former Member · Accepted solution]

hey sir, my abap team didnt allow to change in sm30.. they say dont do that and wen i define a substitution BSEG-HKONT - should i right any PO no.? and inBKPF-BUKRS- should i write my co. code?

[ajaycwa1981 · Accepted solution]

Hi Abhi

HKONT means GL Acount (CENVAT  account)

BUKRS means company code

Your ABAP team should maintain the GB01 entry as I explained.. That is pretty standard and everyone does that

Br. Ajay M

[Former Member · Accepted solution]

hey sir, thanksss i would try that becz the guy told u do on your own

[ajaycwa1981 · Accepted solution]

Hi Abhi

Do one thing.. Instead of BSEG-EBELN, you populate the PO Number in ZUONR field (Assignment field)

Populate the "Po Number / Item No" in the ZUONR field.. That should make your ABAPer happy

br. Ajay M

[Former Member · Accepted solution]

Hi Abhay,

Please follow the link below where I have answered this question.

http://scn.sap.com/thread/1844331

Regards,

Kavita

[Former Member · Accepted solution]

hiii kavita.. thankss for the reply.. i really appreciate it... will revert if any problem

[Former Member · Accepted solution]

HI Abhay,

I am also pasting the code here.. You can give it to your Abaper and use the exit in substitution to substitute on ZUONR field.

FORM u900.

*!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

•   PLEASE DELETE THE FIRST '*' FORM THE BEGINING OF THE FOLLOWING LINES *
•          IF THE ACCOUNTING MODULE IS INSTALLED IN YOUR SYSTEM:         *

*RM08M-EBELN

*SAPLMR1M

  FIELD-SYMBOLS  : <fs_ebeln> TYPE RM08M-EBELN .

  FIELD-SYMBOLS  : <fs_ebelp> TYPE RM08M-EBELP .

  FIELD-SYMBOLS  : <w_ebelp> TYPE ANY .

  DATA : l_fname1(50) TYPE c,

         l_fname2(30) TYPE c VALUE '(SAPLFACI)ACCIT_FI-TAXPS',

         ebelp  LIKE bseg-ebelp.

  l_fname1 = '(SAPLMR1M)RM08M-EBELN' .

  ASSIGN (l_fname1) TO  <fs_ebeln> .

  IF sy-subrc = 0 AND <fs_ebeln> IS NOT INITIAL .

      IF bseg-hkont = '0010018400'.

         l_fname2 = '(SAPLFACI)ACCIT_FI-TAXPS' .

         ASSIGN (l_fname2) TO  <w_ebelp> .

         ebelp = <w_ebelp>+2(4) * 10.

         bseg-xref1 = ebelp .

         bseg-zuonr = <fs_ebeln>.

      ELSE.

         bseg-zuonr = <fs_ebeln>.

     ENDIF.

  endif.

ENDFORM.                                                    "U900

Regards,

Kavita

Note : Chnage the GL in the code as applicable for your organization

[Former Member · Accepted solution]

hey @ Ajay Sir and @ kavita mam.. i created a substitution perquisite but at the time of substitution which exit i have select( ajay sir suggest ZGGBS000) which is not there...

[ajaycwa1981 · Accepted solution]

Hi Abhi

ZGGBS000 is the main exit.. Under that, you have forms like UXXX

Your ABAP needs to guide you here.. They should select the proper form

Br. Ajay M

[Former Member · Accepted solution]

hey sir, thanks for the reply . i will ask my abaper abt this and moreover .. when i try to assign my co-cde the sub... there is already a sub for mbs... soo its not allowing me save

[ajaycwa1981 · Accepted solution]

Hi

If it is already there, double click on it and it takes you to next screen...

Once inside, add your substitution step

Once your issue is addressed, you may close the thread

Br. Ajay M

[Former Member · Accepted solution]

hey sir, thanksss its doing just have check the substitution is working or not

[ajaycwa1981 · Accepted solution]

Hi Abhi

Could not understand... Is it working??

If yes, you may close the thread

Br. Ajay M

[Former Member · Accepted solution]

hey ajay sir, i have created a substitution and all but still i gettting blank in account assignment. provding u the screenshots of sub created

[ajaycwa1981 · Accepted solution]

Hi Abhay

Your substitution is wrong

1. Prerequisite should be

Company Code = SF01 AND (GL Account = xxxxxxx OR GL Account = YYYYYY)

2. Field substituted by - Here you must assign User exit name "Uxxx"

You should not mention BSEG-ZUONR

Br, Ajay M

[Former Member · Accepted solution]

hey ajay sir.. 1st i went to obbh .. double clicked the substitution and created that perquisite and( should i select OR) i had 2 gl where one gl has assignment is blank and another posting date which was changed to purchase order... then in substitution i selected BSEG-ZUONR and i select exit( hope i right).. selecting the exit name and saved it now...

[ajaycwa1981 · Accepted solution]

Hi

Use () for the GL Account as mentioned in my earleir reply

After that, if it does not work, ask ABAP to put a break point and check

Br. Ajay M

[Former Member · Accepted solution]

hey sir... i guess its the problem of user exit ZGGBS000 which i didnt put... can u guide me how can i do that... if then its not done... i will ask my abaper

[Former Member · Accepted solution]

hiii  Ajay Sir and Kavita Mam... i have created the substitution but still not getting the the assignment field.... i will show u my substitution and the assignment.. please guide me .. the abaper has created a exit.. but the form in which he mapped the gl.. is not coming in selection.. he copied the same as Kavita Mam suggested.. Please guide me

[Former Member · Accepted solution]

Hi Abhay,

You have mentioned 2 GL accounts in your Exit. It should be your CENVAT clearing account only. Why have you maintained 2 GL's?

This code is tried and tested. so ask ABaper to put breakpoint and check what is missing. Logic is simple, concatenate P.O. no. and item no. and populate in ZUONR field.

Regards,

Kavita

[Former Member · Accepted solution]

Hii Mam, actually the client has 2 gls. soo i have maintained 2 g/ls .. my Abaper tried the same... and put a breakpoint... i m providing u the screenshot of the same.. if i am wrong .. please help me... my abap guy is with me so he aslo asked the same

[Former Member · Accepted solution]

hiii kavita mam... one more problem he was facing was that at the time assigning form.. he was not getting the u300 which he created in ZRGGBS000