PRD_SALES

Transparent Table Application Table
19 Fields 1 CDS Views

Product: Draft Sales Node

PRD_SALES is an SAP database table in S/4HANA. Product: Draft Sales Node. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProductSalesD view from BASIC

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftkey /BOBF/CONF_KEY NodeID
parentdraftkey /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
activeproduct PRODUCTNUMBER Product
salesstatus SALESSTATUS CrossDChainStat
salesstatusvaliditydate SALESSTATUSVALIDITYDATE Cross-Distr. Chain Product Validity
taxclassification TAXCLASSIFICATION Tax class.
transportationgroup TRANSPORTATIONGROUP Trans. Group
allowedpackagingweightqty ALLOWEDPACKAGINGWEIGHTQTY Allowed pkg wt
allowedpackagingweightqtyunit ALLOWEDPACKAGINGWEIGHTQTYUNIT Allowed Packaging Unit of Weight
allowedpackagingvolumeqty ALLOWEDPACKAGINGVOLUMEQTY Allowed volume
allowedpackagingvolumeqtyunit ALLOWEDPACKAGINGVOLUMEQTYUNIT Allowed Packaging Unit of Volume
pricingreferenceproduct PRICINGREFERENCEPRODUCT X-distr.-chain PRM
variantspricingprofile VARIANTSPRICINGPROFILE Pricing Profile
isvariantpriceallowed ISVARIANTPRICEALLOWED Var. Price Allowed
salesunit SALESUNIT Sales Unit
loadinggroup LOADINGGROUP Loading Group
dummy_prd_incl_eew_ps PRD_INCL_EEW Dummy Field

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.

-- Product: Draft Sales Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_SALES (
    CLIENT,                         -- Client [MANDT]
    DRAFTKEY,                       -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTKEY,                 -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,                -- TRUE [BOOLE_D]
    ACTIVEPRODUCT,                  -- Product [PRODUCTNUMBER]
    SALESSTATUS,                    -- CrossDChainStat [SALESSTATUS]
    SALESSTATUSVALIDITYDATE,        -- Cross-Distr. Chain Product Validity [SALESSTATUSVALIDITYDATE]
    TAXCLASSIFICATION,              -- Tax class. [TAXCLASSIFICATION]
    TRANSPORTATIONGROUP,            -- Trans. Group [TRANSPORTATIONGROUP]
    ALLOWEDPACKAGINGWEIGHTQTY,      -- Allowed pkg wt [ALLOWEDPACKAGINGWEIGHTQTY]
    ALLOWEDPACKAGINGWEIGHTQTYUNIT,  -- Allowed Packaging Unit of Weight [ALLOWEDPACKAGINGWEIGHTQTYUNIT]
    ALLOWEDPACKAGINGVOLUMEQTY,      -- Allowed volume [ALLOWEDPACKAGINGVOLUMEQTY]
    ALLOWEDPACKAGINGVOLUMEQTYUNIT,  -- Allowed Packaging Unit of Volume [ALLOWEDPACKAGINGVOLUMEQTYUNIT]
    PRICINGREFERENCEPRODUCT,        -- X-distr.-chain PRM [PRICINGREFERENCEPRODUCT]
    VARIANTSPRICINGPROFILE,         -- Pricing Profile [VARIANTSPRICINGPROFILE]
    ISVARIANTPRICEALLOWED,          -- Var. Price Allowed [ISVARIANTPRICEALLOWED]
    SALESUNIT,                      -- Sales Unit [SALESUNIT]
    LOADINGGROUP,                   -- Loading Group [LOADINGGROUP]
    DUMMY_PRD_INCL_EEW_PS,          -- Dummy Field [PRD_INCL_EEW]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);

Learn More