MMPUR_EXT_EKBE

Transparent Table Application Table
81 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 81 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 (81)

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
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

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]
    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]
    PRIMARY KEY (MANDT, EBELN, EBELP, ZEKKN, VGABE, GJAHR, BELNR, BUZEI, EXTSOURCESYSTEM)
);

Learn More