S4HANA Fiori Extension Real Time Scenario – Extending Display Line Item in General Ledger
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 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 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 🙂
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:
The association _ZZVENDOR_TX cannot be used locally in the view (see long text)
Do you know why?
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.
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.