MMSRCGPROJ_D

Transparent Table Application Table
71 Fields 2 CDS Views

Draft table for entity R_SOURCINGPROJECTTP

MMSRCGPROJ_D is an SAP database table in S/4HANA. Draft table for entity R_SOURCINGPROJECTTP. It contains 71 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SourcingProjectD view_entity from EXTENSION Sourcing Project - Extension
R_SourcingProjectDraft view_entity from BASIC Sourcing Project - Draft

Fields (71)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
sourcingproject VDM_SOURCINGPROJECT Sourcing Project
sourcingprojectversion VDM_SOURCINGPROJECTVERSION Sourcing Project Version
sourcingprojecttype MM_PUR_SRCGPROJ_TYPE Sourcing Project Type
sourcingprojectname VDM_SOURCINGPROJECTNAME Name
srcgprojlifecyclestatus VDM_SRCGPROJECTLFCYCSTS Status
srcgprojapprovalstatus VDM_SRCGPROJECTAPPRVLSTS Approval Status
sourcingprojectphase MM_PUR_SRCGPROJ_PHASE Phase
sourcingsupplierlistuuid VDM_SUPPLIERLISTUUID Supplier List UUID
srcgprojrevisionsts VDM_SRCGPROJREVISIONSTS Revision Status
srcgprojactvtnsts VDM_SRCGPROJACTVTNSTS Activation Status
srcgprojpubgsts VDM_SRCGPROJPUBGSTS Publishing Status
companycode BUKRS Company Code
purchasinggroup BKGRP Purch. Group
purchasingorganization EKORG_LL Purchasing Organization
materialgroup MATKL Material Group
documentcurrency VDM_DOCUMENTCURRENCY Document Currency
srcgprojtotaltargetamount VDM_SRCGPROJTOTALTARGETAMOUNT Total Target Amount
purchaserrespworkagreement VDM_PURCHASERRESPONSIBLE Purchaser Responsible
qtnlatestsubmissiondatetime VDM_SUBMISSIONDATETIME Submission Deadline
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
createdbyuser VDM_CREATEDBYUSERID Created By
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
creationdatetime VDM_SRCGPROJCREATIONDATE Created On
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
incotermsversion INCOV Inco. Version
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
paymentterms FARP_DZTERM Payment Terms
cashdiscount1days DZBD1T Days 1
cashdiscount2days DZBD2T Days 2
cashdiscount1percent DZBD1P CD Percentage 1
cashdiscount2percent DZBD2P CD Percentage 2
netpaymentdays DZBD3T Days Net
srcgprojpubgdtetme VDM_SRCGPROJPUBGDTETME Published On
srcgprojcancdtetme VDM_SRCGPROJCANCDTETME Canceled On
srcgprojattchsareforbidden VDM_SRCGPROJATTCHSAREFORBIDDEN Forbid Attachments
srcgprojnotesareforbidden VDM_SRCGPROJNOTESAREFORBIDDEN Forbid Notes
srcgprojfollowondocumentcat FOLLOWONDOCCAT Follow-On Document Category
srcgprojfollowondocumenttype FOLLOWONDOCTYPE Follow-On Document Type
purcontrvaliditystartdate KDATB Validity Start
purcontrvalidityenddate KDATE Validity End
exchangeratetype KURST Exch. Rate Type
sourcingorigin VDM_SOURCINGORIGIN Sourcing Origin
sourcingscenario VDM_SOURCINGSCENARIO Integration Scenario
externalsourcingprojectref VDM_EXTERNALSRCGPROJREFERENCE External Reference
logicalsystem LOGSYSTEM Logical System
shippinginstruction EVERS Shipping Instr.
sourcesourcingprojectuuid VDM_SOURCESOURCINGPROJECTUUID Source Sourcing Project UUID
centralpurchasecontract VDM_CENTRALPURCHASECONTRACT Central Purchase Contract
procurementplanningbundleuuid VDM_PROCMTPLANNINGBUNDLEUUID Procurement Planning Bundle UUID
sourcingprojectversioningrsn MM_PUR_SRCGPROJ_REASON Reason
srcgprojpaymenttermismanual ABAP_BOOLEAN Truth Value
sourcingprojectuniqueid VDM_SOURCINGPROJECTUNIQUEID Unique ID
srcgprojhasbeenactivated abap.char
srcgprojearliestcndnseldate VDM_SRCGPROJEARLIESTCNDNSELDTE Earliest Start Date for Conditions
srcgprojcancellationrsn MM_PUR_SRCGPROJ_CANCEL_REASON Cancelation Reason
sourcingprojecttypeforedit MM_PUR_SRCGPROJ_TYPE Sourcing Project Type
purchasingorganizationforedit EKORG_LL Purchasing Organization
purchasinggroupforedit BKGRP Purch. Group
companycodeforedit BUKRS Company Code
materialgroupforedit MATKL Material Group
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_srcgprojhdr_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.

-- Draft table for entity R_SOURCINGPROJECTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPROJ_D (
    MANDT,                          -- Client [MANDT]
    SOURCINGPROJECTUUID,            -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    SOURCINGPROJECT,                -- Sourcing Project [VDM_SOURCINGPROJECT]
    SOURCINGPROJECTVERSION,         -- Sourcing Project Version [VDM_SOURCINGPROJECTVERSION]
    SOURCINGPROJECTTYPE,            -- Sourcing Project Type [MM_PUR_SRCGPROJ_TYPE]
    SOURCINGPROJECTNAME,            -- Name [VDM_SOURCINGPROJECTNAME]
    SRCGPROJLIFECYCLESTATUS,        -- Status [VDM_SRCGPROJECTLFCYCSTS]
    SRCGPROJAPPROVALSTATUS,         -- Approval Status [VDM_SRCGPROJECTAPPRVLSTS]
    SOURCINGPROJECTPHASE,           -- Phase [MM_PUR_SRCGPROJ_PHASE]
    SOURCINGSUPPLIERLISTUUID,       -- Supplier List UUID [VDM_SUPPLIERLISTUUID]
    SRCGPROJREVISIONSTS,            -- Revision Status [VDM_SRCGPROJREVISIONSTS]
    SRCGPROJACTVTNSTS,              -- Activation Status [VDM_SRCGPROJACTVTNSTS]
    SRCGPROJPUBGSTS,                -- Publishing Status [VDM_SRCGPROJPUBGSTS]
    COMPANYCODE,                    -- Company Code [BUKRS]
    PURCHASINGGROUP,                -- Purch. Group [BKGRP]
    PURCHASINGORGANIZATION,         -- Purchasing Organization [EKORG_LL]
    MATERIALGROUP,                  -- Material Group [MATKL]
    DOCUMENTCURRENCY,               -- Document Currency [VDM_DOCUMENTCURRENCY]
    SRCGPROJTOTALTARGETAMOUNT,      -- Total Target Amount [VDM_SRCGPROJTOTALTARGETAMOUNT]
    PURCHASERRESPWORKAGREEMENT,     -- Purchaser Responsible [VDM_PURCHASERRESPONSIBLE]
    QTNLATESTSUBMISSIONDATETIME,    -- Submission Deadline [VDM_SUBMISSIONDATETIME]
    LASTCHANGEDBYUSER,              -- Changed By [VDM_LASTCHANGEDBYUSERID]
    CREATEDBYUSER,                  -- Created By [VDM_CREATEDBYUSERID]
    LASTCHANGEDATETIME,             -- Last Changed On [VDM_LASTCHANGEDON]
    CREATIONDATETIME,               -- Created On [VDM_SRCGPROJCREATIONDATE]
    INCOTERMSCLASSIFICATION,        -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,      -- Incoterms 2 [INCO2]
    INCOTERMSVERSION,               -- Inco. Version [INCOV]
    INCOTERMSLOCATION1,             -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,             -- Inco. Location2 [INCO3_L]
    PAYMENTTERMS,                   -- Payment Terms [FARP_DZTERM]
    CASHDISCOUNT1DAYS,              -- Days 1 [DZBD1T]
    CASHDISCOUNT2DAYS,              -- Days 2 [DZBD2T]
    CASHDISCOUNT1PERCENT,           -- CD Percentage 1 [DZBD1P]
    CASHDISCOUNT2PERCENT,           -- CD Percentage 2 [DZBD2P]
    NETPAYMENTDAYS,                 -- Days Net [DZBD3T]
    SRCGPROJPUBGDTETME,             -- Published On [VDM_SRCGPROJPUBGDTETME]
    SRCGPROJCANCDTETME,             -- Canceled On [VDM_SRCGPROJCANCDTETME]
    SRCGPROJATTCHSAREFORBIDDEN,     -- Forbid Attachments [VDM_SRCGPROJATTCHSAREFORBIDDEN]
    SRCGPROJNOTESAREFORBIDDEN,      -- Forbid Notes [VDM_SRCGPROJNOTESAREFORBIDDEN]
    SRCGPROJFOLLOWONDOCUMENTCAT,    -- Follow-On Document Category [FOLLOWONDOCCAT]
    SRCGPROJFOLLOWONDOCUMENTTYPE,   -- Follow-On Document Type [FOLLOWONDOCTYPE]
    PURCONTRVALIDITYSTARTDATE,      -- Validity Start [KDATB]
    PURCONTRVALIDITYENDDATE,        -- Validity End [KDATE]
    EXCHANGERATETYPE,               -- Exch. Rate Type [KURST]
    SOURCINGORIGIN,                 -- Sourcing Origin [VDM_SOURCINGORIGIN]
    SOURCINGSCENARIO,               -- Integration Scenario [VDM_SOURCINGSCENARIO]
    EXTERNALSOURCINGPROJECTREF,     -- External Reference [VDM_EXTERNALSRCGPROJREFERENCE]
    LOGICALSYSTEM,                  -- Logical System [LOGSYSTEM]
    SHIPPINGINSTRUCTION,            -- Shipping Instr. [EVERS]
    SOURCESOURCINGPROJECTUUID,      -- Source Sourcing Project UUID [VDM_SOURCESOURCINGPROJECTUUID]
    CENTRALPURCHASECONTRACT,        -- Central Purchase Contract [VDM_CENTRALPURCHASECONTRACT]
    PROCUREMENTPLANNINGBUNDLEUUID,  -- Procurement Planning Bundle UUID [VDM_PROCMTPLANNINGBUNDLEUUID]
    SOURCINGPROJECTVERSIONINGRSN,   -- Reason [MM_PUR_SRCGPROJ_REASON]
    SRCGPROJPAYMENTTERMISMANUAL,    -- Truth Value [ABAP_BOOLEAN]
    SOURCINGPROJECTUNIQUEID,        -- Unique ID [VDM_SOURCINGPROJECTUNIQUEID]
    SRCGPROJHASBEENACTIVATED,       -- abap.char
    SRCGPROJEARLIESTCNDNSELDATE,    -- Earliest Start Date for Conditions [VDM_SRCGPROJEARLIESTCNDNSELDTE]
    SRCGPROJCANCELLATIONRSN,        -- Cancelation Reason [MM_PUR_SRCGPROJ_CANCEL_REASON]
    SOURCINGPROJECTTYPEFOREDIT,     -- Sourcing Project Type [MM_PUR_SRCGPROJ_TYPE]
    PURCHASINGORGANIZATIONFOREDIT,  -- Purchasing Organization [EKORG_LL]
    PURCHASINGGROUPFOREDIT,         -- Purch. Group [BKGRP]
    COMPANYCODEFOREDIT,             -- Company Code [BUKRS]
    MATERIALGROUPFOREDIT,           -- Material Group [MATKL]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_SRCGPROJHDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SOURCINGPROJECTUUID)
);

Learn More