on 2024 Mar 18 5:57 AM
Hi Team,
Hope you all are doing great,
I am creating GSTR2 Report for Accounts Payable Process in SAP S4 HANA Public Cloud. It is a Compliance Report for India. Standard Report is not available so we are creating it by using CDS View app. I am facing Following Errors and unable to proceed further.
Thanks and Regards,
Shreshtha Pareek
Request clarification before answering.
Hello Shreshtha,
you're not facing technical errors, but data modelling issues/ questions.
For 1. If you use a supplier invoice object as primary data source, then it's only recommended to associate a CDS View if you can define a fitting join condition. Associating the I_MaterialDocumentItem_2 for example should be done with a join condition on material document item level. If that's not possible, you might get multiple entries in your data result set.
Please use the 'alternative search' in the app View Browser to search for the column 'StorageLocation'. Please also filter for 'Key User release state = released'. In the results you should get 171 released CDS Views with the column 'StorageLocation'. Analyse them for a possible join condition if you want to add them to your Custom CDS View. But if there is no fitting join condition, then it's not recommended to combine the views.
For 2. You can use the 'alternative search' in the app View Browser app again and search for e.g. 'Assessable Value'. I can't find a CDS View with that field name, but maybe you have an idea to search for different keywords? If there is no CDS View in standard, you might solve it with a Custom CDS View using calculations.
Please use the interactive Workflow for Analytics Key Users to approach the requirement with In-App-Extensibility: https://help.sap.com/docs/SAP_S4HANA_CLOUD/a630d57fc5004c6383e7a81efee7a8bb/be498df903ed461c8a74e803...
Even without being able to provide the perfect CDS Views, I hope that my thoughts and tips are helpful.
Best regards,
Sascha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
112 | |
9 | |
6 | |
5 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.