PROD_PROC

Transparent Table Application Table
20 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTPROCUREMENTWD

PROD_PROC is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTPROCUREMENTWD. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productprocurementd view from EXTENSION Extension draft view-product procurement

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
product matnr Material
purchaseorderquantityunit bstme Order Unit
varblpurordunitstatus vabme Var. Order Unit
purchasingacknprofile ekwsl Purch.value key
procurementrule bwvor Procure. rule
sourceofsupplycategory bwscl Supply source
purchasinggroup ekgrp Purch. Group
authorizationgroup begru AuthorizGroup
storelistingenddate storelistingenddate Str Listed to
distrcntrlistingenddate distrcntrlistingenddate DC Listed to
storelistingstartdate storelistingstartdate Str Listed from
distrcntrlistingstartdate distrcntrlistingstartdate DC Listed from
storelistingprocedure lstfl LP for Stores
distrcntrlistingprocedure lstvz LP distr. ctrs
assortmentgrade sstuf Assortm. Grade
prodextassortmentpriority pflks Ext. asst prio.
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_PRODUCTPROCUREMENTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_PROC (
    MANDT,                      -- Client [mandt]
    DRAFTUUID,                  -- Key [/bobf/uuid]
    PARENTDRAFTUUID,            -- Key [/bobf/uuid]
    PRODUCT,                    -- Material [matnr]
    PURCHASEORDERQUANTITYUNIT,  -- Order Unit [bstme]
    VARBLPURORDUNITSTATUS,      -- Var. Order Unit [vabme]
    PURCHASINGACKNPROFILE,      -- Purch.value key [ekwsl]
    PROCUREMENTRULE,            -- Procure. rule [bwvor]
    SOURCEOFSUPPLYCATEGORY,     -- Supply source [bwscl]
    PURCHASINGGROUP,            -- Purch. Group [ekgrp]
    AUTHORIZATIONGROUP,         -- AuthorizGroup [begru]
    STORELISTINGENDDATE,        -- Str Listed to [storelistingenddate]
    DISTRCNTRLISTINGENDDATE,    -- DC Listed to [distrcntrlistingenddate]
    STORELISTINGSTARTDATE,      -- Str Listed from [storelistingstartdate]
    DISTRCNTRLISTINGSTARTDATE,  -- DC Listed from [distrcntrlistingstartdate]
    STORELISTINGPROCEDURE,      -- LP for Stores [lstfl]
    DISTRCNTRLISTINGPROCEDURE,  -- LP distr. ctrs [lstvz]
    ASSORTMENTGRADE,            -- Assortm. Grade [sstuf]
    PRODEXTASSORTMENTPRIORITY,  -- Ext. asst prio. [pflks]
    HASACTIVEENTITY,            -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More