MMSPQITMPFPRNT

Transparent Table Application Table
17 Fields 2 CDS Views

Sourcing Project Quotation Item Product Footprint

MMSPQITMPFPRNT is an SAP database table in S/4HANA. Sourcing Project Quotation Item Product Footprint. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgProjQtnItemProdFprnt view_entity from EXTENSION Prod Footprint for Qtn Item - Extension
R_SrcgProjQtnItemProdFprnt view_entity from BASIC Product Footprint in Quotation Item

Fields (17)

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
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.

-- Sourcing Project Quotation Item Product Footprint
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQITMPFPRNT (
    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]
    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