EKBEH

Transparent Table Application Table
8 Fields 9 CDS Views

Removed PO History Records

EKBEH is an SAP database table in S/4HANA. Removed PO History Records. It contains 8 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
Fclm_Mm_Pohist view union_all Purchasing Order History
FMLV_EKBEBZH_UCT_UNION view from History per Purchasing Document w. External CURTP
FNDEI_EKBEH_BLOCKINGINFO view from Filter View for table EKBEH
FNDEI_EKBEH_FILTER view from Filter View for table EKBEH
I_PPS_PurgHistWthRemovedDoc view union_all COMPOSITE History of Purchase Order
I_PurgDocRemovedHistory view from BASIC Removed Purchasing Document Item History
P_PurchaseOrderHistory2 view union_all BASIC
P_PurchasingDocumentHistory view union_all BASIC
P_SchedgAgrmtHistory2 view union_all BASIC

Fields (8)

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

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.

-- Removed PO History Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKBEH (
    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]
    PRIMARY KEY (MANDT, EBELN, EBELP, ZEKKN, VGABE, GJAHR, BELNR, BUZEI)
);

Learn More