SAP table SAFT_PT_TAX_DATA (Tax Details for SAFT-PT)
SAP table SAFT_PT_TAX_DATA has 6 primary key fields being MANDT,TAXTYPE,TAXCOUNTRYREGION,TAXCODE,TAX_CODE_OFFICIA,TAXEXPIRATIONDAT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| TAXTYPE | Tax Type | CHAR | 3 | 0 | DESC_TAX_TYPE | ||
| TAXCOUNTRYREGION | Country/Region | CHAR | 5 | 0 | TAXCOUN_REG | ||
| TAXCODE | Tax on sales/purchases code | CHAR | 2 | 0 | MWSKZ | ||
| TAX_CODE_OFFICIA | Official Tax Code | CHAR | 10 | 0 | FIPT_OFF_TAXCODE | ||
| TAXEXPIRATIONDAT | Tax Expiry Date | DATS | 8 | 0 | TAXEXPDATE | ||
| DESCRIPTION | Text, 255 Characters | CHAR | 255 | 0 | TEXT255 | ||
| TAXPERCENTAGE | Rate (condition amount or percentage) | CHAR | 31 | 0 | TXW_KBETR | ||
| TAXAMOUNT | Tax Amount in Local Currency | CURR | 23 | 2 | MWSTS | ||
| TAXEXEMPTIONREAS | Tax Exemption Reason | CHAR | 60 | 0 | EXEMPTREASON | ||
| TAXCURRENCY | Currency Key | CUKY | 5 | 0 | WAERS | ||
| TAXEXEMPTIONCODE | SAFT : Reason Code of Tax Exemption | CHAR | 3 | 0 | FIEU_TAX_EXEMP_CODE | ||
| NON_REVENUE_BASED | SAFT: Tax Code is NOT Revenue Based | CHAR | 1 | 0 | FIEU_TAX_NOT_REVENUE_BASED |