I_TAXCODE
Tax Code
I_TAXCODE is a CDS View in S/4HANA. Tax Code. It contains 15 fields. 40 CDS views read from this table.
CDS Views using this table (40)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CATaxCodeValueHelp | view | from | CONSUMPTION | Value Help - Tax Code |
| C_MM_TaxCodeValueHelp | view | from | CONSUMPTION | Tax Code Value Help |
| C_NO_SAFTTax | view_entity | inner | CONSUMPTION | SAF-T Norway Tax |
| C_PE_StRpJournalEntryWithTax | view | inner | CONSUMPTION | Peru journal entries with tax |
| C_PPS_PurOrderTaxCodeVH | view_entity | from | CONSUMPTION | Purchase Order Item Tax Code |
| C_PPS_PurReqnTaxCodeVH | view_entity | from | CONSUMPTION | Purchase Requisition Tax Code |
| C_StRpDocLineItemWthRefDoc | view | inner | CONSUMPTION | Tax Items with Reference Accounting Documents |
| FAC_AUDIT_Z3_TAX_CODE | view | from | Tax Code | |
| FAC_TAXCODEVH | view | from | Value help for tax code | |
| I_DigitalVehicleTaxCode | view_entity | from | BASIC | Digital Vehicle Tax Code |
| I_PPS_PurchaseContractTaxCode | view_entity | from | COMPOSITE | Purchase Contract Tax Code values |
| I_RU_TaxCodeValueHelp | view | from | BASIC | RU Tax codes |
| I_SAFTTaxRate | view_entity | inner | BASIC | SAF-T Tax Rate |
| I_SAFTVatCode | view | from | COMPOSITE | SAFT Vat Codes |
| I_StRpTaxItem | view | inner | COMPOSITE | Tax Item view for Statutory Reporting |
| I_TaxCodeStdVH | view_entity | from | COMPOSITE | Tax Code |
| I_TaxCodeValueHelp | view | from | COMPOSITE | Tax Code |
| I_TripTaxCodeVH | view | from | BASIC | Trip tax code VH |
| P_AR_TaxItem | view | inner | CONSUMPTION | |
| P_GB_ParkedTaxItems | view | left_outer | CONSUMPTION | |
| P_HR_StRpTaxItem | view_entity | inner | COMPOSITE | Croatia selection for tax reporting |
| P_HU_ReverseItem | view_entity | inner | CONSUMPTION | |
| P_MX_DueDeferredTaxItem | view | inner | COMPOSITE | |
| P_NL_SAFTVATCode | view | from | COMPOSITE | |
| P_NL_SAFTVATCode | view | union | COMPOSITE | |
| P_NO_SAFTTAXRATE | view | inner | COMPOSITE | |
| P_PE_PurDmstcSuplrTaxItem | view | inner | CONSUMPTION | |
| P_PE_PurFrgnSuplrTaxItem | view_entity | inner | CONSUMPTION | |
| P_PL_SAFTInvoiceTaxEUCode | view | inner | COMPOSITE | |
| P_PT_CAOpenItemSum | view_entity | inner | COMPOSITE | |
| P_RO_SAFTInvoiceItemCount | view | inner | CONSUMPTION | |
| P_RO_SAFTNTRPurInvItem | view_entity | inner | CONSUMPTION | |
| P_RO_SAFTNTRPURINVWIAHEADER | view_entity | inner | CONSUMPTION | |
| P_RO_SAFTNTRSlsInvItem | view_entity | inner | CONSUMPTION | |
| P_RO_SAFTNTRSLSINVWIAHEADER | view_entity | inner | CONSUMPTION | |
| P_RU_TaxCode | view | from | COMPOSITE | |
| P_SK_StRpVATCSDfrrdTaxItem | view | inner | COMPOSITE | |
| P_SlsPurListBPTaxItem | view | left_outer | CONSUMPTION | Sales Purchase List BP Tax Item |
| P_StRpTaxItmWithEUTaxClass7 | view | inner | COMPOSITE | |
| P_TH_TaxCodeRate | view | left_outer | COMPOSITE |
Fields (15)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | TargetTaxCode | TargetTaxCode,TaxCode | 7 |
| KEY | TaxCalculationProcedure | TaxCalculationProcedure | 14 |
| KEY | TaxCode | TaxCode | 10 |
| KEY | TaxType | TaxType | 17 |
| _TaxCalculationProcedure | _TaxCalculationProcedure | 2 | |
| _TaxType | _TaxType | 2 | |
| _Text | _TaxCodeText,_Text | 3 | |
| EUAcqnInputTaxCode | EUAcqnInputTaxCode | 2 | |
| EUAcqnOutputTaxCode | EUAcqnOutputTaxCode | 2 | |
| EUTaxClassification | EUTaxClassification | 4 | |
| IsSalesTaxes | IsSalesTaxes | 1 | |
| MiniOneStopShopTxRptgCntry | MiniOneStopShopTxRptgCntry | 3 | |
| TaxReturnCountry | TaxCodeReturnCountry,TaxReturnCountry | 4 | |
| TaxTolerancePercent | TaxTolerancePercent | 1 | |
| UnitedStatesTaxCategory | TaxCategory | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Tax Code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TAXCODE (
TARGETTAXCODE,
TAXCALCULATIONPROCEDURE,
TAXCODE,
TAXTYPE,
_TAXCALCULATIONPROCEDURE,
_TAXTYPE,
_TEXT,
EUACQNINPUTTAXCODE,
EUACQNOUTPUTTAXCODE,
EUTAXCLASSIFICATION,
ISSALESTAXES,
MINIONESTOPSHOPTXRPTGCNTRY,
TAXRETURNCOUNTRY,
TAXTOLERANCEPERCENT,
UNITEDSTATESTAXCATEGORY,
PRIMARY KEY (TARGETTAXCODE, TAXCALCULATIONPROCEDURE, TAXCODE, TAXTYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA