I_CO_DIANTAXCODE

CDS View
8 Fields 4 CDS Views

DIAN Tax Code

I_CO_DIANTAXCODE is a CDS View in S/4HANA. DIAN Tax Code. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_CO_DIANFrmt1001TaxItem view inner CONSUMPTION Format 1001 - VAT Tax Item
P_CO_DIANTaxCodeForVATFormat view from CONSUMPTION Format 1005 & 1006 - DIAN Tax Code
P_CO_DIANTaxCodeForVATFormat view union_all CONSUMPTION Format 1005 & 1006 - DIAN Tax Code
P_CODIANStRpTaxCodesAndItems view inner CONSUMPTION DIAN Format 1001 Tax Codes And Tax Items

Fields (8)

KeyField CDS FieldsUsed in Views
KEY CO_DIANReportFormat CO_DIANReportFormat 3
KEY CO_DIANReportItemType CO_DIANReportItemType 3
KEY TaxCalculationProcedure TaxCalculationProcedure 2
KEY TaxCode TaxCode 2
KEY TransactionTypeDetermination TransactionTypeDetermination 2
KEY ValidityStartDate ValidityStartDate 1
CO_DIANAmountClassification CO_DIANAmountClassification 3
ValidityEndDate ValidityEndDate 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.

-- DIAN Tax Code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CO_DIANTAXCODE (
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TRANSACTIONTYPEDETERMINATION,
    VALIDITYSTARTDATE,
    CO_DIANAMOUNTCLASSIFICATION,
    VALIDITYENDDATE,
    PRIMARY KEY (CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, TAXCALCULATIONPROCEDURE, TAXCODE, TRANSACTIONTYPEDETERMINATION, VALIDITYSTARTDATE)
);

Learn More