_COMMODITYCODE

13 Fields

_COMMODITYCODE is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CommodityCode CommodityCode 1
KEY Country Country 1
KEY ValidityStartDate ValidityStartDate 1
_CustomsUnitOfMeasure _CustomsUnitOfMeasure 1
_SecondCustomsUnitOfMeasure _SecondCustomsUnitOfMeasure 1
_SecondSupplementaryUnit _SecondSupplementaryUnit 1
_SupplementaryUnit _SupplementaryUnit 1
CustomsUnitOfMeasure CustomsUnitOfMeasure 1
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure 1
SecondSupplementaryUnit SecondSupplementaryUnit 1
SupplementaryUnit SupplementaryUnit 1
UnitOfMeasureSystem UnitOfMeasureSystem 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _COMMODITYCODE (
    COMMODITYCODE,
    COUNTRY,
    VALIDITYSTARTDATE,
    _CUSTOMSUNITOFMEASURE,
    _SECONDCUSTOMSUNITOFMEASURE,
    _SECONDSUPPLEMENTARYUNIT,
    _SUPPLEMENTARYUNIT,
    CUSTOMSUNITOFMEASURE,
    SECONDCUSTOMSUNITOFMEASURE,
    SECONDSUPPLEMENTARYUNIT,
    SUPPLEMENTARYUNIT,
    UNITOFMEASURESYSTEM,
    VALIDITYENDDATE,
    PRIMARY KEY (COMMODITYCODE, COUNTRY, VALIDITYSTARTDATE)
);

Learn More