2797772 - S/4HC: How to access Business Partner Tax Number via CDS views

How to access Business Partner Tax Number via CDS views.

 SAP S/4HANA Cloud Public Edition

The BP Tax Number field stores the value in table DFKKBPTAXNUM. CDS View I_BUSINESSPARTNERTAXNUMBER fetches data from table DFKKBPTAXNUM.

CDS Views I_CUSTOMER and I_SUPPLIER can also be used to get the tax numbers. These CDS views provide fields TaxNumber1, 2, ..., 5 which are filled with the values inserted in tax categories. There is also a field in these CDS Views for VATRegistration.

The steps to maintain tax numbers with Tax Categories in App Maintain Business Partner are as follows:

1. Go to App Maintain Business Partner.
2. Create or Open an existing BP in Business Partner (Gen.) role.
3. Go to Identification Tab.
4. Go to section Tax Numbers to maintain tax categories and its correspondng tax number.
   
   

Note: If the Tax Number maintained is for a country which is different than the BP country maintained, then KNA1 and LFA1 tables would not store tax numbers. Hence, in such scenarios, CDS Views I_CUSTOMER and I_SUPPLIER would return blank values.

[Enter your See Also here...]

SAP S/4HANA Cloud Public Edition, S4_PC, KNA1-STCEG, KNA1-STCD1, KNA1-STCD2, KNA1-STCD5, tax, number, VAT, BP, maintain, manage, business, partner, customer, vendor, supplier, LO-MD-BP, AP-MD-BP, CDS, views, I_BUSINESSPARTNERTAXNUMBER, business partner , KBA , LO-MD-BP , Business Partners , How To

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions