PRODUCT

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 PRODUCT (
    BUSINESSPARTNER,
    CHANGENUMBER,
    PLANT,
    PRODUCT,
    PRODUCTDISTRIBUTIONCHNL,
    PRODUCTSALESORG,
    VALUATIONAREA,
    VALUATIONTYPE,
    _CHANGEMASTER,
    _CROSSPLANTCONFIGURABLEPRODUCT,
    _PRODUCT,
    _PRODUCTCATEGORY,
    _PRODUCTGROUP,
    _PRODUCTGROUP_2,
    _PRODUCTTYPE,
    _TEXT,
    ALTERNATIVEUNIT,
    AUTHORIZATIONGROUP,
    BASEUNIT,
    BRGEW,
    CHANGENUMBERVALIDFROMDATE,
    CONVERSIONFACTOR,
    CROSSPLANTCONFIGURABLEPRODUCT,
    DIVISION,
    EXTERNALPRODUCTGROUP,
    GEWEI,
    II_QUANTITY_EMO,
    II_UNIT_EMO,
    INDUSTRYSECTOR,
    LOADINGGROUP,
    MATERIALREVISIONLEVEL,
    MATERIALTYPE,
    MATKL,
    MATNR,
    MATNR_EXTERNAL,
    MEASUREUNIT,
    MEINS,
    MRPRESPONSIBLE,
    MRPTYPE,
    MTART,
    NTGEW,
    OBJMGMTRECDOBJECTINTERNALID,
    PLANTCATEGORY,
    PRODUCTCATEGORY,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTEXTERNALID,
    PRODUCTGROUP,
    PRODUCTHIERARCHY,
    PRODUCTNAME,
    PRODUCTSTANDARDID,
    PRODUCTTYPE,
    PRODUCTUUID,
    PURCHASINGGROUP,
    QUANTITYDENOMINATOR,
    QUANTITYNUMERATOR,
    RO_SAFTGOODSSERVICE,
    SOURCEUNITOFMEASUREFACTOR,
    TRDCLASSFCTNNMBRSCHMCNTNT,
    TRDCLASSFCTNREMARK,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VALUATIONCLASS,
    VOLEH,
    VOLUM,
    WEIGHTUNIT,
    PRIMARY KEY (BUSINESSPARTNER, CHANGENUMBER, PLANT, PRODUCT, PRODUCTDISTRIBUTIONCHNL, PRODUCTSALESORG, VALUATIONAREA, VALUATIONTYPE)
);