PROD_SALES

Transparent Table Application Table
28 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSALESWD

PROD_SALES is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTSALESWD. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productsalesd view from EXTENSION Extension draft view-product sales

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
product matnr Material
salesstatus mstav X-DChain status
salesstatusvaliditydate salesstatusvaliditydate Cross-Distr. Chain Product Validity
taxclassification taklv Tax class.
transportationgroup tragr Trans. Group
allowedpackagingweightqty ergew Allowed Pkg wt
allowedpackagingweightqtyunit allowedpackagingweightqtyunit Allowed Packaging Unit of Weight
allowedpackagingvolumeqty ervol Allowed Volume
allowedpackagingvolumeqtyunit allowedpackagingvolumeqtyunit Allowed Packaging Unit of Volume
pricingreferenceproduct pmatn Pr. Ref. Matl
variantspricingprofile sprof Pricing profile
isvariantpriceallowed wpm_allow_pmat_igno_mat Var. Price Allowed
loadinggroup ladgr Loading Group
authorizationgroup begru AuthorizGroup
excessweighttolerance excessweighttolerance Excess Weight Tolerance
excessvolumetolerance excessvolumetolerance Excess Volume Tolerance
stackingfactor stfak Stacking factor
isclosedpackagingmaterial kzgvh Closed
volumemaximumlevel fuelg Maximum level
packagingmaterialtype packagingmaterialtype Packaging Material Type
storesaleenddate storesaleenddate sale till (str)
distrcntrsaleenddate distrcntrsaleenddate sale till (DC)
storesalestartdate storesalestartdate sale from (str)
distrcntrsalestartdate distrcntrsalestartdate sale from (DC)
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_PRODUCTSALESWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_SALES (
    MANDT,                          -- Client [mandt]
    DRAFTUUID,                      -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                -- Key [/bobf/uuid]
    PRODUCT,                        -- Material [matnr]
    SALESSTATUS,                    -- X-DChain status [mstav]
    SALESSTATUSVALIDITYDATE,        -- Cross-Distr. Chain Product Validity [salesstatusvaliditydate]
    TAXCLASSIFICATION,              -- Tax class. [taklv]
    TRANSPORTATIONGROUP,            -- Trans. Group [tragr]
    ALLOWEDPACKAGINGWEIGHTQTY,      -- Allowed Pkg wt [ergew]
    ALLOWEDPACKAGINGWEIGHTQTYUNIT,  -- Allowed Packaging Unit of Weight [allowedpackagingweightqtyunit]
    ALLOWEDPACKAGINGVOLUMEQTY,      -- Allowed Volume [ervol]
    ALLOWEDPACKAGINGVOLUMEQTYUNIT,  -- Allowed Packaging Unit of Volume [allowedpackagingvolumeqtyunit]
    PRICINGREFERENCEPRODUCT,        -- Pr. Ref. Matl [pmatn]
    VARIANTSPRICINGPROFILE,         -- Pricing profile [sprof]
    ISVARIANTPRICEALLOWED,          -- Var. Price Allowed [wpm_allow_pmat_igno_mat]
    LOADINGGROUP,                   -- Loading Group [ladgr]
    AUTHORIZATIONGROUP,             -- AuthorizGroup [begru]
    EXCESSWEIGHTTOLERANCE,          -- Excess Weight Tolerance [excessweighttolerance]
    EXCESSVOLUMETOLERANCE,          -- Excess Volume Tolerance [excessvolumetolerance]
    STACKINGFACTOR,                 -- Stacking factor [stfak]
    ISCLOSEDPACKAGINGMATERIAL,      -- Closed [kzgvh]
    VOLUMEMAXIMUMLEVEL,             -- Maximum level [fuelg]
    PACKAGINGMATERIALTYPE,          -- Packaging Material Type [packagingmaterialtype]
    STORESALEENDDATE,               -- sale till (str) [storesaleenddate]
    DISTRCNTRSALEENDDATE,           -- sale till (DC) [distrcntrsaleenddate]
    STORESALESTARTDATE,             -- sale from (str) [storesalestartdate]
    DISTRCNTRSALESTARTDATE,         -- sale from (DC) [distrcntrsalestartdate]
    HASACTIVEENTITY,                -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More