I_CO_DIANITEMTYPE

CDS View
4 Fields 11 CDS Views

DIAN Item Type

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

CDS Views using this table (11)

ViewTypeJoinVDMDescription
P_CO_DIANFrmt1001TaxItem view inner CONSUMPTION Format 1001 - VAT Tax Item
P_CO_DIANFrmt1001WhldgItmTpGL view_entity from CONSUMPTION Format 1001 - Whldg Itm Type to GLAcct
P_CO_DIANItemType view from CONSUMPTION DIAN Item Type
P_CO_DIANJrnlEntrInvcFinDocLog view inner CONSUMPTION DEPRECATED - DO NOT USE!
P_CO_DIANJrnlEntrWthInvcFinDoc view inner CONSUMPTION DEPRECATED - DO NOT USE!
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 1008 & 1009 - Supplier and Customer Operational View
P_CO_DIANStRpSuplrCustOpnItmLg view inner CONSUMPTION 1008 & 1009 - Suplr & Cust Open Item Log
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 ItemTypeStartDate,ValidityStartDate 2
ValidityEndDate ItemTypeEndDate,ValidityEndDate 2

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