/SCDL/DB_PROCI_P

Transparent Table Application Table
40 Fields 1 CDS Views

Production Material Request Item

/SCDL/DB_PROCI_P is an SAP database table in S/4HANA. Production Material Request Item. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWM_ProdnMatlReqItem view_entity from BASIC Production Material Request Item

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY docid /SCDL/DL_DOCID Document ID
KEY itemid /SCDL/DL_ITEMID Item ID
doccat /SCDL/DL_DOCCAT Doc. Category
docno /SCDL/DL_DOCNO_INT Document Number
itemno /SCDL/DL_ITEMNO Item Number
itemuuid /SCDL/DL_ITEMUUID Item UUID
itemcat /SCDL/DL_ITEMCAT Item Category
itemtype /SCDL/DL_ITEMTYPE Item Type
cretst /SCDL/DL_CRETST Created On
creusr /SCDL/DL_CREUSR Created By
chgtst /SCDL/DL_CHGTST Changed On
chgusr /SCDL/DL_CHGUSR Changed By
chgversion /SCDL/DL_VERSION Version
manual /SCDL/DL_MANUAL Manually
productid /SCDL/DL_PRODUCTID Product ID
productno /SCDL/DL_PRODUCTNO Product
batchno /SCDL/DL_BATCHNO Batch Number
productno_ext /SCDL/DL_PRODUCTNO_EXT Ext. Product
productent /SCDL/DL_PROD_ENTERED Product Entered
qty /SCDL/DL_QUANTITY Quantity
uom /SCDL/DL_UOM Unit of Measure
stock_usage /SCDL/DL_STOCK_USAGE Usage
stock_category /SCDL/DL_STOCK_CATEGORY Stock Type
stock_owner /SCDL/DL_STOCK_OWNER Owner
stock_owner_role /SCDL/DL_STOCK_OWNER_ROLE Owner Role
stock_cat_ind /SCDL/DL_INDICATOR Determin. Ind.
stock_rel /SCDL/DL_WH_STOCK_RELEVANCE Whse Stock Relevance
status_gi /SCDL/DL_STATUS_VALUE Status Value
status_compl /SCDL/DL_STATUS_VALUE Status Value
refdocno_mo /SCDL/DL_REFDOCNO Reference Doc.
sap DUMMY Dummy function in length 1
batchno_ind /SCDL/DL_INDICATOR Determin. Ind.
entitled /SCWM/DE_ENTITLED Disposal Party
entitled_role /SCWM/DE_ENTITLED_ROLE Partner Role
stock_doccat /SCWM/DE_STOCK_DOCCAT Type
stock_docno /SCWM/DE_STOCK_DOCNO Stk Ref. Doc.
stock_itmno /SCWM/DE_STOCK_ITMNO Ref. Doc. Itm
req_seg_long /SCWM/REQ_SEG_LONG Reqmt Segment
stk_seg_long /SCWM/STK_SEG_LONG Stock Segment

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.

-- Production Material Request Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCDL/DB_PROCI_P (
    MANDT,             -- Client [MANDT]
    DOCID,             -- Document ID [/SCDL/DL_DOCID]
    ITEMID,            -- Item ID [/SCDL/DL_ITEMID]
    DOCCAT,            -- Doc. Category [/SCDL/DL_DOCCAT]
    DOCNO,             -- Document Number [/SCDL/DL_DOCNO_INT]
    ITEMNO,            -- Item Number [/SCDL/DL_ITEMNO]
    ITEMUUID,          -- Item UUID [/SCDL/DL_ITEMUUID]
    ITEMCAT,           -- Item Category [/SCDL/DL_ITEMCAT]
    ITEMTYPE,          -- Item Type [/SCDL/DL_ITEMTYPE]
    CRETST,            -- Created On [/SCDL/DL_CRETST]
    CREUSR,            -- Created By [/SCDL/DL_CREUSR]
    CHGTST,            -- Changed On [/SCDL/DL_CHGTST]
    CHGUSR,            -- Changed By [/SCDL/DL_CHGUSR]
    CHGVERSION,        -- Version [/SCDL/DL_VERSION]
    MANUAL,            -- Manually [/SCDL/DL_MANUAL]
    PRODUCTID,         -- Product ID [/SCDL/DL_PRODUCTID]
    PRODUCTNO,         -- Product [/SCDL/DL_PRODUCTNO]
    BATCHNO,           -- Batch Number [/SCDL/DL_BATCHNO]
    PRODUCTNO_EXT,     -- Ext. Product [/SCDL/DL_PRODUCTNO_EXT]
    PRODUCTENT,        -- Product Entered [/SCDL/DL_PROD_ENTERED]
    QTY,               -- Quantity [/SCDL/DL_QUANTITY]
    UOM,               -- Unit of Measure [/SCDL/DL_UOM]
    STOCK_USAGE,       -- Usage [/SCDL/DL_STOCK_USAGE]
    STOCK_CATEGORY,    -- Stock Type [/SCDL/DL_STOCK_CATEGORY]
    STOCK_OWNER,       -- Owner [/SCDL/DL_STOCK_OWNER]
    STOCK_OWNER_ROLE,  -- Owner Role [/SCDL/DL_STOCK_OWNER_ROLE]
    STOCK_CAT_IND,     -- Determin. Ind. [/SCDL/DL_INDICATOR]
    STOCK_REL,         -- Whse Stock Relevance [/SCDL/DL_WH_STOCK_RELEVANCE]
    STATUS_GI,         -- Status Value [/SCDL/DL_STATUS_VALUE]
    STATUS_COMPL,      -- Status Value [/SCDL/DL_STATUS_VALUE]
    REFDOCNO_MO,       -- Reference Doc. [/SCDL/DL_REFDOCNO]
    SAP,               -- Dummy function in length 1 [DUMMY]
    BATCHNO_IND,       -- Determin. Ind. [/SCDL/DL_INDICATOR]
    ENTITLED,          -- Disposal Party [/SCWM/DE_ENTITLED]
    ENTITLED_ROLE,     -- Partner Role [/SCWM/DE_ENTITLED_ROLE]
    STOCK_DOCCAT,      -- Type [/SCWM/DE_STOCK_DOCCAT]
    STOCK_DOCNO,       -- Stk Ref. Doc. [/SCWM/DE_STOCK_DOCNO]
    STOCK_ITMNO,       -- Ref. Doc. Itm [/SCWM/DE_STOCK_ITMNO]
    REQ_SEG_LONG,      -- Reqmt Segment [/SCWM/REQ_SEG_LONG]
    STK_SEG_LONG,      -- Stock Segment [/SCWM/STK_SEG_LONG]
    PRIMARY KEY (MANDT, DOCID, ITEMID)
);

Learn More