SAP ABAP Table EKBNK (Purchasing Fields, Inventory Management, Delivery Costs)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	INTTAB	Structure
Structure	EKBNK	Table Relationship Diagram
Short Description	Purchasing Fields, Inventory Management, Delivery Costs

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
2	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
3	STUNR	☐	STUNR	STUNR	NUMC	3	0	Level Number	*
4	ZAEHK	☐	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
5	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
6	KWRFW	☐	KWERT	WERTV7	CURR	13	2	Condition Value
7	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
8	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
9	REWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
10	KVSL1	☐	KVSL1	KVSCHL	CHAR	3	0	Account key	T687
11	KVSL2	☐	KVSL2	KVSCHL	CHAR	3	0	Account key - accruals / provisions	T687
12	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
13	FRWMG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
14	FRWWR	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
15	FRWFR	☐	WEWWR	WERT7	CURR	13	2	Value of goods received in foreign currency
16	FRRMG	☐	REMNG	MENG13	QUAN	13	3	Quantity invoiced
17	FRRWR	☐	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
18	FRRFR	☐	REWWR	WERT7	CURR	13	2	Invoice Amount in Foreign Currency
19	FRAWE	☐	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
20	FRAWW	☐	AREWW	WERT7	CURR	13	2	Clearing value on GR/IR clearing account (transac. currency)
21	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
22	FRBNR	☐	FRBNR1	XBLNR1	CHAR	16	0	Number of Bill of Lading at Time of Goods Receipt
23	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
24	VTEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
25	BEWTP	☐	BEWTP	BEWTP	CHAR	1	0	Purchase Order History Category	*
26	FRERF	☐	FRERF	XFELD	CHAR	1	0	Vendor for delivery costs enterable at time of GR
27	NAWMG	☐	NAWMG	MENG13	QUAN	13	3	GR quantity, subsequent settlement
28	NAWWR	☐	NAWWR	WERT7	CURR	13	2	GR value, subsequent settlement
29	NAWFR	☐	WEWWR	WERT7	CURR	13	2	Value of goods received in foreign currency
30	FNWMG	☐	FNWMG	MENG13	QUAN	13	3	GR quantity: Miscellaneous provisions
31	FNWWR	☐	FNWWR	WERT7	CURR	13	2	GR value: Miscellaneous provisions
32	FNWFR	☐	WEWWR	WERT7	CURR	13	2	Value of goods received in foreign currency
33	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
34	VOBNK	☐	XVOBNK	XFELD	CHAR	1	0	Sign (+/-) for del. costs differs fr. that of goods movement
35	BPFRW	☐	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
36	BPFRR	☐	BPREM	MENG13	QUAN	13	3	Invoice receipt quantity in order price unit
37	BPNAW	☐	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
38	BPFNW	☐	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
39	XBPRM	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
40	VNETW	☐	VNETWR	WERT7	CURR	13	2	Net value of condition (predefined externally)
41	VMENG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
42	BNKTK	☐	VF_BNKTK	VF_BNKTK	CHAR	1	0	Copy delivery costs from shipment costs document
43	PREDC	☐	PREDC	XFELD	CHAR	1	0	Parked Delivery Costs Exist
44	FRAWB	☐	FRAWB	WERT7	CURR	13	2	Clearing Value on GR/IR Account in PO Currency
45	FRRWB	☐	FRRWB	WERT7	CURR	13	2	Invoice Amount in PO Currency
46	XBESW	☐	XBESW	XFELD	CHAR	1	0	Indicator: Update in PO Currency
47	KUDIF	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
48	KUDIF_GR	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
49	KUDIF_IR	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
50	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
51	XHISTMA	☐	XHISTMA	CHAR1	CHAR	1	0	Update Multiple Account Assignment EKBE_MA, EKBZ_MA
52	WKURS_GR	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
53	WKURS_IR	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
54	PARKED_QTY	☐	PARKED_QTY	MENG13	QUAN	13	3	Parked Invoice Quantity
55	FRWMG_ABD	☐	WEMNG_ABD	FLTP	FLTP	16	16	Goods Receipt Quantity for Amount-Based Distribution
56	FRRMG_ABD	☐	REMNG_ABD	FLTP	FLTP	16	16	Invoice Receipt Quantity for Amount-Based Distribution
57	BPFRW_ABD	☐	BPWEM_ABD	FLTP	FLTP	16	16	GR Quantity in Purchase Order Price Unit for Dist. by Amount
58	BPFRR_ABD	☐	BPREM_ABD	FLTP	FLTP	16	16	IR Qty in Order Price Unit for Amount-Based Distribution
59	BPNAW_ABD	☐	BPWEM_ABD	FLTP	FLTP	16	16	GR Quantity in Purchase Order Price Unit for Dist. by Amount
60	FNWMG_ABD	☐	FNWMG_ABD	FLTP	FLTP	16	16	GR Quantity Miscellaneous Provisions Distribution by Amount
61	BPFNW_ABD	☐	BPWEM_ABD	FLTP	FLTP	16	16	GR Quantity in Purchase Order Price Unit for Dist. by Amount
62	MAA_BNK_KONV	☐	MAA_BNK_KONV	CHAR1	CHAR	1	0	Convert Del. Costs from Table KONV, Cond. Amt (Note 1027899)
63	.INCLU--AP	☐				0	0	Additional Fields Volume-Based Rebate
64	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKBNK	EBELN	EKKO	EBELN
2	EKBNK	EBELP	EKPO	EBELP
3	EKBNK	KVSL1	T687	KVSL1
4	EKBNK	KVSL2	T687	KVSL1
5	EKBNK	LIFNR	LFA1	LIFNR
6	EKBNK	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in