PROD_DC_SALES

Transparent Table Application Table
54 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSALESDELIVERYWD

PROD_DC_SALES is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTSALESDELIVERYWD. It contains 54 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productsalesdeliveryd view from EXTENSION Ext view prd sald draft (PRD_sales_del)

Fields (54)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
product productnumber Product
productsalesorg vkorg Sales Org.
productdistributionchnl vtweg Distr. Channel
productforedit productnumber Product
productsalesorgforedit vkorg Sales Org.
productdistributionchnlforedit vtweg Distr. Channel
minimumorderquantity minau Min.order qty
supplyingplant dwerk_ext Deliver.Plant
pricespecificationproductgroup pricespecificationproductgroup Prd.Price Grp
accountdetnproductgroup ktgrm AcctAssmtGrpMat
deliverynoteprocmindelivqty minlf Min. Dely Qty
itemcategorygroup mtpos Item Cat. Group
deliveryquantityunit schme Unit Of Measure
deliveryquantity schrt Delivery unit
productsalesstatus vmsta Status
productsalesstatusvaliditydate vmstd Valid from
salesmeasureunit vrkme Sales Unit
ismarkedfordeletion lvovk DF DChain level
producthierarchy prodh_d Prod. Hierarchy
firstsalesspecproductgroup firstsalesspecproductgroup ProductGroup 1
secondsalesspecproductgroup secondsalesspecproductgroup ProductGroup 2
thirdsalesspecproductgroup thirdsalesspecproductgroup ProductGroup 3
fourthsalesspecproductgroup fourthsalesspecproductgroup ProductGroup 4
fifthsalesspecproductgroup fifthsalesspecproductgroup ProductGroup 5
minimummaketoorderorderqty minef MakeToOrder qty
logisticsstatisticsgroup stgma Matl stats grp
volumerebategroup bonus Vol. Rebate Grp
productcommissiongroup provg Commission Grp
cashdiscountisdeductible sktof Cash Discount
pricingreferenceproduct pmatn Pr. Ref. Matl
assortmentgrade sstuf Assortm. Grade
storelistingprocedure lstfl LP for Stores
distrcntrlistingprocedure lstvz LP distr. ctrs
storelistingstartdate storelistingstartdate Str Listed from
storelistingenddate storelistingenddate Str Listed to
distrcntrlistingstartdate distrcntrlistingstartdate DC Listed from
distrcntrlistingenddate distrcntrlistingenddate DC Listed to
storesalestartdate storesalestartdate sale from (str)
storesaleenddate storesaleenddate sale till (str)
distrcntrsalestartdate distrcntrsalestartdate sale from (DC)
distrcntrsaleenddate distrcntrsaleenddate sale till (DC)
roundingprofile rdprf Rnding Profile
productunitgroup megru UoM Group
maxdeliveryqtystoreorder maxlf Max. dely qty
pricefixingcategory pbind Price fixing
variablesalesunitisnotallowed vavme SUn not var.
competitionpressurecategory matkc Comp. charactn
prodextassortmentpriority pflks Ext. asst prio.
baseunit meins Base Unit
prodisentlmntrlvt cmd_prd_is_entlmnt_rlvt Rel. Entitlement Gen
hasactiveentity sdraft_has_active Has active

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]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More