Skip to Content
Product Information
Author's profile photo Angelika Huber

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.

Screenshot of the app with the following standard columns: Customer, Company Code, Clearing Status, Assignment, Journal Entry Date, Journal Entry, Journal Entry Type, Special G/L, Due Net (Symbol), Amount, (CoCode Crcy), and Clearing Journal Entry

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.

Screenshot of the View Settings dialog box showing additional columns, such as Account Group, Account Memo, Account Number, Account Type, and several more.

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.

Screenshot of Custom Fields app showing available fields for the Customer Line Items data source. The Document Header Text field is highlighted.

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.

Screenshot of Custom Fields app showing showing the selected Document Header Text field in the Selected Fields section together with the technical field name, the field path, and standard label and tooltip text.

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

App Extensibility: Manage Supplier Line Items

https://blogs.sap.com/2019/02/05/key-user-extensibility-in-sap-s4hana-cloud-data-source-extensions-part-2/

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Víctor Álvarez
      Víctor Álvarez

      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.

       

      Author's profile photo Angelika Huber
      Angelika Huber
      Blog Post Author

      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.

      Author's profile photo Thomas van Vuuren
      Thomas van Vuuren

      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

       

      Author's profile photo Angelika Huber
      Angelika Huber
      Blog Post Author

      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

       

      Author's profile photo Thomas van Vuuren
      Thomas van Vuuren

      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

      Author's profile photo Angelika Huber
      Angelika Huber
      Blog Post Author

      Hello Thomas,

      Sorry for the late reply.
      Here's the link to the SAP Note 3156013.

      Best regards,
      Angelika

      Author's profile photo Thomas van Vuuren
      Thomas van Vuuren

      Hi Angelika,

      We ended up doing a custom implementation.

      But thank you very much for referencing the note for others.

      Kind regards,

      Thomas

      Author's profile photo gaytri pardeshi
      gaytri pardeshi

      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

      Author's profile photo Steffen Riemann
      Steffen Riemann

      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

      Author's profile photo gaytri pardeshi
      gaytri pardeshi

      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

       

      Author's profile photo Steffen Riemann
      Steffen Riemann

      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

      Author's profile photo Emma BEJI
      Emma BEJI

      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

       

       

      Author's profile photo Angelika Huber
      Angelika Huber
      Blog Post Author

      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

      Author's profile photo Priyanka Avhad
      Priyanka Avhad

      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.

      Author's profile photo Steffen Riemann
      Steffen Riemann

      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