I_CO_DIANITEMTYPE

CDS View
4 Fields 10 CDS Views

DIAN Item Type

I_CO_DIANITEMTYPE is a CDS View in S/4HANA. DIAN Item Type. It contains 4 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_CO_DIANFrmt1001TaxItem view inner CONSUMPTION Format 1001 - VAT Tax Item
P_CO_DIANItemType view from CONSUMPTION
P_CO_DIANJrnlEntrInvcFinDocLog view inner CONSUMPTION
P_CO_DIANJrnlEntrWthInvcFinDoc view inner CONSUMPTION
P_CO_DIANStRpAggrgCreditor view inner CONSUMPTION Union Creditors for Colombia DIAN
P_CO_DIANStRpAggrgFormat1001 view inner CONSUMPTION Format 1001 - Acctg and Payroll Items
P_CO_DIANStRpSuplrCustOplVw view inner CONSUMPTION
P_CO_DIANStRpSuplrCustOpnItmLg view inner CONSUMPTION
P_CO_DIANStRpWhldgTaxItem view inner CONSUMPTION Withholding Tax Item for Colombia DIAN
P_CODIANStRpTaxCodesAndItems view inner CONSUMPTION DIAN Format 1001 Tax Codes And Tax Items

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CO_DIANReportFormat CO_DIANReportFormat 3
KEY CO_DIANReportItemType CO_DIANReportItemType 3
KEY ValidityStartDate ValidityStartDate 1
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 Item Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CO_DIANITEMTYPE (
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    VALIDITYSTARTDATE,
    VALIDITYENDDATE,
    PRIMARY KEY (CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, VALIDITYSTARTDATE)
);

Learn More