Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 17, 2017 at 10:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded