SAP Knowledge Base Article - Public

3296143 - Customer and Supplier names in App Display line items in General ledger.

Symptom

Customer has to add the following fields in the App Display Line items in General Ledgers.

  • Header text.
  • Customer name.
  • Supplier name.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP S/4HANA Cloud.

Cause

The customer field has the (customer number + customer name), for customer column in the display the "ID (Text)" format is used as a standard. 

This new feature in SAP UI5 is intended.

Resolution

In the App  Display line items in general ledger the fields Customer and Supplier can be included as column fields. Let's take an example for customer field as it is similar for the Supplier field as well.

If you need to split these attributes to separate columns in the exported file, you can select "Export As..." option and check the "Split cells with multiple values" option before export.

 

Additionaly there is another field Name of customer and Name of supplier that you can include as a column.

 

Further if you want to display the customer / supplier full name as a column option in the Line items report then you can extend it similarly to Header text field as given in the note.
https://launchpad.support.sap.com/#/notes/3133392 

Please, see the App Extensibility help.sap document https://help.sap.com/docs/SAP_S4HANA_CLOUD/0fa84c9d9c634132b7c4abb9ffdd8f06/15ee31fac4be4e6497a76abe449fe49c.html?locale=en-US

 

Following steps are on extending the Customer full name field.

  1. Create data source extension by clicking the create button (+).
  2. From the dropdown choose the data source  Display Line Items in general ledger (FAC_GLV_GL_ACCOUNT_LINE_ITEMS_SRV ).
  3. Provide the description for your data source extension.
  4. Press create button.
  5. In the data source extension go to Field Selection tab.
  6. Press search button to search for the Field Customer Name/Supplier Name.
  7. Select the first option (Similarly for both customer name and supplier name).
  8. Check your field selection. You can provide a custom label or custom tooltip by selecting the Customer Text check box on the filed selection screen.
  9. Publish your data source extension.

 

Similarly, use the Supplier field or extend the Supplier full name field.

Keywords

customer ,supplier, name, data, source, extension, custom, fields, and, logic, F2217, "Split cells with multiple values", SAP UI5 , KBA , FI-FIO-GL-IS , Reporting Apps , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions