MMPUR_EXT_EKBE

Transparent Table Application Table
9 Fields 1 CDS Views

History per Purchasing Document

MMPUR_EXT_EKBE is an SAP database table in S/4HANA. History per Purchasing Document. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CentralPurchaseOrderHistory view from BASIC Central Purchase Order History

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ebeln ebeln Purchasing Doc.
KEY ebelp ebelp Item
KEY zekkn dzekkn Account Assgmt No.
KEY vgabe vgabe Trans./ev. type
KEY gjahr mjahr Mat. Doc. Year
KEY belnr mblnr Material Doc.
KEY buzei mblpo Mat. Doc.Item
KEY extsourcesystem 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.

-- History per Purchasing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_EKBE (
    MANDT,            -- Client [mandt]
    EBELN,            -- Purchasing Doc. [ebeln]
    EBELP,            -- Item [ebelp]
    ZEKKN,            -- Account Assgmt No. [dzekkn]
    VGABE,            -- Trans./ev. type [vgabe]
    GJAHR,            -- Mat. Doc. Year [mjahr]
    BELNR,            -- Material Doc. [mblnr]
    BUZEI,            -- Mat. Doc.Item [mblpo]
    EXTSOURCESYSTEM,  -- Connected System ID [mmpur_d_source_sys]
    PRIMARY KEY (MANDT, EBELN, EBELP, ZEKKN, VGABE, GJAHR, BELNR, BUZEI, EXTSOURCESYSTEM)
);

Learn More