cancel
Showing results for 
Search instead for 
Did you mean: 

Issue in Creating GSTR2 Report ,Unable To Find Assessable Value Data Source and add Storage Location

shreshtha_pareek
Explorer
0 Kudos
457

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.

  1. I have added Supplier Invoice Data source, while adding Storage Location from Material Document Item data source multiple entries are generating as there is no Data Source available for Line item like Supplier Invoice Item Data Source. Please advise Is there any way to add Storage location so that Multiple entries should not generate.
  2. My client is using Custom Duty Process for which they are booking Custom Duty and GST on Assessable Value but in CDS View, I am unable to get the Assessable Value. Can you Please Suggest if any Data Source is available for Assessable value or How to add the Tax amount calculated on Assessable value. 

 

 

Thanks and Regards,

Shreshtha Pareek

Accepted Solutions (0)

Answers (1)

Answers (1)

SaschaZygar
Product and Topic Expert
Product and Topic Expert
0 Kudos

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