A4MB

Transparent Table Application Table
10 Fields 2 CDS Views

VDM_SOURCI/VDM_SRCGPR/VDM_SRCGPR/Unique ID

A4MB is an SAP database table in S/4HANA. VDM_SOURCI/VDM_SRCGPR/VDM_SRCGPR/Unique ID. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SrcgProjQtnItemCondition view from BASIC Sourcing Project Item Condition
P_SrcgProjQtnItmCndnValidity view_entity from BASIC Src Proj Qtn Item Condition Validity

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kappl kappl Application
KEY kschl kscha Condition Type
KEY sourcingprojectquotation vdm_sourcingprojectquotation Supplier Quotation
KEY srcgprojquotationversion vdm_srcgprojqtnversion Version
KEY srcgprojqtnitem vdm_srcgprojqtnitem Item
KEY be_plant_unique_id mmpur_be_plant_unique_id Plant Unique ID
KEY datbi kodatbi Valid To
datab kodatab Valid From
knumh knumh Cond.Record No.

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.

-- VDM_SOURCI/VDM_SRCGPR/VDM_SRCGPR/Unique ID
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A4MB (
    MANDT,                     -- Client [mandt]
    KAPPL,                     -- Application [kappl]
    KSCHL,                     -- Condition Type [kscha]
    SOURCINGPROJECTQUOTATION,  -- Supplier Quotation [vdm_sourcingprojectquotation]
    SRCGPROJQUOTATIONVERSION,  -- Version [vdm_srcgprojqtnversion]
    SRCGPROJQTNITEM,           -- Item [vdm_srcgprojqtnitem]
    BE_PLANT_UNIQUE_ID,        -- Plant Unique ID [mmpur_be_plant_unique_id]
    DATBI,                     -- Valid To [kodatbi]
    DATAB,                     -- Valid From [kodatab]
    KNUMH,                     -- Cond.Record No. [knumh]
    PRIMARY KEY (MANDT, KAPPL, KSCHL, SOURCINGPROJECTQUOTATION, SRCGPROJQUOTATIONVERSION, SRCGPROJQTNITEM, BE_PLANT_UNIQUE_ID, DATBI)
);

Learn More