SAP ABAP Table EBAN1 (Reactivated structure to read in 2.2 archive prod. order)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC-CPL (Application Component) Order Closing
     ⤷ CORE (Package) Archiving for application area PP

Basic Data

Table Category	INTTAB	Structure
Structure	EBAN1	Table Relationship Diagram
Short Description	Reactivated structure to read in 2.2 archive prod. order

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	.INCLUDE	☐				0	0	Purchase Requisition
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
4	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
5	BSART	☐	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	T161
6	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
7	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
8	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
9	STATU	☐	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
10	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
11	FRGKZ	☐	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	T161S
12	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
13	FRGST	☐	FRGST	FRGST	CHAR	2	0	Release strategy in the purchase requisition
14	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
15	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
16	ERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
18	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
19	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
20	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
21	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
22	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
23	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
24	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
25	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
26	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
27	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	T006
28	BUMNG	☐	BUMNG	MENG13	QUAN	13	3	Shortage (stock undercoverage) quantity
29	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
30	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	TPRG
31	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
32	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
33	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
34	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
35	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
36	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
37	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
38	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
39	KFLAG	☐	KFLAG	XFELD	CHAR	1	0	Acct.asst.changeable
40	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
41	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
42	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
43	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
44	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
45	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	LFA1
46	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
47	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
48	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
49	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
50	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
51	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
52	ZUGBA	☐	DZUGBA	XFELD	CHAR	1	0	Assigned Source of Supply
53	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
54	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
55	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
56	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
57	BVDAT	☐	BVDAT	DATUM	DATS	8	0	Date of last resubmission
58	BATOL	☐	BATOL	BATOL	DEC	3	0	Resubmission interval of purchase requisition
59	BVDRK	☐	BVDRK	ZAEHL	DEC	7	0	Number of resubmissions
60	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
61	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	EKPO
62	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
63	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
64	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	ESSR
65	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
66	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
67	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
68	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
69	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
70	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
71	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
72	FIXKZ	☐	BAFIX	XFELD	CHAR	1	0	Purchase requisition is fixed
73	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
74	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
75	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
76	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
77	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
78	BPUEB	☐	BPUEB	BPUEB	CHAR	1	0	Adopt requisition price in purchase order
79	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
80	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	T16FG
81	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
82	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
83	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
84	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
85	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
86	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
87	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
88	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
89	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
90	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
91	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
92	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
93	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
94	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
95	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	ADRC
96	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	KNA1
97	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
98	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
99	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
100	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
101	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
102	GSFRG	☐	GSFRG	XFELD	CHAR	1	0	Overall release of purchase requisitions
103	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
104	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
105	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
106	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
107	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
108	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
109	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
110	FORDN	☐	SFORDN	EBELN	CHAR	10	0	Framework Order	*
111	FORDP	☐	FORDP	EBELP	NUMC	5	0	Item of framework order	*
112	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
113	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
114	UZEIT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot
115	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
116	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
117	MEMORY	☐	MEMBF	XFELD	CHAR	1	0	Purchase Requisition not yet Complete
118	BANPR	☐	BANPR	BANPR	CHAR	2	0	Requisition Processing State
119	RLWRT	☐	RLWRT	WERT15	CURR	15	2	Total value at time of release
120	BLCKD	☐	BLCKD	BLCKD	CHAR	1	0	Purchase Requisition Blocked
121	REVNO	☐	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
122	BLCKT	☐	BLCKT	CHAR60K	CHAR	60	0	Reason for Item Block
123	BESWK	☐	BESWK	WERKS	CHAR	4	0	Procuring Plant	T001W
124	EPROFILE	☐	MEPROFILE	EPROFILE	CHAR	2	0	External Procurement Profile
125	EPREFDOC	☐	EPREFDOC	EPREFDOC	CHAR	10	0	External Procurement Reference Document
126	EPREFITM	☐	EPREFITM	EPREFITM	NUMC	5	0	External Procurement Reference Item
127	GMMNG	☐	GMMNG	MENG13	QUAN	13	3	PO Quantity of Purchase Requisition in POs on Hold
128	WRTKZ	☐	WRTKZ	XFELD	CHAR	1	0	Value-Based Commitment Reduction for Service Purchase Reqs
129	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
130	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
131	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
132	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
133	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
134	MEMORYTYPE	☐	MEMORYTYPE	MM_MEMORYTYPE	CHAR	1	0	Category of Incompleteness
135	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
136	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
137	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
138	NODISP	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
139	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
140	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
141	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
142	.INCLUDE	☐				0	0
143	.INCLU--AP	☐				0	0	Append to EBAN for DFPS
144	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code	/ISDFPS/ADVCODE2
145	STACODE	☐	/ISDFPS/STACODE	/ISDFPS/STACODE	CHAR	2	0	Status Code	/ISDFPS/CSTACODE
146	.INCLU--AP	☐				0	0	DFPS: EBAN Enhancement (Cross System)
147	.INCLUDE	☐				0	0	DFPS: EBAN Enhancement (Cross System), Append Structure
148	BANFN_CS	☐	/ISDFPS/BANFN_CS	BANFN	CHAR	10	0	Cross-System PReq Number
149	BNFPO_CS	☐	/ISDFPS/BNFPO_CS	BNFPO	NUMC	5	0	Cross-System PReq Item	*
150	ITEM_CS	☐	/ISDFPS/ITEM_CS	/ISDFPS/ITEM_CS	CHAR	1	0	Cross-System Item Category
151	BSMNG_SND	☐	/ISDFPS/BSMNG_SND	MENG13	QUAN	13	3	PO Quantity Sender
152	.INCLU--AP	☐				0	0	IUID Append
153	IUID_RELEVANT	☐	IUID_RELEVANT	UID_RELEVANT	CHAR	1	0	IUID-Relevant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EBAN1	ADRN2	ADRC	ADDRNUMBER
2	EBAN1	ADRNR	ADRC	ADDRNUMBER
3	EBAN1	ADVCODE	/ISDFPS/ADVCODE2	ADVCODE
4	EBAN1	AKTNR	WAKH	AKTNR	KEY	1	N
5	EBAN1	BESWK	T001W	WERKS	REF	1	N
6	EBAN1	BMEIN	T006	MSEHI	REF	1	N
7	EBAN1	BSART	T161	BSART	REF	1	N
8	EBAN1	BWTAR	T149D	BWTAR	REF	1	N
9	EBAN1	DISPO	T024D	DISPO	REF	1	N
10	EBAN1	EBELN	EKKO	EBELN	REF	1	N
11	EBAN1	EBELP	EKPO	EBELP	REF	1	N
12	EBAN1	EKGRP	T024	EKGRP	REF	1	N
13	EBAN1	EKORG	T024E	EKORG	REF	1	N
14	EBAN1	EMATN	MARA	MATNR	REF	1	N
15	EBAN1	EMLIF	LFA1	LIFNR	REF	1	N
16	EBAN1	FLIEF	LFA1	LIFNR	REF	1	N
17	EBAN1	FRGGR	T16FG	FRGGR	REF	1	CN
18	EBAN1	FRGKZ	T161S	FRGKZ	REF	1	CN
19	EBAN1	INFNR	EINA	INFNR	REF	1	N
20	EBAN1	KNTTP	T163K	KNTTP	REF	1	N
21	EBAN1	KONNR	EKKO	EBELN	REF	1	N
22	EBAN1	KTPNR	EKPO	EBELP	REF	1	N
23	EBAN1	KUNNR	KNA1	KUNNR	REF	1	N
24	EBAN1	LBLNI	ESSR	LBLNI	KEY	1	N
25	EBAN1	LGORT	T001L	LGORT	REF	1	N
26	EBAN1	LIFNR	LFA1	LIFNR	REF	1	N
27	EBAN1	LPEIN	TPRG	PRGBZ	REF	1	N
28	EBAN1	MANDT	T000	MANDT	KEY	1	N
29	EBAN1	MATKL	T023	MATKL	REF	1	N
30	EBAN1	MATNR	MARA	MATNR	REF	1	N
31	EBAN1	MEINS	T006	MSEHI	REF	1	N
32	EBAN1	MFRNR	LFA1	LIFNR
33	EBAN1	PACKNO	ESLH	PACKNO	KEY	1	N
34	EBAN1	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
35	EBAN1	PRIO_URG	PURG	PRIO_URG	REF	1	CN
36	EBAN1	PSTYP	T163	PSTYP	REF	1	N
37	EBAN1	SOBKZ	T148	SOBKZ	REF	1	N
38	EBAN1	SPRAS	T002	SPRAS	REF	1	N
39	EBAN1	STACODE	/ISDFPS/CSTACODE	STACODE
40	EBAN1	WAERS	TCURC	WAERS
41	EBAN1	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in