Table or CDS view for Tax Codes in S4H Public Cloud

[sivasankarans]

Hi there, I am looking for Tax (VAT or GST) specific backend CDS view in S4H Public Cloud matching below tables from SAP R3/ECC 6.0 

T007S ---> Tax Code Names

T007A ---> Tax Keys

T007C ---> Groupings for tax codes

IDCFMBRSETX_HST ---> History table for taxation

I remember we used to check the Tax Condition Record in KNVH and refer back to these tables with relevance to BSET Tax table from an Accounting Document view. 

Is there any way to obtain the corresponding CDS views for above? 

Any help is much appreciated

Regards, Sivasankaran 

[OwenLiu]

Hi Siva, Suggest you to check existing views: https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/535accb2502d43369578f56a... If no suitable one, please raise feature request. Best Regards, Owen

[sivasankarans]

Hi Owen, thanks for heads up. Yes ,I am aware of that loop, however, I tried multiple tables as suggested by Ernesto below too, nothing could be of help. I have subsequently escalated to SAP itself ,where they have asked to raise a Change Request within Public Cloud, so SAP can address the lacune here............as detailed in my issue narration. They have accepted 'it's missing in the CDS view level' so it would be a future change from SAP. Thanks for your response as well. Regards, Siva

[Ernesto_Cepeda]

Hi Sivasankaran,

For the Table “Tax Code Names” (T007S), which contains the Procedure, Tax Code and Description I suggest reviewing (at least) the following CDS Views: I_TaxCode, I_TaxCodeText and I_TaxCodeValueHelp.

For the Table “Tax Keys” (T007A), which contains the key fields Procedure, Tax Code, Tax Type, Target Tax, etc. I suggest reviewing (at least) the following CDS Views: I_TaxType and I_TaxTypeText

For the Table “Groupings for tax Codes” (T007C), which contains the key fields Account Type, Tax Category, Display Info, etc. I suggest reviewing (at least) the following CDS View: I_CustomerTaxGrouping

I was not able to find a CDS for the Table “History table for taxation” (IDCFMBRSETX_HST), which contains the key fields Company Code, Transaction, Payment Date, Tax Type, etc.

If you’re trying to find similar CDS views I suggest going to api.sap.com -> SAP S/4HANA Cloud Public Edition -> CDS Views and then search by description or field. If you have access to a Public Edition system, you can also search in the “View Browser” App.

I hope this helps.

Ernesto Cepeda

[sivasankarans]

Hi Ernesto, thanks for your inputs. Yes, I am aware of those individual tables, but as a single source of info, there isn't a precise CDS view, that SAP has realized, after my escalation as an Incident. They have subsequently accepted to take it up as a change for future improvements for CDS View update. Thanks again for your response, Regards, Siva

[sivasankarans]

Additional inputs:

I have already explored the below CDS views and find it unhelpful. 

I_TaxBalancesGrp - this is NOT accessible to me as a Key User or table view doesn't exist. 

I_TaxBaseBalancesGroup - this is accessible, but no data resides in this view. Has this been replaced already by another view? 

Any thoughts on this how to go about it, most welcome. 

Thanks, Siva