I_TRANSPORTATIONCOMMODITYCODE

CDS View
13 Fields 4 CDS Views

Transportation Commodity Code

I_TRANSPORTATIONCOMMODITYCODE is a CDS View in S/4HANA. Transportation Commodity Code. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_ProductTCCVH view_entity from CONSUMPTION Commodity Code
C_TranspCommodityCodeTextTP view_entity from CONSUMPTION Transportation Commodity Code - Text
C_TranspCommodityCodeTP view_entity from CONSUMPTION Transportation Commodity Code
C_TranspCommodityCodeVH view_entity from CONSUMPTION Transportation Commodity Code

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CommodityCode CommodityCode 4
KEY TrdClassfctnNmbrSchmCntnt TrdClassfctnNmbrSchmCntnt 3
KEY ValidityStartDate ValidityStartDate 4
_CreatedByUser _CreatedByUser 1
_Date _Date 3
_LastChangedByUser _LastChangedByUser 1
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt 3
_TrdClassfctnNmbrSchmCntntTxt _TrdClassfctnNmbrSchmCntntTxt 3
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ValidityEndDate 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.

-- Transportation Commodity Code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRANSPORTATIONCOMMODITYCODE (
    COMMODITYCODE,
    TRDCLASSFCTNNMBRSCHMCNTNT,
    VALIDITYSTARTDATE,
    _CREATEDBYUSER,
    _DATE,
    _LASTCHANGEDBYUSER,
    _TRDCLASSFCTNNMBRSCHMCNTNT,
    _TRDCLASSFCTNNMBRSCHMCNTNTTXT,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    VALIDITYENDDATE,
    PRIMARY KEY (COMMODITYCODE, TRDCLASSFCTNNMBRSCHMCNTNT, VALIDITYSTARTDATE)
);

Learn More