MMSPQITMPFPRNT_D

Transparent Table Application Table
25 Fields 2 CDS Views

Draft Table for Entity R_SrcgProjQtnItmProdFprntDraft

MMSPQITMPFPRNT_D is an SAP database table in S/4HANA. Draft Table for Entity R_SrcgProjQtnItmProdFprntDraft. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgProjQtnItemProdFprntD view_entity from EXTENSION Prod Footprint for Qtn Item - Extension
R_SrcgProjQtnItmProdFprntDraft view_entity from BASIC Prod Fprnt for SrcgProjQtnItm - Draft

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY srcgprojqtnitemprodfprntuuid VDM_SPQTNITEMPRODUCTFPRNTUUID Product Footprint UUID
sourcingprojectquotationuuid VDM_SRCGPROJQUOTATIONUUID Supplier Quotation UUID
srcgprojqtnitemuuid VDM_SRCGPROJQTNITEMUUID Supplier Quotation Item UUID
srcgprojqtnitmprodfprnt VDM_SRCGPROJQTNITMPRODFPRNT Product Footprint ID
pfmfootprintbndrycndn PFMFOOTPRINTBNDRYCNDN Boundary Condition
pfmfootprintaccountingstd PFMFOOTPRINTACCOUNTINGSTD Accounting Standard
pfmfootprintfxdptdcmlquantity PFMFOOTPRINTQUANTITY_QUAN Quantity
pfmfootprintunit PFMFOOTPRINTUNIT Unit
pfmfootprintperiodstartdate PFMFOOTPRINTPERIODSTARTDATE Period Start Date
pfmfootprintperiodenddate PFMFOOTPRINTPERIODENDDATE Period End Date
spqtnitmcrbnfpqtyprimshrpctunt VDM_SPQICRBNFPQTYPRIMSHRPCTUNT Share of Primary Emissions Unit
pfmfootprintqtyprimaryshrpct PFMFOOTPRINTQTYPRIMARYSHRPCT Share of Primary Emissions
pfmfprntemissionfctrsrcedesc PFMFPRNTEMISSIONFCTRSRCEDESC Source of Emission Factor
baseunit MEINS Base Unit
spqtnitemprodfprntplantname VDM_SPQTNITMPRODFPRNTSUPLRPLNT Supplier Plant
srcgprojqtnitmprodfprntcountry VDM_SPQTNITEMPRODFPRNTCOUNTRY Country/Region of Supplier Plant
srcgprojqtnitemprodfprntregion VDM_SPQTNITMPRODFPRNTREGION Region of Supplier Plant
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_spqitmpfprnt_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_SrcgProjQtnItmProdFprntDraft
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQITMPFPRNT_D (
    MANDT,                           -- Client [MANDT]
    SRCGPROJQTNITEMPRODFPRNTUUID,    -- Product Footprint UUID [VDM_SPQTNITEMPRODUCTFPRNTUUID]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [VDM_SRCGPROJQUOTATIONUUID]
    SRCGPROJQTNITEMUUID,             -- Supplier Quotation Item UUID [VDM_SRCGPROJQTNITEMUUID]
    SRCGPROJQTNITMPRODFPRNT,         -- Product Footprint ID [VDM_SRCGPROJQTNITMPRODFPRNT]
    PFMFOOTPRINTBNDRYCNDN,           -- Boundary Condition [PFMFOOTPRINTBNDRYCNDN]
    PFMFOOTPRINTACCOUNTINGSTD,       -- Accounting Standard [PFMFOOTPRINTACCOUNTINGSTD]
    PFMFOOTPRINTFXDPTDCMLQUANTITY,   -- Quantity [PFMFOOTPRINTQUANTITY_QUAN]
    PFMFOOTPRINTUNIT,                -- Unit [PFMFOOTPRINTUNIT]
    PFMFOOTPRINTPERIODSTARTDATE,     -- Period Start Date [PFMFOOTPRINTPERIODSTARTDATE]
    PFMFOOTPRINTPERIODENDDATE,       -- Period End Date [PFMFOOTPRINTPERIODENDDATE]
    SPQTNITMCRBNFPQTYPRIMSHRPCTUNT,  -- Share of Primary Emissions Unit [VDM_SPQICRBNFPQTYPRIMSHRPCTUNT]
    PFMFOOTPRINTQTYPRIMARYSHRPCT,    -- Share of Primary Emissions [PFMFOOTPRINTQTYPRIMARYSHRPCT]
    PFMFPRNTEMISSIONFCTRSRCEDESC,    -- Source of Emission Factor [PFMFPRNTEMISSIONFCTRSRCEDESC]
    BASEUNIT,                        -- Base Unit [MEINS]
    SPQTNITEMPRODFPRNTPLANTNAME,     -- Supplier Plant [VDM_SPQTNITMPRODFPRNTSUPLRPLNT]
    SRCGPROJQTNITMPRODFPRNTCOUNTRY,  -- Country/Region of Supplier Plant [VDM_SPQTNITEMPRODFPRNTCOUNTRY]
    SRCGPROJQTNITEMPRODFPRNTREGION,  -- Region of Supplier Plant [VDM_SPQTNITMPRODFPRNTREGION]
    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_SPQITMPFPRNT_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SRCGPROJQTNITEMPRODFPRNTUUID)
);

Learn More