EKBEH

Removed PO History Records | #transactional | Component: Purchasing
Column Name Description
MANDT Client
EBELN Purchasing Document Number
EBELP Item Number of Purchasing Document
ZEKKN Sequential Number of Account Assignment
VGABE Transaction/event type, purchase order history Show values
GJAHR Material Document Year
BELNR Number of Material Document
BUZEI Item in Material Document
Column Name Description
💲 Currency Key (T001.WAERS):
DMBTR Amount in Local Currency
WRBTR Amount in Document Currency
AREWR GR/IR account clearing value in local currency
REEWR Invoice Value Entered (in Local Currency)
REFWR Invoice Value in Foreign Currency
AREWW Clearing value on GR/IR clearing account (transac. currency)
AREWB Clearing Value on GR/IR Account in PO Currency
REWRB Invoice Amount in PO Currency
DMBTR_POP Amount in Local Currency
WRBTR_POP Amount in Document Currency
AREWR_POP GR/IR account clearing value in local currency
KUDIF Exchange Rate Difference Amount
RETAMT_FC Retention Amount in Document Currency
RETAMT_LC Retention Amount in Company Code Currency
RETAMTP_FC Posted Retention Amount in Document Currency
RETAMTP_LC Posted Security Retention Amount in Company Code Currency
Column Name Description
📏 Purchase Order Unit of Measure (EKPO.MEINS):
MENGE Quantity
WESBS Goods Receipt Blocked Stock in Order Unit
MENGE_POP Quantity
WESBB Valuated Goods Receipt Blocked Stock in Order Unit
/CWM/WESBS Goods Receipt Blocked Stock in Base/Parallel Unit of Measure
/CWM/WESBB Val. Goods Receipt Blocked Stock in Basis or Parallel UoM
QTY_DIFF Quantity
📏 Order Price Unit (Purchasing) (EKPO.BPRME):
BPMNG Quantity in purchase order price unit
BPWES Quantity in GR blocked stock in order price unit
BPMNG_POP Quantity in purchase order price unit
BPWEB Quantity in Valuated GR Blocked Stock in Order Price Unit
📏 Unit of Measure From Delivery Note (LSMEH):
LSMNG Quantity in Unit of Measure from Delivery Note
📏 Base Unit of Measure (EKPO.LMEIN):
BAMNG Quantity
/CWM/BAMNG Quantity in Parallel Unit of Measure
Column Name Description
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
BLDAT Document Date in Document
_DATAAGING Data Filter Value for Data Aging
Column Name Description
VGABE Transaction/event type, purchase order history Show values
SHKZG Debit/Credit Indicator Show values
ELIKZ "Delivery Completed" Indicator Show values
XWSBR Reversal of GR allowed for GR-based IV despite invoice Show values
XWOFF Calculation of val. open Show values
XUNPL Unplanned Account Assignment from Invoice Verification Show values
LEMIN Returns Indicator Show values
WEORA Acceptance At Origin Show values
INV_ITEM_ORIGIN Origin of an Invoice Item Show values
ET_UPD Procedure for Updating the Schedule Line Quantity Show values
/CWM/TY2TQ Type of Parallel Unit of Measure Show values
Column Name Description Domain name
XBLNR Reference Document Number XBLNR1
LFGJA Fiscal Year of a Reference Document GJAHR
LFBNR Document No. of a Reference Document BELNR
LFPOS Item of a Reference Document MBLPO
ETENS Sequential Number of Supplier Confirmation NUM04
KNUMV Number of the Document Condition KNUMV
MWSKZ Tax on sales/purchases code MWSKZ
TAX_COUNTRY Tax Reporting Country/Region LAND1
CHARG Batch Number CHARG
ERNAM Name of Person Responsible for Creating the Object USNAM
SRVPOS Service number ASNUM
PACKNO Package Number of Service PACKNO
INTROW Line Number of Service INTROW
BEKKN Number of PO Account Assignment NUM02
SAPRL SAP Release SAPRL
XMACC Multiple Account Assignment CHAR1
WKURS Exchange Rate KURSP
VBELN_ST Delivery VBELN
VBELP_ST Delivery Item POSNR
SGT_SCAT Stock Segment SGT_SRCA
LOGSY Logical System LOGSYS
J_SC_DIE_COMP_F Depreciation completion flag /SAPNEA/J_SC_DIE_COMP_F
FSH_SEASON_YEAR Season Year FSH_CJAHR
FSH_SEASON Season RFM_SAISO
FSH_COLLECTION Fashion Collection FSH_COLLECTION
FSH_THEME Fashion Theme FSH_THEME
WRF_CHARSTC1 Characteristic Value 1 WRF_CHARSTC
WRF_CHARSTC2 Characteristic Value 2 WRF_CHARSTC
WRF_CHARSTC3 Characteristic Value 3 WRF_CHARSTC
Master Data Relations Join Conditions
Purchase Order History Category
  • EKBEH.MANDT == T163B.MANDT
  • EKBEH.BEWTP == T163B.BEWTP
Movement type (inventory management)
  • EKBEH.MANDT == T156.MANDT
  • EKBEH.BWART == T156.BWART
Valuation Type
  • EKBEH.MANDT == T149D.MANDT
  • EKBEH.BWTAR == T149D.BWTAR
Material number
  • Material number
  • Client
  • EKBEH.EMATN == MARA.MATNR
  • EKBEH.MANDT == MARA.MANDT
Compliance with Shipping Instructions
  • Compliance with Shipping Instructions
  • ?
  • EKBEH.MANDT == T027C.MANDT
  • EKBEH.EVERE == T027C.EVERE
  • EKBEH.[column in domain "EVERS"] == T027C.EVERS
Reason for Movement
  • Reason for Movement
  • Movement type (inventory management)
  • EKBEH.MANDT == T157D.MANDT
  • EKBEH.GRUND == T157D.GRUND
  • EKBEH.BWART == T157D.BWART
Local currency key
  • EKBEH.MANDT == TCURC.MANDT
  • EKBEH.HSWAE == TCURC.WAERS
Unit of Measure From Delivery Note
  • EKBEH.MANDT == T006.MANDT
  • EKBEH.LSMEH == T006.MSEHI
Material Number
  • Material Number
  • Client
  • EKBEH.MATNR == MARA.MATNR
  • EKBEH.MANDT == MARA.MANDT
Currency Key
  • EKBEH.MANDT == TCURC.MANDT
  • EKBEH.WAERS == TCURC.WAERS
Plant
  • EKBEH.MANDT == T001W.MANDT
  • EKBEH.WERKS == T001W.WERKS