PROD_DC_SALES

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.

-- I_PRODUCTWD I_PRODUCTSALESDELIVERYWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_DC_SALES (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                 -- Key [/BOBF/UUID]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    PRODUCTSALESORG,                 -- Sales Org. [VKORG]
    PRODUCTDISTRIBUTIONCHNL,         -- Distr. Channel [VTWEG]
    PRODUCTFOREDIT,                  -- Product [PRODUCTNUMBER]
    PRODUCTSALESORGFOREDIT,          -- Sales Org. [VKORG]
    PRODUCTDISTRIBUTIONCHNLFOREDIT,  -- Distr. Channel [VTWEG]
    MINIMUMORDERQUANTITY,            -- Min.order qty [MINAU]
    SUPPLYINGPLANT,                  -- Deliver.Plant [DWERK_EXT]
    PRICESPECIFICATIONPRODUCTGROUP,  -- Prd.Price Grp [PRICESPECIFICATIONPRODUCTGROUP]
    ACCOUNTDETNPRODUCTGROUP,         -- AcctAssmtGrpMat [KTGRM]
    DELIVERYNOTEPROCMINDELIVQTY,     -- Min. Dely Qty [MINLF]
    ITEMCATEGORYGROUP,               -- Item Cat. Group [MTPOS]
    DELIVERYQUANTITYUNIT,            -- Unit Of Measure [SCHME]
    DELIVERYQUANTITY,                -- Delivery unit [SCHRT]
    PRODUCTSALESSTATUS,              -- Status [VMSTA]
    PRODUCTSALESSTATUSVALIDITYDATE,  -- Valid from [VMSTD]
    SALESMEASUREUNIT,                -- Sales Unit [VRKME]
    ISMARKEDFORDELETION,             -- DF DChain level [LVOVK]
    PRODUCTHIERARCHY,                -- Prod. Hierarchy [PRODH_D]
    FIRSTSALESSPECPRODUCTGROUP,      -- ProductGroup 1 [FIRSTSALESSPECPRODUCTGROUP]
    SECONDSALESSPECPRODUCTGROUP,     -- ProductGroup 2 [SECONDSALESSPECPRODUCTGROUP]
    THIRDSALESSPECPRODUCTGROUP,      -- ProductGroup 3 [THIRDSALESSPECPRODUCTGROUP]
    FOURTHSALESSPECPRODUCTGROUP,     -- ProductGroup 4 [FOURTHSALESSPECPRODUCTGROUP]
    FIFTHSALESSPECPRODUCTGROUP,      -- ProductGroup 5 [FIFTHSALESSPECPRODUCTGROUP]
    MINIMUMMAKETOORDERORDERQTY,      -- MakeToOrder qty [MINEF]
    LOGISTICSSTATISTICSGROUP,        -- Matl stats grp [STGMA]
    VOLUMEREBATEGROUP,               -- Vol. Rebate Grp [BONUS]
    PRODUCTCOMMISSIONGROUP,          -- Commission Grp [PROVG]
    CASHDISCOUNTISDEDUCTIBLE,        -- Cash Discount [SKTOF]
    PRICINGREFERENCEPRODUCT,         -- Pr. Ref. Matl [PMATN]
    ASSORTMENTGRADE,                 -- Assortm. Grade [SSTUF]
    STORELISTINGPROCEDURE,           -- LP for Stores [LSTFL]
    DISTRCNTRLISTINGPROCEDURE,       -- LP distr. ctrs [LSTVZ]
    STORELISTINGSTARTDATE,           -- Str Listed from [STORELISTINGSTARTDATE]
    STORELISTINGENDDATE,             -- Str Listed to [STORELISTINGENDDATE]
    DISTRCNTRLISTINGSTARTDATE,       -- DC Listed from [DISTRCNTRLISTINGSTARTDATE]
    DISTRCNTRLISTINGENDDATE,         -- DC Listed to [DISTRCNTRLISTINGENDDATE]
    STORESALESTARTDATE,              -- sale from (str) [STORESALESTARTDATE]
    STORESALEENDDATE,                -- sale till (str) [STORESALEENDDATE]
    DISTRCNTRSALESTARTDATE,          -- sale from (DC) [DISTRCNTRSALESTARTDATE]
    DISTRCNTRSALEENDDATE,            -- sale till (DC) [DISTRCNTRSALEENDDATE]
    ROUNDINGPROFILE,                 -- Rnding Profile [RDPRF]
    PRODUCTUNITGROUP,                -- UoM Group [MEGRU]
    MAXDELIVERYQTYSTOREORDER,        -- Max. dely qty [MAXLF]
    PRICEFIXINGCATEGORY,             -- Price fixing [PBIND]
    VARIABLESALESUNITISNOTALLOWED,   -- SUn not var. [VAVME]
    COMPETITIONPRESSURECATEGORY,     -- Comp. charactn [MATKC]
    PRODEXTASSORTMENTPRIORITY,       -- Ext. asst prio. [PFLKS]
    BASEUNIT,                        -- Base Unit [MEINS]
    PRODISENTLMNTRLVT,               -- Rel. Entitlement Gen [CMD_PRD_IS_ENTLMNT_RLVT]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_SALD_INCL_EEW_PS,          -- MD Product Sales Delivery [SALD_INCL_EEW]
    SUBSCRPNCONTRDFLTDURATION,       -- Def Contract Term [CRMS4_SOM_CTR_DUR_DEF]
    SUBSCRPNCONTRALTVDURATION1,      -- Contract Term 1 [CRMS4_SOM_CTR_DUR_1]
    SUBSCRPNCONTRALTVDURATION2,      -- Contract Term 2 [CRMS4_SOM_CTR_DUR_2]
    SUBSCRPNCONTRDURATIONUNIT,       -- Unit Contract Term [CRMS4_SOM_CTR_TERM_UNIT]
    SUBSCRPNCONTRDFLTEXTNDURN,       -- Def Extension Period [CRMS4_SOM_CTR_TRM_EXT_DEF]
    SUBSCRPNCONTRALTVEXTNDURN1,      -- Extension Period 1 [CRMS4_SOM_CTR_TRM_EXT_1]
    SUBSCRPNCONTRALTVEXTNDURN2,      -- Extension Period 2 [CRMS4_SOM_CTR_TRM_EXT_2]
    SUBSCRPNCONTREXTNDURNUNIT,       -- Unit for Extension [CRMS4_SOM_EXT_PERIOD_UNIT]
    LSTMIPRODUCTPACKAGETYPE,         -- Package Type [LMD_MDE_PACKAGE_TYPE]
    LSTMIPRODUCTPACKAGESIZECODE,     -- Package Size [LMD_MDE_PACKAGE_SIZE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);