PROD_SALES

Transparent Table Application Table
42 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTSALESWD

PROD_SALES is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTSALESWD. It contains 42 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 (42)

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
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_prd_incl_eew_ps PRD_INCL_EEW Dummy Field
serviceduration CRMT_PR_DURATION Work Duration
servicedurationunit CRMT_PR_DURATION_UOM Unit
serviceprofile SRV_SERWI Service Profile
responseprofile SRV_ESCAL Response Prof.
cabillgcycle CYCLE_KK Billing Cycle
subscrpnprodbillgcycdetn CRM_ISX_CYCLE_RULE Billing Cycle Determ
subscrpnprodtechrsceschema CRMT_TC_SCHEMA Assignment Schema
contractautorenewaltype CRMS4_SOM_CTR_AUTORENEWAL Ctr. Auto Renew Ind.

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]
    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_PRD_INCL_EEW_PS,          -- Dummy Field [PRD_INCL_EEW]
    SERVICEDURATION,                -- Work Duration [CRMT_PR_DURATION]
    SERVICEDURATIONUNIT,            -- Unit [CRMT_PR_DURATION_UOM]
    SERVICEPROFILE,                 -- Service Profile [SRV_SERWI]
    RESPONSEPROFILE,                -- Response Prof. [SRV_ESCAL]
    CABILLGCYCLE,                   -- Billing Cycle [CYCLE_KK]
    SUBSCRPNPRODBILLGCYCDETN,       -- Billing Cycle Determ [CRM_ISX_CYCLE_RULE]
    SUBSCRPNPRODTECHRSCESCHEMA,     -- Assignment Schema [CRMT_TC_SCHEMA]
    CONTRACTAUTORENEWALTYPE,        -- Ctr. Auto Renew Ind. [CRMS4_SOM_CTR_AUTORENEWAL]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More