	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

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