EKBE

Transparent Table Application Table
90 Fields 25 CDS Views

History per Purchasing Document

EKBE is an SAP database table in S/4HANA. History per Purchasing Document. It contains 90 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
Fclm_Mm_Pohist view from Purchasing Order History
FMLV_EKBEBZ_UCT_UNION view from History per Purchasing Document w. External CURTP
FNDEI_EKBE_BLOCKINGINFO view from Blocking View for table EKBE
FNDEI_EKBE_FILTER view from Filter View for table EKBE
I_BR_PurchaseHistory view from BASIC Brazil Purchase History
I_PPS_GoodsMovementProcessFlow view from BASIC Goods Movement Documents For XPO History
I_PPS_PurchasingHistory view from BASIC History Per Purchasing Document
I_PPS_PurgHistWthRemovedDoc view from COMPOSITE History of Purchase Order
I_PurchasingDocHistory view from BASIC Purchase Document History
I_PurchasingDocumentHistoryBsc view from BASIC History per Purchasing Document Item
I_PurDocHistory view from BASIC Purchasing Document History
M_V_PHL_EKBE view from CDS View for PO History Light
m_v_po_hdr_status_ekbe view from Helper f. PO History in PO Header Status
m_v_po_itm_status_ekbe view from Helper for PO History in PO Item Status
m_v_sa_itm_status_ekbe view from History in Sched.Agr.Item Status
N_PurchaseOrderHistoryBasic view from Auxiliary View for Purchase Order History
P_CFinLocalPurgDocHistory view from COMPOSITE
P_POGRSchedLineDetails view from CONSUMPTION PO Goods Receipt and Sched Line Details
P_PurchaseOrderHistory_Basic view from BASIC
P_PurchaseOrderHistory2 view from BASIC
P_PurchasingDocHistory view from BASIC
P_PurchasingDocumentHistory view from BASIC
P_SchedgAgrmtHistory2 view from BASIC
PurgDocHistory view from
V_Mmim_Ddl_Obd_Pohist view from Show Outbound Deliveries from PO history

Fields (90)

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
bewtp BEWTP PO History Cat.
bwart BWART Movement Type
budat BUDAT Posting Date
menge MENGE_D Quantity
bpmng MENGE_BPR Qty. in OPUn
dmbtr DMBTR_CS Amount in LC
wrbtr WRBTR_CS Amount
waers WAERS Currency
arewr AREWR GR/IR clr.value
wesbs WESBS GR Bl.St. OUn
bpwes BPWES GR blocked stck
shkzg SHKZG Debit/Credit
bwtar BWTAR_D Valuation Type
elikz ELIKZ Deliv. Compl.
xblnr XBLNR1 Reference
lfgja LFBJA Fisc.yr.ref.doc
lfbnr LFBNR Reference Doc.
lfpos LFPOS Ref. Doc. Item
grund MB_GRBEW Reason for Mvmt
cpudt CPUDT Entered On
cputm CPUTM Entered at
reewr REEWR Invoice Value
evere EVERE Compliance
refwr REFWR Inv.Value in FC
matnr MATNR Material
werks WERKS_D Plant
xwsbr XWSBR RevGR desp. IR
etens ETENS Sequential No.
knumv KNUMV Doc. Condition
mwskz MWSKZ Tax Code
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
lsmng LSMNG Del. Note Qty
lsmeh LSMEH Del. Note Unit
ematn EMATNR Material
areww AREWW GR/IR clr.value
hswae HSWAE Local currency
bamng MENGE_D Quantity
charg CHARG_D Batch
bldat BLDAT Document Date
xwoff XWOFF Calcn of val.Open
xunpl XUNPL UAcctAssignment
ernam ERNAM Created By
srvpos SRVPOS Service
packno PACKNO_EKBE Package Number
introw INTROW_EKBE Service line
bekkn BEKKN SeqNo.PO AccAss
lemin SRVRET SRV Returns Ind.
arewb AREWB GR/IR clr.value
rewrb REWRB FC invoice amnt
saprl SAPRL SAP Release
menge_pop MENGE_D Quantity
bpmng_pop MENGE_BPR Qty. in OPUn
dmbtr_pop DMBTR_CS Amount in LC
wrbtr_pop WRBTR_CS Amount
wesbb WESBB Val. GR BlStock OUn
bpweb BPWEB Val. GR BS OPUn
weora WEORA Origin Accept.
arewr_pop AREWR GR/IR clr.value
kudif KUDIF Exch.Rate Diff.
retamt_fc RET_AMT_FC Retent. in Doc. Crcy
retamt_lc RET_AMT_LC Retention in CC Crcy
retamtp_fc RET_AMT_POST_FC Retent. in Doc. Crcy
retamtp_lc RET_AMT_POST_LC Retention in CC Crcy
xmacc XMACC Multi Acct Assgt
wkurs WKURS Exchange Rate
inv_item_origin INV_ITM_ORIGIN Item Origin
vbeln_st VBELN_VL Delivery
vbelp_st POSNR_VL Item
sgt_scat SGT_SCAT Stock Segment
_dataaging DATA_TEMPERATURE Data Aging
sesuom SES_UOM SES UoM
logsy LOGSYSTEM Logical System
et_upd ET_UPD1 SLPU
j_sc_die_comp_f /SAPNEA/J_SC_DIE_COMP_F Die complete flag
fsh_season_year FSH_SAISJ Season Year
fsh_season FSH_SAISO Season
fsh_collection FSH_COLLECTION Collection
fsh_theme FSH_THEME Theme
qty_diff MENGE_QTYDIFF Quantity
wrf_charstc1 WRF_CHARSTC1 Characteristic 1
wrf_charstc2 WRF_CHARSTC2 Characteristic 2
wrf_charstc3 WRF_CHARSTC3 Characteristic 3

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 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]
    BEWTP,            -- PO History Cat. [BEWTP]
    BWART,            -- Movement Type [BWART]
    BUDAT,            -- Posting Date [BUDAT]
    MENGE,            -- Quantity [MENGE_D]
    BPMNG,            -- Qty. in OPUn [MENGE_BPR]
    DMBTR,            -- Amount in LC [DMBTR_CS]
    WRBTR,            -- Amount [WRBTR_CS]
    WAERS,            -- Currency [WAERS]
    AREWR,            -- GR/IR clr.value [AREWR]
    WESBS,            -- GR Bl.St. OUn [WESBS]
    BPWES,            -- GR blocked stck [BPWES]
    SHKZG,            -- Debit/Credit [SHKZG]
    BWTAR,            -- Valuation Type [BWTAR_D]
    ELIKZ,            -- Deliv. Compl. [ELIKZ]
    XBLNR,            -- Reference [XBLNR1]
    LFGJA,            -- Fisc.yr.ref.doc [LFBJA]
    LFBNR,            -- Reference Doc. [LFBNR]
    LFPOS,            -- Ref. Doc. Item [LFPOS]
    GRUND,            -- Reason for Mvmt [MB_GRBEW]
    CPUDT,            -- Entered On [CPUDT]
    CPUTM,            -- Entered at [CPUTM]
    REEWR,            -- Invoice Value [REEWR]
    EVERE,            -- Compliance [EVERE]
    REFWR,            -- Inv.Value in FC [REFWR]
    MATNR,            -- Material [MATNR]
    WERKS,            -- Plant [WERKS_D]
    XWSBR,            -- RevGR desp. IR [XWSBR]
    ETENS,            -- Sequential No. [ETENS]
    KNUMV,            -- Doc. Condition [KNUMV]
    MWSKZ,            -- Tax Code [MWSKZ]
    TAX_COUNTRY,      -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    LSMNG,            -- Del. Note Qty [LSMNG]
    LSMEH,            -- Del. Note Unit [LSMEH]
    EMATN,            -- Material [EMATNR]
    AREWW,            -- GR/IR clr.value [AREWW]
    HSWAE,            -- Local currency [HSWAE]
    BAMNG,            -- Quantity [MENGE_D]
    CHARG,            -- Batch [CHARG_D]
    BLDAT,            -- Document Date [BLDAT]
    XWOFF,            -- Calcn of val.Open [XWOFF]
    XUNPL,            -- UAcctAssignment [XUNPL]
    ERNAM,            -- Created By [ERNAM]
    SRVPOS,           -- Service [SRVPOS]
    PACKNO,           -- Package Number [PACKNO_EKBE]
    INTROW,           -- Service line [INTROW_EKBE]
    BEKKN,            -- SeqNo.PO AccAss [BEKKN]
    LEMIN,            -- SRV Returns Ind. [SRVRET]
    AREWB,            -- GR/IR clr.value [AREWB]
    REWRB,            -- FC invoice amnt [REWRB]
    SAPRL,            -- SAP Release [SAPRL]
    MENGE_POP,        -- Quantity [MENGE_D]
    BPMNG_POP,        -- Qty. in OPUn [MENGE_BPR]
    DMBTR_POP,        -- Amount in LC [DMBTR_CS]
    WRBTR_POP,        -- Amount [WRBTR_CS]
    WESBB,            -- Val. GR BlStock OUn [WESBB]
    BPWEB,            -- Val. GR BS OPUn [BPWEB]
    WEORA,            -- Origin Accept. [WEORA]
    AREWR_POP,        -- GR/IR clr.value [AREWR]
    KUDIF,            -- Exch.Rate Diff. [KUDIF]
    RETAMT_FC,        -- Retent. in Doc. Crcy [RET_AMT_FC]
    RETAMT_LC,        -- Retention in CC Crcy [RET_AMT_LC]
    RETAMTP_FC,       -- Retent. in Doc. Crcy [RET_AMT_POST_FC]
    RETAMTP_LC,       -- Retention in CC Crcy [RET_AMT_POST_LC]
    XMACC,            -- Multi Acct Assgt [XMACC]
    WKURS,            -- Exchange Rate [WKURS]
    INV_ITEM_ORIGIN,  -- Item Origin [INV_ITM_ORIGIN]
    VBELN_ST,         -- Delivery [VBELN_VL]
    VBELP_ST,         -- Item [POSNR_VL]
    SGT_SCAT,         -- Stock Segment [SGT_SCAT]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    SESUOM,           -- SES UoM [SES_UOM]
    LOGSY,            -- Logical System [LOGSYSTEM]
    ET_UPD,           -- SLPU [ET_UPD1]
    J_SC_DIE_COMP_F,  -- Die complete flag [/SAPNEA/J_SC_DIE_COMP_F]
    FSH_SEASON_YEAR,  -- Season Year [FSH_SAISJ]
    FSH_SEASON,       -- Season [FSH_SAISO]
    FSH_COLLECTION,   -- Collection [FSH_COLLECTION]
    FSH_THEME,        -- Theme [FSH_THEME]
    QTY_DIFF,         -- Quantity [MENGE_QTYDIFF]
    WRF_CHARSTC1,     -- Characteristic 1 [WRF_CHARSTC1]
    WRF_CHARSTC2,     -- Characteristic 2 [WRF_CHARSTC2]
    WRF_CHARSTC3,     -- Characteristic 3 [WRF_CHARSTC3]
    PRIMARY KEY (MANDT, EBELN, EBELP, ZEKKN, VGABE, GJAHR, BELNR, BUZEI)
);

Learn More