Skip to Content
Technical Articles
Author's profile photo Mohit Bansal
Mohit Bansal
December 11, 2020 2 minute read

S4HANA Fiori Extension Real Time Scenario – Extending Display Line Item in General Ledger

SAP S4HANA have delivered  many great Fiori Elements based applications which are much better in terms of user experience(UX), overall performance, and overall extensibility point of view when it is compared to their respective SAP GUI based Transaction Code based Reports.

Here, I would be presenting one of the especially useful and common real time scenarios to extend S4HANA based Finance Reports such as Display Line Item in General Ledger.

Display Line Items in General Ledger(F2217) which is quite similar to FBL3N Report, but the overall user experience, performance and extension features are much better.

And off coarse “Thanks to S4HANA and Fiori Element Framework” 

Here is the quick view of the application (From Fiori Library), for more information for this application, can be checked here.

 

Business Scenario

Business wants to have GL and Offset GL Description in Foreign language  available as part of the field selection. If the user wants, he/she can add it via setting option.

Here is the snapshot from the Fiori application after extension, can see the Highlighted in  Green additional added field is available.

 

Technical Explanation

Technical details of the Fiori applications can be found under Fiori app reference library or developer can just debug(F12) and found the gate way service and all.

Steps to be followed

  • Identify the SAP Standard OData Service, which is FAC_GLV_GL_ACCOUNT_LINE_ITEM_SRV in this scenario.

  • Identity the Gateway Project and underneath Consumption CDS. Which can be verified from the reference data source in Gateway Project.

  • Create Extension of the Standard CDS C_JournalEntryItemBrowser as follows.Important : Remember to use associations instead of normal joins 

  •  

    And here we go, development is done and ready for Business to testing.

    Really quite easy to extend,  Again Thanks to S4HANA and Fiori Element Framework 🙂

 

 

 

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sebastiano Marchesini
      Sebastiano Marchesini

      Hi Mohit Bansal ,

      the solutions seems really easy but it seams I can't use locally the associated CDS.
      Do you know why ?

      They are both simple:

      @AbapCatalog.sqlViewAppendName: 'ZZVENDORDESCREXT'

extend view C_JournalEntryItemBrowser with ZZVENDOR_DESCR
  association [0..1] to ZCDS_ZZVENDOR_TX as _zzvendor_tx on _zzvendor_tx.VendorCode = _Extension.zzvendor

{
   
   @EndUserText.label: 'Vendor (Custom) Descr.'
   _zzvendor_tx.Description as VendorDescription
}

       

      @AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Vendor (Custom) Descr'
@AbapCatalog.sqlViewName: 'ZCDSVZZVENDORTX'

define view ZCDS_ZZVENDOR_TX
  as select from lfa1
{
        @ObjectModel.text.element: ['Description']
  key   lifnr as VendorCode,

        @Semantics.text: true
        @EndUserText.label: 'Vendor (Custom) Descr.'
        name1 as Description

}

      ERROR:
      The association _ZZVENDOR_TX cannot be used locally in the view (see long text)

      Do you know why?

      Author's profile photo Sebastiano Marchesini
      Sebastiano Marchesini

      The filed zzvendor is an extension of the C_JournalEntryItemBrowser created by Custom Field and Logic.

      I can't use that field to extend the CDS.

      Resolved

      Author's profile photo Tulasi Deepthi Loya
      Tulasi Deepthi Loya

      Hi Sebastiano,

      I am also facing similar issue while trying to add association to the extend view. Can you please let me know how you have resolved this issue.

      My requirement is to add the Bank account name on the F2217 App. I have added a custom field for Bank Account Description using Custom Field and Logic for Business Context: Journal Entry Item. Enabled the usage of that field in Odata service FAC_GLV_GL_ACCOUNT_LINE_ITEMS_SRV and published it. It has created the CDS extend view for C_JournalEntryItemBrowser for the custom field. It is not allowing the association on the CDS extend view

      Please can you help me here how are you able to resolve it in your case.

      Thank you.

      Regards,

      Tulasi