MMSPQTNINCOTRM

Transparent Table Application Table
12 Fields 1 CDS Views

Sourcing Project Quotation Item Incoterms

MMSPQTNINCOTRM is an SAP database table in S/4HANA. Sourcing Project Quotation Item Incoterms. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SrcgProjQtnItemIncoterms view_entity from BASIC Incoterms for Itm in Srcg Proj Quotation

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY srcgprojqtnitemincotermsuuid VDM_SRCGPROJQTNITMINCOTERMUUID Incoterms UUID
srcgprojqtnitemuuid VDM_SRCGPROJQTNITEMUUID Supplier Quotation Item UUID
sourcingprojectquotationuuid VDM_SRCGPROJQUOTATIONUUID Supplier Quotation UUID
plant EWERK Plant
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
incotermsversion INCOV Inco. Version
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
companycode BUKRS Company Code
procurementhubsourcesystem MMPUR_D_SOURCE_SYS Connected System 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 Incoterms
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQTNINCOTRM (
    MANDT,                         -- Client [MANDT]
    SRCGPROJQTNITEMINCOTERMSUUID,  -- Incoterms UUID [VDM_SRCGPROJQTNITMINCOTERMUUID]
    SRCGPROJQTNITEMUUID,           -- Supplier Quotation Item UUID [VDM_SRCGPROJQTNITEMUUID]
    SOURCINGPROJECTQUOTATIONUUID,  -- Supplier Quotation UUID [VDM_SRCGPROJQUOTATIONUUID]
    PLANT,                         -- Plant [EWERK]
    INCOTERMSCLASSIFICATION,       -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,     -- Incoterms 2 [INCO2]
    INCOTERMSVERSION,              -- Inco. Version [INCOV]
    INCOTERMSLOCATION1,            -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,            -- Inco. Location2 [INCO3_L]
    COMPANYCODE,                   -- Company Code [BUKRS]
    PROCUREMENTHUBSOURCESYSTEM,    -- Connected System ID [MMPUR_D_SOURCE_SYS]
    PRIMARY KEY (MANDT, SRCGPROJQTNITEMINCOTERMSUUID)
);

Learn More