	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

364 COLUMNS | 7 INDEXES | ERP 6.0 | EKPO TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Purchasing
1	ERP EHP7	6.0	EKPO	364	7	Purchasing Document Item	Purchasing

SQL: selectupdate insert create

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

SELECT MANDT, EBELN, EBELP, LOEKZ, STATU, AEDAT, TXZ01, MATNR, EMATN, BUKRS, WERKS, LGORT, BEDNR, MATKL, INFNR, IDNLF, KTMNG, MENGE, MEINS, BPRME, BPUMZ, BPUMN, UMREZ, UMREN, NETPR, PEINH, NETWR, BRTWR, AGDAT, WEBAZ, MWSKZ, BONUS, INSMK, SPINF, PRSDR, SCHPR, MAHNZ, MAHN1, MAHN2, MAHN3, UEBTO, UEBTK, UNTTO, BWTAR, BWTTY, ABSKZ, AGMEM, ELIKZ, EREKZ, PSTYP, KNTTP, KZVBR, VRTKZ, TWRKZ, WEPOS, WEUNB, REPOS, WEBRE, KZABS, LABNR, KONNR, KTPNR, ABDAT, ABFTZ, ETFZ1, ETFZ2, KZSTU, NOTKZ, LMEIN, EVERS, ZWERT, NAVNW, ABMNG, PRDAT, BSTYP, EFFWR, XOBLR, KUNNR, ADRNR, EKKOL, SKTOF, STAFO, PLIFZ, NTGEW, GEWEI, TXJCD, ETDRK, SOBKZ, ARSNR, ARSPS, INSNC, SSQSS, ZGTYP, EAN11, BSTAE, REVLV, GEBER, FISTL, FIPOS, KO_GSBER, KO_PARGB, KO_PRCTR, KO_PPRCTR, MEPRF, BRGEW, VOLUM, VOLEH, INCO1, INCO2, VORAB, KOLIF, LTSNR, PACKNO, FPLNR, GNETWR, STAPO, UEBPO, LEWED, EMLIF, LBLKZ, SATNR, ATTYP, VSART, HANDOVERLOC, KANBA, ADRN2, CUOBJ, XERSY, EILDT, DRDAT, DRUHR, DRUNR, AKTNR, ABELN, ABELP, ANZPU, PUNEI, SAISO, SAISJ, EBON2, EBON3, EBONF, MLMAA, MHDRZ, ANFNR, ANFPS, KZKFG, USEQU, UMSOK, BANFN, BNFPO, MTART, UPTYP, UPVOR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, SIKGR, MFZHI, FFZHI, RETPO, AUREL, BSGRU, LFRET, MFRGR, NRFHG, J_1BNBM, J_1BMATUSE, J_1BMATORG, J_1BOWNPRO, J_1BINDUST, ABUEB, NLABD, NFABD, KZBWS, BONBA, FABKZ, J_1AINDXP, J_1AIDATEP, MPROF, EGLKZ, KZTLF, KZFME, RDPRF, TECHS, CHG_SRV, CHG_FPLNR, MFRPN, MFRNR, EMNFR, NOVET, AFNAM, TZONRC, IPRKZ, LEBRE, BERID, XCONDITIONS, APOMS, CCOMP, GRANT_NBR, FKBER, STATUS, RESLO, KBLNR, KBLPOS, WEORA, SRV_BAS_COM, PRIO_URG, PRIO_REQ, EMPST, DIFF_INVOICE, TRMRISK_RELEVANT, SPE_ABGRU, SPE_CRM_SO, SPE_CRM_SO_ITEM, SPE_CRM_REF_SO, SPE_CRM_REF_ITEM, SPE_CRM_FKREL, SPE_CHNG_SYS, SPE_INSMK_SRC, SPE_CQ_CTRLTYPE, SPE_CQ_NOCQ, REASON_CODE, CQU_SAR, ANZSN, SPE_EWM_DTC, EXLIN, EXSNR, EHTYP, RETPC, DPTYP, DPPCT, DPAMT, DPDAT, FLS_RSTO, EXT_RFX_NUMBER, EXT_RFX_ITEM, EXT_RFX_SYSTEM, SRM_CONTRACT_ID, SRM_CONTRACT_ITM, BLK_REASON_ID, BLK_REASON_TXT, ITCONS, FIXMG, WABWE, TC_AUT_DET, MANUAL_TC_REASON, FISCAL_INCENTIVE, TAX_SUBJECT_ST, FISCAL_INCENTIVE_ID, SF_TXJCD, /BEV1/NEGEN_ITEM, /BEV1/NEDEPFREE, /BEV1/NESTRUCCAT, ADVCODE, BUDGET_PD, EXCPE, FMFGUS_KEY, IUID_RELEVANT, MRPIND, OIPIPEVAL, OIC_LIFNR, OIC_DCITYC, OIC_DCOUNC, OIC_DREGIO, OIC_DLAND1, OIC_OCITYC, OIC_OCOUNC, OIC_OREGIO, OIC_OLAND1, OIC_PORGIN, OIC_PDESTN, OIC_PTRIP, OIC_PBATCH, OIC_MOT, OIC_AORGIN, OIC_ADESTN, OIC_TRUCKN, OIA_BASELO, OITAXFROM, OIHANTYP, OIPRICIE, OITAXTO, OITAXCON, OITAXGRP, OIOILCON, OIINEX, OIEXGNUM, OIEXGTYP, OIFEETOT, OIFEEDT, OINETCYC, OIFERP, OIFEECH, OIA_IPMVAT, OIA_SPLTIV, OIVATH, OIVATF, OISBREL, OIBASPROD, OITRKNR, OITRKJR, OIEXTNR, OIITMNR, OIFTIND, OIPRIOP, OITRIND, OIGHNDL, OIUMBAR, OITXCON1, OITXCON2, OITXCON3, OITXCON4, OITXCON5, OITXCON6, OID_EXTBOL, OID_MISCDL, OIMATCYC, OIEDOK, OIEDBAL, OIEDBALM, OICERTF1, OIDATFM1, OIDATTO1, OIH_LICTP, OIH_LICIN, OIH_LCFOL, OIH_FOLQTY, OIEDOK_GI, OIEDBAL_GI, OIEDBALM_GI, OIHANTYP_GI, OIINEX_GI, OITAXGRP_GI, OICERTF1_GI, OIDATFM1_GI, OIDATTO1_GI, OIH_LICTP_GI, OIH_LICIN_GI, OIH_LCFOL_GI, OIH_FOLQTY_GI, SGT_SCAT, SGT_RCAT, WRF_CHARSTC1, WRF_CHARSTC2, WRF_CHARSTC3, REFSITE, SERRU, SERNP, DISUB_SOBKZ, DISUB_PSPNR, DISUB_KUNNR, DISUB_VBELN, DISUB_POSNR, DISUB_OWNER, REF_ITEM, SOURCE_ID, SOURCE_KEY, PUT_BACK, POL_ID, CONS_ORDER FROM EKPO

TOP ERP 6.0 | EKPO COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
3	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
4	LOEKZ	Deletion Indicator in Purchasing Document	char	1	0	Allow NULL?
5	STATU	RFQ status	char	1	0	Allow NULL?
6	AEDAT	Purchasing Document Item Change Date	nvarchar	8	0	Allow NULL?
7	TXZ01	Short Text	nvarchar	40	0	Allow NULL?
8	MATNR	Material Number	nvarchar	18	0	Allow NULL?
9	EMATN	Material Number	nvarchar	18	0	Allow NULL?
10	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
11	WERKS	Plant	nvarchar	4	0	Allow NULL?
12	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
13	BEDNR	Requirement Tracking Number	nvarchar	10	0	Allow NULL?
14	MATKL	Material Group	nvarchar	9	0	Allow NULL?
15	INFNR	Number of Purchasing Info Record	nvarchar	10	0	Allow NULL?
16	IDNLF	Material Number Used by Vendor	nvarchar	35	0	Allow NULL?
17	KTMNG	Target Quantity	decimal	13	3
18	MENGE	Purchase Order Quantity	decimal	13	3
19	MEINS	Purchase Order Unit of Measure	nvarchar	3	0	Allow NULL?
20	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	Allow NULL?
21	BPUMZ	Numerator for Conversion of Order Price Unit into Order Unit	decimal	5	0
22	BPUMN	Denominator for Conv. of Order Price Unit into Order Unit	decimal	5	0
23	UMREZ	Numerator for Conversion of Order Unit to Base Unit	decimal	5	0
24	UMREN	Denominator for Conversion of Order Unit to Base Unit	decimal	5	0
25	NETPR	Net Price in Purchasing Document (in Document Currency)	decimal	11	2
26	PEINH	Price Unit	decimal	5	0
27	NETWR	Net Order Value in PO Currency	decimal	13	2
28	BRTWR	Gross order value in PO currency	decimal	13	2
29	AGDAT	Deadline for Submission of Bid/Quotation	nvarchar	8	0	Allow NULL?
30	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0
31	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
32	BONUS	Settlement Group 1 (Purchasing)	nvarchar	2	0	Allow NULL?
33	INSMK	Stock Type	char	1	0	Allow NULL?
34	SPINF	Indicator: Update Info Record	char	1	0	Allow NULL?
35	PRSDR	Price Printout	char	1	0	Allow NULL?
36	SCHPR	Indicator: Estimated Price	char	1	0	Allow NULL?
37	MAHNZ	Number of Reminders/Expediters	decimal	3	0
38	MAHN1	Number of Days for First Reminder/Expediter	decimal	3	0
39	MAHN2	Number of Days for Second Reminder/Expediter	decimal	3	0
40	MAHN3	Number of Days for Third Reminder/Expediter	decimal	3	0
41	UEBTO	Overdelivery Tolerance Limit	decimal	3	1
42	UEBTK	Indicator: Unlimited Overdelivery Allowed	char	1	0	Allow NULL?
43	UNTTO	Underdelivery Tolerance Limit	decimal	3	1
44	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
45	BWTTY	Valuation Category	char	1	0	Allow NULL?
46	ABSKZ	Rejection Indicator	char	1	0	Allow NULL?
47	AGMEM	Internal Comment on Quotation	nvarchar	3	0	Allow NULL?
48	ELIKZ	"Delivery Completed" Indicator	char	1	0	Allow NULL?
49	EREKZ	Final Invoice Indicator	char	1	0	Allow NULL?
50	PSTYP	Item Category in Purchasing Document	char	1	0	Allow NULL?
51	KNTTP	Account Assignment Category	char	1	0	Allow NULL?
52	KZVBR	Consumption Posting	char	1	0	Allow NULL?
53	VRTKZ	Distribution indicator for multiple account assignment	char	1	0	Allow NULL?
54	TWRKZ	Partial Invoice Indicator	char	1	0	Allow NULL?
55	WEPOS	Goods Receipt Indicator	char	1	0	Allow NULL?
56	WEUNB	Goods Receipt, Non-Valuated	char	1	0	Allow NULL?
57	REPOS	Invoice Receipt Indicator	char	1	0	Allow NULL?
58	WEBRE	Indicator: GR-Based Invoice Verification	char	1	0	Allow NULL?
59	KZABS	Order Acknowledgment Requirement	char	1	0	Allow NULL?
60	LABNR	Order Acknowledgment Number	nvarchar	20	0	Allow NULL?
61	KONNR	Number of Principal Purchase Agreement	nvarchar	10	0	Allow NULL?
62	KTPNR	Item Number of Principal Purchase Agreement	nvarchar	5	0	Allow NULL?
63	ABDAT	Reconciliation Date for Agreed Cumulative Quantity	nvarchar	8	0	Allow NULL?
64	ABFTZ	Agreed Cumulative Quantity	decimal	13	3
65	ETFZ1	Firm Zone (Go-Ahead for Production)	decimal	3	0
66	ETFZ2	Trade-Off Zone (Go-Ahead for Materials Procurement)	decimal	3	0
67	KZSTU	Firm/Trade-Off Zones Binding with Regard to Mat. Planning	char	1	0	Allow NULL?
68	NOTKZ	Exclusion in Outline Agreement Item with Material Class	char	1	0	Allow NULL?
69	LMEIN	Base Unit of Measure	nvarchar	3	0	Allow NULL?
70	EVERS	Shipping Instructions	nvarchar	2	0	Allow NULL?
71	ZWERT	Target Value for Outline Agreement in Document Currency	decimal	13	2
72	NAVNW	Non-deductible input tax	decimal	13	2
73	ABMNG	Standard release order quantity	decimal	13	3
74	PRDAT	Date of Price Determination	nvarchar	8	0	Allow NULL?
75	BSTYP	Purchasing Document Category	char	1	0	Allow NULL?
76	EFFWR	Effective value of item	decimal	13	2
77	XOBLR	Item affects commitments	char	1	0	Allow NULL?
78	KUNNR	Customer	nvarchar	10	0	Allow NULL?
79	ADRNR	Manual address number in purchasing document item	nvarchar	10	0	Allow NULL?
80	EKKOL	Condition Group with Vendor	nvarchar	4	0	Allow NULL?
81	SKTOF	Item Does Not Qualify for Cash Discount	char	1	0	Allow NULL?
82	STAFO	Update group for statistics update	nvarchar	6	0	Allow NULL?
83	PLIFZ	Planned Delivery Time in Days	decimal	3	0
84	NTGEW	Net Weight	decimal	13	3
85	GEWEI	Unit of Weight	nvarchar	3	0	Allow NULL?
86	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
87	ETDRK	Indicator: Print-relevant schedule lines exist	char	1	0	Allow NULL?
88	SOBKZ	Special Stock Indicator	char	1	0	Allow NULL?
89	ARSNR	Settlement reservation number	nvarchar	10	0	Allow NULL?
90	ARSPS	Item number of the settlement reservation	nvarchar	4	0	Allow NULL?
91	INSNC	Quality inspection indicator cannot be changed	char	1	0	Allow NULL?
92	SSQSS	Control Key for Quality Management in Procurement	nvarchar	8	0	Allow NULL?
93	ZGTYP	Certificate Type	nvarchar	4	0	Allow NULL?
94	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	Allow NULL?
95	BSTAE	Confirmation Control Key	nvarchar	4	0	Allow NULL?
96	REVLV	Revision Level	nvarchar	2	0	Allow NULL?
97	GEBER	Fund	nvarchar	10	0	Allow NULL?
98	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
99	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
100	KO_GSBER	Business area reported to the partner	nvarchar	4	0	Allow NULL?
101	KO_PARGB	assumed business area of the business partner	nvarchar	4	0	Allow NULL?
102	KO_PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
103	KO_PPRCTR	Partner Profit Center	nvarchar	10	0	Allow NULL?
104	MEPRF	Price Determination (Pricing) Date Control	char	1	0	Allow NULL?
105	BRGEW	Gross Weight	decimal	13	3
106	VOLUM	Volume	decimal	13	3
107	VOLEH	Volume unit	nvarchar	3	0	Allow NULL?
108	INCO1	Incoterms (Part 1)	nvarchar	3	0	Allow NULL?
109	INCO2	Incoterms (Part 2)	nvarchar	28	0	Allow NULL?
110	VORAB	Advance procurement: project stock	char	1	0	Allow NULL?
111	KOLIF	Prior Vendor	nvarchar	10	0	Allow NULL?
112	LTSNR	Vendor Subrange	nvarchar	6	0	Allow NULL?
113	PACKNO	Package number	nvarchar	10	0	Allow NULL?
114	FPLNR	Invoicing plan number	nvarchar	10	0	Allow NULL?
115	GNETWR	Currently not used	decimal	13	2
116	STAPO	Item is statistical	char	1	0	Allow NULL?
117	UEBPO	Higher-Level Item in Purchasing Documents	nvarchar	5	0	Allow NULL?
118	LEWED	Latest Possible Goods Receipt	nvarchar	8	0	Allow NULL?
119	EMLIF	Vendor to be supplied/who is to receive delivery	nvarchar	10	0	Allow NULL?
120	LBLKZ	Subcontracting vendor	char	1	0	Allow NULL?
121	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	Allow NULL?
122	ATTYP	Material Category	nvarchar	2	0	Allow NULL?
123	VSART	Shipping type	nvarchar	2	0	Allow NULL?
124	HANDOVERLOC	Location for a physical handover of goods	nvarchar	10	0	Allow NULL?
125	KANBA	Kanban Indicator	char	1	0	Allow NULL?
126	ADRN2	Number of delivery address	nvarchar	10	0	Allow NULL?
127	CUOBJ	Configuration (internal object number)	nvarchar	18	0	Allow NULL?
128	XERSY	Evaluated Receipt Settlement (ERS)	char	1	0	Allow NULL?
129	EILDT	Start Date for GR-Based Settlement	nvarchar	8	0	Allow NULL?
130	DRDAT	Last Transmission	nvarchar	8	0	Allow NULL?
131	DRUHR	Time	nvarchar	6	0	Allow NULL?
132	DRUNR	Sequential Number	nvarchar	4	0	Allow NULL?
133	AKTNR	Promotion	nvarchar	10	0	Allow NULL?
134	ABELN	Allocation Table Number	nvarchar	10	0	Allow NULL?
135	ABELP	Item number of allocation table	nvarchar	5	0	Allow NULL?
136	ANZPU	Number of Points	decimal	13	3
137	PUNEI	Points unit	nvarchar	3	0	Allow NULL?
138	SAISO	Season Category	nvarchar	4	0	Allow NULL?
139	SAISJ	Season Year	nvarchar	4	0	Allow NULL?
140	EBON2	Settlement Group 2 (Rebate Settlement, Purchasing)	nvarchar	2	0	Allow NULL?
141	EBON3	Settlement Group 3 (Rebate Settlement, Purchasing)	nvarchar	2	0	Allow NULL?
142	EBONF	Item Relevant to Subsequent (Period-End Rebate) Settlement	char	1	0	Allow NULL?
143	MLMAA	Material ledger activated at material level	char	1	0	Allow NULL?
144	MHDRZ	Minimum Remaining Shelf Life	decimal	4	0
145	ANFNR	RFQ Number	nvarchar	10	0	Allow NULL?
146	ANFPS	Item Number of RFQ	nvarchar	5	0	Allow NULL?
147	KZKFG	Origin of Configuration	char	1	0	Allow NULL?
148	USEQU	Quota arrangement usage	char	1	0	Allow NULL?
149	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	Allow NULL?
150	BANFN	Purchase Requisition Number	nvarchar	10	0	Allow NULL?
151	BNFPO	Item Number of Purchase Requisition	nvarchar	5	0	Allow NULL?
152	MTART	Material Type	nvarchar	4	0	Allow NULL?
153	UPTYP	Subitem Category, Purchasing Document	char	1	0	Allow NULL?
154	UPVOR	Subitems Exist	char	1	0	Allow NULL?
155	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2
156	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2
157	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2
158	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2
159	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2
160	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2
161	SIKGR	Processing key for sub-items	nvarchar	3	0	Allow NULL?
162	MFZHI	Maximum Cumulative Material Go-Ahead Quantity	decimal	15	3
163	FFZHI	Maximum Cumulative Production Go-Ahead Quantity	decimal	15	3
164	RETPO	Returns Item	char	1	0	Allow NULL?
165	AUREL	Relevant to Allocation Table	char	1	0	Allow NULL?
166	BSGRU	Reason for Ordering	nvarchar	3	0	Allow NULL?
167	LFRET	Delivery Type for Returns to Vendors	nvarchar	4	0	Allow NULL?
168	MFRGR	Material freight group	nvarchar	8	0	Allow NULL?
169	NRFHG	Material qualifies for discount in kind	char	1	0	Allow NULL?
170	J_1BNBM	Brazilian NCM Code	nvarchar	16	0	Allow NULL?
171	J_1BMATUSE	Usage of the material	char	1	0	Allow NULL?
172	J_1BMATORG	Origin of the material	char	1	0	Allow NULL?
173	J_1BOWNPRO	Produced in-house	char	1	0	Allow NULL?
174	J_1BINDUST	Material CFOP category	nvarchar	2	0	Allow NULL?
175	ABUEB	Release Creation Profile	nvarchar	4	0	Allow NULL?
176	NLABD	Next Forecast Delivery Schedule Transmission	nvarchar	8	0	Allow NULL?
177	NFABD	Next JIT Delivery Schedule Transmission	nvarchar	8	0	Allow NULL?
178	KZBWS	Valuation of Special Stock	char	1	0	Allow NULL?
179	BONBA	Rebate basis 1	decimal	13	2
180	FABKZ	Indicator: Item Relevant to JIT Delivery Schedules	char	1	0	Allow NULL?
181	J_1AINDXP	Inflation Index	nvarchar	5	0	Allow NULL?
182	J_1AIDATEP	Inflation Index Date	nvarchar	8	0	Allow NULL?
183	MPROF	Manufacturer Part Profile	nvarchar	4	0	Allow NULL?
184	EGLKZ	"Outward Delivery Completed" Indicator	char	1	0	Allow NULL?
185	KZTLF	Partial Delivery at Item Level (Stock Transfer)	char	1	0	Allow NULL?
186	KZFME	Units of measure usage	char	1	0	Allow NULL?
187	RDPRF	Rounding Profile	nvarchar	4	0	Allow NULL?
188	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	Allow NULL?
189	CHG_SRV	Configuration changed	char	1	0	Allow NULL?
190	CHG_FPLNR	No invoice for this item although not free of charge	char	1	0	Allow NULL?
191	MFRPN	Manufacturer Part Number	nvarchar	40	0	Allow NULL?
192	MFRNR	Number of a Manufacturer	nvarchar	10	0	Allow NULL?
193	EMNFR	External manufacturer code name or number	nvarchar	10	0	Allow NULL?
194	NOVET	Item blocked for SD delivery	char	1	0	Allow NULL?
195	AFNAM	Name of Requisitioner/Requester	nvarchar	12	0	Allow NULL?
196	TZONRC	Time zone of recipient location	nvarchar	6	0	Allow NULL?
197	IPRKZ	Period Indicator for Shelf Life Expiration Date	char	1	0	Allow NULL?
198	LEBRE	Indicator for Service-Based Invoice Verification	char	1	0	Allow NULL?
199	BERID	MRP Area	nvarchar	10	0	Allow NULL?
200	XCONDITIONS	Conditions for item although no invoice	char	1	0	Allow NULL?
201	APOMS	APO as Planning System	char	1	0	Allow NULL?
202	CCOMP	Posting Logic in the Case of Stock Transfers	char	1	0	Allow NULL?
203	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
204	FKBER	Functional Area	nvarchar	16	0	Allow NULL?
205	STATUS	Status of Purchasing Document Item	char	1	0	Allow NULL?
206	RESLO	Issuing Storage Location for Stock Transport Order	nvarchar	4	0	Allow NULL?
207	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
208	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	Allow NULL?
209	WEORA	Acceptance At Origin	char	1	0	Allow NULL?
210	SRV_BAS_COM	Service-Based Commitment	char	1	0	Allow NULL?
211	PRIO_URG	Requirement Urgency	nvarchar	2	0	Allow NULL?
212	PRIO_REQ	Requirement Priority	nvarchar	3	0	Allow NULL?
213	EMPST	Receiving point	nvarchar	25	0	Allow NULL?
214	DIFF_INVOICE	Differential Invoicing	nvarchar	2	0	Allow NULL?
215	TRMRISK_RELEVANT	Risk Relevancy in Purchasing	nvarchar	2	0	Allow NULL?
216	SPE_ABGRU	Reason for rejection of quotations and sales orders	nvarchar	2	0	Allow NULL?
217	SPE_CRM_SO	CRM Sales Order Number for TPOP Process	nvarchar	10	0	Allow NULL?
218	SPE_CRM_SO_ITEM	CRM Sales Order Item Number in TPOP Process	nvarchar	6	0	Allow NULL?
219	SPE_CRM_REF_SO	CRM Reference Order Number for TPOP Process	nvarchar	35	0	Allow NULL?
220	SPE_CRM_REF_ITEM	CRM Reference Sales Order Item Number in TPOP Process	nvarchar	6	0	Allow NULL?
221	SPE_CRM_FKREL	Billing Relevance CRM	char	1	0	Allow NULL?
222	SPE_CHNG_SYS	Last Changer's System Type	char	1	0	Allow NULL?
223	SPE_INSMK_SRC	Stock Type of Source Storage Location in STO	char	1	0	Allow NULL?
224	SPE_CQ_CTRLTYPE	CQ Control Type	char	1	0	Allow NULL?
225	SPE_CQ_NOCQ	No Transmission of Cumulative Quantities in SA Release	char	1	0	Allow NULL?
226	REASON_CODE	Goods Receipt Reason Code	nvarchar	4	0	Allow NULL?
227	CQU_SAR	Cumulative Goods Receipts from Redirected Purchase Orders	decimal	15	3
228	ANZSN	Number of serial numbers	int	10	0	Allow NULL?
229	SPE_EWM_DTC	EWM Delivery Based Tolerance Check	char	1	0	Allow NULL?
230	EXLIN	Item Number Length	nvarchar	40	0	Allow NULL?
231	EXSNR	External Sorting	nvarchar	5	0	Allow NULL?
232	EHTYP	External Hierarchy Category	nvarchar	4	0	Allow NULL?
233	RETPC	Retention in Percent	decimal	5	2
234	DPTYP	Down Payment Indicator	nvarchar	4	0	Allow NULL?
235	DPPCT	Down Payment Percentage	decimal	5	2
236	DPAMT	Down Payment Amount in Document Currency	decimal	11	2
237	DPDAT	Due Date for Down Payment	nvarchar	8	0	Allow NULL?
238	FLS_RSTO	Store Return with Inbound and Outbound Delivery	char	1	0	Allow NULL?
239	EXT_RFX_NUMBER	Document Number of External Document	nvarchar	35	0	Allow NULL?
240	EXT_RFX_ITEM	Item Number of External Document	nvarchar	10	0	Allow NULL?
241	EXT_RFX_SYSTEM	Logical System	nvarchar	10	0	Allow NULL?
242	SRM_CONTRACT_ID	Central Contract	nvarchar	10	0	Allow NULL?
243	SRM_CONTRACT_ITM	Central Contract Item Number	nvarchar	10	0	Allow NULL?
244	BLK_REASON_ID	Blocking Reason - ID	nvarchar	4	0	Allow NULL?
245	BLK_REASON_TXT	Blocking Reason - Text	nvarchar	40	0	Allow NULL?
246	ITCONS	Real-Time Consumption Posting of Subcontracting Components	char	1	0	Allow NULL?
247	FIXMG	Delivery Date and Quantity Fixed	char	1	0	Allow NULL?
248	WABWE	Indicator for GI-based goods receipt	char	1	0	Allow NULL?
249	TC_AUT_DET	Tax Code Automatically Determined	nvarchar	2	0	Allow NULL?
250	MANUAL_TC_REASON	Manual Tax Code Reason	nvarchar	2	0	Allow NULL?
251	FISCAL_INCENTIVE	Tax Incentive Type	nvarchar	4	0	Allow NULL?
252	TAX_SUBJECT_ST	Tax Subject to Substituição Tributária	char	1	0	Allow NULL?
253	FISCAL_INCENTIVE_ID	Incentive ID	nvarchar	4	0	Allow NULL?
254	SF_TXJCD	Jurisdiction Code of the Point of Origin	nvarchar	15	0	Allow NULL?
255	/BEV1/NEGEN_ITEM	Indicator: Item Is Generated	char	1	0	Allow NULL?
256	/BEV1/NEDEPFREE	Indicator: Dependent Items Are Free of Charge	char	1	0	Allow NULL?
257	/BEV1/NESTRUCCAT	Structure Category for Material Relationship	char	1	0	Allow NULL?
258	ADVCODE	Advice Code	nvarchar	2	0	Allow NULL?
259	BUDGET_PD	FM: Budget Period	nvarchar	10	0	Allow NULL?
260	EXCPE	Acceptance Period	nvarchar	2	0	Allow NULL?
261	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	Allow NULL?
262	IUID_RELEVANT	IUID-Relevant	char	1	0	Allow NULL?
263	MRPIND	Max. Retail Price Relevant	char	1	0	Allow NULL?
264	OIPIPEVAL	Validation indicator for pipeline fields (X=ON, blank=OFF)	char	1	0	Allow NULL?
265	OIC_LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
266	OIC_DCITYC	Destination city code	nvarchar	4	0	Allow NULL?
267	OIC_DCOUNC	Destination county code	nvarchar	3	0	Allow NULL?
268	OIC_DREGIO	Destination region	nvarchar	3	0	Allow NULL?
269	OIC_DLAND1	Destination country	nvarchar	3	0	Allow NULL?
270	OIC_OCITYC	Origin city code	nvarchar	4	0	Allow NULL?
271	OIC_OCOUNC	Origin county code	nvarchar	3	0	Allow NULL?
272	OIC_OREGIO	Origin region	nvarchar	3	0	Allow NULL?
273	OIC_OLAND1	Origin country	nvarchar	3	0	Allow NULL?
274	OIC_PORGIN	Tax origin	nvarchar	15	0	Allow NULL?
275	OIC_PDESTN	Tax destination	nvarchar	15	0	Allow NULL?
276	OIC_PTRIP	Pipeline trip number (external)	nvarchar	16	0	Allow NULL?
277	OIC_PBATCH	Pipeline operator´s external batch number	nvarchar	16	0	Allow NULL?
278	OIC_MOT	IS-OIL MAP external details mode of transport	nvarchar	2	0	Allow NULL?
279	OIC_AORGIN	Alternate origin	nvarchar	15	0	Allow NULL?
280	OIC_ADESTN	Alternate destination	nvarchar	15	0	Allow NULL?
281	OIC_TRUCKN	Truck number	nvarchar	10	0	Allow NULL?
282	OIA_BASELO	Base location	nvarchar	15	0	Allow NULL?
283	OITAXFROM	Excise duty tax key for 'from' location	nvarchar	2	0	Allow NULL?
284	OIHANTYP	Excise Duty Handling Type	nvarchar	2	0	Allow NULL?
285	OIPRICIE	ED pricing: external (indicator)	char	1	0	Allow NULL?
286	OITAXTO	Excise duty tax key for 'to' location	nvarchar	2	0	Allow NULL?
287	OITAXCON	Excise duty tax from pricing conditions	decimal	13	2
288	OITAXGRP	Excise Duty Group	nvarchar	2	0	Allow NULL?
289	OIOILCON	Oil content in a material as a percentage	decimal	5	2
290	OIINEX	Code for internal or external excise duty rate determination	nvarchar	2	0	Allow NULL?
291	OIEXGNUM	Exchange agreement number	nvarchar	10	0	Allow NULL?
292	OIEXGTYP	Exchange type	nvarchar	4	0	Allow NULL?
293	OIFEETOT	Fee total	decimal	13	2
294	OIFEEDT	Fee pricing condition date	nvarchar	8	0	Allow NULL?
295	OINETCYC	Netting cycle (FI blocking indicator)	char	1	0	Allow NULL?
296	OIFERP	Fee repricing indicator	char	1	0	Allow NULL?
297	OIFEECH	Fee edit control	char	1	0	Allow NULL?
298	OIA_IPMVAT	VAT on internally-posted material	char	1	0	Allow NULL?
299	OIA_SPLTIV	Indicator for split invoice verification	char	1	0	Allow NULL?
300	OIVATH	Amount in Local Currency	decimal	13	2
301	OIVATF	Amount in document currency	decimal	13	2
302	OISBREL	Sub product/ base product relevence indicator	nvarchar	3	0	Allow NULL?
303	OIBASPROD	Base product number	nvarchar	18	0	Allow NULL?
304	OITRKNR	Tracking number	nvarchar	10	0	Allow NULL?
305	OITRKJR	Tracking number year	nvarchar	4	0	Allow NULL?
306	OIEXTNR	External tracking number	nvarchar	18	0	Allow NULL?
307	OIITMNR	Tracking number item line	nvarchar	5	0	Allow NULL?
308	OIFTIND	Final transfer indicator	char	1	0	Allow NULL?
309	OIPRIOP	Price options for gain calculation	char	1	0	Allow NULL?
310	OITRIND	Transfer sign for plant-to-plant transfers	char	1	0	Allow NULL?
311	OIGHNDL	Gain handling	char	1	0	Allow NULL?
312	OIUMBAR	Valuation type of issuing location for two-step transfer	nvarchar	10	0	Allow NULL?
313	OITXCON1	Excise duty tax from pricing conditions: rate 1	decimal	13	2
314	OITXCON2	Excise duty tax from pricing conditions: rate 2	decimal	13	2
315	OITXCON3	Excise duty tax from pricing conditions: rate 3	decimal	13	2
316	OITXCON4	Excise duty tax from pricing conditions: rate 4	decimal	13	2
317	OITXCON5	Excise duty tax from pricing conditions: rate 5	decimal	13	2
318	OITXCON6	Excise duty tax from pricing conditions: rate 6	decimal	13	2
319	OID_EXTBOL	External bill of lading	nvarchar	16	0	Allow NULL?
320	OID_MISCDL	Miscellaneous delivery number	nvarchar	16	0	Allow NULL?
321	OIMATCYC	Invoicing cycle for purchase material costs	char	1	0	Allow NULL?
322	OIEDOK	Excise duty validation indicator	char	1	0	Allow NULL?
323	OIEDBAL	Excise duty balancing is required (indicator)	char	1	0	Allow NULL?
324	OIEDBALM	Excise duty balancing method indicator	char	1	0	Allow NULL?
325	OICERTF1	Excise tax external license number	nvarchar	15	0	Allow NULL?
326	OIDATFM1	Excise Duty License Valid from Date	nvarchar	8	0	Allow NULL?
327	OIDATTO1	Valid to date for excise duty tax certificate	nvarchar	8	0	Allow NULL?
328	OIH_LICTP	License type	nvarchar	4	0	Allow NULL?
329	OIH_LICIN	Excise tax internal license number	nvarchar	10	0	Allow NULL?
330	OIH_LCFOL	Follow-on license for quantity license	nvarchar	10	0	Allow NULL?
331	OIH_FOLQTY	Excise Tax Follow-On License Quantity	decimal	13	3
332	OIEDOK_GI	Excise Duty Validation Indicator for Material (STO)	char	1	0	Allow NULL?
333	OIEDBAL_GI	Excise Duty Balancing is Required for Mat. (STO)	char	1	0	Allow NULL?
334	OIEDBALM_GI	Excise Duty Balancing Method Indicator for Mat. (STO)	char	1	0	Allow NULL?
335	OIHANTYP_GI	Excise Duty Handling Type - Denotes Use of Material	nvarchar	2	0	Allow NULL?
336	OIINEX_GI	Code for Internal or External Excise Duty Rate Determination	nvarchar	2	0	Allow NULL?
337	OITAXGRP_GI	Excise Duty Group	nvarchar	2	0	Allow NULL?
338	OICERTF1_GI	Excise Tax External License Number Used During GI (STO)	nvarchar	15	0	Allow NULL?
339	OIDATFM1_GI	Excise Duty License Valid from Date for Mat. (STO)	nvarchar	8	0	Allow NULL?
340	OIDATTO1_GI	Valid To Date for Excise Duty Tax Certificate for Mat. (STO)	nvarchar	8	0	Allow NULL?
341	OIH_LICTP_GI	License Type to Material (STO)	nvarchar	4	0	Allow NULL?
342	OIH_LICIN_GI	Excise Tax Internal License Number to Mat. (STO)	nvarchar	10	0	Allow NULL?
343	OIH_LCFOL_GI	Follow-On License for Quantity License to Mat. (STO)	nvarchar	10	0	Allow NULL?
344	OIH_FOLQTY_GI	Excise Tax Follow-On License Quantity to Mat. (STO)	decimal	13	3
345	SGT_SCAT	Stock Segment	nvarchar	16	0	Allow NULL?
346	SGT_RCAT	Requirement Segment	nvarchar	16	0	Allow NULL?
347	WRF_CHARSTC1	Characteristic Value 1	nvarchar	18	0	Allow NULL?
348	WRF_CHARSTC2	Characteristic Value 2	nvarchar	18	0	Allow NULL?
349	WRF_CHARSTC3	Characteristic Value 3	nvarchar	18	0	Allow NULL?
350	REFSITE	Reference Site For Purchasing	nvarchar	4	0	Allow NULL?
351	SERRU	Type of subcontracting	char	1	0	Allow NULL?
352	SERNP	Serial Number Profile	nvarchar	4	0	Allow NULL?
353	DISUB_SOBKZ	Special stock indicator Subcontracting	char	1	0	Allow NULL?
354	DISUB_PSPNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
355	DISUB_KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
356	DISUB_VBELN	Sales and Distribution Document Number	nvarchar	10	0	Allow NULL?
357	DISUB_POSNR	Item number of the SD document	nvarchar	6	0	Allow NULL?
358	DISUB_OWNER	Owner of stock	nvarchar	10	0	Allow NULL?
359	REF_ITEM	Reference Item for Remaining Qty Cancellation	nvarchar	5	0	Allow NULL?
360	SOURCE_ID	Origin Profile	nvarchar	3	0	Allow NULL?
361	SOURCE_KEY	Key in Source System	nvarchar	32	0	Allow NULL?
362	PUT_BACK	Indicator for Putting Back from Grouped PO Document	char	1	0	Allow NULL?
363	POL_ID	Order List Item Number	nvarchar	10	0	Allow NULL?
364	CONS_ORDER	Purchase Order for Consignment	char	1	0	Allow NULL?

TOP ERP 6.0 | EKPO INDEXES

Name	Primary	Unique	Type	Columns
EKPO~0	Yes	Yes	CLUSTERED	EBELP, EBELN, MANDT
EKPO~1	No	No	NONCLUSTERED	MATKL, ELIKZ, LOEKZ, BSTYP, WERKS, MATNR, MANDT
EKPO~A	No	No	NONCLUSTERED	BSTYP, AFNAM, MANDT
EKPO~B	No	No	NONCLUSTERED	BSTYP, BEDNR, MANDT
EKPO~BAN	No	No	NONCLUSTERED	BANFN, MANDT
EKPO~FPL	No	No	NONCLUSTERED	MANDT, FPLNR
EKPO~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

364 COLUMNS | 7 INDEXES | ERP 6.0 | EKPO TABLE

TOP ERP 6.0 | EKPO COLUMNS

TOP ERP 6.0 | EKPO 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

364 COLUMNS | 7 INDEXES | ERP 6.0 | EKPO TABLE

TOPERP 6.0 | EKPO COLUMNS

TOPERP 6.0 | EKPO INDEXES

TOP ERP 6.0 | EKPO COLUMNS

TOP ERP 6.0 | EKPO INDEXES