I_TRDCLASSFCTNNMBR

CDS View

Number

I_TRDCLASSFCTNNMBR is a CDS View in S/4HANA. Number. It contains 4 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_IntrastatServiceCodeFKeyDate view from CONSUMPTION Intrastat Service Code for Key Date
I_CommodityCode view from COMPOSITE Commodity Code
I_ControlClass view from COMPOSITE Control Class
I_CustomsTariffNumber view from COMPOSITE Customs Tariff Number
I_IntrastatServiceCode view from COMPOSITE Intrastat Service Code
I_TransportationCommodityCode view_entity from BASIC Transportation Commodity Code

Fields (4)

KeyField CDS FieldsUsed in Views
KEY TrdClassfctnNmbr IntrastatServiceCode 1
KEY TrdClassfctnNmbrSchmCntnt TrdClassfctnNmbrSchmCntnt 6
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRDCLASSFCTNNMBR (
    TRDCLASSFCTNNMBR,
    TRDCLASSFCTNNMBRSCHMCNTNT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (TRDCLASSFCTNNMBR, TRDCLASSFCTNNMBRSCHMCNTNT)
);