I_TRDCLASSFCTNNMBRSCHM

CDS View

Numbering Scheme

I_TRDCLASSFCTNNMBRSCHM is a CDS View in S/4HANA. Numbering Scheme. It contains 4 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_ProductTCCVH view_entity inner CONSUMPTION Commodity Code
C_ProductTrdClassfctn view inner CONSUMPTION Product Classfication
C_ProductTrdClassfctnLglRgln view inner CONSUMPTION Product Classfication Legal Regulation
C_TranspClsfctnNmbrSchmVH view_entity from CONSUMPTION Numbering Scheme
I_CmmdtyCodeNmbrSchm view from BASIC Numbering Scheme - Commodity Code
I_CstmsTNNmbrSchmEndUseVH view inner BASIC Customs Tariff Number Numbering Schema with End Use VH
I_CstmsTrifNmbrNmbrSchm view from BASIC Numbering Scheme - Customs Tariff Number
I_CtrlClNmbrSchm view from BASIC Numbering Scheme - Control Class
I_IntrastatSrvcNmbrSchm view from BASIC Numbering Scheme - Intrastat Service Code
I_ProductTCCClassification view_entity cross COMPOSITE Classify Product with Commodity Code
I_TrdClassfctnLoclClfNrgScmVH view_entity from COMPOSITE Trade Classify for Local Classification
P_ClassifyProductForKeyDate view cross COMPOSITE
P_ReclassifyProductForKeyDate view inner COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY TrdClassfctnNmbrSchm TrdClassfctnNmbrSchm 5
_TrdClassfctnNmbrSchmText _TrdClassfctnNmbrSchmText 3
_TrdClassfctnNmbrSchmTypeText _TrdClassfctnNmbrSchmTypeText 3
TrdClassfctnNmbrSchmType TrdClassfctnNmbrSchmType 5

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.

-- Numbering Scheme
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRDCLASSFCTNNMBRSCHM (
    TRDCLASSFCTNNMBRSCHM,
    _TRDCLASSFCTNNMBRSCHMTEXT,
    _TRDCLASSFCTNNMBRSCHMTYPETEXT,
    TRDCLASSFCTNNMBRSCHMTYPE,
    PRIMARY KEY (TRDCLASSFCTNNMBRSCHM)
);