Copy line item text (SGTXT) from RE document into FI ZP during F110 via Substitution

[Former Member]

Hello All,

Can you please help on this below requirement

Requirement : What ever item text is existed in the vendor invoice document MIRO (RE) and in vendor line item and the same item text needs to copied to payment document (ZP) generated by F110 - Automatic Payment Run under vendor line item (posting key 25)

Process flow : PO created manually and MIRO posted manually -> payment making through F110 (Without GR).

To achieve the above, we have created substitution rule with following:

Prerequisite:

BKPF- T CODE = 'F110' AND BKPF-BLART='ZP'

Substitution Rule (by substituting BSEG-SGTXT using User Exit, module pool ZCOX0001) with following user exit code:

Select BSEG-SGTXT

From BSIK
Where BUKRS = BSEG-BUKRS
AND LIFNR=BSEG-LIFNR
AND GJHAR=BSEG-GJHAR
AND BELNR=BSEG-BELNR
AND HKONT=BSEG-HKONT

However the program is unable to fetch the correct invoice text against the respective payment document. We have a one to one payment document creation for each invoice document. The substitution is picking up item text of any one invoice item and populating it against all the payment documents. Hence we are unable to identify the invoice document number during the payment run so that we can isolate the same and write the exit accordingly.

Need your help to:

- How to debug the payment run program? This is to identify the invoice document number field during payment run (for ex: BSIK-BELNR?).

- Is there any standard exit point/enhancement point in the F110 payment run where we can write our code?

- Any way to correct the above substitution logic to meet the requirement?

Please help.

Regards

[周建华]

http://saptechnical.com/Tutorials/ExitsBADIs/F110/Index.htm

[former_member182371]

Hi,

if you search for it in the forum you will find threads like this:

Update BSEG-SGTXT at F110 thru user exit.

Best regards,

Pablo

[Former Member]

Hi Pablo,

Thanks for your reply... 🙂

Let me check with BTE 00001120.

In suggested Link there are two sap notes i.e. 3652 & 3967 which are not existed because A sap note consist of minimum 6 digits but provided notes are 4 digits consisted.

Can you please provide us what are those note number.

Much appreciated quick response.

Thanks.

Bodu.

[former_member182371]

Hi,

maybe...

regarding "identify the invoice document number during the payment run" ...you could try something with field-symbols, e.g.

DATA: y_reguh(40) VALUE '(SAPF110S)REGUP-BELNR'.

DATA: y_regup(40) VALUE '(SAPF110S)REGUP-GJAHR'.

FIELD-SYMBOLS <bel> LIKE ausz1-belnr.
FIELD-SYMBOLS <gjahr> LIKE ausz1-gjahr.

IF bkpf-blart = 'ZP'.
 ASSIGN (y_reguh) TO <bel>.
  ASSIGN (y_regup) TO <gjahr>.
ENDIF.

Read this OSS Note too:

386896 - Substitution at call-up point 3 ("Complete document")

Best regards,

Pablo