Technical Articles
How to export custom fields in the Payment List Form
Description
One Business Add-In (BAdI) FINS_PAYMENT_LIST_PRINT_ITEM (Payment List Output Item Adaption) is available for adding custom fields to payment list forms.
Goal
The goal of this post is to describe the step-by -step process of how to export the custom field and logic in the payment list form, Based on the best practice experience, it will be explained for you with an example:
• Export Invoice item text into a payment list form
Possible business scenarios/processes:
You use the enhancement spot (Business Add-In BAdI):
- Finance: Payment List
Note: To be able to access this app and follow the described process, your user must be assigned a role that has the authorization as defined in the business catalog Extensibility (SAP_CORE_BC_EXT), or you could use the user Administrator.
The content of the document is the following:
- Prerequisite
- Create Custom Field
- Maintain Form Template
- Upload Form Template
- Assign Form Template
- Output Parameter Determination (BRF+)
- Testing
Prerequisite
The business process and preliminary steps to configure the payment list are described in the accounts payable scope item (J60).
- 5.3 BRF + Settings for Payment Advice (Similar steps, Payment List part will be included into the CE2105 version)
- 2 Invoice Entry without Purchase Order
- 6 Payment Run
- See also
Adding Custom Fields to Payment List Forms – SAP Help Portal
Configuring the Output of Payment Proposal Lists and Payment Lists
Create Custom Field
- Open the APP: Custom Fields from the extensibility business group on your launchpad
- In the Custom Fields tab
- Choose +(Create) to add and create a new header field
- Fill out the dialog box as explained in the following table and then choose Create.
Field Explanation Business Context Finance: Payment List Item Label InvoiceItemText Identifier YY1_ITEM_TXT Tooltip Invoice_Item_Text Type Text - Enable the field usage in the Form Templates
Create Custom Logic
- Switch to the Custom Logic tab
- Choose + (Create) to add and create new enhancement implementation for the Header filed
- Fill out the dialog box as explained in the following table and then choose Create.* Note: There is only 1 Implementation can be created, the new custom fields should be adopted in the existing logic
Field Explanation Business Context Finance: Payment List Item BAdI Description Payment List Output Item Adoption Implementation Description Payment List Extension Implementation ID YY1_PAYMENTLISTEXTENSION - To get the invoice Item text you must implement the following logic.
- Choose Save Draft in the bottom-right corner.
Choose Publish in the bottom-right corner to activate your new logic.
Maintain Form Template
- Open the app Maintain Form Templates, switch to the tap ‘Pre-delivered Templates’, search the “FIN_FO_PAYM_LIST_V2”
- Download the payment list form and it will be extracted as the ZIP file Note: Please choose “SOMU_FORM_MASTER_A4” from drop-down list and make sure the checkbox “Download without Form Template Master” is NOT selected
- Install the software ‘Adobe LiveCycle Designer’ into your laptop, and open the downloaded form “FIN_FO_PAYM_LIST_V2_E.xdp”
- Find out your custom field from the ‘Data View’ structure
Items PaymentNode
Add the custom field ‘InvoiceItemText’(YY1_INV_ITEM_TXT_PLI) into the form and binding the dataNote: As the form is filled by current fields, so it is recommended to replace an existed field rather than adding a new column
- Save the changes and open the app Maintain Form Templates to upload your own customized form
- Click + to create a form template
Input explanationForm Template Name [Your customized form template] Language Choose the supported language Select Form Template File Select the customized form adopted in previous step Data Source FDP_FFO_PAYM_LIST_SRV Form Type Content Assign Form Template
- Login as Administrator
- In APP: Output Parameter Determination, choose “Payment List” and “Form Template” from the drop-down list, fill your customized form template ID
Testing
- Login as AP_ACCOUNTANT
- Create invoice by APP: Create Incoming Invoice with Item Text “*TEST item1”
Note: The “*” is must have, otherwise the text cannot be displayed in the payment list form - Create and schedule payment proposal by APP: Manage Automatic Payments
- Preview the payment list form by APP: Revise Payment Proposal
-
Choose the Export to PDF icon above the Payments table.
- [Check]: Item text “*TEST item1” is in the form.
- Schedule payment run and review the payment list form by APP: Manage Automatic Payments
- [Check]: Item text “*TEST item1” is in the form.
- To view a payment list in the Manage Automatic Payments app, proceed as follows:
- Switch to the Payments Processed tab.
- Search for the payment that you want to view.
- Open the payment from the search result.
- Switch to the PAYMENTS tab.
- Choose the Export to PDF icon above the Payments table.