EKBNK SAP (Purchasing Fields, Inventory Management, Delivery Costs) Structure details

Dictionary Type: Structure
Description: Purchasing Fields, Inventory Management, Delivery Costs




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




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

EKBNK is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Purchasing Fields, Inventory Management, Delivery Costs" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_EKBNK TYPE EKBNK.

The EKBNK table consists of various fields, each holding specific information or linking keys about Purchasing Fields, Inventory Management, Delivery Costs data available in SAP. These include EBELP (Item Number of Purchasing Document), STUNR (Step number), ZAEHK (Condition counter), KWERT (Condition value).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EKBNK structure 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
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
STUNRStep number STUNRNUMC3Assigned to domainSTUNR
ZAEHKCondition counter DZAEHKNUMC2ZAEHK
KWERTCondition value KWERTCURR13(2) WERTV7
KWRFWCondition value KWERTCURR13(2) WERTV7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
REWAECurrency Key WAERSCUKY5Assigned to domainWAERSFWS
KVSL1Account key KVSL1CHAR3T687KVSCHL
KVSL2Account key - accruals / provisions KVSL2CHAR3T687KVSCHL
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
FRWMGQuantity of Goods Received WEMNGQUAN13(3) MENG13
FRWWRValue of goods received in local currency WEWRTCURR13(2) WERT7
FRWFRValue of goods received in foreign currency WEWWRCURR13(2) WERT7
FRRMGQuantity invoiced REMNGQUAN13(3) MENG13
FRRWRInvoice value in local currency REWRTCURR13(2) WRTV7
FRRFRInvoice Amount in Foreign Currency REWWRCURR13(2) WERT7
FRAWEInvoice value in local currency REWRTCURR13(2) WRTV7
FRAWWClearing value on GR/IR clearing account (transac. currency) AREWWCURR13(2) WERT7
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
FRBNRNumber of Bill of Lading at Time of Goods Receipt FRBNR1CHAR16XBLNR1
KSCHLCondition Type KSCHLCHAR4Assigned to domainKSCHLVKS
VTEXTDescription VTEXTCHAR20TEXT20
BEWTPPO history category BEWTPCHAR1Assigned to domainBEWTP
FRERFVendor for delivery costs enterable at time of GR FRERFCHAR1XFELD
NAWMGGR quantity, subsequent settlement NAWMGQUAN13(3) MENG13
NAWWRGR value, subsequent settlement NAWWRCURR13(2) WERT7
NAWFRValue of goods received in foreign currency WEWWRCURR13(2) WERT7
FNWMGGR quantity: Miscellaneous provisions FNWMGQUAN13(3) MENG13
FNWWRGR value: Miscellaneous provisions FNWWRCURR13(2) WERT7
FNWFRValue of goods received in foreign currency WEWWRCURR13(2) WERT7
RETPOReturns Item RETPOCHAR1XFELD
VOBNKSign (+/-) for del. costs differs fr. that of goods movement XVOBNKCHAR1XFELD
BPFRWGoods Receipt Quantity in Purchase Order Price Unit BPWEMQUAN13(3) MENG13
BPFRRInvoice receipt quantity in order price unit BPREMQUAN13(3) MENG13
BPNAWGoods Receipt Quantity in Purchase Order Price Unit BPWEMQUAN13(3) MENG13
BPFNWGoods Receipt Quantity in Purchase Order Price Unit BPWEMQUAN13(3) MENG13
XBPRMNew Input Values XFLAGCHAR1XFLAG
VNETWNet value of condition (predefined externally) VNETWRCURR13(2) WERT7
VMENGQuantity of Goods Received WEMNGQUAN13(3) MENG13
BNKTKCopy delivery costs from shipment costs document VF_BNKTKCHAR1VF_BNKTK
PREDCParked Delivery Costs Exist PREDCCHAR1XFELD
FRAWBClearing Value on GR/IR Account in PO Currency FRAWBCURR13(2) WERT7
FRRWBInvoice Amount in PO Currency FRRWBCURR13(2) WERT7
XBESWIndicator: Update in PO Currency XBESWCHAR1XFELD
KUDIFExchange Rate Difference Amount KUDIFCURR13(2) WERT7
KUDIF_GRExchange Rate Difference Amount KUDIFCURR13(2) WERT7
KUDIF_IRExchange Rate Difference Amount KUDIFCURR13(2) WERT7
KUFIXIndicator: Fixing of Exchange Rate KUFIXCHAR1XFELD
XHISTMAUpdate Multiple Account Assignment EKBE_MA, EKBZ_MA XHISTMACHAR1CHAR1
WKURS_GRExchange Rate WKURSDEC9(5) EXCRTKURSP
WKURS_IRExchange Rate WKURSDEC9(5) EXCRTKURSP
PARKED_QTYParked Invoice Quantity PARKED_QTYQUAN13(3) MENG13
FRWMG_ABDGoods Receipt Quantity for Amount-Based Distribution WEMNG_ABDFLTP16(16) FLTP
FRRMG_ABDInvoice Receipt Quantity for Amount-Based Distribution REMNG_ABDFLTP16(16) FLTP
BPFRW_ABDGR Quantity in Purchase Order Price Unit for Dist. by Amount BPWEM_ABDFLTP16(16) FLTP
BPFRR_ABDIR Qty in Order Price Unit for Amount-Based Distribution BPREM_ABDFLTP16(16) FLTP
BPNAW_ABDGR Quantity in Purchase Order Price Unit for Dist. by Amount BPWEM_ABDFLTP16(16) FLTP
FNWMG_ABDGR Quantity Miscellaneous Provisions Distribution by Amount FNWMG_ABDFLTP16(16) FLTP
BPFNW_ABDGR Quantity in Purchase Order Price Unit for Dist. by Amount BPWEM_ABDFLTP16(16) FLTP
MAA_BNK_KONVConvert Del. Costs from Table KONV, Cond. Amt (Note 1027899) MAA_BNK_KONVCHAR1CHAR1
.INCLU--AP 0
KNUMHCondition record number KNUMHCHAR10KNUMB

Key field Non-key field



How do I retrieve data from SAP structure EKBNK using ABAP code?

As EKBNK is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on EKBNK as there is no data to select.

How to access SAP table EKBNK

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