_MATERIAL

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 _MATERIAL (
    COSTESTIMATE,
    MATERIAL,
    MATERIALBASEUNIT,
    PROCESSCATEGORY,
    PRODUCT,
    _BASEUNIT,
    _MATERIALGROUP,
    _MATERIALTYPE,
    _WEIGHTUNIT,
    ACCOUNTINGDOCUMENT,
    AUTHORIZATIONGROUP,
    BASEUNIT,
    COMPANYCODE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CROSSPLANTSTATUS,
    CURRENCY,
    FISCALYEAR,
    INVENTORYAMTINCCCRCY,
    INVENTORYVALUATIONTYPE,
    ISBATCHMANAGEMENTREQUIRED,
    LEDGERGLLINEITEM,
    LEDGERVALUATIONCURRENCYROLE,
    MATERIAL_TYPE,
    MATERIALAUTHORIZATIONGROUP,
    MATERIALCONSUMPTIONQTY,
    MATERIALCONSUMPTIONVALUE,
    MATERIALGROSSWEIGHT,
    MATERIALGROUP,
    MATERIALISBATCHMANAGED,
    MATERIALMANUFACTURERNUMBER,
    MATERIALMANUFACTURERPARTNUMBER,
    MATERIALNAME,
    MATERIALNETWEIGHT,
    MATERIALPROCUREMENTTYPE,
    MATERIALTYPE,
    MATERIALTYPENAME,
    MATERIALVALUATIONCLASS,
    MATERIALWEIGHTUNIT,
    PACKAGINGMATERIALTYPE,
    PLANT,
    PLANTNAME,
    PRODCHARC1INTERNALNUMBER,
    PRODCHARC2INTERNALNUMBER,
    PRODCHARC3INTERNALNUMBER,
    PRODUCTCATEGORY,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTEXTERNALID,
    PRODUCTGROUP,
    PRODUCTGROUPAUTHORIZATIONGROUP,
    PRODUCTHIERARCHY,
    PRODUCTTYPE,
    PRODUCTTYPEAUTHORIZATIONGROUP,
    PROFITCENTER,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SOURCECOMPANYCODE,
    SOURCELEDGER,
    SUPPLIER,
    TIMESTAMP,
    VALUATIONAREA,
    VALUATIONQUANTITY,
    VALUATIONQUANTITYUNIT,
    WBSELEMENT,
    PRIMARY KEY (COSTESTIMATE, MATERIAL, MATERIALBASEUNIT, PROCESSCATEGORY, PRODUCT)
);