MMSPQTNALWITRM

Transparent Table Application Table
12 Fields 1 CDS Views

Allowed Sourcing Project Quotation Incoterms

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SrcgProjQtnAllowedIncoterms view_entity from BASIC Allowed Incoterms in Srcg Proj Quotation

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY srcgprojqtnallwdincotermsuuid vdm_spqtnallwdincotermuuid Allowed Incoterm UUID
srcgprojqtnitemincotermsuuid vdm_srcgprojqtnitmincotermuuid Incoterms 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.

-- Allowed Sourcing Project Quotation Incoterms
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQTNALWITRM (
    MANDT,                          -- Client [mandt]
    SRCGPROJQTNALLWDINCOTERMSUUID,  -- Allowed Incoterm UUID [vdm_spqtnallwdincotermuuid]
    SRCGPROJQTNITEMINCOTERMSUUID,   -- Incoterms UUID [vdm_srcgprojqtnitmincotermuuid]
    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, SRCGPROJQTNALLWDINCOTERMSUUID)
);

Learn More