Model / MM / EKBE

MM — Materials Management

EKBE

38 fields · 5 key · 11 foreign keys · sourced from leanx.eu

History per Purchasing Document — the PO-history table that records every goods-movement and invoice event against a purchase-order line, one row per PO item per account-assignment sequence per history-event type per material-document reference. This is the goods-receipt/invoice-receipt (GR/IR) tie-out table: the lane that reconciles what was ordered (EKPO), what was received (linked via GJAHR/BELNR/BUZEI back to the material document, MKPF/MSEG on ECC or MATDOC on S/4), and what was invoiced (REEWR/REFWR) against the GR/IR clearing account. SAP's real table carries 90+ fields including country/industry extensions (oil, CWM parallel units, depreciation completion); this definition is scoped to the full key, the GR/IR reconciliation fields (BEWTP, BWART, quantities, amounts, currencies), the material-document link fields, and the fields a crosswalk into ACDOCA would consume — no fewer than 25 fields, per the wide-table rule.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
DEM_NUM keydocumentum emptionis numerusPurchasing Document NumberEBELNCHAR 10EKKO
POS_NUM_DEM keypositio numerus documentum emptionisItem Number of Purchasing DocumentEBELPNUMC 5EKPO
NUM_RAT_ASG keynumerus ratio assignatioSequential Number of Account AssignmentDZEKKNNUMC 2
GEN_MEM keygenus mandatum emptionisTransaction/event type, purchase order historyVGABECHAR 1
MAT_DOC_ANNmateria documentum annusMaterial Document YearMJAHRNUMC 4
NUM_MAT_DOCnumerus materia documentumNumber of Material DocumentMBLNRCHAR 10
POS_MAT_DOCpositio materia documentumItem in Material DocumentMBLPONUMC 4
CTGcategoriaPO history categoryBEWTPCHAR 1T163B
MTM_GENmotus genusMovement Type (Inventory Management)BWARTCHAR 3T156
DIN_DOCdies inscriptionis documentumPosting Date in the DocumentBUDATDATS 8
QNTquantitasQuantityMENGE_DQUAN 13,3
QNT_MEM_PREquantitas mandatum emptionis pretiumQuantity in purchase order price unitMENGE_BPRQUAN 13,3
SUM_MONsumma monetaAmount in Local CurrencyDMBTRCURR 13,2
SUM_DOC_MONsumma documentum monetaAmount in document currencyWRBTRCURR 13,2
CVMclavis monetaeCurrency KeyWAERSCUKY 5TCURC
RAT_CPN_VALratio compensatio valorGR/IR account clearing value in local currencyAREWRCURR 13,2
AMR_CPA_MNDacceptio mercium copia mandatumGoods Receipt Blocked Stock in Order UnitWESBSQUAN 13,3
QNT_CPA_MNDquantitas copia mandatumQuantity in GR blocked stock in order price unitBPWESQUAN 13,3
DBT_CRD_IDXdebitum creditum indexDebit/Credit IndicatorSHKZGCHAR 1
AES_GENaestimatio genusValuation TypeBWTAR_DCHAR 10T149D
TRD_IDXtraditio index'Delivery Completed' IndicatorELIKZCHAR 1
RFR_NDOreferentia numerus documentiReference Document NumberXBLNR1CHAR 16
ANF_RFR_DOCannus fiscalis referentia documentumFiscal Year of a Reference DocumentLFBJANUMC 4
DOC_RFRdocumentum referentiaDocument No. of a Reference DocumentLFBNRCHAR 10
POS_RFR_DOCpositio referentia documentumItem of a Reference DocumentLFPOSNUMC 4
CSA_MTMcausa motusReason for MovementMB_GRBEWNUMC 4T157D
DIE_DOCdies documentumDay On Which Accounting Document Was EnteredCPUDTDATS 8
TMPtempusTime of EntryCPUTMTIMS 6
FAC_VAL_MONfactura valor monetaInvoice Value Entered (in Local Currency)REEWRCURR 13,2
EVERECompliance with Shipping InstructionsEVERECHAR 2T027C
FAC_VAL_MON2factura valor monetaInvoice value in foreign currencyREFWRCURR 13,2
MAT_NUMmateria numerusMaterial NumberMATNRCHAR 18MARA
OFCofficinaPlantWERKS_DCHAR 4T001W
NUM_DOC_CNDnumerus documentum condicioNumber of the document conditionKNUMVCHAR 10
TRB_VDT_CODtributum venditio codexTax on sales/purchases codeMWSKZCHAR 2
GRX_NUMgrex numerusBatch NumberCHARG_DCHAR 10
DDC_DOCdies documenti documentumDocument Date in DocumentBLDATDATS 8

Foreign keys

FieldCheck tableCheck field
MANDTT000MANDT
EBELNEKKOEBELN
EBELPEKPOEBELP
BEWTPT163BBEWTP
BWARTT156BWART
WAERSTCURCWAERS
BWTART149DBWTAR
GRUNDT157DGRUND
EVERET027CEVERE
MATNRMARAMATNR
WERKST001WWERKS

View EKBE.yaml in the repository