MMSRCGPITEM_D

Transparent Table Application Table
66 Fields 2 CDS Views

Draft table for entity R_SOURCINGPROJECTITEMTP

MMSRCGPITEM_D is an SAP database table in S/4HANA. Draft table for entity R_SOURCINGPROJECTITEMTP. It contains 66 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SourcingProjectItemD view_entity from EXTENSION Item in Sourcing Project - Extension
R_SourcingProjectItemDraft view_entity from BASIC Sourcing Project Item - Draft

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sourcingprojectitemuuid vdm_sourcingprojectitemuuid Item UUID
sourcingprojectitem vdm_sourcingprojectitem Item
sourcingprojectuuid vdm_sourcingprojectuuid Sourcing Project UUID
sourcingprojectitemtype vdm_sourcingprojectitemtype Item Type
srcgprojitemclassification vdm_srcgprojitemclassification Item Classification
sourcingprojectitemstableuuid mm_srcgprojitemstableuuid Stable ID
srcgprojitemdescription vdm_srcgprojitemdesc Description
material matnr Material
producttype vdm_srcgprojproducttype Product Type
materialgroup matkl Material Group
srcgprojitemtargetamount vdm_srcgprojitemtargetamount Target Price
srcgprojitmtgtamtquantity srcgprojitmtgtamtquantity Price Unit for Target Price
srcgprojitemtotaltargetamount vdm_srcgprojitmtottargetamount Total Target Amount
requestedquantity vdm_requested_quantity Requested Quantity
maximumrequestedquantity vdm_max_requested_quantity Max. 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
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
sourcingprojectitemparent vdm_sourcingprojectitemparent Item Parent
hierarchynodelevel vdm_hierarchynodelevel Hierarchy Node Level
alternativeitemid vdm_alternativeitemid Alternative Item ID
formatteditemid vdm_formatteditemid Item Number
purchaserequisition banfn Purchase Req.
purchaserequisitionitem bnfpo Requisn. item
srcgprojfollowondocumentcat followondoccat Follow-On Document Category
srcgprojfollowondocumenttype followondoctype Follow-On Document Type
documentcurrency vdm_documentcurrency Document Currency
sourcingprojecttype mm_pur_srcgproj_type Sourcing Project Type
procmthubplantuniqueid mmpur_be_plant_unique_id Plant Unique ID
srcgprojitemdemandconfcode vdm_srcgprojectitmdmndconfcode Confirmation Code
srcgprojitemunconfddemandrsn mm_pur_srcgproj_unconf_dmndrsn Rsn for Unconfd Dmnd
procmtplanningbundleitemuuid vdm_procmtplngbundleitemuuid ProcurementPlanningBundleItemUUID
sourcingorigin vdm_sourcingorigin Sourcing Origin
sourcingscenario vdm_sourcingscenario Integration Scenario
centralpurchasecontract vdm_centralpurchasecontract Central Purchase Contract
centralpurchasecontractitem vdm_cntrlpurchasecontractitem Item in Central Purchase Contract
sourcesourcingprojectitemuuid vdm_sourcesourcingprojitemuuid Source Item UUID
srcgprojattchsareforbidden vdm_srcgprojattchsareforbidden Forbid Attachments
srcgprojectitemsettledstatus vdm_srcgprojitemsettledstatus Item Status
hierarchynode abap.char
hierarchyparentnode abap.sstring
hierarchydistancefromroot abap.int4
hierarchydescendantcount abap.int4
hierarchydrillstate abap.char
hierarchyrank hum_hierarchy_rank Hierarchy Rank
hierarchylevel abap.int4
requesteddeliverydateischanged abap.char
plantischanged boolean Boolean Variable (X = True, - = False, Space = Unknown)
suppliercostbreakdownisenabled vdm_suplrcbdtemplisenabled Cost Breakdown
suplrcostbreakdowntemplateuuid vdm_suplrcostbrkdwntmpluuid SUPLRCBDTUUID
suppliercostbreakdowntemplate vdm_suplrcostbrkdwntmplid Cost Breakdown Templ
suplrcostbrkdwntemplateversion vdm_suplrcostbrkdwntmplversion Version
supcosbrktmplactiveversion vdm_supcosbrktmplactiveversion Suplr CostBrkDwnTmpl
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

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.

-- Draft table for entity R_SOURCINGPROJECTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPITEM_D (
    MANDT,                           -- Client [mandt]
    SOURCINGPROJECTITEMUUID,         -- Item UUID [vdm_sourcingprojectitemuuid]
    SOURCINGPROJECTITEM,             -- Item [vdm_sourcingprojectitem]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [vdm_sourcingprojectuuid]
    SOURCINGPROJECTITEMTYPE,         -- Item Type [vdm_sourcingprojectitemtype]
    SRCGPROJITEMCLASSIFICATION,      -- Item Classification [vdm_srcgprojitemclassification]
    SOURCINGPROJECTITEMSTABLEUUID,   -- Stable ID [mm_srcgprojitemstableuuid]
    SRCGPROJITEMDESCRIPTION,         -- Description [vdm_srcgprojitemdesc]
    MATERIAL,                        -- Material [matnr]
    PRODUCTTYPE,                     -- Product Type [vdm_srcgprojproducttype]
    MATERIALGROUP,                   -- Material Group [matkl]
    SRCGPROJITEMTARGETAMOUNT,        -- Target Price [vdm_srcgprojitemtargetamount]
    SRCGPROJITMTGTAMTQUANTITY,       -- Price Unit for Target Price [srcgprojitmtgtamtquantity]
    SRCGPROJITEMTOTALTARGETAMOUNT,   -- Total Target Amount [vdm_srcgprojitmtottargetamount]
    REQUESTEDQUANTITY,               -- Requested Quantity [vdm_requested_quantity]
    MAXIMUMREQUESTEDQUANTITY,        -- Max. Requested Quantity [vdm_max_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]
    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]
    SOURCINGPROJECTITEMPARENT,       -- Item Parent [vdm_sourcingprojectitemparent]
    HIERARCHYNODELEVEL,              -- Hierarchy Node Level [vdm_hierarchynodelevel]
    ALTERNATIVEITEMID,               -- Alternative Item ID [vdm_alternativeitemid]
    FORMATTEDITEMID,                 -- Item Number [vdm_formatteditemid]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    SRCGPROJFOLLOWONDOCUMENTCAT,     -- Follow-On Document Category [followondoccat]
    SRCGPROJFOLLOWONDOCUMENTTYPE,    -- Follow-On Document Type [followondoctype]
    DOCUMENTCURRENCY,                -- Document Currency [vdm_documentcurrency]
    SOURCINGPROJECTTYPE,             -- Sourcing Project Type [mm_pur_srcgproj_type]
    PROCMTHUBPLANTUNIQUEID,          -- Plant Unique ID [mmpur_be_plant_unique_id]
    SRCGPROJITEMDEMANDCONFCODE,      -- Confirmation Code [vdm_srcgprojectitmdmndconfcode]
    SRCGPROJITEMUNCONFDDEMANDRSN,    -- Rsn for Unconfd Dmnd [mm_pur_srcgproj_unconf_dmndrsn]
    PROCMTPLANNINGBUNDLEITEMUUID,    -- ProcurementPlanningBundleItemUUID [vdm_procmtplngbundleitemuuid]
    SOURCINGORIGIN,                  -- Sourcing Origin [vdm_sourcingorigin]
    SOURCINGSCENARIO,                -- Integration Scenario [vdm_sourcingscenario]
    CENTRALPURCHASECONTRACT,         -- Central Purchase Contract [vdm_centralpurchasecontract]
    CENTRALPURCHASECONTRACTITEM,     -- Item in Central Purchase Contract [vdm_cntrlpurchasecontractitem]
    SOURCESOURCINGPROJECTITEMUUID,   -- Source Item UUID [vdm_sourcesourcingprojitemuuid]
    SRCGPROJATTCHSAREFORBIDDEN,      -- Forbid Attachments [vdm_srcgprojattchsareforbidden]
    SRCGPROJECTITEMSETTLEDSTATUS,    -- Item Status [vdm_srcgprojitemsettledstatus]
    HIERARCHYNODE,                   -- abap.char
    HIERARCHYPARENTNODE,             -- abap.sstring
    HIERARCHYDISTANCEFROMROOT,       -- abap.int4
    HIERARCHYDESCENDANTCOUNT,        -- abap.int4
    HIERARCHYDRILLSTATE,             -- abap.char
    HIERARCHYRANK,                   -- Hierarchy Rank [hum_hierarchy_rank]
    HIERARCHYLEVEL,                  -- abap.int4
    REQUESTEDDELIVERYDATEISCHANGED,  -- abap.char
    PLANTISCHANGED,                  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    SUPPLIERCOSTBREAKDOWNISENABLED,  -- Cost Breakdown [vdm_suplrcbdtemplisenabled]
    SUPLRCOSTBREAKDOWNTEMPLATEUUID,  -- SUPLRCBDTUUID [vdm_suplrcostbrkdwntmpluuid]
    SUPPLIERCOSTBREAKDOWNTEMPLATE,   -- Cost Breakdown Templ [vdm_suplrcostbrkdwntmplid]
    SUPLRCOSTBRKDWNTEMPLATEVERSION,  -- Version [vdm_suplrcostbrkdwntmplversion]
    SUPCOSBRKTMPLACTIVEVERSION,      -- Suplr CostBrkDwnTmpl [vdm_supcosbrktmplactiveversion]
    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]
    PRIMARY KEY (MANDT, SOURCINGPROJECTITEMUUID)
);

Learn More