MPPRSRCITM_D

Transparent Table Temporary Data
31 Fields 1 CDS Views

Generated draft table for core CDS view: I_MPPurchasingSourc

MPPRSRCITM_D is an SAP database table in S/4HANA. Generated draft table for core CDS view: I_MPPurchasingSourc. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_MPPurchasingSourceItemDraft view from EXTENSION Extension View for Draft Table on Source List Item View

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sourcelistrecorddraftuuid /bobf/uuid Key
activematerial matnr Material
activeplant ewerk Plant
activesourcelistrecord dzeord Number
creationdate erdat Created On
createdbyusername ernam Created By
validitystartdate ordab Valid From
validityenddate ordbi Valid to
supplier elifn Supplier
supplierisfixed flifn Fixed Supplier
purchaseoutlineagreement evrtn Agreement
purchaseoutlineagreementitem evrtp Item
puroutlineagreementisfixed febel Fixed Agmt Item
supplyingplant bewrk Proc. Plant
issgplantisfixed fresw Fixed iss.plant
manufacturermaterial ematn MPN: Material
sourceofsupplyisblocked ordsp Blocked
sourceofsupplyisfixed flag Indicator
sourceliststatus sl_status Source List Status(Fixed/Blocked)
purchasingorganization ekorg Purchasing Org.
purchasingdocumentcategory bstyp Doc. Category
sourcelistrecordcategory eortp Control
mrpsourcingcontrol autet MRP
mrparea abap.char
orderquantityunit bstme Order Unit
originsystem logsystem Logical System
inventoryspecialstocktype sobkz Special Stock
sourcelistrecord dzeord Number
sourcelistdraftuuid /bobf/uuid Key
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.

-- Generated draft table for core CDS view: I_MPPurchasingSourc
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPPRSRCITM_D (
    MANDT,                         -- Client [mandt]
    SOURCELISTRECORDDRAFTUUID,     -- Key [/bobf/uuid]
    ACTIVEMATERIAL,                -- Material [matnr]
    ACTIVEPLANT,                   -- Plant [ewerk]
    ACTIVESOURCELISTRECORD,        -- Number [dzeord]
    CREATIONDATE,                  -- Created On [erdat]
    CREATEDBYUSERNAME,             -- Created By [ernam]
    VALIDITYSTARTDATE,             -- Valid From [ordab]
    VALIDITYENDDATE,               -- Valid to [ordbi]
    SUPPLIER,                      -- Supplier [elifn]
    SUPPLIERISFIXED,               -- Fixed Supplier [flifn]
    PURCHASEOUTLINEAGREEMENT,      -- Agreement [evrtn]
    PURCHASEOUTLINEAGREEMENTITEM,  -- Item [evrtp]
    PUROUTLINEAGREEMENTISFIXED,    -- Fixed Agmt Item [febel]
    SUPPLYINGPLANT,                -- Proc. Plant [bewrk]
    ISSGPLANTISFIXED,              -- Fixed iss.plant [fresw]
    MANUFACTURERMATERIAL,          -- MPN: Material [ematn]
    SOURCEOFSUPPLYISBLOCKED,       -- Blocked [ordsp]
    SOURCEOFSUPPLYISFIXED,         -- Indicator [flag]
    SOURCELISTSTATUS,              -- Source List Status(Fixed/Blocked) [sl_status]
    PURCHASINGORGANIZATION,        -- Purchasing Org. [ekorg]
    PURCHASINGDOCUMENTCATEGORY,    -- Doc. Category [bstyp]
    SOURCELISTRECORDCATEGORY,      -- Control [eortp]
    MRPSOURCINGCONTROL,            -- MRP [autet]
    MRPAREA,                       -- abap.char
    ORDERQUANTITYUNIT,             -- Order Unit [bstme]
    ORIGINSYSTEM,                  -- Logical System [logsystem]
    INVENTORYSPECIALSTOCKTYPE,     -- Special Stock [sobkz]
    SOURCELISTRECORD,              -- Number [dzeord]
    SOURCELISTDRAFTUUID,           -- Key [/bobf/uuid]
    HASACTIVEENTITY,               -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, SOURCELISTRECORDDRAFTUUID)
);

Learn More