Product Information
Need another field in “Manage Customer Line Items” or “Manage Supplier Line Items”? Data source extension could be the answer.
You can use the Manage Customer Line Items app and the Manage Supplier Line Items app for all sorts of analyses on customer or supplier line items.
That’s why many fields and columns are displayed when you open the apps. But what if you’re missing a field?
Let’s take a closer look at the Manage Customer Line Items app. The following standard columns are displayed by default.
Fig. 1: Standard columns shown in the “Manage Customer Line Items” app
And there are many other fields and columns that you can simply select from the Settings dialog box and display in the app.
Fig. 2: “View Settings” dialog box showing additional columns
But what if you need a column or field in the app that is not listed here?
Data source extension could be the answer.
To use this, your key user only has to open the Custom Fields app and choose the plus sign on the Data Source Extension tab to create a data source extension for the Customer Line Items (FAR_CUSTOMER_LINE_ITEMS_SRV) data source.
All fields available for this data source are displayed.
In the Available Fields tree, the key user simply has to navigate down to the field that you want to add to the Manage Customer Line Items app.
Fig. 3: Available fields for the “Customer Line Items” data source
Once the key user has selected the field that you want to add, the field information is shown in the Selected Fields section. Here, the key user can even change the field label and tooltip text by selecting the Custom Text checkbox and entering a text of your choice.
Fig. 4: Selected field
Once your key user has published the extension, the new field is available for all users.
Thanks for reading this blog post. I hope you’ve understood how simple it is to add a new field to the Manage Customer Line Items app.
Of course, if you want to add a field to the Manage Supplier Line Items app, your key user simply has to create an extension for the Supplier Line Items (FAP_VENDOR_LINE_ITEMS_SRV) data source.
Feel free to leave any comments you may have below.
See also:
App Extensibility: Manage Customer Line Items
Really the game changer should be like in OnPrem BADI: if_ex_fi_items_ch_data~change_items or BTE 1650 for adding custom fields calculated on the fly. Both of them (specially for perfomance the BADI) were widely used in almost all SAP projects.
Since 2208 the technology is there Edit Source Extensions-Calculated fields ( https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/d72a13f700de4b2fbd33a6e7fc562fa9.html?locale=en-US&version=2208.503 ) we only need customer and supplier line items data source to be available for adding calculated fields and therefore by free to fecth customer information through BADI.
Thanks very much for your comment. Unfortunately, we cannot provide the Calculated Fields feature for the line item apps at the moment.
But since we’re currently reworking the apps, we will try and see if we can provide this feature in the new apps.
Hi Angelika, thank you for the great blog!
Is the document header text under "Journal Entry" a new addition to the customer / supplier line item data sources?
Having a look at the same data source on my end, the only options I have under "Customer Line Items" are "customer", "Customer Company" and "One-Time Account Data for Customer Items":
Thanks.
Regards, Thomas
Hello Thomas,
Thanks for your comment.
May I ask you if you looked in an on-premise system?
The blog post refers to S/4HANA Cloud, and in S/4HANA OnPremise the document header text under Journal Entry is available as of 2021 FPS2.
For S/4HANA OnPremise 2021 FPS0 and FPS1, a SAP Note needs to be implemented.
Best regards,
Angelika
Hi Angelika, thank you for your response.
I looked at an S/4HANA OnPremise system, release 2021 (initial shipment stack).
Could you kindly reference the SAP note which needs to be implemented for this to be added?
Thank you very much once again.
Kind regards,
Thomas
Hello Thomas,
Sorry for the late reply.
Here's the link to the SAP Note 3156013.
Best regards,
Angelika
Hi Angelika,
We ended up doing a custom implementation.
But thank you very much for referencing the note for others.
Kind regards,
Thomas
Hi Angelika,
Thanks for details on custom fields for Manage customer line items Fiori App. We have similar requirement from user but for the field BKPF-XREF1_HD. User want this field to be added as new column for customer manage line items fiori app. Could you please guide on this or do we need to raise OSS.
If OSS not required, then what customizations are required if this field is not readily available in (FAR_CUSTOMER_LINE_ITEMS_SRV) data source fields. Please provide step by step solution required for this customization as I not much experienced on customizing standard fiori applications.
Thanks,
Gayatri
Hello Gayatri
To add field BKPF - XREF1_HD, please follow the path "Customer Line Items" -> "Journal Entry" and select the field "Reference 1". This field corresponds to BKPF - XREF1_HD.
Please note, that the association to "Journal Entry" which represents the document header (BKPF) is available as of S/4HANA OnPremise 2021 FPS2 and higher. For S/4HANA OnPremise 2021 FPS0 and FPS1, a SAP Note needs to be implemented. (SAP Note 3156013).
For S/4HANA Public Cloud this association is generally available.
Best regards
Steffen
Hi Steffen,
Thanks for quick reply. Hope you are doing well!!
We are still on S/4HANA On-premise 2020 and I wonder whether above solution will work for me.
Any work around or alternative for S/4HANA On-premise 2020?
Please suggest.
Thanks,
Gayatri
Hello Gayatri
S/4HANA On-Premise 2020 does not support the data source extension for "Journal Entry" fields. Unfortunately I am not aware of an alternative solution.
Best regards
Steffen Riemann
Hello @Angelika
Thank you for this instructif blog.
I have a question related to data extension.
In case, we want to add a calculated field to the column , is it possible?
Thank you
Hello Emma,
Thanks for your feedback.
At the moment, we cannot provide the Calculated Fields feature for the line item apps.
We are, however, reworking the line item apps, and will try and see if we can provide this feature in the new apps.
Best regards,
Angelika
Hello Angelika Huber,
Thanks for details on custom fields for Manage customer line items Fiori App.
Can you please suggest how to add the Supplier Bank account number and Bank name in Manage Supplier Line item through Key User Extensibility in SAP S/4 HANA Cloud - data Sources Extensions ?
How to get Data sources list for the particular app ?
Thanks in Advance.
Hello Priyanka,
Thank you very much for your feedback.
The supplier bank account data cannot be displayed in the app "Manage Supplier Line items" because there can be more than one bank account maintained for a business partner. The app "Manage Supplier Line item" displays always exact one table row per supplier line item. If a supplier respectively a business partner has two or more bank accounts, the system could not determine which of the bank accounts should be displayed.
You can however display the supplier bank accounts in the app Display Supplier List (F1861).
Please note, if a supplier has more than one bank account, then this app will display several rows for the same supplier - one fore each bank account.
Best regards
Steffen