	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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

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

486 COLUMNS | 1 INDEXES | ERP 6.0 | GLE_FI_ITEM_MODF TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Accounting - General :: Accounting Interface
1	ERP EHP7	6.0	GLE_FI_ITEM_MODF	486	1	ECS: Modified FI Line Items (Header/Item/Currency Data)	Accounting Interface

SQL: selectupdate insert create

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

SELECT MANDT, ITEM_ID, AWTYP, AWREF, AWORG, AWSYS, GLVOR, PROCESS, SUBSET, USNAM, TCODE, CPUDT, CPUTM, BKTXT, DOCID, BARCD, KNUMV, STATUS_NEW, STATUS_OLD, GRPID, ACC_PRINCIPLE, RLDNR, LDGRP, NOSPLIT, GLPROCESS, GLPROCVAR, EXCLUDE_FLAG, DBBLG, KURSX, KUR2X, KUR3X, POSNR, LOGVO, ISTAT, KSTAT, AWREF_REV, AWORG_REV, AWREF_REB, AWORG_REB, BUKRS_ORIG, BUKRS, BELNR, GJAHR, BUZEI, OBZEI, DOCLN, BLDAT, BUDAT, WWERT, VALUT, MONAT, BLART, XBLNR, XREF1, XREF2, XREF3, XREF1_HD, XREF2_HD, VORGN, PRVRG, PRVRG_SV, STBUK, XMWST, MWSKZ, KTOSL, KNUMH, TXJCD, TXDAT, KBETR, TXJDP, TXJLV, TAXPS, OLD_DOC_NUMBER, BUPLA, SECCO, XSKRL, ZUMSK, UMSKZ, BSTAT, BSCHL, SHKZG, PSWSL, PSWBT, PYCUR, PYAMT, KOART, KUNNR, LIFNR, SAKNR, HKONT, ALTKT, FILKD, XFILKD, LOKKT, GVTYP, GKOAR, GKONT, CACCT, LINETYPE, XSPLITMOD, ZTERM, ZFBDT, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, ZBFIX, UZAWE, ZLSCH, EMPFB, RSTGR, REBZG, REBZJ, REBZZ, REBZT, REBZG_CHECK, MABER, MSCHL, MADAT, MANST, MANSP, ZLSPR, ADRNR, STCEG, XEGDR, LZBKZ, LANDL, LAND1_ACNT, DIEKZ, SAMNR, ABPER, ZUONR, DTWS1, DTWS2, DTWS3, DTWS4, SGTXT, GSBER, KOSTL, LSTAR, KOKRS, PERNR, BPMNG, BPRME, AUFNR, ANLN1, ANLN2, BZDAT, ANBWA, WEBUD, RMVCT, ABUKR, AIBN1, AIBN2, MATNR, MENGE, MEINS, WERKS, BWART, PARGB, GSBER_GP, BUZID, HOART, HRKFT, HKMAT, IMKEY, KSTRG, PAOBJNR, PRZNR, PRCTR, PPRCTR, PROJK, PS_PSP_PNR, MAT_PSPNR, NPLNR, AUFPL, APLZL, AUFPS, FIKRS, FIPOS, FISTL, GEBER, KBLNR, KBLPOS, KBLTYP_EXT, KBLREF_EXT, KBLORG_EXT, KBLPOS_EXT, ERLKZ, LOTKZ, STTAX, STHTX, VBELN, KDAUF, KDPOS, MAT_KDAUF, MAT_KDPOS, KZVBR, KZBWS, SOBKZ, ZINKZ, VBUND, BWKEY, BWTAR, VNAME, EGRUP, BTYPE, EBELN, EBELP, ZEKKN, VPRSV, RECID, RECID_MAN, ETYPE, VPTNR, XBILK, XUMSW, TAXIT, XAUTO, FCVAL, BEKNZ, KZBEW, PSTYP, BUSTW, TBTKZ, XUMBW, SCOPE, AUTYP, XMFRW, ESRNR, ESRPZ, ESRRE, QSSKZ, BKLAS, BWMOD, MTART, EPRCTR, POSNR_SD, KSCHL, STUNR, ZAEHK, FKART, VTWEG, KUNAG, SPART, VKORG, VKBUR, VKGRP, FKDAT, FKTYP, FBUDA, AUBEL, AUPOS, FKIMG, VRKME, FKLMG, KAPPL, KNTYP, KURSK, KZZUAB, KINAK, NTGEW, BRGEW, GEWEI, VOLUM, VOLEH, VBTYP, VBEL2, POSN2, FDLEV, FDTAG, FDGRP, FDWBT, KZUML, XPKON, KOAID, XAKON, FKBER, AFABE, VERSA, WIP_CAT, XLIFO, ERFMG, ERFME, DABRZ, AUGDT, AUGCP, AUGBL, AGZEI, XNEGP, STGRD, CCINS, CCNUM, CCFOL, DATAB, DATBI, CCNAME, CSOUR, AUTWR, CCWAE, SETTL, AUNUM, AUTRA, AUDAT, AUTIM, MERCH, LOCID, TRMID, CCBTC, CCTYP, CCARD_GUID, KKBER, SHKZG_VA, SDSTR, POSAR, ANLO1, ANLO2, CONDI, BEMOT, ABSBT, KIDNO, BRNCH, NUMPG, ADISC, GRICD, GRIRG, GITYP, WT_KEY, XBGBB, VERTT, VERTN, VBEWA, BVTYP, HBKID, HKTID, NEBTR, MWSK1, DMBT1, MWSK2, DMBT2, MWSK3, DMBT3, ABWZE, BVTYPABW, BAPI_PARAM, BAPI_TABIX, CCACT, CO_KAKST, CO_KAAUF, CO_KAPRO, CO_KAKTR, CO_KANPL, CO_KAIMO, CO_KAKDA, CO_KAERG, CO_KAABS, CO_KAPRZ, CO_KASAT, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, BVALTNR, KALN1, AUFNR_ORG, CESSION_KZ, MLMAA, MLAST, ZEILE, URZEILE, MLBWG, MLNPRD, LSQTY, PRQTY, EKORG, VKWRT, UMMAT, UMWRK, KNTTP, UMSOK, UMWER, RRREL, MAT_LIFNR, XOBEW, TPKNZ, XINVE, KRUEK, AWTYP_REV, AWTYP_REB, VORNR, PGEBER, PENRC, GRANT_NBR, PGRANT_NBR, GMVKZ, SRTYPE, REINDAT, IDXSP, INTRENO, GLUPM, MEASURE, STBLG, HZUON, SEGMENT, PSEGMENT, PFKBER, PKOSTL, KSTAR, FLG_NOBUD, PPA_EX_IND, CASE_GUID_CORE, LONGNUM, STODT, BDGT_SUBTYPE, COHORT, PUBLAW, LEGIS, FMCMMTSTR, PRODPER, TCOBJNR, DATEOFSERVICE, NOTAXCORR, DIFFOPTRATE, HASDIFFOPTRATE, CURTP, WAERS, WRBTR, FWBAS, SKFBT, WSKTO, QSSHB, QSFBT, BUALT, KWERT, NAVBT, WMWST, CURRTYP, VALUTYP, GBETR, KURSR, WRBTR_FIX, WRBTR_AVG, CURT1, HWAER, DMBTR, KURSF, HWSTE, HWBAS, TXKRS, SKNTO, KZBTR, MWSTS, DMBTR_AVG, CURT2, HWAE2, DMBE2, KURS2, H2STE, SKNT2, MWST2, TXBH2, BASW2, UMRD2, KUTY2, DMBE2_AVG, CURT3, HWAE3, DMBE3, KURS3, H3STE, SKNT3, MWST3, TXBH3, BASW3, UMRD3, KUTY3, DMBE3_AVG FROM GLE_FI_ITEM_MODF

TOP ERP 6.0 | GLE_FI_ITEM_MODF COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	ITEM_ID	ID of Error Correction Item	varbinary	16	0
3	AWTYP	Reference Transaction	nvarchar	5	0	Allow NULL?
4	AWREF	Reference Document Number	nvarchar	10	0	Allow NULL?
5	AWORG	Reference Organizational Units	nvarchar	10	0	Allow NULL?
6	AWSYS	Logical System	nvarchar	10	0	Allow NULL?
7	GLVOR	Business Transaction	nvarchar	4	0	Allow NULL?
8	PROCESS	Transaction for which CO interface is accessed	nvarchar	8	0	Allow NULL?
9	SUBSET	Defines subset of components for the FI/CO interface	nvarchar	4	0	Allow NULL?
10	USNAM	User name	nvarchar	12	0	Allow NULL?
11	TCODE	Transaction Code	nvarchar	20	0	Allow NULL?
12	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	Allow NULL?
13	CPUTM	Time of Entry	nvarchar	6	0	Allow NULL?
14	BKTXT	Document Header Text	nvarchar	25	0	Allow NULL?
15	DOCID	Document type	nvarchar	10	0	Allow NULL?
16	BARCD	SAP ArchiveLink: Document ID	nvarchar	40	0	Allow NULL?
17	KNUMV	Number of the document condition	nvarchar	10	0	Allow NULL?
18	STATUS_NEW	New Status of Transferred Document	char	1	0	Allow NULL?
19	STATUS_OLD	Previous Status of Transferred Document	char	1	0	Allow NULL?
20	GRPID	Batch Input Session Name	nvarchar	12	0	Allow NULL?
21	ACC_PRINCIPLE	Accounting Principle	nvarchar	4	0	Allow NULL?
22	RLDNR	Ledger	nvarchar	2	0	Allow NULL?
23	LDGRP	Ledger Group	nvarchar	4	0	Allow NULL?
24	NOSPLIT	New Input Values	char	1	0	Allow NULL?
25	GLPROCESS	Business Transaction	nvarchar	4	0	Allow NULL?
26	GLPROCVAR	Business Transaction Variant	nvarchar	4	0	Allow NULL?
27	EXCLUDE_FLAG	PPA Exclude Indicator	char	1	0	Allow NULL?
28	DBBLG	Recurring Entry Document Number	nvarchar	10	0	Allow NULL?
29	KURSX	Market Data Exchange Rate	decimal	28	14
30	KUR2X	Market Data Exchange Rate 2	decimal	28	14
31	KUR3X	Market Data Exchange Rate 3	decimal	28	14
32	POSNR	Accounting Document Line Item Number	nvarchar	10	0	Allow NULL?
33	LOGVO	Logical Transaction	nvarchar	6	0	Allow NULL?
34	ISTAT	Item History	char	1	0	Allow NULL?
35	KSTAT	Indicator for Statistical Line Items	char	1	0	Allow NULL?
36	AWREF_REV	Reversal: Reverse Document Reference Document Number	nvarchar	10	0	Allow NULL?
37	AWORG_REV	Reversal: Reverse Document Reference Organization	nvarchar	10	0	Allow NULL?
38	AWREF_REB	Invoice Reference: Document Number for Invoice Reference	nvarchar	10	0	Allow NULL?
39	AWORG_REB	Invoice reference: Reference organization for inv. reference	nvarchar	10	0	Allow NULL?
40	BUKRS_ORIG	Source Company Code from Cross-Company-Code Posting	nvarchar	4	0	Allow NULL?
41	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
42	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
43	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
44	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
45	OBZEI	Number of Line Item in Original Document	nvarchar	3	0	Allow NULL?
46	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0	Allow NULL?
47	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
48	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
49	WWERT	Translation Date	nvarchar	8	0	Allow NULL?
50	VALUT	Value date	nvarchar	8	0	Allow NULL?
51	MONAT	Fiscal Period	nvarchar	2	0	Allow NULL?
52	BLART	Document Type	nvarchar	2	0	Allow NULL?
53	XBLNR	Reference Document Number	nvarchar	16	0	Allow NULL?
54	XREF1	Business partner reference key	nvarchar	12	0	Allow NULL?
55	XREF2	Business partner reference key	nvarchar	12	0	Allow NULL?
56	XREF3	Reference key for line item	nvarchar	20	0	Allow NULL?
57	XREF1_HD	Reference Key 1 Internal for Document Header	nvarchar	20	0	Allow NULL?
58	XREF2_HD	Reference Key 2 Internal for Document Header	nvarchar	20	0	Allow NULL?
59	VORGN	Transaction Type for General Ledger	nvarchar	4	0	Allow NULL?
60	PRVRG	Business transaction for validations	nvarchar	4	0	Allow NULL?
61	PRVRG_SV	Business transaction for status management	nvarchar	4	0	Allow NULL?
62	STBUK	Tax Company Code	nvarchar	4	0	Allow NULL?
63	XMWST	Calculate tax automatically	char	1	0	Allow NULL?
64	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
65	KTOSL	Transaction Key	nvarchar	3	0	Allow NULL?
66	KNUMH	Condition record number	nvarchar	10	0	Allow NULL?
67	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
68	TXDAT	Date for defining tax rates	nvarchar	8	0	Allow NULL?
69	KBETR	Rate (condition amount or percentage)	decimal	11	2
70	TXJDP	Tax Jurisdiction Code - Jurisdiction for Lowest Level Tax	nvarchar	15	0	Allow NULL?
71	TXJLV	Tax jurisdiction code level	char	1	0	Allow NULL?
72	TAXPS	Tax document item number	nvarchar	6	0	Allow NULL?
73	OLD_DOC_NUMBER	Temporary document number when calculating taxes	nvarchar	10	0	Allow NULL?
74	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
75	SECCO	Section Code	nvarchar	4	0	Allow NULL?
76	XSKRL	Indicator: Line item not liable to cash discount?	char	1	0	Allow NULL?
77	ZUMSK	Target Special G/L Indicator	char	1	0	Allow NULL?
78	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
79	BSTAT	Document Status	char	1	0	Allow NULL?
80	BSCHL	Posting Key	nvarchar	2	0	Allow NULL?
81	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
82	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	Allow NULL?
83	PSWBT	Amount for Updating in General Ledger	decimal	13	2
84	PYCUR	Currency for Automatic Payment	nvarchar	5	0	Allow NULL?
85	PYAMT	Amount in Payment Currency	decimal	13	2
86	KOART	Account Type	char	1	0	Allow NULL?
87	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
88	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
89	SAKNR	G/L Account Number	nvarchar	10	0	Allow NULL?
90	HKONT	General Ledger Account	nvarchar	10	0	Allow NULL?
91	ALTKT	Account Number in Group	nvarchar	10	0	Allow NULL?
92	FILKD	Account Number of the Branch	nvarchar	10	0	Allow NULL?
93	XFILKD	Indicator: Break off branch/head office relationship	char	1	0	Allow NULL?
94	LOKKT	Account Number in the Local Chart of Accounts	nvarchar	10	0	Allow NULL?
95	GVTYP	P&L statement account type	nvarchar	2	0	Allow NULL?
96	GKOAR	Offsetting Account Type	char	1	0	Allow NULL?
97	GKONT	Offsetting Account Number	nvarchar	10	0	Allow NULL?
98	CACCT	G/L offsetting acct number	nvarchar	10	0	Allow NULL?
99	LINETYPE	Item category	nvarchar	5	0	Allow NULL?
100	XSPLITMOD	Item changed by document splitting	char	1	0	Allow NULL?
101	ZTERM	Terms of Payment Key	nvarchar	4	0	Allow NULL?
102	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
103	ZBD1T	Cash discount days 1	decimal	3	0
104	ZBD2T	Cash discount days 2	decimal	3	0
105	ZBD3T	Net Payment Terms Period	decimal	3	0
106	ZBD1P	Cash Discount Percentage 1	decimal	5	3
107	ZBD2P	Cash Discount Percentage 2	decimal	5	3
108	ZBFIX	Fixed Payment Terms	char	1	0	Allow NULL?
109	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
110	ZLSCH	Payment Method	char	1	0	Allow NULL?
111	EMPFB	Payee/Payer	nvarchar	10	0	Allow NULL?
112	RSTGR	Reason Code for Payments	nvarchar	3	0	Allow NULL?
113	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
114	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	Allow NULL?
115	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	Allow NULL?
116	REBZT	Follow-On Document Type	char	1	0	Allow NULL?
117	REBZG_CHECK	Check Indicator for REBZG Checks in ACC Interface	char	1	0	Allow NULL?
118	MABER	Dunning Area	nvarchar	2	0	Allow NULL?
119	MSCHL	Dunning key	char	1	0	Allow NULL?
120	MADAT	Last dunned on	nvarchar	8	0	Allow NULL?
121	MANST	Dunning level	char	1	0	Allow NULL?
122	MANSP	Dunning block	char	1	0	Allow NULL?
123	ZLSPR	Payment Block Key	char	1	0	Allow NULL?
124	ADRNR	Address	nvarchar	10	0	Allow NULL?
125	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
126	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	Allow NULL?
127	LZBKZ	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
128	LANDL	Supplying Country	nvarchar	3	0	Allow NULL?
129	LAND1_ACNT	Customer/Vendor Country	nvarchar	3	0	Allow NULL?
130	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	Allow NULL?
131	SAMNR	Invoice List Number	nvarchar	8	0	Allow NULL?
132	ABPER	Settlement period	nvarchar	6	0	Allow NULL?
133	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
134	DTWS1	Instruction key 1	nvarchar	2	0	Allow NULL?
135	DTWS2	Instruction key 2	nvarchar	2	0	Allow NULL?
136	DTWS3	Instruction key 3	nvarchar	2	0	Allow NULL?
137	DTWS4	Instruction key 4	nvarchar	2	0	Allow NULL?
138	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
139	GSBER	Business Area	nvarchar	4	0	Allow NULL?
140	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
141	LSTAR	Activity Type	nvarchar	6	0	Allow NULL?
142	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
143	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
144	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3
145	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	Allow NULL?
146	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
147	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
148	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
149	BZDAT	Asset value date	nvarchar	8	0	Allow NULL?
150	ANBWA	Asset Transaction Type	nvarchar	3	0	Allow NULL?
151	WEBUD	Goods receipt posting date	nvarchar	8	0	Allow NULL?
152	RMVCT	Transaction Type	nvarchar	3	0	Allow NULL?
153	ABUKR	Company Code which will be Cleared Against	nvarchar	4	0	Allow NULL?
154	AIBN1	Original asset that was transferred	nvarchar	12	0	Allow NULL?
155	AIBN2	Original asset that was transferred	nvarchar	4	0	Allow NULL?
156	MATNR	Material Number	nvarchar	18	0	Allow NULL?
157	MENGE	Quantity	decimal	13	3
158	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
159	WERKS	Plant	nvarchar	4	0	Allow NULL?
160	BWART	Movement Type (Inventory Management)	nvarchar	3	0	Allow NULL?
161	PARGB	Trading partner's business area	nvarchar	4	0	Allow NULL?
162	GSBER_GP	Business area reported to the partner	nvarchar	4	0	Allow NULL?
163	BUZID	Identification of the Line Item	char	1	0	Allow NULL?
164	HOART	Type of origin object (EC-PCA)	nvarchar	2	0	Allow NULL?
165	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	Allow NULL?
166	HKMAT	Material-related origin	char	1	0	Allow NULL?
167	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	Allow NULL?
168	KSTRG	Cost Object	nvarchar	12	0	Allow NULL?
169	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
170	PRZNR	Business Process	nvarchar	12	0	Allow NULL?
171	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
172	PPRCTR	Partner Profit Center	nvarchar	10	0	Allow NULL?
173	PROJK	Project Account Assignment (PS_PSP_PNR Batch Input Field)	nvarchar	24	0	Allow NULL?
174	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
175	MAT_PSPNR	Valuated Sales Order Stock WBS Element	nvarchar	8	0	Allow NULL?
176	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
177	AUFPL	Routing number of operations in the order	nvarchar	10	0	Allow NULL?
178	APLZL	Internal counter	nvarchar	8	0	Allow NULL?
179	AUFPS	Order Item Number	nvarchar	4	0	Allow NULL?
180	FIKRS	Financial Management Area	nvarchar	4	0	Allow NULL?
181	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
182	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
183	GEBER	Fund	nvarchar	10	0	Allow NULL?
184	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
185	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	Allow NULL?
186	KBLTYP_EXT	Earmarked Funds: Reference Object Type	nvarchar	5	0	Allow NULL?
187	KBLREF_EXT	Earmarked Funds: Reference Document Number	nvarchar	10	0	Allow NULL?
188	KBLORG_EXT	Earmarked Funds: Reference Organization Units	nvarchar	10	0	Allow NULL?
189	KBLPOS_EXT	Earmarked Funds: Reference Line Item	nvarchar	10	0	Allow NULL?
190	ERLKZ	Completion indicator for line item	char	1	0	Allow NULL?
191	LOTKZ	Lot Number for Documents	nvarchar	10	0	Allow NULL?
192	STTAX	Tax amount as statistical information in document currency	decimal	13	2
193	STHTX	Tax Amount as Statistical Information in Co. Code Currency	decimal	13	2
194	VBELN	Sales and Distribution Document Number	nvarchar	10	0	Allow NULL?
195	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
196	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
197	MAT_KDAUF	Sales Order Number of Valuated Sales Order Stock	nvarchar	10	0	Allow NULL?
198	MAT_KDPOS	Sales Order Item of Valuated Sales Order Stock	nvarchar	6	0	Allow NULL?
199	KZVBR	Consumption Posting	char	1	0	Allow NULL?
200	KZBWS	Valuation of Special Stock	char	1	0	Allow NULL?
201	SOBKZ	Special Stock Indicator	char	1	0	Allow NULL?
202	ZINKZ	Exempted from interest calculation	nvarchar	2	0	Allow NULL?
203	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
204	BWKEY	Valuation Area	nvarchar	4	0	Allow NULL?
205	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
206	VNAME	Joint Venture	nvarchar	6	0	Allow NULL?
207	EGRUP	Equity group	nvarchar	3	0	Allow NULL?
208	BTYPE	Payroll Type	nvarchar	2	0	Allow NULL?
209	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
210	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
211	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	Allow NULL?
212	VPRSV	Price control indicator	char	1	0	Allow NULL?
213	RECID	Recovery Indicator	nvarchar	2	0	Allow NULL?
214	RECID_MAN	Indicator: Recovery Indicator Set Manually.	char	1	0	Allow NULL?
215	ETYPE	Equity type	nvarchar	3	0	Allow NULL?
216	VPTNR	Partner account number	nvarchar	10	0	Allow NULL?
217	XBILK	Indicator: Account is a balance sheet account?	char	1	0	Allow NULL?
218	XUMSW	Indicator: Sales-related item ?	char	1	0	Allow NULL?
219	TAXIT	Indicator: Tax Item	char	1	0	Allow NULL?
220	XAUTO	Indicator: Line item automatically created	char	1	0	Allow NULL?
221	FCVAL	Indicator: Line Item Contains Foreign Currency Valuation	char	1	0	Allow NULL?
222	BEKNZ	Debit/credit indicator	char	1	0	Allow NULL?
223	KZBEW	Movement Indicator	char	1	0	Allow NULL?
224	PSTYP	Item Category in Purchasing Document	char	1	0	Allow NULL?
225	BUSTW	Posting string for values	nvarchar	4	0	Allow NULL?
226	TBTKZ	Indicator: subsequent debit/credit	char	1	0	Allow NULL?
227	XUMBW	Revaluation	char	1	0	Allow NULL?
228	SCOPE	Object Class	nvarchar	2	0	Allow NULL?
229	AUTYP	Order category	nvarchar	2	0	Allow NULL?
230	XMFRW	Indicator: Update quantity in RW	char	1	0	Allow NULL?
231	ESRNR	ISR Subscriber Number	nvarchar	11	0	Allow NULL?
232	ESRPZ	ISR Check Digit	nvarchar	2	0	Allow NULL?
233	ESRRE	ISR Reference Number	nvarchar	27	0	Allow NULL?
234	QSSKZ	Withholding Tax Code	nvarchar	2	0	Allow NULL?
235	BKLAS	Valuation Class	nvarchar	4	0	Allow NULL?
236	BWMOD	Valuation Grouping Code	nvarchar	4	0	Allow NULL?
237	MTART	Material Type	nvarchar	4	0	Allow NULL?
238	EPRCTR	Partner profit center for elimination of internal business	nvarchar	10	0	Allow NULL?
239	POSNR_SD	Item number of the SD document	nvarchar	6	0	Allow NULL?
240	KSCHL	Condition type	nvarchar	4	0	Allow NULL?
241	STUNR	Step number	nvarchar	3	0	Allow NULL?
242	ZAEHK	Condition counter	nvarchar	2	0	Allow NULL?
243	FKART	Billing Type	nvarchar	4	0	Allow NULL?
244	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
245	KUNAG	Sold-to party	nvarchar	10	0	Allow NULL?
246	SPART	Division	nvarchar	2	0	Allow NULL?
247	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
248	VKBUR	Sales Office	nvarchar	4	0	Allow NULL?
249	VKGRP	Sales Group	nvarchar	3	0	Allow NULL?
250	FKDAT	Billing date for billing index and printout	nvarchar	8	0	Allow NULL?
251	FKTYP	Billing category	char	1	0	Allow NULL?
252	FBUDA	Date on which services rendered	nvarchar	8	0	Allow NULL?
253	AUBEL	Sales Document	nvarchar	10	0	Allow NULL?
254	AUPOS	Sales Document Item	nvarchar	6	0	Allow NULL?
255	FKIMG	Actual Invoiced Quantity	decimal	13	3
256	VRKME	Sales unit	nvarchar	3	0	Allow NULL?
257	FKLMG	Billing quantity in stockkeeping unit	decimal	13	3
258	KAPPL	Application	nvarchar	2	0	Allow NULL?
259	KNTYP	Condition category (examples: tax, freight, price, cost)	char	1	0	Allow NULL?
260	KURSK	Exchange Rate for Price Determination	decimal	9	5
261	KZZUAB	Debit/Credit Indicator	char	1	0	Allow NULL?
262	KINAK	Condition is inactive	char	1	0	Allow NULL?
263	NTGEW	Net weight	decimal	15	3
264	BRGEW	Gross weight	decimal	15	3
265	GEWEI	Weight Unit	nvarchar	3	0	Allow NULL?
266	VOLUM	Volume	decimal	15	3
267	VOLEH	Volume unit	nvarchar	3	0	Allow NULL?
268	VBTYP	SD document category	char	1	0	Allow NULL?
269	VBEL2	Sales Document	nvarchar	10	0	Allow NULL?
270	POSN2	Sales Document Item	nvarchar	6	0	Allow NULL?
271	FDLEV	Planning level	nvarchar	2	0	Allow NULL?
272	FDTAG	Planning date	nvarchar	8	0	Allow NULL?
273	FDGRP	Planning Group	nvarchar	10	0	Allow NULL?
274	FDWBT	Planning amount in document currency	decimal	13	2
275	KZUML	Stock transfer/transfer posting	char	1	0	Allow NULL?
276	XPKON	Check account assignment	char	1	0	Allow NULL?
277	KOAID	Condition class	char	1	0	Allow NULL?
278	XAKON	Indicator: CO account assignment field filled automatically	char	1	0	Allow NULL?
279	FKBER	Functional Area	nvarchar	16	0	Allow NULL?
280	AFABE	Real depreciation area	nvarchar	2	0	Allow NULL?
281	VERSA	Results Analysis Version	nvarchar	3	0	Allow NULL?
282	WIP_CAT	Work in Process Categories for Profit Center Accounting	nvarchar	2	0	Allow NULL?
283	XLIFO	LIFO/FIFO-Relevant	char	1	0	Allow NULL?
284	ERFMG	Quantity in Unit of Entry	decimal	13	3
285	ERFME	Unit of Entry	nvarchar	3	0	Allow NULL?
286	DABRZ	Reference Date for Settlement	nvarchar	8	0	Allow NULL?
287	AUGDT	Clearing Date	nvarchar	8	0	Allow NULL?
288	AUGCP	Clearing Entry Date	nvarchar	8	0	Allow NULL?
289	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	Allow NULL?
290	AGZEI	Clearing Item	decimal	5	0
291	XNEGP	Indicator: Negative posting	char	1	0	Allow NULL?
292	STGRD	Reason for Reversal	nvarchar	2	0	Allow NULL?
293	CCINS	Payment cards: Card type	nvarchar	4	0	Allow NULL?
294	CCNUM	Payment cards: Card number	nvarchar	25	0	Allow NULL?
295	CCFOL	Payment cards: Payment card suffix	nvarchar	10	0	Allow NULL?
296	DATAB	Payment cards: Valid from	nvarchar	8	0	Allow NULL?
297	DATBI	Payment Cards: Valid To	nvarchar	8	0	Allow NULL?
298	CCNAME	Payment cards: Name of cardholder	nvarchar	40	0	Allow NULL?
299	CSOUR	Payment cards: Entry mode	char	1	0	Allow NULL?
300	AUTWR	Payment cards: Authorized amount	decimal	15	2
301	CCWAE	Currency Key	nvarchar	5	0	Allow NULL?
302	SETTL	Payment cards: Settlement carried out	char	1	0	Allow NULL?
303	AUNUM	Payment cards: Authorization number	nvarchar	10	0	Allow NULL?
304	AUTRA	Payment cards: Authoriz. reference code of clearing house	nvarchar	15	0	Allow NULL?
305	AUDAT	Payment cards: Authorization date	nvarchar	8	0	Allow NULL?
306	AUTIM	Payment cards: Authorization time	nvarchar	6	0	Allow NULL?
307	MERCH	Payment cards: Merchant ID at the clearing house	nvarchar	15	0	Allow NULL?
308	LOCID	Payment cards: Point of receipt for the transaction	nvarchar	10	0	Allow NULL?
309	TRMID	Payment cards: Terminal	nvarchar	10	0	Allow NULL?
310	CCBTC	Payment cards: Settlement run	nvarchar	10	0	Allow NULL?
311	CCTYP	Payment cards: Card category	nvarchar	2	0	Allow NULL?
312	CCARD_GUID	Reference to Encrypted Payment Card Data	nvarchar	32	0	Allow NULL?
313	KKBER	Credit control area	nvarchar	4	0	Allow NULL?
314	SHKZG_VA	Returns Item	char	1	0	Allow NULL?
315	SDSTR	Third-Party Order Processing	char	1	0	Allow NULL?
316	POSAR	Item type	char	1	0	Allow NULL?
317	ANLO1	Main Asset Number	nvarchar	12	0	Allow NULL?
318	ANLO2	Asset Subnumber	nvarchar	4	0	Allow NULL?
319	CONDI	Joint Venture Indicator (Condition Key)	nvarchar	2	0	Allow NULL?
320	BEMOT	Accounting Indicator	nvarchar	2	0	Allow NULL?
321	ABSBT	Credit management: Hedged amount	decimal	13	2
322	KIDNO	Payment Reference	nvarchar	30	0	Allow NULL?
323	BRNCH	Branch Number	nvarchar	4	0	Allow NULL?
324	NUMPG	Number of pages of invoice	nvarchar	3	0	Allow NULL?
325	ADISC	Indicator: entry represents a discount document	char	1	0	Allow NULL?
326	GRICD	Activity Code for Gross Income Tax	nvarchar	2	0	Allow NULL?
327	GRIRG	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
328	GITYP	Distribution Type for Employment Tax	nvarchar	2	0	Allow NULL?
329	WT_KEY	Grouping key for withholding tax information	nvarchar	6	0	Allow NULL?
330	XBGBB	Posting for offsetting entry	char	1	0	Allow NULL?
331	VERTT	Contract Type	char	1	0	Allow NULL?
332	VERTN	Contract Number	nvarchar	13	0	Allow NULL?
333	VBEWA	Flow Type	nvarchar	4	0	Allow NULL?
334	BVTYP	Partner Bank Type	nvarchar	4	0	Allow NULL?
335	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
336	HKTID	ID for account details	nvarchar	5	0	Allow NULL?
337	NEBTR	Net Payment Amount	decimal	13	2
338	MWSK1	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
339	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2
340	MWSK2	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
341	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2
342	MWSK3	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
343	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2
344	ABWZE	Alternative payee	nvarchar	10	0	Allow NULL?
345	BVTYPABW	Bank type of alternative payer	nvarchar	4	0	Allow NULL?
346	BAPI_PARAM	Field Name	nvarchar	30	0	Allow NULL?
347	BAPI_TABIX	Row Index of Internal Tables	int	10	0	Allow NULL?
348	CCACT	G/L Account Number for Payment Card Receivables	nvarchar	10	0	Allow NULL?
349	CO_KAKST	Account Assignment Type: Cost Center	char	1	0	Allow NULL?
350	CO_KAAUF	Account assignment type: Order	char	1	0	Allow NULL?
351	CO_KAPRO	Project account assignment type	char	1	0	Allow NULL?
352	CO_KAKTR	Account Assignment Type: Cost Object	char	1	0	Allow NULL?
353	CO_KANPL	Account Assignment Type: Network	char	1	0	Allow NULL?
354	CO_KAIMO	Account Assignment Type: Real Estate Object	char	1	0	Allow NULL?
355	CO_KAKDA	Account Assignment Type: Sales Order	char	1	0	Allow NULL?
356	CO_KAERG	Business segment account assignment type	char	1	0	Allow NULL?
357	CO_KAABS	Account assignment type: reconciliation object	char	1	0	Allow NULL?
358	CO_KAPRZ	Account Assignment Type: Business Process	char	1	0	Allow NULL?
359	CO_KASAT	Account Assignment Type Not Used	char	1	0	Allow NULL?
360	ZZSPREG	Special Region	nvarchar	5	0	Allow NULL?
361	ZZBUSPARTN	Business partner	nvarchar	10	0	Allow NULL?
362	ZZPRODUCT	Product group	nvarchar	10	0	Allow NULL?
363	ZZLOCA	City	nvarchar	4	0	Allow NULL?
364	ZZCHAN	Distribution channel	nvarchar	4	0	Allow NULL?
365	ZZLOB	BUSINESS LINE	nvarchar	7	0	Allow NULL?
366	ZZNFAL		nvarchar	10	0	Allow NULL?
367	ZZUSERFLD1	Territory	nvarchar	9	0	Allow NULL?
368	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	Allow NULL?
369	ZZUSERFLD3	Vein	nvarchar	22	0	Allow NULL?
370	ZZREGION	Location	nvarchar	3	0	Allow NULL?
371	ZZSTATE	State/Province Code	nvarchar	3	0	Allow NULL?
372	BVALTNR	Procurement alternative/process	nvarchar	12	0	Allow NULL?
373	KALN1	Cost Estimate Number - Product Costing	nvarchar	12	0	Allow NULL?
374	AUFNR_ORG	Original Order Number	nvarchar	12	0	Allow NULL?
375	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	Allow NULL?
376	MLMAA	Material ledger activated at material level	char	1	0	Allow NULL?
377	MLAST	Material Price Determination: Control	char	1	0	Allow NULL?
378	ZEILE	Item in material or invoice verification document	nvarchar	6	0	Allow NULL?
379	URZEILE	Original item in material or invoice document	nvarchar	6	0	Allow NULL?
380	MLBWG	Movement Type Group for ML Update	nvarchar	2	0	Allow NULL?
381	MLNPRD	Do not break down price differences in profit center acctg	char	1	0	Allow NULL?
382	LSQTY	Last Settlement Amount in Current Period (Production Order)	decimal	15	3
383	PRQTY	Base Quantity for Invoice Verification Price Differences	decimal	15	3
384	EKORG	Purchasing Organization	nvarchar	4	0	Allow NULL?
385	VKWRT	Value at Sales Prices Including Value-Added Tax	decimal	13	2
386	UMMAT	Receiving/Issuing Material	nvarchar	18	0	Allow NULL?
387	UMWRK	Receiving/Issuing Plant	nvarchar	4	0	Allow NULL?
388	KNTTP	Account Assignment Category	char	1	0	Allow NULL?
389	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	Allow NULL?
390	UMWER	Value Update in Material Master Record	char	1	0	Allow NULL?
391	RRREL	Revenue recognition category	char	1	0	Allow NULL?
392	MAT_LIFNR	Valuated Vendor Stocks	nvarchar	10	0	Allow NULL?
393	XOBEW	Vendor Stock Valuation Indicator	char	1	0	Allow NULL?
394	TPKNZ	Transfer Price Indicator	char	1	0	Allow NULL?
395	XINVE	Indicator: Capital Goods Affected?	char	1	0	Allow NULL?
396	KRUEK	Condition is Relevant for Accrual (e.g. Freight)	char	1	0	Allow NULL?
397	AWTYP_REV	Reference Transaction	nvarchar	5	0	Allow NULL?
398	AWTYP_REB	Reference Transaction	nvarchar	5	0	Allow NULL?
399	VORNR	Operation/Activity Number	nvarchar	4	0	Allow NULL?
400	PGEBER	Partner Fund	nvarchar	10	0	Allow NULL?
401	PENRC	Reason for late payment	nvarchar	2	0	Allow NULL?
402	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
403	PGRANT_NBR	Partner Grant	nvarchar	20	0	Allow NULL?
404	GMVKZ	Item is in Execution	char	1	0	Allow NULL?
405	SRTYPE	Type of Additional Receivable	nvarchar	2	0	Allow NULL?
406	REINDAT	Invoice Receipt Date	nvarchar	8	0	Allow NULL?
407	IDXSP	Inflation Index	nvarchar	5	0	Allow NULL?
408	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	Allow NULL?
409	GLUPM	Update Method for FM - FI-CA Integration	char	1	0	Allow NULL?
410	MEASURE	Funded Program	nvarchar	24	0	Allow NULL?
411	STBLG	Reverse Document Number	nvarchar	10	0	Allow NULL?
412	HZUON	Assignment Number for Special G/L Accounts	nvarchar	18	0	Allow NULL?
413	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
414	PSEGMENT	Partner Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
415	PFKBER	Partner Functional Area	nvarchar	16	0	Allow NULL?
416	PKOSTL	Sender cost center	nvarchar	10	0	Allow NULL?
417	KSTAR	Cost Element	nvarchar	10	0	Allow NULL?
418	FLG_NOBUD	Not budget-relevant	char	1	0	Allow NULL?
419	PPA_EX_IND	PPA Exclude Indicator	char	1	0	Allow NULL?
420	CASE_GUID_CORE	Technical Case Key (Case GUID)	nvarchar	32	0	Allow NULL?
421	LONGNUM	Smart Number	nvarchar	40	0	Allow NULL?
422	STODT	Planned Date for the Reverse Posting	nvarchar	8	0	Allow NULL?
423	BDGT_SUBTYPE	Budget Subtype	nvarchar	4	0	Allow NULL?
424	COHORT	Reporting Year for Cohort	nvarchar	4	0	Allow NULL?
425	PUBLAW	Public Law Cited	nvarchar	20	0	Allow NULL?
426	LEGIS	Type of Legislation	char	1	0	Allow NULL?
427	FMCMMTSTR	FM Commitment String For Budgetary Ledger	nvarchar	62	0	Allow NULL?
428	PRODPER	Production Month (Date to find period and year)	nvarchar	8	0	Allow NULL?
429	TCOBJNR	Object number	nvarchar	22	0	Allow NULL?
430	DATEOFSERVICE	Date of Service	nvarchar	8	0	Allow NULL?
431	NOTAXCORR	Do Not Consider Item in Input Tax Correction	char	1	0	Allow NULL?
432	DIFFOPTRATE	Real estate option rate	decimal	9	6
433	HASDIFFOPTRATE	Use Different Option Rate	char	1	0	Allow NULL?
434	CURTP	Currency Type and Valuation View	nvarchar	2	0	Allow NULL?
435	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
436	WRBTR	Amount or tax amount in the currency of the currency types	decimal	13	2
437	FWBAS	Tax base amount in the currency of the currency types	decimal	13	2
438	SKFBT	Amnt Eligible for Cash Disc.in the Curr.of the Curr.Types	decimal	13	2
439	WSKTO	Cash Discount Amount in the Currency of the Currency Types	decimal	13	2
440	QSSHB	Withholding Tax Base Amnt in the Currency of the Curr.Types	decimal	13	2
441	QSFBT	Amnt Exempt from Withhold.Tax in the Curr.of the Curr.Types	decimal	13	2
442	BUALT	Amount posted in alternative price control	decimal	13	2
443	KWERT	Condition value	decimal	13	2
444	NAVBT	Non-Deductible Input Tax (in Document Currency)	decimal	13	2
445	WMWST	Tax amount in document currency	decimal	13	2
446	CURRTYP	Currency Type	nvarchar	2	0	Allow NULL?
447	VALUTYP	Valuation View	char	1	0	Allow NULL?
448	GBETR	Hedged Amount in Foreign Currency	decimal	13	2
449	KURSR	Hedged Exchange Rate	decimal	9	5
450	WRBTR_FIX	Fixed Part of Amount in Currency of Currency Type	decimal	13	2
451	WRBTR_AVG	ADB: Average Amount	decimal	23	2
452	CURT1	Currency type of the first local currency	nvarchar	2	0	Allow NULL?
453	HWAER	Local Currency	nvarchar	5	0	Allow NULL?
454	DMBTR	Amount in Local Currency	decimal	13	2
455	KURSF	Exchange rate	decimal	9	5
456	HWSTE	Tax Amount in Local Currency	decimal	13	2
457	HWBAS	Tax Base Amount in Local Currency	decimal	13	2
458	TXKRS	Exchange Rate for Taxes	decimal	9	5
459	SKNTO	Cash discount amount in local currency	decimal	13	2
460	KZBTR	Original Reduction Amount in Local Currency	decimal	13	2
461	MWSTS	Tax Amount in Local Currency	decimal	13	2
462	DMBTR_AVG	ADB: Average Amount	decimal	23	2
463	CURT2	Currency Type of Second Local Currency	nvarchar	2	0	Allow NULL?
464	HWAE2	Currency Key of Second Local Currency	nvarchar	5	0	Allow NULL?
465	DMBE2	Amount in Second Local Currency	decimal	13	2
466	KURS2	Exchange Rate for the Second Local Currency	decimal	9	5
467	H2STE	Tax Amount in Local Currency 2	decimal	13	2
468	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2
469	MWST2	Tax Amount in Second Local Currency	decimal	13	2
470	TXBH2	Tax Base/Original Tax Base in Second Local Currency	decimal	13	2
471	BASW2	Source Currency for Currency Translation	char	1	0	Allow NULL?
472	UMRD2	Translation Date Type for Second Local Currency	char	1	0	Allow NULL?
473	KUTY2	Exchange Rate Type	nvarchar	4	0	Allow NULL?
474	DMBE2_AVG	ADB: Average Amount	decimal	23	2
475	CURT3	Currency Type of Third Local Currency	nvarchar	2	0	Allow NULL?
476	HWAE3	Currency Key of Third Local Currency	nvarchar	5	0	Allow NULL?
477	DMBE3	Amount in Third Local Currency	decimal	13	2
478	KURS3	Exchange Rate for the Third Local Currency	decimal	9	5
479	H3STE	Tax Amount in Local Currency 3	decimal	13	2
480	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2
481	MWST3	Tax Amount in Third Local Currency	decimal	13	2
482	TXBH3	Tax Base/Original Tax Base in Third Local Currency	decimal	13	2
483	BASW3	Source Currency for Currency Translation	char	1	0	Allow NULL?
484	UMRD3	Translation Date Type for Third Local Currency	char	1	0	Allow NULL?
485	KUTY3	Exchange Rate Type	nvarchar	4	0	Allow NULL?
486	DMBE3_AVG	ADB: Average Amount	decimal	23	2

TOP ERP 6.0 | GLE_FI_ITEM_MODF INDEXES

Name	Primary	Unique	Type	Columns
GLE_FI_ITEM_MODF~0	Yes	Yes	CLUSTERED	ITEM_ID, 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

486 COLUMNS | 1 INDEXES | ERP 6.0 | GLE_FI_ITEM_MODF TABLE

TOP ERP 6.0 | GLE_FI_ITEM_MODF COLUMNS

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

486 COLUMNS | 1 INDEXES | ERP 6.0 | GLE_FI_ITEM_MODF TABLE

TOPERP 6.0 | GLE_FI_ITEM_MODF COLUMNS

TOPERP 6.0 | GLE_FI_ITEM_MODF INDEXES

TOP ERP 6.0 | GLE_FI_ITEM_MODF COLUMNS

TOP ERP 6.0 | GLE_FI_ITEM_MODF INDEXES