	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

161 COLUMNS | 7 INDEXES | ERP 6.0 | EBAN TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Purchasing
1	ERP EHP7	6.0	EBAN	161	7	Purchase Requisition	Purchasing

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BANFN, BNFPO, BSART, BSTYP, BSAKZ, LOEKZ, STATU, ESTKZ, FRGKZ, FRGZU, FRGST, EKGRP, ERNAM, ERDAT, AFNAM, TXZ01, MATNR, EMATN, WERKS, LGORT, BEDNR, MATKL, RESWK, MENGE, MEINS, BUMNG, BADAT, LPEIN, LFDAT, FRGDT, WEBAZ, PREIS, PEINH, PSTYP, KNTTP, KZVBR, KFLAG, VRTKZ, TWRKZ, WEPOS, WEUNB, REPOS, LIFNR, FLIEF, EKORG, VRTYP, KONNR, KTPNR, INFNR, ZUGBA, QUNUM, QUPOS, DISPO, SERNR, BVDAT, BATOL, BVDRK, EBELN, EBELP, BEDAT, BSMNG, LBLNI, BWTAR, XOBLR, EBAKZ, RSNUM, SOBKZ, ARSNR, ARSPS, FIXKZ, BMEIN, REVLV, VORAB, PACKNO, KANBA, BPUEB, CUOBJ, FRGGR, FRGRL, AKTNR, CHARG, UMSOK, VERID, FIPOS, FISTL, GEBER, KZKFG, SATNR, MNG02, DAT01, ATTYP, ADRNR, ADRN2, KUNNR, EMLIF, LBLKZ, KZBWS, WAERS, IDNLF, GSFRG, MPROF, KZFME, SPRAS, TECHS, MFRPN, MFRNR, EMNFR, FORDN, FORDP, PLIFZ, BERID, UZEIT, FKBER, GRANT_NBR, MEMORY, BANPR, RLWRT, BLCKD, REVNO, BLCKT, BESWK, EPROFILE, EPREFDOC, EPREFITM, GMMNG, WRTKZ, RESLO, KBLNR, KBLPOS, PRIO_URG, PRIO_REQ, MEMORYTYPE, ANZSN, MHDRZ, IPRKZ, NODISP, SRM_CONTRACT_ID, SRM_CONTRACT_ITM, BUDGET_PD, FMFGUS_KEY, ADVCODE, STACODE, BANFN_CS, BNFPO_CS, ITEM_CS, BSMNG_SND, NO_MARD_DATA, SERRU, DISUB_SOBKZ, DISUB_PSPNR, DISUB_KUNNR, DISUB_VBELN, DISUB_POSNR, DISUB_OWNER, IUID_RELEVANT, SGT_SCAT, SGT_RCAT, WRF_CHARSTC1, WRF_CHARSTC2, WRF_CHARSTC3 FROM EBAN

TOP ERP 6.0 | EBAN COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	BANFN	Purchase Requisition Number	nvarchar	10	0	CHAR	(N' ')	No		BANFN	Allow NULL?
3	BNFPO	Item Number of Purchase Requisition	nvarchar	5	0	NUMC	(N'00000')	No		BNFPO	Allow NULL?
4	BSART	Purchase Requisition Document Type	nvarchar	4	0	CHAR	(N' ')	Yes	T161	BBSRT	Allow NULL?
5	BSTYP	Purchasing Document Category	char	1	0	CHAR	(N' ')	Yes		BSTYP	Allow NULL?
6	BSAKZ	Control indicator for purchasing document type	char	1	0	CHAR	(N' ')	Yes		BSAKZ	Allow NULL?
7	LOEKZ	Deletion Indicator in Purchasing Document	char	1	0	CHAR	(N' ')	Yes		ELOEK	Allow NULL?
8	STATU	Processing status of purchase requisition	char	1	0	CHAR	(N' ')	Yes		BANST	Allow NULL?
9	ESTKZ	Creation Indicator (Purchase Requisition/Schedule Lines)	char	1	0	CHAR	(N' ')	Yes		ESTKZ	Allow NULL?
10	FRGKZ	Release Indicator	char	1	0	CHAR	(N' ')	Yes	T161S	FRGKZ	Allow NULL?
11	FRGZU	Release status	nvarchar	8	0	CHAR	(N' ')	Yes		FRGZU	Allow NULL?
12	FRGST	Release Strategy in Purchase Requisition	nvarchar	2	0	CHAR	(N' ')	Yes		FRGST	Allow NULL?
13	EKGRP	Purchasing Group	nvarchar	3	0	CHAR	(N' ')	Yes	T024	EKGRP	Allow NULL?
14	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
15	ERDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
16	AFNAM	Name of Requisitioner/Requester	nvarchar	12	0	CHAR	(N' ')	Yes		AFNAM	Allow NULL?
17	TXZ01	Short Text	nvarchar	40	0	CHAR	(N' ')	Yes		TXZ01	Allow NULL?
18	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
19	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	EMATN	Allow NULL?
20	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	EWERK	Allow NULL?
21	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
22	BEDNR	Requirement Tracking Number	nvarchar	10	0	CHAR	(N' ')	Yes		BEDNR	Allow NULL?
23	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
24	RESWK	Supplying (Issuing) Plant in Stock Transport Order	nvarchar	4	0	CHAR	(N' ')	Yes	*	RESWK	Allow NULL?
25	MENGE	Purchase Requisition Quantity	decimal	13	3	QUAN	((0))	Yes		BAMNG
26	MEINS	Purchase Requisition Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BAMEI	Allow NULL?
27	BUMNG	Shortage (stock undercoverage) quantity	decimal	13	3	QUAN	((0))	Yes		BUMNG
28	BADAT	Requisition (Request) Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BADAT	Allow NULL?
29	LPEIN	Category of Delivery Date	char	1	0	CHAR	(N' ')	Yes	TPRG	LPEIN	Allow NULL?
30	LFDAT	Item Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		EINDT	Allow NULL?
31	FRGDT	Purchase Requisition Release Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FRGDT	Allow NULL?
32	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0	DEC	((0))	Yes		WEBAZ
33	PREIS	Price in Purchase Requisition	decimal	11	2	CURR	((0))	Yes		BAPRE
34	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		EPEIN
35	PSTYP	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	T163	PSTYP	Allow NULL?
36	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
37	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
38	KFLAG	Acct.asst.changeable	char	1	0	CHAR	(N' ')	Yes		KFLAG	Allow NULL?
39	VRTKZ	Distribution indicator for multiple account assignment	char	1	0	CHAR	(N' ')	Yes		VRTKZ	Allow NULL?
40	TWRKZ	Partial Invoice Indicator	char	1	0	CHAR	(N' ')	Yes		TWRKZ	Allow NULL?
41	WEPOS	Goods Receipt Indicator	char	1	0	CHAR	(N' ')	Yes		WEPOS	Allow NULL?
42	WEUNB	Goods Receipt, Non-Valuated	char	1	0	CHAR	(N' ')	Yes		WEUNB	Allow NULL?
43	REPOS	Invoice Receipt Indicator	char	1	0	CHAR	(N' ')	Yes		REPOS	Allow NULL?
44	LIFNR	Desired Vendor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	WLIEF	Allow NULL?
45	FLIEF	Fixed Vendor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	FLIEF	Allow NULL?
46	EKORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	T024E	EKORG	Allow NULL?
47	VRTYP	Purchasing Document Category	char	1	0	CHAR	(N' ')	Yes		BSTYP	Allow NULL?
48	KONNR	Number of Principal Purchase Agreement	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	KONNR	Allow NULL?
49	KTPNR	Item Number of Principal Purchase Agreement	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	KTPNR	Allow NULL?
50	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	EINA	INFNR	Allow NULL?
51	ZUGBA	Assigned Source of Supply	char	1	0	CHAR	(N' ')	Yes		DZUGBA	Allow NULL?
52	QUNUM	Number of Quota Arrangement	nvarchar	10	0	CHAR	(N' ')	Yes		QUNUM	Allow NULL?
53	QUPOS	Quota Arrangement Item	nvarchar	3	0	NUMC	(N'000')	Yes		QUPOS	Allow NULL?
54	DISPO	MRP Controller (Materials Planner)	nvarchar	3	0	CHAR	(N' ')	Yes	T024D	DISPO	Allow NULL?
55	SERNR	BOM explosion number	nvarchar	8	0	CHAR	(N' ')	Yes	*	SERNR	Allow NULL?
56	BVDAT	Date of last resubmission	nvarchar	8	0	DATS	(N'00000000')	Yes		BVDAT	Allow NULL?
57	BATOL	Resubmission Interval of Purchase Requisition	decimal	3	0	DEC	((0))	Yes		BATOL
58	BVDRK	Number of resubmissions	decimal	7	0	DEC	((0))	Yes		BVDRK
59	EBELN	Purchase Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	BSTNR	Allow NULL?
60	EBELP	Purchase Order Item Number	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	BSTPO	Allow NULL?
61	BEDAT	Purchase Order Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEDAT	Allow NULL?
62	BSMNG	Quantity Ordered Against this Purchase Requisition	decimal	13	3	QUAN	((0))	Yes		BSMNG
63	LBLNI	Entry Sheet Number	nvarchar	10	0	CHAR	(N' ')	Yes	ESSR	LBLNI	Allow NULL?
64	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
65	XOBLR	Item affects commitments	char	1	0	CHAR	(N' ')	Yes		XOBLR	Allow NULL?
66	EBAKZ	Purchase Requisition Closed	char	1	0	CHAR	(N' ')	Yes		EBAKZ	Allow NULL?
67	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	RSNUM	Allow NULL?
68	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	T148	SOBKZ	Allow NULL?
69	ARSNR	Settlement reservation number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		ARSNR	Allow NULL?
70	ARSPS	Item number of the settlement reservation	nvarchar	4	0	NUMC	(N'0000')	Yes		ARSPS	Allow NULL?
71	FIXKZ	Purchase Requisition is Fixed	char	1	0	CHAR	(N' ')	Yes		BAFIX	Allow NULL?
72	BMEIN	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
73	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
74	VORAB	Advance procurement: project stock	char	1	0	CHAR	(N' ')	Yes		VORAB	Allow NULL?
75	PACKNO	Package number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	ESLH	PACKNO	Allow NULL?
76	KANBA	Kanban Indicator	char	1	0	CHAR	(N' ')	Yes		KBNKZ	Allow NULL?
77	BPUEB	Adopt Requisition Price in Purchase Order	char	1	0	CHAR	(N' ')	Yes		BPUEB	Allow NULL?
78	CUOBJ	Configuration (internal object number)	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ	Allow NULL?
79	FRGGR	Release group	nvarchar	2	0	CHAR	(N' ')	Yes	T16FG	FRGGR	Allow NULL?
80	FRGRL	Release Not Yet Completely Effected	char	1	0	CHAR	(N' ')	Yes		FRGRL	Allow NULL?
81	AKTNR	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	WAKH	WAKTION	Allow NULL?
82	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
83	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	CHAR	(N' ')	Yes	*	UMSOK	Allow NULL?
84	VERID	Production Version	nvarchar	4	0	CHAR	(N' ')	Yes	*	VERID	Allow NULL?
85	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
86	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
87	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
88	KZKFG	Origin of Configuration	char	1	0	CHAR	(N' ')	Yes		KZCUH	Allow NULL?
89	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	SATNR	Allow NULL?
90	MNG02	Committed Quantity	decimal	13	3	QUAN	((0))	Yes		MNG06
91	DAT01	Committed Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DAT05	Allow NULL?
92	ATTYP	Material Category	nvarchar	2	0	CHAR	(N' ')	Yes		ATTYP	Allow NULL?
93	ADRNR	Manual address number in purchasing document item	nvarchar	10	0	CHAR	(N' ')	Yes	ADRC	ADRNR_MM	Allow NULL?
94	ADRN2	Number of delivery address	nvarchar	10	0	CHAR	(N' ')	Yes	ADRC	ADRN2	Allow NULL?
95	KUNNR	Customer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	EKUNNR	Allow NULL?
96	EMLIF	Vendor to be supplied/who is to receive delivery	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	EMLIF	Allow NULL?
97	LBLKZ	Subcontracting vendor	char	1	0	CHAR	(N' ')	Yes		LBLKZ	Allow NULL?
98	KZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
99	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
100	IDNLF	Material Number Used by Vendor	nvarchar	35	0	CHAR	(N' ')	Yes		IDNLF	Allow NULL?
101	GSFRG	Overall release of purchase requisitions	char	1	0	CHAR	(N' ')	Yes		GSFRG	Allow NULL?
102	MPROF	Manufacturer Part Profile	nvarchar	4	0	CHAR	(N' ')	Yes	*	MPROF	Allow NULL?
103	KZFME	Units of measure usage	char	1	0	CHAR	(N' ')	Yes		KZWSO	Allow NULL?
104	SPRAS	Language Key	char	1	0	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
105	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	CHAR	(N' ')	Yes		TECHS	Allow NULL?
106	MFRPN	Manufacturer Part Number	nvarchar	40	0	CHAR	(N' ')	Yes		MFRPN	Allow NULL?
107	MFRNR	Number of a Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	MFRNR	Allow NULL?
108	EMNFR	External manufacturer code name or number	nvarchar	10	0	CHAR	(N' ')	Yes		EMNFR	Allow NULL?
109	FORDN	Framework Order	nvarchar	10	0	CHAR	(N' ')	Yes	*	SFORDN	Allow NULL?
110	FORDP	Item of framework order	nvarchar	5	0	NUMC	(N'00000')	Yes	*	FORDP	Allow NULL?
111	PLIFZ	Planned Delivery Time in Days	decimal	3	0	DEC	((0))	Yes		PLIFZ
112	BERID	MRP Area	nvarchar	10	0	CHAR	(N' ')	Yes	*	BERID	Allow NULL?
113	UZEIT	Delivery Date Time-Spot	nvarchar	6	0	TIMS	(N'000000')	Yes		LZEIT	Allow NULL?
114	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
115	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
116	MEMORY	Purchase Requisition not yet Complete	char	1	0	CHAR	(N' ')	Yes		MEMBF	Allow NULL?
117	BANPR	Requisition Processing State	nvarchar	2	0	CHAR	(N' ')	Yes		BANPR	Allow NULL?
118	RLWRT	Total value at time of release	decimal	15	2	CURR	((0))	Yes		RLWRT
119	BLCKD	Purchase Requisition Blocked	char	1	0	CHAR	(N' ')	Yes		BLCKD	Allow NULL?
120	REVNO	Version number in Purchasing	nvarchar	8	0	CHAR	(N' ')	Yes		REVNO	Allow NULL?
121	BLCKT	Reason for Item Block	nvarchar	60	0	CHAR	(N' ')	Yes		BLCKT	Allow NULL?
122	BESWK	Procuring Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	BESWK	Allow NULL?
123	EPROFILE	External Procurement Profile	nvarchar	2	0	CHAR	(N' ')	Yes		MEPROFILE	Allow NULL?
124	EPREFDOC	External Procurement Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes		EPREFDOC	Allow NULL?
125	EPREFITM	External Procurement Reference Item	nvarchar	5	0	NUMC	(N'00000')	Yes		EPREFITM	Allow NULL?
126	GMMNG	PO Quantity of Purchase Requisition in POs on Hold	decimal	13	3	QUAN	((0))	Yes		GMMNG
127	WRTKZ	Value-Based Commitment Reduction for Service Purchase Reqs	char	1	0	CHAR	(N' ')	Yes		WRTKZ	Allow NULL?
128	RESLO	Issuing Storage Location for Stock Transport Order	nvarchar	4	0	CHAR	(N' ')	Yes	*	RESLO	Allow NULL?
129	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR	Allow NULL?
130	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
131	PRIO_URG	Requirement Urgency	nvarchar	2	0	NUMC	(N'00')	Yes	PURG	PRIO_URG	Allow NULL?
132	PRIO_REQ	Requirement Priority	nvarchar	3	0	NUMC	(N'000')	Yes	PREQ	PRIO_REQ	Allow NULL?
133	MEMORYTYPE	Category of Incompleteness	char	1	0	CHAR	(N' ')	Yes		MEMORYTYPE	Allow NULL?
134	ANZSN	Number of serial numbers	int	10	0	INT4	((0))	Yes		ANZSN	Allow NULL?
135	MHDRZ	Minimum Remaining Shelf Life	decimal	4	0	DEC	((0))	Yes		MHDRZ
136	IPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	CHAR	(N' ')	Yes		DATTP	Allow NULL?
137	NODISP	Ind: Reserv. not applicable to MRP;Purc. req. not created	char	1	0	CHAR	(N' ')	Yes		NODISP	Allow NULL?
138	SRM_CONTRACT_ID	Central Contract	nvarchar	10	0	CHAR	(N' ')	Yes		SRM_CONTRACT_ID	Allow NULL?
139	SRM_CONTRACT_ITM	Central Contract Item Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes		SRM_CONTRACT_ITEM	Allow NULL?
140	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
141	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	CHAR	(N' ')	Yes		FMFG_US_KEY	Allow NULL?
142	ADVCODE	Advice Code	nvarchar	2	0	CHAR	(N' ')	Yes	/ISDFPS/ADVCODE2	/ISDFPS/ADVCODE	Allow NULL?
143	STACODE	Status Code	nvarchar	2	0	CHAR	(N' ')	Yes	/ISDFPS/CSTACODE	/ISDFPS/STACODE	Allow NULL?
144	BANFN_CS	Cross-System PReq Number	nvarchar	10	0	CHAR	(N' ')	Yes		/ISDFPS/BANFN_CS	Allow NULL?
145	BNFPO_CS	Cross-System PReq Item	nvarchar	5	0	NUMC	(N'00000')	Yes	*	/ISDFPS/BNFPO_CS	Allow NULL?
146	ITEM_CS	Cross-System Item Category	char	1	0	CHAR	(N' ')	Yes		/ISDFPS/ITEM_CS	Allow NULL?
147	BSMNG_SND	PO Quantity Sender	decimal	13	3	QUAN	((0))	Yes		/ISDFPS/BSMNG_SND
148	NO_MARD_DATA	No Storage Location Data Exists for Material	char	1	0	CHAR	(N' ')	Yes		/ISDFPS/NO_MARD_DATA	Allow NULL?
149	SERRU	Type of subcontracting	char	1	0	CHAR	(N' ')	Yes		SERRU	Allow NULL?
150	DISUB_SOBKZ	Special stock indicator Subcontracting	char	1	0	CHAR	(N' ')	Yes		DISUB_SOBKZ_LB	Allow NULL?
151	DISUB_PSPNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
152	DISUB_KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
153	DISUB_VBELN	Sales and Distribution Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN	Allow NULL?
154	DISUB_POSNR	Item number of the SD document	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR	Allow NULL?
155	DISUB_OWNER	Owner of stock	nvarchar	10	0	CHAR	(N' ')	Yes	*	OWNER_D	Allow NULL?
156	IUID_RELEVANT	IUID-Relevant	char	1	0	CHAR	(N' ')	Yes		IUID_RELEVANT	Allow NULL?
157	SGT_SCAT	Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_SCAT	Allow NULL?
158	SGT_RCAT	Requirement Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_RCAT	Allow NULL?
159	WRF_CHARSTC1	Characteristic Value 1	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC1	Allow NULL?
160	WRF_CHARSTC2	Characteristic Value 2	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC2	Allow NULL?
161	WRF_CHARSTC3	Characteristic Value 3	nvarchar	18	0	CHAR	(N' ')	Yes		WRF_CHARSTC3	Allow NULL?

TOP ERP 6.0 | EBAN INDEXES

Name	Primary	Unique	Type	Columns
EBAN~0	Yes	Yes	CLUSTERED	BNFPO, BANFN, MANDT
EBAN~1	No	No	NONCLUSTERED	MATKL, LOEKZ, WERKS, MATNR, MANDT
EBAN~2	No	No	NONCLUSTERED	FLIEF, EKORG, ZUGBA, EKGRP, MANDT
EBAN~3	No	No	NONCLUSTERED	FRGST, FRGGR, FRGRL, MANDT
EBAN~4	No	No	NONCLUSTERED	AFNAM, MANDT
EBAN~B	No	No	NONCLUSTERED	BEDNR, MANDT
EBAN~SRV	No	No	NONCLUSTERED	PACKNO, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

161 COLUMNS | 7 INDEXES | ERP 6.0 | EBAN TABLE

TOP ERP 6.0 | EBAN COLUMNS

TOP ERP 6.0 | EBAN INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

161 COLUMNS | 7 INDEXES | ERP 6.0 | EBAN TABLE

TOPERP 6.0 | EBAN COLUMNS

TOPERP 6.0 | EBAN INDEXES

TOP ERP 6.0 | EBAN COLUMNS

TOP ERP 6.0 | EBAN INDEXES