EKBEH SAP (Removed PO History Records) Table details

Dictionary Type: Table
Description: Removed PO History Records




ABAP Code to SELECT data from EKBEH
Related tables to EKBEH
Access table EKBEH




Table field list including key, data, relationships and ABAP select examples

EKBEH is a standard SAP Table which is used to store Removed PO History Records data and is available within R/3 SAP systems depending on the version and release level.

The EKBEH table consists of various fields, each holding specific information or linking keys about Removed PO History Records data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), ZEKKN (Sequential Number of Account Assignment), VGABE (Transaction/event type, purchase order history).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EKBEH table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
VGABETransaction/event type, purchase order history VGABECHAR1VGABE
GJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
BELNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
BUZEIItem in Material Document MBLPONUMC4MBLPOPOS
BEWTPPO history category BEWTPCHAR1T163BBEWTP
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
BUDATPosting Date in the Document BUDATDATS8DATUM
MENGEQuantity MENGE_DQUAN13(3) MENG13
BPMNGQuantity in purchase order price unit MENGE_BPRQUAN13(3) MENG13
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
AREWRGR/IR account clearing value in local currency AREWRCURR13(2) WERT7
WESBSGoods Receipt Blocked Stock in Order Unit WESBSQUAN13(3) MENG13
BPWESQuantity in GR blocked stock in order price unit BPWESQUAN13(3) MENG13
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
LFGJAFiscal Year of a Reference Document LFBJANUMC4GJAHRGJAHR
LFBNRDocument No. of a Reference Document LFBNRCHAR10ALPHABELNR
LFPOSItem of a Reference Document LFPOSNUMC4MBLPO
GRUNDReason for Movement MB_GRBEWNUMC4T157DMB_GRBEW
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
REEWRInvoice Value Entered (in Local Currency) REEWRCURR13(2) WRTV7
EVERECompliance with Shipping Instructions EVERECHAR2T027CEVERE
REFWRInvoice value in foreign currency REFWRCURR13(2) WRTV7
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
XWSBRReversal of GR allowed for GR-based IV despite invoice XWSBRCHAR1XFELD
ETENSSequential Number of Vendor Confirmation ETENSNUMC4NUM04
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
LSMNGQuantity in Unit of Measure from Delivery Note LSMNGQUAN13(3) MENG13
LSMEHUnit of Measure From Delivery Note LSMEHUNIT3T006CUNITMEINS
EMATNMaterial Number EMATNRCHAR18MARAMATN1MATNRMAT
AREWWClearing value on GR/IR clearing account (transac. currency) AREWWCURR13(2) WERT7
HSWAELocal currency key HSWAECUKY5TCURCWAERS
BAMNGQuantity MENGE_DQUAN13(3) MENG13
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
BLDATDocument Date in Document BLDATDATS8DATUM
XWOFFCalculation of val. open XWOFFCHAR1XFELD
XUNPLUnplanned Account Assignment from Invoice Verification XUNPLCHAR1XFELD
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
SRVPOSService number SRVPOSCHAR18Assigned to domainALPHAASNUM
PACKNOPackage Number of Service PACKNO_EKBENUMC10Assigned to domainPACKNO
INTROWLine Number of Service INTROW_EKBENUMC10INTROW
BEKKNNumber of PO Account Assignment BEKKNNUMC2NUM02
LEMINReturns Indicator SRVRETCHAR1XFELD
AREWBClearing Value on GR/IR Account in PO Currency AREWBCURR13(2) WERT7
REWRBInvoice Amount in PO Currency REWRBCURR13(2) WERT7
SAPRLSAP Release SAPRLCHAR4SAPRL
MENGE_POPQuantity MENGE_DQUAN13(3) MENG13
BPMNG_POPQuantity in purchase order price unit MENGE_BPRQUAN13(3) MENG13
DMBTR_POPAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTR_POPAmount in document currency WRBTRCURR13(2) WERT7
WESBBValuated Goods Receipt Blocked Stock in Order Unit WESBBQUAN13(3) MENG13
BPWEBQuantity in Valuated GR Blocked Stock in Order Price Unit BPWEBQUAN13(3) MENG13
WEORAAcceptance At Origin WEORACHAR1XFELD
AREWR_POPGR/IR account clearing value in local currency AREWRCURR13(2) WERT7
KUDIFExchange Rate Difference Amount KUDIFCURR13(2) WERT7
RETAMT_FCRetention Amount in Document Currency RET_AMT_FCCURR13(2) WERT7
RETAMT_LCRetention Amount in Company Code Currency RET_AMT_LCCURR13(2) WERT7
RETAMTP_FCPosted Retention Amount in Document Currency RET_AMT_POST_FCCURR13(2) WERT7
RETAMTP_LCPosted Security Retention Amount in Company Code Currency RET_AMT_POST_LCCURR13(2) WERT7
XMACCMultiple Account Assignment XMACCCHAR1CHAR1
WKURSExchange Rate WKURSDEC9(5) EXCRTKURSP
INV_ITEM_ORIGINOrigin of an Invoice Item INV_ITM_ORIGINCHAR1INV_ITM_ORIGIN
VBELN_STDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
VBELP_STDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
ET_UPDProcedure for Updating the Schedule Line Quantity ET_UPD1CHAR1ET_UPD1
.INCLU--AP 0
J_SC_DIE_COMP_FDepreciation completion flag /SAPNEA/J_SC_DIE_COMP_FCHAR1/SAPNEA/J_SC_DIE_COMP_F
.INCLU--AP 0
QTY_DIFFQuantity MENGE_QTYDIFFQUAN13(3) MENG13

Key field Non-key field



How do I retrieve data from SAP table EKBEH using ABAP code

The following ABAP code Example will allow you to do a basic selection on EKBEH to SELECT all data from the table
DATA: WA_EKBEH TYPE EKBEH.

SELECT SINGLE *
FROM EKBEH
INTO CORRESPONDING FIELDS OF WA_EKBEH
WHERE...

How to access SAP table EKBEH

Within an ECC or HANA version of SAP you can also view further information about EKBEH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!