SAP ABAP Table EBEFU (Purchasing Fields, Inventory Management)

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	EBEFU	Table Relationship Diagram
Short Description	Purchasing Fields, Inventory Management

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	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
4	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
8	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
9	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
10	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
11	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
12	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
13	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
14	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
15	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
16	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
17	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
18	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
19	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
20	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
21	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
22	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
23	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
24	LFBJA	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
25	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
26	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
27	KONTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
28	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
29	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
30	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
31	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
32	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
33	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
34	KZBRB	☐	KZBRB	CHAR1	CHAR	1	0	Gross requirements indicator
35	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
36	ANLN2	☐	ANLN2_4	ANLN2_4	CHAR	4	0	New asset subnumber, 4 characters
37	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
38	AUFPS	☐	AUFPS	CHAR2	CHAR	2	0	Order item number
39	AUPFD	☐	AUPFD	AUPFD	CHAR	2	0	Alternative operation sequence/path
40	AUFAV	☐	AUFAV	AUFAV	CHAR	4	0	Order Operation
41	AUFKM	☐	AUFKM	AUFKM	NUMC	4	0	Bill of Material component in order
42	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level
43	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
44	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
45	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
46	BSMNG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
47	NETWR	☐	BSTWR	WERT7	CURR	13	2	Net order value in document currency
48	NETWW	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
49	UETMG	☐	UETMG	MENG13	QUAN	13	3	Overdelivery tolerance (quantity)
50	UNTMG	☐	UNTMG	MENG13	QUAN	13	3	Underdelivery Tolerance (Quantity)
51	GLMNG	☐	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
52	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
53	WESBS	☐	WESBS	MENG13	QUAN	13	3	Goods receipt blocked stock in order unit
54	LWSBS	☐	LWSBS	MENG13	QUAN	13	3	GR blocked stock in order unit per shipping notif. item
55	BPWES	☐	BPWES	MENG13	QUAN	13	3	Quantity in GR blocked stock in order price unit
56	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
57	BPWEM	☐	BPWEM	MENG13	QUAN	13	3	Goods receipt quantity in order unit
58	WEMMG	☐	WEMMG	MENG13V	QUAN	13	3	Non-valuated goods receipt quantity
59	BPWMM	☐	BPWMM	MENG13V	QUAN	13	3	Non-valuated goods receipt quantity in order price unit
60	WEWRT	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
61	WEWWR	☐	WEWWR	WERT7	CURR	13	2	Value of goods received in foreign currency
62	REMNG	☐	REMNG	MENG13	QUAN	13	3	Quantity invoiced
63	BPREM	☐	BPREM	MENG13	QUAN	13	3	Invoice receipt quantity in order price unit
64	REWRT	☐	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
65	REWWR	☐	REWWR	WERT7	CURR	13	2	Invoice Amount in Foreign Currency
66	AREWR	☐	AREWR	WERT7	CURR	13	2	GR/IR account clearing value in local currency
67	AREWW	☐	AREWW	WERT7	CURR	13	2	Clearing value on GR/IR clearing account (transac. currency)
68	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
69	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
70	MULKO	☐	MULKO	XFELD	CHAR	1	0	Indicator: Multiple account assignment
71	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	*
72	INSNC	☐	INSNC	XFELD	CHAR	1	0	Quality inspection indicator cannot be changed
73	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	*
74	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	*
75	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
76	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
77	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
78	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
79	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
80	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
81	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
82	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
83	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
84	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
85	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
86	KO_GSBER	☐	GSBER_GP	GSBER	CHAR	4	0	Business area reported to the partner	*
87	KO_PARGB	☐	PARGB_GP	GSBER	CHAR	4	0	assumed business area of the business partner	*
88	KO_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
89	KO_PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
90	LAMNG	☐	BBMNG	MENGE	QUAN	13	3	Quantity as Per Vendor Confirmation
91	LWMNG	☐	DABMG	MENGE	QUAN	13	3	Quantity Reduced (MRP)
92	LEINDT	☐	BBEIN	DATUM	DATS	8	0	Delivery Date of Vendor Confirmation
93	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
94	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
95	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
96	UEBPO	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	*
97	ETENS	☐	ETENS	NUM04	NUMC	4	0	Sequential Number of Vendor Confirmation
98	LEWED	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
99	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
100	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
101	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
102	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
103	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
104	.INCLUDE	☐				0	0
105	ERFMG	☐	BERFM	MENG13	QUAN	13	3	Quantity entered for goods receipt in order unit
106	BPMNG	☐	BERFB	MENG13	QUAN	13	3	Quantity entered for goods receipt in order price unit
107	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
108	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
109	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	*
110	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	*
111	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
112	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
113	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
114	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
115	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
116	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
117	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
118	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
119	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
120	VKWRA	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
121	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
122	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
123	UPVOR	☐	UPVOR	CHAR1	CHAR	1	0	Subitems Exist
124	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	*
125	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
126	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
127	LTSSF	☐	LTSSF	NUMC5	NUMC	5	0	Sort Sequence Number
128	AUREL	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
129	LFRET	☐	LFRET	LFART	CHAR	4	0	Delivery Type for Returns to Vendors	*
130	XBNSB	☐	XBNSB	XFELD	CHAR	1	0	Debit delivery costs separately
131	REWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
132	KZFME	☐	KZFME	KZFME	CHAR	1	0	ID: Leading unit of measure for completing a transaction
133	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
134	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
135	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
136	RETAR	☐	RETAR	RETAR	CHAR	1	0	Returns type
137	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
138	AUFPL_ORD	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
139	APLZL_ORD	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
140	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
141	PRERR	☐	PRERR	CHAR12	CHAR	12	0	Price determination error at time of goods receipt
142	MTUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
143	NFVAL	☐	J_1BNETVAL	WERTV8	CURR	15	2	Net Value
144	FRLFD	☐	FRLFD	DATUM	DATS	8	0	Earliest delivery date
145	VBELN_VL	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
146	VBELP_VL	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
147	NOQTY	☐	NOQTY	CHAR01	CHAR	1	0	Do not calculate default quantity
148	GWEMG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
149	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
150	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
151	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
152	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
153	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
154	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
155	WESBB	☐	WESBB	MENG13	QUAN	13	3	Valuated Goods Receipt Blocked Stock in Order Unit
156	BPWEB	☐	BPWEB	MENG13	QUAN	13	3	Quantity in Valuated GR Blocked Stock in Order Price Unit
157	LWSBB	☐	LWSBB	MENG13	QUAN	13	3	Val. GR Blocked Stock in Order Unit per Shipping Notif. Item
158	WEORA	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
159	WEORA_EKBE	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
160	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
161	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
162	KUDIF	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
163	KUDIF_GR	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
164	KUDIF_IR	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
165	.INCLUDE	☐				0	0	Erweiterungsfelder der Bestellung (nur Position)
166	DUMMY2	☐	XFELD	XFELD	CHAR	1	0	Checkbox
167	.INCLUDE	☐				0	0	Enhancement Fields for Purchase Order (Item and Header)
168	DUMMY3	☐	XFELD	XFELD	CHAR	1	0	Checkbox
169	.INCLUDE	☐				0	0	SRM Fields in Purchase Order Item
170	EXLIN	☐	EXLIN	EXLIN	CHAR	40	0	Item Number Length
171	EXSNR	☐	EXSNR	EXSNR	NUMC	5	0	External Sorting
172	EHTYP	☐	EHTYP	EHTYP	CHAR	4	0	External Hierarchy Category	TMSRM_EHTYP
173	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
174	XHISTMA	☐	XHISTMA	CHAR1	CHAR	1	0	Update Multiple Account Assignment EKBE_MA, EKBZ_MA
175	REMNG_F	☐	MENGE_F		FLTP	16	16	Quantity (Floating Point Number - Internal Field)
176	BPREM_F	☐	MENGE_F		FLTP	16	16	Quantity (Floating Point Number - Internal Field)
177	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
178	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
179	CO_ORDER	☐	ME_IR_CO_ORDER	XFELD	CHAR	1	0	Real-Time Consumption Posting of Subcontracting Components
180	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
181	XDINV	☐	XDINV	CHAR1	CHAR	1	0	Indicator for Differential Invoicing
182	GWEBS	☐	WESBS	MENG13	QUAN	13	3	Goods receipt blocked stock in order unit
183	GWEBB	☐	WESBB	MENG13	QUAN	13	3	Valuated Goods Receipt Blocked Stock in Order Unit
184	WABWE	☐	WABWE	XFELD	CHAR	1	0	Indicator for GI-based goods receipt
185	.INCLU--AP	☐				0	0	Seas. Proc.: Append to EBEFU for Consignment Stock Transfers
186	.INCLUDE	☐				0	0	Seasonal Procurement: Include for Consignment Processing
187	CONS_ORDER	☐	WRF_CONS_ORDER	WRF_CONS_ORDER	CHAR	1	0	Purchase Order for Consignment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EBEFU	ANLN1	ANLH	ANLN1
2	EBEFU	AUFNR	AUFK	AUFNR
3	EBEFU	BPRME	T006	MSEHI
4	EBEFU	BSTME	T006	MSEHI
5	EBEFU	BWTAR	T149D	BWTAR
6	EBEFU	EBELN	EKKO	EBELN
7	EBEFU	EBELP	EKPO	EBELP
8	EBEFU	EHTYP	TMSRM_EHTYP	EHTYP
9	EBEFU	GSBER	TGSB	GSBER
10	EBEFU	KDAUF	VBUK	VBELN
11	EBEFU	KNTTP	T163K	KNTTP
12	EBEFU	KONTO	SKA1	SAKNR
13	EBEFU	KOSTL	CSKS	KOSTL
14	EBEFU	LGORT	T001L	LGORT
15	EBEFU	MATNR	MARA	MATNR
16	EBEFU	PSTYP	T163	PSTYP
17	EBEFU	SOBKZ	T148	SOBKZ
18	EBEFU	WAERS	TCURC	WAERS
19	EBEFU	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in