MMSPQIPFPRNTP

Transparent Table Application Table
8 Fields 2 CDS Views

Sourcing Project Quotation Item Product Footprint Plant

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SPQtnItemProdFprntPlant view_entity from EXTENSION Prod Fprnt Plant in Qtn Itm - Extension
R_SPQtnItemProdFprntPlant view_entity from BASIC Product Footprint Plant in Quotation Itm

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY spqtnitemprodfprntplantuuid vdm_spqtnitmprodfprntplantuuid Product Footprint Plant UUID
sourcingprojectquotationuuid vdm_srcgprojquotationuuid Supplier Quotation UUID
srcgprojqtnitemprodfprntuuid vdm_spqtnitemproductfprntuuid Product Footprint UUID
plant ewerk Plant
companycode bukrs Company Code
procurementhubsourcesystem mmpur_d_source_sys Connected System ID
procmthubplantuniqueid mmpur_be_plant_unique_id Plant Unique ID

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 Plant
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQIPFPRNTP (
    MANDT,                         -- Client [mandt]
    SPQTNITEMPRODFPRNTPLANTUUID,   -- Product Footprint Plant UUID [vdm_spqtnitmprodfprntplantuuid]
    SOURCINGPROJECTQUOTATIONUUID,  -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    SRCGPROJQTNITEMPRODFPRNTUUID,  -- Product Footprint UUID [vdm_spqtnitemproductfprntuuid]
    PLANT,                         -- Plant [ewerk]
    COMPANYCODE,                   -- Company Code [bukrs]
    PROCUREMENTHUBSOURCESYSTEM,    -- Connected System ID [mmpur_d_source_sys]
    PROCMTHUBPLANTUNIQUEID,        -- Plant Unique ID [mmpur_be_plant_unique_id]
    PRIMARY KEY (MANDT, SPQTNITEMPRODFPRNTPLANTUUID)
);

Learn More