Substitution XBLNR to ZUONR

[former_member190906]

Hi All,

Need your urgent help in below. i have written below substitution to update the GL field of ZUONR.

BKPF-BUKRS = '1000' AND BSEG-KOART = 'K' AND

BKPF-BLART = 'ZP' AND BSEG-HKONT = '220511'

Assignment             Field             BKPF-XBLNR

Do not why substitution is not working please help.

Please help.

[former_member206852]

Dear Avinash

You are changing field XBLNR with Z Tcode in the document "change" mode (FB02), which will work but substitution to field ZUONR will not work in this case, as OBBH is called at the time of "Posting" a document and not when document is changed.

Its better you modify your Z program to include the updation of both ZBLNR and ZUONR fields.

Best Regards

Abbas

[nico_dewaele]

Abbas,

not true, substitution is also called in FB02.

kr

Nico

[former_member206852]

Dear Nico

I am not talking about User exit or enhancement based substitution (which is as good as adding user exit or substitution without OBBH and which works. What does not work in FB02 is validation based substitution (following the substitution only when Pre-Requisites are met).

Hope it clears now.

Thanks

Abbas

[iklovski]

As Nico said, this is incorrect: FB02 calls substitution, without any difference whether it was made as user-exit or as 'simple' one. Of course, substitution will be called, subject to all relevant assumptions. E.g. if it's defined on line level and what is modified is the header only, it won't be called.

[iklovski]

Try putting leading zeros in HKONT, e.g. '0000220511'. If still doesn't work, put a trace in the substitution in OBBH.

[former_member190906]

Thanks so much Eli,

Substation is working fine at the time of payment entry, but when i am trying to updated the filed with Z transaction code, basically i ma updating or changing XBLENR field of header with  UTR No which i received once payment get transferred to vendor account, Z program successfully updating XBLENR at header level but same  XBLENR is not getting substituted in ZUONR of bank GL, what i want to achieve form substation.

Please help what i am missing in configuration.

Thanks for your kind help in advance.

[iklovski]

Hi,

Your Z-program, whatever it is, might simply not call substitution. Substitution is called only within standard process of document creation.

Regards,

Eli

[former_member190906]

Hi,

We are updating BDC recorded transaction code of FB02.

Please help.

[iklovski]

Why won't you integrate this change in the program itself? But, once more, put a trace on substitution and see why it's not called, if you perform FB02 in front-end.

[former_member206852]

Dear Avinash

There is no need for writing substitution. What you can do is for your BSEG-HKONT = '220511', just fix the sort key as correctly mentioned by Ankur Chauhan .

For your help, you can refer below screen on how to add field 'Reference' onto the list of sort keys;

Hope this helps you.

Best Regards

Abbas

[former_member190906]

Hi Sir,

My requirement is to update last 13 digit of XBLNR  in bank GL assignment field from document header. if i will do it from short field because all digit will be updated, my purposes can not be achieved. Since i am not able to do it from standard OBBH, if i will achieve from OBBH, will ask apaper to write substation in exit for same filed and pick last 13 digit only.

Will attache same exit in substation.

Kindly help.

[former_member206852]

Dear Avinash

You can pick 13 digits also with the sort key option. In my screenshot below you can see that system picks last 13 char out of total 16 char allowed.

Hope this helps you.

Best Regards

Abbas

[former_member206852]

Dear Avinash

Do let me know if this answer helped you and please mark the answer as helpful.

Regards

Abbas

[former_member190906]

Sir,

Thant will not suffice my purposes.

[nico_dewaele]

Hi,

do you want it to be shown on the vendor line or on the GL account line? these are 2 different things.

check tables BSIK and BSEG

the sort key should work. either on GL account or vendor depending on where you used that sort key.

kr

Nico

[former_member206852]

Dear Avinash

Can you explain by diagram what is your exact requirement?

As of now what I can understand and the option that I gave you will suffice your 100% requirement.

Regards

Abbas

[former_member198650]

Hi Avinash,

What is your requirement? Please explain clearly.

Regards,

Mukthar

[former_member190906]

Hi Sir,

My requirement is to update last 13 digit of XBLNR  in bank GL assignment field from document header. if i will do it from short field because all digit will be updated, my purposes can not be achieved. Since i am not able to do it from standard OBBH, if i will achieve from OBBH, will ask apaper to write substation in exit for same filed and pick last 13 digit only.

Will attache same exit in substation.

[ankurch]

Hi ,

Avinash if I'm understanding your requirement correctly, You need to change the sort key in GL to make changes in GL documents.

Go to FS00 & change as per below screen shot -

Please check & revert back!!

Thanks

Ankur Chauhan