Customer/Vendor Tax Codes in custom global reports migration into S4

[himanshugupta12]

Hello fellow members and experts,

Apologies if this question has been answered, I looked for similar posts but could not find.

My client was using ECC system and for customer/vendor tax codes using KNA1-STC* / LFA1-STC* fields to maintain tax codes in customer master.

We have some programs (reports, forms etc) which have these tax codes printed or displayed in ALV. Tax team has already done analysis and figured it out the Tax Categories (KE1, KE3, SA0 etc) which will be used by customers and vendors of different countries.

For example: Below tax codes will be by below 4 countries in S/4

KE3 (KNA1-STCD3)	Kenya: PIN number
TZ3(KNA1-STCD3)	Tanzania:Tax Identification number (TIN)
UG3 (KNA1-STCD3)	Uganda: VAT Registration Number
GH1 (KNA1-STCD1)	Ghana: Taxpayer Identification Number

But in ECC all the tax codes are maintained in STCD1 so if a custom interface which uses STCD1 to get the Tax Code and send it to 3rd Party system will stop working for Kenya, Tanzania and Uganda in S/4.

SAP standard report RFUMSV00 also uses BSEG-STCEG (which in turns gets populated from KNA1-STCEG) to print VAT number in ALV. This report will not work for below countries because these VAT numbers will not be stored in KNA1-STCEG.

CH2	Switzerland: VAT Number
DE2	Germany: VAT Number (Credit Proc. §14)
GB6	Northern Ireland Protocol: VAT Reg. No.
KE1	Kenya: VAT Registration Number
KR2	South Korea: VAT Registration Number
NO1	Norway : VAT Number

I was checking some global report to see how SAP is using tax code table DFKKBPTAXNUM to get the tax code for multiple countries customers/vendor.

Any pointers with the standard report used for multiple countries customer or any solutions will be highly appreciated.

Version of S/4 HANA is as below

Product	Release	SP / FP Stack	Description
S4HANA ON PREMISE	2022	02 (05/2023)	SAP S/4HANA 2022

Thanks and regards,

Himanshu