SAP ABAP Table EBAN (Purchase Requisition)

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	TRANSP	Transparent table
Transparent table	EBAN	Table Relationship Diagram
Short Description	Purchase Requisition

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BANFN	☑	BANFN	BANFN	CHAR	10	0	Purchase requisition number
3	BNFPO	☑	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition
4	BSART	☐	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	*
5	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
6	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
7	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
8	STATU	☐	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
9	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
10	FRGKZ	☐	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	*
11	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
12	FRGST	☐	FRGST	FRGST	CHAR	2	0	Release strategy in the purchase requisition
13	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
14	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	ERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
17	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
18	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
19	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number
20	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
21	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
22	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
23	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
24	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
25	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
26	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	T006
27	BUMNG	☐	BUMNG	MENG13	QUAN	13	3	Shortage (stock undercoverage) quantity
28	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
29	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
30	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
31	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
32	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
33	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
34	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
35	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
36	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
37	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
38	KFLAG	☐	KFLAG	XFELD	CHAR	1	0	Acct.asst.changeable
39	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
40	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
41	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
42	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
43	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
44	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	LFA1
45	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
46	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
47	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
48	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
49	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
50	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
51	ZUGBA	☐	DZUGBA	XFELD	CHAR	1	0	Assigned Source of Supply
52	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
53	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
54	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
55	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
56	BVDAT	☐	BVDAT	DATUM	DATS	8	0	Date of last resubmission
57	BATOL	☐	BATOL	BATOL	DEC	3	0	Resubmission interval of purchase requisition
58	BVDRK	☐	BVDRK	ZAEHL	DEC	7	0	Number of resubmissions
59	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
60	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	EKPO
61	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
62	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
63	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	*
64	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
65	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
66	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
67	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
68	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
69	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
70	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
71	FIXKZ	☐	BAFIX	XFELD	CHAR	1	0	Purchase requisition is fixed
72	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
73	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
74	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
75	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
76	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
77	BPUEB	☐	BPUEB	BPUEB	CHAR	1	0	Adopt requisition price in purchase order
78	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
79	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	*
80	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
81	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion
82	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
83	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
84	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
85	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
86	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
87	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
88	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
89	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material
90	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
91	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
92	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
93	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
94	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	ADRC
95	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	*
96	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
97	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
98	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
99	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
100	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
101	GSFRG	☐	GSFRG	XFELD	CHAR	1	0	Overall release of purchase requisitions
102	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
103	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
104	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
105	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
106	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
107	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
108	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
109	FORDN	☐	SFORDN	EBELN	CHAR	10	0	Framework Order	*
110	FORDP	☐	FORDP	EBELP	NUMC	5	0	Item of framework order	*
111	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EBAN	ADRN2	ADRC	ADDRNUMBER
2	EBAN	ADRNR	ADRC	ADDRNUMBER	KEY	1	CN
3	EBAN	BMEIN	T006	MSEHI	REF	1	N
4	EBAN	EBELN	EKKO	EBELN	REF	1	N
5	EBAN	EBELP	EKPO	EBELP	REF	1	N
6	EBAN	EKGRP	T024	EKGRP	REF	1	N
7	EBAN	EKORG	T024E	EKORG	REF	1	N
8	EBAN	EMLIF	LFA1	LIFNR	REF	1	N
9	EBAN	FLIEF	LFA1	LIFNR	REF	1	N
10	EBAN	KONNR	EKKO	EBELN	REF	1	N
11	EBAN	KTPNR	EKPO	EBELP	REF	1	N
12	EBAN	LIFNR	LFA1	LIFNR	REF	1	N
13	EBAN	MANDT	T000	MANDT	KEY	1	N
14	EBAN	MATKL	T023	MATKL	REF	1	N
15	EBAN	MEINS	T006	MSEHI	REF	1	N
16	EBAN	MFRNR	LFA1	LIFNR
17	EBAN	RESWK	T001W	WERKS	REF	1	N
18	EBAN	SPRAS	T002	SPRAS	REF	1	N
19	EBAN	WAERS	TCURC	WAERS
20	EBAN	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130604
SAP Release Created in