S4HANA PUBLIC CLOUD EDITION - CDS_VIEW FOR TAX RATE INFORMATION NOT FOUND

[Guillermo_Rodriguez]

Good Morning,

We are trying to get in S4HANA PUBLIC EDITION  tax rate amount in cds views but we are not able to get the proper one. Neither in other blogs , community and post around.

Best regards,

Guillermo

[Jerry_Lowery]

Hi Guillermo - what tax information do you need? for the Sales Order? (its probably in the pricing conditions) for Purchase Orders? Please clarify your question and someone could probably help you on here. Thank you, Jerry

[Jerry_Lowery]

Hi Guillermo,

Have you already reviewed all the CDS Views on the Business Accelerator Hub?

https://api.sap.com/products/SAPS4HANACloud/onstackextensibility/cdsviews

There are 183 there just filtering on Tax.

Perhaps I_PurOrdPricingElementAPI01?

https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/48e1ef6b2bde46a99a373981...

Or maybe I_CsgnmtAndSTOTxPrpslTaxItem

https://help.sap.com/docs/SAP_S4HANA_CLOUD/c0c54048d35849128be8e872df5bea6d/dc11c8f553f44fa4a1900b5f...

Thank you
Jerry

[Guillermo_Rodriguez]

Thank you Jerry. Unfortunately these apps do not show data. Seems I_CsgnmtAndSTOTxPrpslTaxItem requires consignment or stock transfer orders and I_PurOrdPricingElementAPI01 retrieves the pricing element fields of a purchase order. Nevermind, I am strongly confused about it. How can we search cds view based on this field KBETR?? Such as tricky way to find something that other SAP versions was quite easy 😞 BR! Guillermo

[Jerry_Lowery]

Hi Guillermo,

In the View Browser, if you go to the advanced search you can search for tables or columns.

I did a quick search - there are views but they are not released - meaning they are not exposed except for internal application use.

If you have the Abap developer tools installed, you could check there for options in Developer Extensibility, assuming you have a 3SL system.

You don't mention your use case if it is side by side or On Stack. (or in app or BADI)

Have you looked at the available public apis? https://api.sap.com/products/SAPS4HANACloud/apis/all

Or maybe one of the available on stack business objects

Maybe Pricing Access helps: https://api.sap.com/cdsviews/I_PRICINGACCESS?

Thank you

Jerry

Thank you

Jerry

[Guillermo_Rodriguez]

Hi Jerry!

Thank for your answer. We are trying to get tax rate (percentage) in order to apply it in vendor invoice (MM)

BR,

Guilllermo

[Guillermo_Rodriguez]

.