MMSRCGPITEM

Transparent Table Application Table
55 Fields 6 CDS Views

Sourcing Project Item

MMSRCGPITEM is an SAP database table in S/4HANA. Sourcing Project Item. It contains 55 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_SourcingProjectItem view_entity from EXTENSION Item in Sourcing Project - Extension
P_SourcingProjectItemDEX view_entity from BASIC Private Data Extraction For Sourcing Project Item
P_SRCGPROJ_ITEM_BASE_DB view_entity from SDM SRCGPROJ item base
P_SRCGPROJ_ITEM_BASE_PID view_entity from SDM SRCGPROJ item base PID
P_SRCGPROJ_ITEM_BASE_PUUID view_entity from SDM SRCGPROJ item base
R_SourcingProjectItem view from BASIC Item in Sourcing Project

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sourcingprojectitemuuid VDM_SOURCINGPROJECTITEMUUID Item UUID
sourcingprojectitem VDM_SOURCINGPROJECTITEM Item
sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
srcgprojitemdescription VDM_SRCGPROJITEMDESC Description
sourcingprojectitemtype VDM_SOURCINGPROJECTITEMTYPE Item Type
srcgprojitemclassification VDM_SRCGPROJITEMCLASSIFICATION Item Classification
sourcingprojectitemstableuuid MM_SRCGPROJITEMSTABLEUUID Stable ID
material MATNR Material
producttype VDM_SRCGPROJPRODUCTTYPE Product Type
materialgroup MATKL Material Group
sourcingprojectitemparent VDM_SOURCINGPROJECTITEMPARENT Item Parent
hierarchynodelevel VDM_HIERARCHYNODELEVEL Hierarchy Node Level
alternativeitemid VDM_ALTERNATIVEITEMID Alternative Item ID
formatteditemid VDM_FORMATTEDITEMID Item Number
hierarchynodesubtreesize VDM_DESCENDANTCOUNT Descendant Count
srcgprojitemtargetamount VDM_SRCGPROJITEMTARGETAMOUNT Target Price
srcgprojitmtgtamtquantity SRCGPROJITMTGTAMTQUANTITY Price Unit for Target Price
srcgprojitemtotaltargetamount VDM_SRCGPROJITMTOTTARGETAMOUNT Total Target Amount
maximumrequestedquantity VDM_MAX_REQUESTED_QUANTITY Max. Requested Quantity
requestedquantity VDM_REQUESTED_QUANTITY Requested Quantity
requestedquantityunit VDM_REQUESTEDQUANTITYUNIT Requested Quantity Unit
requesteddeliverydate VDM_REQUESTEDDELIVERYDATE Requested Delivery Date
performanceperiodstartdate VDM_PERFORMANCEPERIODSTARTDATE Start of Performance Period
performanceperiodenddate VDM_PERFORMANCEPERIODENDDATE End of Performance Period
orderitemqtytobaseqtynmrtr UMBSZ Equal To
orderitemqtytobaseqtydnmntr UMBSN Denominator
plant EWERK Plant
purchaserequisition BANFN Purchase Req.
purchaserequisitionitem BNFPO Requisn. item
companycode BUKRS Company Code
purchasinggroup BKGRP Purch. Group
purchasingorganization EKORG_LL Purchasing Organization
procurementhubsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
storagelocation LGORT_D Location
srcgprojfollowondocumentcat FOLLOWONDOCCAT Follow-On Document Category
srcgprojfollowondocumenttype FOLLOWONDOCTYPE Follow-On Document Type
centralpurchasecontract VDM_CENTRALPURCHASECONTRACT Central Purchase Contract
centralpurchasecontractitem VDM_CNTRLPURCHASECONTRACTITEM Item in Central Purchase Contract
sourcesourcingprojectitemuuid VDM_SOURCESOURCINGPROJITEMUUID Source Item UUID
srcgprojitemdemandconfcode VDM_SRCGPROJECTITMDMNDCONFCODE Confirmation Code
srcgprojitemunconfddemandrsn MM_PUR_SRCGPROJ_UNCONF_DMNDRSN Rsn for Unconfd Dmnd
procmthubplantuniqueid MMPUR_BE_PLANT_UNIQUE_ID Plant Unique ID
procmtplanningbundleitemuuid VDM_PROCMTPLNGBUNDLEITEMUUID ProcurementPlanningBundleItemUUID
sourcingorigin VDM_SOURCINGORIGIN Sourcing Origin
sourcingscenario VDM_SOURCINGSCENARIO Integration Scenario
srcgprojectitemsettledstatus VDM_SRCGPROJITEMSETTLEDSTATUS Item Status
requesteddeliverydateischanged abap.char
srcgprojattchsareforbidden VDM_SRCGPROJATTCHSAREFORBIDDEN Forbid Attachments
suppliercostbreakdownisenabled VDM_SUPLRCBDTEMPLISENABLED Cost Breakdown
suplrcostbreakdowntemplateuuid VDM_SUPLRCOSTBRKDWNTMPLUUID SUPLRCBDTUUID
costbrkdwnattchcrtnisrequired VDM_COSTBRKDWNATTCHCRTNISRQD Attch Creation is Rqd for Cost Brkdown
srcgprojitmtargetamountisfixed VDM_SRCGPROJITMTGTAMTISFIXED Target Price Is Unchangeable
srcgprojitmtgtamtqtyisfixed VDM_SRCGPITMTGTAMTQTYISFIXED Target Price Unit Is Unchangeable
dummy_srcgprojitm_incl_eew_ps CFD_DUMMY Dummy

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.

-- Sourcing Project Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPITEM (
    MANDT,                           -- Client [MANDT]
    SOURCINGPROJECTITEMUUID,         -- Item UUID [VDM_SOURCINGPROJECTITEMUUID]
    SOURCINGPROJECTITEM,             -- Item [VDM_SOURCINGPROJECTITEM]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    SRCGPROJITEMDESCRIPTION,         -- Description [VDM_SRCGPROJITEMDESC]
    SOURCINGPROJECTITEMTYPE,         -- Item Type [VDM_SOURCINGPROJECTITEMTYPE]
    SRCGPROJITEMCLASSIFICATION,      -- Item Classification [VDM_SRCGPROJITEMCLASSIFICATION]
    SOURCINGPROJECTITEMSTABLEUUID,   -- Stable ID [MM_SRCGPROJITEMSTABLEUUID]
    MATERIAL,                        -- Material [MATNR]
    PRODUCTTYPE,                     -- Product Type [VDM_SRCGPROJPRODUCTTYPE]
    MATERIALGROUP,                   -- Material Group [MATKL]
    SOURCINGPROJECTITEMPARENT,       -- Item Parent [VDM_SOURCINGPROJECTITEMPARENT]
    HIERARCHYNODELEVEL,              -- Hierarchy Node Level [VDM_HIERARCHYNODELEVEL]
    ALTERNATIVEITEMID,               -- Alternative Item ID [VDM_ALTERNATIVEITEMID]
    FORMATTEDITEMID,                 -- Item Number [VDM_FORMATTEDITEMID]
    HIERARCHYNODESUBTREESIZE,        -- Descendant Count [VDM_DESCENDANTCOUNT]
    SRCGPROJITEMTARGETAMOUNT,        -- Target Price [VDM_SRCGPROJITEMTARGETAMOUNT]
    SRCGPROJITMTGTAMTQUANTITY,       -- Price Unit for Target Price [SRCGPROJITMTGTAMTQUANTITY]
    SRCGPROJITEMTOTALTARGETAMOUNT,   -- Total Target Amount [VDM_SRCGPROJITMTOTTARGETAMOUNT]
    MAXIMUMREQUESTEDQUANTITY,        -- Max. Requested Quantity [VDM_MAX_REQUESTED_QUANTITY]
    REQUESTEDQUANTITY,               -- Requested Quantity [VDM_REQUESTED_QUANTITY]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [VDM_REQUESTEDQUANTITYUNIT]
    REQUESTEDDELIVERYDATE,           -- Requested Delivery Date [VDM_REQUESTEDDELIVERYDATE]
    PERFORMANCEPERIODSTARTDATE,      -- Start of Performance Period [VDM_PERFORMANCEPERIODSTARTDATE]
    PERFORMANCEPERIODENDDATE,        -- End of Performance Period [VDM_PERFORMANCEPERIODENDDATE]
    ORDERITEMQTYTOBASEQTYNMRTR,      -- Equal To [UMBSZ]
    ORDERITEMQTYTOBASEQTYDNMNTR,     -- Denominator [UMBSN]
    PLANT,                           -- Plant [EWERK]
    PURCHASEREQUISITION,             -- Purchase Req. [BANFN]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [BNFPO]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [EKORG_LL]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    STORAGELOCATION,                 -- Location [LGORT_D]
    SRCGPROJFOLLOWONDOCUMENTCAT,     -- Follow-On Document Category [FOLLOWONDOCCAT]
    SRCGPROJFOLLOWONDOCUMENTTYPE,    -- Follow-On Document Type [FOLLOWONDOCTYPE]
    CENTRALPURCHASECONTRACT,         -- Central Purchase Contract [VDM_CENTRALPURCHASECONTRACT]
    CENTRALPURCHASECONTRACTITEM,     -- Item in Central Purchase Contract [VDM_CNTRLPURCHASECONTRACTITEM]
    SOURCESOURCINGPROJECTITEMUUID,   -- Source Item UUID [VDM_SOURCESOURCINGPROJITEMUUID]
    SRCGPROJITEMDEMANDCONFCODE,      -- Confirmation Code [VDM_SRCGPROJECTITMDMNDCONFCODE]
    SRCGPROJITEMUNCONFDDEMANDRSN,    -- Rsn for Unconfd Dmnd [MM_PUR_SRCGPROJ_UNCONF_DMNDRSN]
    PROCMTHUBPLANTUNIQUEID,          -- Plant Unique ID [MMPUR_BE_PLANT_UNIQUE_ID]
    PROCMTPLANNINGBUNDLEITEMUUID,    -- ProcurementPlanningBundleItemUUID [VDM_PROCMTPLNGBUNDLEITEMUUID]
    SOURCINGORIGIN,                  -- Sourcing Origin [VDM_SOURCINGORIGIN]
    SOURCINGSCENARIO,                -- Integration Scenario [VDM_SOURCINGSCENARIO]
    SRCGPROJECTITEMSETTLEDSTATUS,    -- Item Status [VDM_SRCGPROJITEMSETTLEDSTATUS]
    REQUESTEDDELIVERYDATEISCHANGED,  -- abap.char
    SRCGPROJATTCHSAREFORBIDDEN,      -- Forbid Attachments [VDM_SRCGPROJATTCHSAREFORBIDDEN]
    SUPPLIERCOSTBREAKDOWNISENABLED,  -- Cost Breakdown [VDM_SUPLRCBDTEMPLISENABLED]
    SUPLRCOSTBREAKDOWNTEMPLATEUUID,  -- SUPLRCBDTUUID [VDM_SUPLRCOSTBRKDWNTMPLUUID]
    COSTBRKDWNATTCHCRTNISREQUIRED,   -- Attch Creation is Rqd for Cost Brkdown [VDM_COSTBRKDWNATTCHCRTNISRQD]
    SRCGPROJITMTARGETAMOUNTISFIXED,  -- Target Price Is Unchangeable [VDM_SRCGPROJITMTGTAMTISFIXED]
    SRCGPROJITMTGTAMTQTYISFIXED,     -- Target Price Unit Is Unchangeable [VDM_SRCGPITMTGTAMTQTYISFIXED]
    DUMMY_SRCGPROJITM_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SOURCINGPROJECTITEMUUID)
);

Learn More