MMSPQIPFPRNTP_D

Transparent Table Application Table
9 Fields 2 CDS Views

Draft Table for Entity R_SPQtnItemProdFprntPlantTP

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SPQtnItemProdFprntPlantD view_entity from EXTENSION Prod Fprnt Plant in Qtn Itm - Extension
R_SPQtnItemProdFprntPlantDraft view_entity from BASIC Prod Fprnt Plant SrcgProjQtnItm - Draft

Fields (9)

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
srcgprojqtnitemuuid vdm_srcgprojqtnitemuuid Supplier Quotation Item UUID

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_SPQtnItemProdFprntPlantTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQIPFPRNTP_D (
    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]
    SRCGPROJQTNITEMUUID,           -- Supplier Quotation Item UUID [vdm_srcgprojqtnitemuuid]
    PRIMARY KEY (MANDT, SPQTNITEMPRODFPRNTPLANTUUID)
);

Learn More