EKBZ SAP (History per Purchasing Document: Delivery Costs) Table details

Dictionary Type: Table
Description: History per Purchasing Document: Delivery Costs




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




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

EKBZ is a standard SAP Table which is used to store History per Purchasing Document: Delivery Costs data and is available within R/3 SAP systems depending on the version and release level.

The EKBZ table consists of various fields, each holding specific information or linking keys about History per Purchasing Document: Delivery Costs data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), STUNR (Step number), ZAEHK (Condition counter).. 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 EKBZ 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 MANDTCLNT3T000MANDT
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
STUNRStep number STUNRNUMC3Assigned to domainSTUNR
ZAEHKCondition counter DZAEHKNUMC2ZAEHK
VGABETransaction/event type, purchase order history VGABECHAR1VGABE
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEIItem in Material Document MBLPONUMC4MBLPOPOS
BEWTPPO history category BEWTPCHAR1Assigned to domainBEWTP
BUDATPosting Date in the Document BUDATDATS8DATUM
MENGEQuantity MENGE_DQUAN13(3) MENG13
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
AREWRGR/IR account clearing value in local currency AREWRCURR13(2) WERT7
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
FRBNRNumber of Bill of Lading at Time of Goods Receipt FRBNR1CHAR16XBLNR1
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
REEWRInvoice Value Entered (in Local Currency) REEWRCURR13(2) WRTV7
REFWRInvoice value in foreign currency REFWRCURR13(2) WRTV7
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
KSCHLCondition Type KSCHLCHAR4Assigned to domainKSCHLVKS
BPMNGQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
AREWWClearing value on GR/IR clearing account (transac. currency) AREWWCURR13(2) WERT7
HSWAELocal currency key HSWAECUKY5Assigned to domainWAERS
VNETWNet value of condition (predefined externally) VNETWRCURR13(2) WERT7
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
SHKKODebit/Credit Indicator SHKZGCHAR1SHKZG
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
DMBTR_POPAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTR_POPAmount in document currency WRBTRCURR13(2) WERT7
BPMNG_POPQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
AREWR_POPGR/IR account clearing value in local currency AREWRCURR13(2) WERT7
KUDIFExchange Rate Difference Amount KUDIFCURR13(2) WERT7
XMACCMultiple Account Assignment XMACCCHAR1CHAR1
WKURSExchange Rate WKURSDEC9(5) EXCRTKURSP

Key field Non-key field



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

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

SELECT SINGLE *
FROM EKBZ
INTO CORRESPONDING FIELDS OF WA_EKBZ
WHERE...

How to access SAP table EKBZ

Within an ECC or HANA version of SAP you can also view further information about EKBZ 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!