MMSPQITMPFPRNT_D

Transparent Table Application Table
18 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 18 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 (18)

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

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]
    PRIMARY KEY (MANDT, SRCGPROJQTNITEMPRODFPRNTUUID)
);

Learn More