P_PRODUCTD

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 P_PRODUCTD (
    ACTIVEPRODUCT,
    ANPCODE,
    ARTICLECATEGORY,
    ASSORTMENTGRADE,
    ASSORTMENTLISTTYPE,
    BASEUNIT,
    BASEUNITSPECIFICPRODUCTHEIGHT,
    BASEUNITSPECIFICPRODUCTLENGTH,
    BASEUNITSPECIFICPRODUCTWIDTH,
    BRAND,
    COMMODITIYCODENUMBERUNIT,
    COMMODITYCODE,
    COMPARISONPRICEQUANTITY,
    COMPETITORID,
    CONSUMPTIONVALUECATEGORY,
    CONTENTUNIT,
    COUNTRYOFORIGIN,
    CREATEDBYUSER,
    CREATIONDATE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CROSSPLANTSTATUS,
    CROSSPLANTSTATUSVALIDITYDATE,
    DISTRCNTRLISTINGENDDATE,
    DISTRCNTRLISTINGPROCEDURE,
    DISTRCNTRLISTINGSTARTDATE,
    DISTRCNTRSALEENDDATE,
    DISTRCNTRSALESTARTDATE,
    DIVISION,
    EXTERNALPRODUCTGROUP,
    GOODSISSUEUNIT,
    GROSSCONTENT,
    GROSSWEIGHT,
    HASTEXTILEPARTSWTHANIMALORIGIN,
    INDUSTRYSTANDARDNAME,
    INTERNATIONALARTICLENUMBERCAT,
    ISBATCHMANAGEMENTREQUIRED,
    ITEMCATEGORYGROUP,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LOWLEVELCODE,
    MANUFACTURERPARTPROFILE,
    MATERIALVOLUME,
    NETCONTENT,
    NETWEIGHT,
    PRODNOINGENPRODINPREPACKPROD,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTHIERARCHY,
    PRODUCTISCONFIGURABLE,
    PRODUCTMANUFACTURERNUMBER,
    PRODUCTMEASUREMENTUNIT,
    PRODUCTOLDID,
    PRODUCTSEASONUSAGECATEGORY,
    PRODUCTSTANDARDID,
    PRODUCTTYPE,
    PRODUCTVALIDENDDATE,
    PRODUCTVALIDSTARTDATE,
    PURCHASEORDERQUANTITYUNIT,
    REGIONOFORIGIN,
    SERIALIDENTIFIERASSGMTPROFILE,
    SERIALNOEXPLICITNESSLEVEL,
    SERVICEAGREEMENT,
    SIZEORDIMENSIONTEXT,
    STORELISTINGENDDATE,
    STORELISTINGPROCEDURE,
    STORELISTINGSTARTDATE,
    STORESALEENDDATE,
    STORESALESTARTDATE,
    VALIDITYSTARTDATE,
    VALUATIONCLASS,
    VALUATIONMARGIN,
    VOLUMEUNIT,
    WEIGHTUNIT,
    PRIMARY KEY (ACTIVEPRODUCT)
);