	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

193 COLUMNS | 2 INDEXES | ERP 6.0 | ACCTIT TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting
1	ERP EHP7	6.0	ACCTIT	193	2	Compressed Data from FI/CO Document	Financial Accounting

SQL: selectupdate insert create

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

SELECT MANDT, AWTYP, AWREF, AWORG, POSNR, KSTAT, AWREF_REV, AWORG_REV, BUKRS, BELNR, GJAHR, BLDAT, BUDAT, WWERT, VALUT, MONAT, BLART, XBLNR, VORGN, PRVRG, PRVRG_SV, KTOSL, UMSKZ, BSCHL, SHKZG, PSWSL, PSWBT, KOART, KUNNR, LIFNR, SAKNR, HKONT, ALTKT, GVTYP, SGTXT, GSBER, KOSTL, KOKRS, PERNR, BPMNG, BPRME, AUFNR, ANLN1, ANLN2, ANBWA, RMVCT, ABUKR, AIBN1, AIBN2, MATNR, MENGE, MEINS, WERKS, BWART, PARGB, GSBER_GP, BUZID, HOART, HRKFT, HKMAT, IMKEY, KSTRG, PAOBJNR, PRCTR, PPRCTR, PS_PSP_PNR, NPLNR, AUFPL, VBELN, KDAUF, KDPOS, KZVBR, KZBWS, SOBKZ, VBUND, BWKEY, BWTAR, VNAME, EGRUP, BTYPE, EBELN, EBELP, ZEKKN, RECID, VPTNR, XBILK, XUMSW, KZBEW, TBTKZ, XUMBW, SCOPE, AUTYP, XMFRW, BKLAS, BWMOD, MTART, KZUML, XPKON, KOAID, EPRCTR, FIKRS, FIPOS, FISTL, GEBER, KBLNR, KBLPOS, LOTKZ, STTAX, BEMOT, 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, BUSTW, ZEILE, URZEILE, PSTYP, FKBER, ERFMG, ERFME, DABRZ, APLZL, BUPLA, SECCO, LOKKT, LSTAR, PRZNR, XNEGP, MAT_KDAUF, MAT_KDPOS, MAT_PSPNR, LOGVO, XBGBB, TPKNZ, GRANT_NBR, AUFPS, SEGMENT, PSEGMENT, BUDGET_PD, AUBEL, AUPOS, BUZEI, MEASURE, MWSKZ, POSN2, POSNR_SD, PSOBT, PSOZL, REBZG, REBZJ, REBZT, REBZZ, SHKZG_VA, STHTX, TAXIT, TXJCD, VBEL2, XAUTO, XREF2, XREF3, ZBD1P, ZBD1T, ZBD2T, ZBD3T, ZFBDT, ZUONR, FMXDOCNR, FMXYEAR, FMXDOCLN, FMXZEKKN, ANL01, ANL02, HBKID, PRODPER FROM ACCTIT

TOP ERP 6.0 | ACCTIT 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	*	MANDT	Allow NULL?
2	AWTYP	Reference Transaction	nvarchar	5	0	CHAR	(N' ')	No	*	AWTYP	Allow NULL?
3	AWREF	Reference Document Number	nvarchar	10	0	CHAR	(N' ')	No		AWREF	Allow NULL?
4	AWORG	Reference Organizational Units	nvarchar	10	0	CHAR	(N' ')	No		AWORG	Allow NULL?
5	POSNR	Accounting Document Line Item Number	nvarchar	10	0	NUMC	(N'0000000000')	No		POSNR_ACC	Allow NULL?
6	KSTAT	Indicator for Statistical Line Items	char	1	0	CHAR	(N' ')	No		KSTAZ	Allow NULL?
7	AWREF_REV	Reversal: Reverse Document Reference Document Number	nvarchar	10	0	CHAR	(N' ')	No		AWREF_REV	Allow NULL?
8	AWORG_REV	Reversal: Reverse Document Reference Organization	nvarchar	10	0	CHAR	(N' ')	No		AWORG_REV	Allow NULL?
9	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
10	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	No		BELNR_D	Allow NULL?
11	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
12	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	No		BLDAT	Allow NULL?
13	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	No		BUDAT	Allow NULL?
14	WWERT	Translation Date	nvarchar	8	0	DATS	(N'00000000')	No		WWERT_D	Allow NULL?
15	VALUT	Value date	nvarchar	8	0	DATS	(N'00000000')	No		VALUT	Allow NULL?
16	MONAT	Fiscal Period	nvarchar	2	0	NUMC	(N'00')	No		MONAT	Allow NULL?
17	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	No	*	BLART	Allow NULL?
18	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	No		XBLNR1	Allow NULL?
19	VORGN	Transaction Type for General Ledger	nvarchar	4	0	CHAR	(N' ')	No		VORGN	Allow NULL?
20	PRVRG	Business transaction for validations	nvarchar	4	0	CHAR	(N' ')	No	*	PRVRG	Allow NULL?
21	PRVRG_SV	Business transaction for status management	nvarchar	4	0	CHAR	(N' ')	No	*	PRVRG_SV	Allow NULL?
22	KTOSL	Transaction Key	nvarchar	3	0	CHAR	(N' ')	No		KTOSL	Allow NULL?
23	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	No	*	UMSKZ	Allow NULL?
24	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	No	*	BSCHL	Allow NULL?
25	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	No		SHKZG	Allow NULL?
26	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	No	*	PSWSL	Allow NULL?
27	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	No		PSWBT
28	KOART	Account Type	char	1	0	CHAR	(N' ')	No		KOART	Allow NULL?
29	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	No	*	KUNNR	Allow NULL?
30	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	No	*	LIFNR	Allow NULL?
31	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	No	*	SAKNR	Allow NULL?
32	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	No	*	HKONT	Allow NULL?
33	ALTKT	Account Number in Group	nvarchar	10	0	CHAR	(N' ')	No		ALTKT	Allow NULL?
34	GVTYP	P&L statement account type	nvarchar	2	0	CHAR	(N' ')	No		GVTYP	Allow NULL?
35	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	No		SGTXT	Allow NULL?
36	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	No	*	GSBER	Allow NULL?
37	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	*	KOSTL	Allow NULL?
38	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	No	*	KOKRS	Allow NULL?
39	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	No		PERNR_D	Allow NULL?
40	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	No		BPMNG
41	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	UNIT	(N' ')	No	*	BPRME	Allow NULL?
42	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
43	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	No	*	ANLN1	Allow NULL?
44	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	No	*	ANLN2	Allow NULL?
45	ANBWA	Asset Transaction Type	nvarchar	3	0	CHAR	(N' ')	No	*	ANBWA	Allow NULL?
46	RMVCT	Transaction Type	nvarchar	3	0	CHAR	(N' ')	No	*	RMVCT	Allow NULL?
47	ABUKR	Company Code which will be Cleared Against	nvarchar	4	0	CHAR	(N' ')	No	*	ABUKR	Allow NULL?
48	AIBN1	Original asset that was transferred	nvarchar	12	0	CHAR	(N' ')	No	*	AIBN1	Allow NULL?
49	AIBN2	Original asset that was transferred	nvarchar	4	0	CHAR	(N' ')	No	*	AIBN2	Allow NULL?
50	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	No	*	MATNR	Allow NULL?
51	MENGE	Quantity	decimal	13	3	QUAN	((0))	No		MENGE_D
52	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	No	*	MEINS	Allow NULL?
53	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	No	*	WERKS_D	Allow NULL?
54	BWART	Movement Type (Inventory Management)	nvarchar	3	0	CHAR	(N' ')	No	*	BWART	Allow NULL?
55	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	No	*	PARGB	Allow NULL?
56	GSBER_GP	Business area reported to the partner	nvarchar	4	0	CHAR	(N' ')	No	*	GSBER_GP	Allow NULL?
57	BUZID	Identification of the Line Item	char	1	0	CHAR	(N' ')	No		BUZID	Allow NULL?
58	HOART	Type of origin object (EC-PCA)	nvarchar	2	0	NUMC	(N'00')	No		HOART	Allow NULL?
59	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	CHAR	(N' ')	No	*	HRKFT	Allow NULL?
60	HKMAT	Material-related origin	char	1	0	CHAR	(N' ')	No		HKMAT	Allow NULL?
61	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	No		IMKEY	Allow NULL?
62	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	No	*	KSTRG	Allow NULL?
63	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	No		RKEOBJNR	Allow NULL?
64	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	No	*	PRCTR	Allow NULL?
65	PPRCTR	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	No	*	PPRCTR	Allow NULL?
66	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
67	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	No	*	NPLNR	Allow NULL?
68	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	No		CO_AUFPL	Allow NULL?
69	VBELN	Sales and Distribution Document Number	nvarchar	10	0	CHAR	(N' ')	No	*	VBELN	Allow NULL?
70	KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	No	*	KDAUF	Allow NULL?
71	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	No		KDPOS	Allow NULL?
72	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	No		KZVBR	Allow NULL?
73	KZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
74	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	*	SOBKZ	Allow NULL?
75	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	No	*	RASSC	Allow NULL?
76	BWKEY	Valuation Area	nvarchar	4	0	CHAR	(N' ')	No	*	BWKEY	Allow NULL?
77	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	No	*	BWTAR_D	Allow NULL?
78	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	No	*	JV_NAME	Allow NULL?
79	EGRUP	Equity group	nvarchar	3	0	CHAR	(N' ')	No	*	JV_EGROUP	Allow NULL?
80	BTYPE	Payroll Type	nvarchar	2	0	CHAR	(N' ')	No	*	JV_BILIND	Allow NULL?
81	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	No	*	EBELN	Allow NULL?
82	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	No	*	EBELP	Allow NULL?
83	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		DZEKKN	Allow NULL?
84	RECID	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	No	*	JV_RECIND	Allow NULL?
85	VPTNR	Partner account number	nvarchar	10	0	CHAR	(N' ')	No	*	JV_PART	Allow NULL?
86	XBILK	Indicator: Account is a balance sheet account?	char	1	0	CHAR	(N' ')	No		XBILK	Allow NULL?
87	XUMSW	Indicator: Sales-related item ?	char	1	0	CHAR	(N' ')	No		XUMSW	Allow NULL?
88	KZBEW	Movement Indicator	char	1	0	CHAR	(N' ')	No		KZBEW	Allow NULL?
89	TBTKZ	Indicator: subsequent debit/credit	char	1	0	CHAR	(N' ')	No		TBTKZ	Allow NULL?
90	XUMBW	Revaluation	char	1	0	CHAR	(N' ')	No		XUMBW	Allow NULL?
91	SCOPE	Object Class	nvarchar	2	0	CHAR	(N' ')	No		SCOPE_CV	Allow NULL?
92	AUTYP	Order category	nvarchar	2	0	NUMC	(N'00')	No		AUFTYP	Allow NULL?
93	XMFRW	Indicator: Update quantity in RW	char	1	0	CHAR	(N' ')	No		XMFRW	Allow NULL?
94	BKLAS	Valuation Class	nvarchar	4	0	CHAR	(N' ')	No	*	BKLAS	Allow NULL?
95	BWMOD	Valuation Grouping Code	nvarchar	4	0	CHAR	(N' ')	No		BWMOD	Allow NULL?
96	MTART	Material Type	nvarchar	4	0	CHAR	(N' ')	No	*	MTART	Allow NULL?
97	KZUML	Stock transfer/transfer posting	char	1	0	CHAR	(N' ')	No		KZUML	Allow NULL?
98	XPKON	Check account assignment	char	1	0	CHAR	(N' ')	No		XPKON	Allow NULL?
99	KOAID	Condition class	char	1	0	CHAR	(N' ')	No		KOAID	Allow NULL?
100	EPRCTR	Partner profit center for elimination of internal business	nvarchar	10	0	CHAR	(N' ')	No	*	EPRCTR	Allow NULL?
101	FIKRS	Financial Management Area	nvarchar	4	0	CHAR	(N' ')	No	*	FIKRS	Allow NULL?
102	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	No	*	FIPOS	Allow NULL?
103	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
104	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
105	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	No	*	KBLNR	Allow NULL?
106	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	No	*	KBLPOS	Allow NULL?
107	LOTKZ	Lot Number for Documents	nvarchar	10	0	CHAR	(N' ')	No		LOTKZ	Allow NULL?
108	STTAX	Tax amount as statistical information in document currency	decimal	13	2	CURR	((0))	No		STTAX
109	BEMOT	Accounting Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	*	BEMOT	Allow NULL?
110	CO_KAKST	Account Assignment Type: Cost Center	char	1	0	NUMC	(N'0')	No		CO_KAKST	Allow NULL?
111	CO_KAAUF	Account assignment type: Order	char	1	0	NUMC	(N'0')	No		CO_KAAUF	Allow NULL?
112	CO_KAPRO	Project account assignment type	char	1	0	NUMC	(N'0')	No		CO_KAPRO	Allow NULL?
113	CO_KAKTR	Account Assignment Type: Cost Object	char	1	0	NUMC	(N'0')	No		CO_KAKTR	Allow NULL?
114	CO_KANPL	Account Assignment Type: Network	char	1	0	NUMC	(N'0')	No		CO_KANPL	Allow NULL?
115	CO_KAIMO	Account Assignment Type: Real Estate Object	char	1	0	NUMC	(N'0')	No		CO_KAIMO	Allow NULL?
116	CO_KAKDA	Account Assignment Type: Sales Order	char	1	0	NUMC	(N'0')	No		CO_KAKDA	Allow NULL?
117	CO_KAERG	Business segment account assignment type	char	1	0	NUMC	(N'0')	No		CO_KAERG	Allow NULL?
118	CO_KAABS	Account assignment type: reconciliation object	char	1	0	NUMC	(N'0')	No		CO_KAABS	Allow NULL?
119	CO_KAPRZ	Account Assignment Type: Business Process	char	1	0	NUMC	(N'0')	Yes		CO_KAPRZ	Allow NULL?
120	CO_KASAT	Account Assignment Type Not Used	char	1	0	NUMC	(N'0')	Yes		CO_KASAT	Allow NULL?
121	ZZSPREG	Special Region	nvarchar	5	0	CHAR	(N' ')	Yes	ZZSPREG	ZREGION	Allow NULL?
122	ZZBUSPARTN	Business partner	nvarchar	10	0	CHAR	(N' ')	Yes		ZZBUSPARTN	Allow NULL?
123	ZZPRODUCT	Product group	nvarchar	10	0	CHAR	(N' ')	Yes		ZZPRODUCT	Allow NULL?
124	ZZLOCA	City	nvarchar	4	0	CHAR	(N' ')	Yes		ZZLOCA	Allow NULL?
125	ZZCHAN	Distribution channel	nvarchar	4	0	CHAR	(N' ')	Yes		ZZCHAN	Allow NULL?
126	ZZLOB	BUSINESS LINE	nvarchar	7	0	CHAR	(N' ')	Yes	*	ZZLOB	Allow NULL?
127	ZZNFAL		nvarchar	10	0		(N' ')	Yes			Allow NULL?
128	ZZUSERFLD1	Territory	nvarchar	9	0	CHAR	(N' ')	Yes	ZFU1	ZZUSERFLD1	Allow NULL?
129	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	CHAR	(N' ')	Yes		ZZUSERFLD2	Allow NULL?
130	ZZUSERFLD3	Vein	nvarchar	22	0	CHAR	(N' ')	Yes		ZZUSERFLD3	Allow NULL?
131	ZZREGION	Location	nvarchar	3	0	CHAR	(N' ')	Yes	ZREG	ZZREGION	Allow NULL?
132	ZZSTATE	State/Province Code	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	ZZSTATE	Allow NULL?
133	BUSTW	Posting string for values	nvarchar	4	0	CHAR	(N' ')	Yes		BUSTW	Allow NULL?
134	ZEILE	Item in material or invoice verification document	nvarchar	6	0	NUMC	(N'000000')	Yes		CK_ZEILE	Allow NULL?
135	URZEILE	Original item in material or invoice document	nvarchar	6	0	NUMC	(N'000000')	Yes		CK_URZEILE	Allow NULL?
136	PSTYP	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	*	PSTYP	Allow NULL?
137	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
138	ERFMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
139	ERFME	Unit of Entry	nvarchar	3	0	UNIT	(N' ')	Yes	*	ERFME	Allow NULL?
140	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
141	APLZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
142	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
143	SECCO	Section Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	SECCO	Allow NULL?
144	LOKKT	Account Number in the Local Chart of Accounts	nvarchar	10	0	CHAR	(N' ')	Yes	*	LOKKT	Allow NULL?
145	LSTAR	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	*	LSTAR	Allow NULL?
146	PRZNR	Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_PRZNR	Allow NULL?
147	XNEGP	Indicator: Negative posting	char	1	0	CHAR	(N' ')	Yes		XNEGP	Allow NULL?
148	MAT_KDAUF	Sales Order Number of Valuated Sales Order Stock	nvarchar	10	0	CHAR	(N' ')	Yes	*	MAT_KDAUF	Allow NULL?
149	MAT_KDPOS	Sales Order Item of Valuated Sales Order Stock	nvarchar	6	0	NUMC	(N'000000')	Yes		MAT_KDPOS	Allow NULL?
150	MAT_PSPNR	Valuated Sales Order Stock WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	MAT_PSPNR	Allow NULL?
151	LOGVO	Logical Transaction	nvarchar	6	0	CHAR	(N' ')	Yes		LOGVO	Allow NULL?
152	XBGBB	Posting for offsetting entry	char	1	0	CHAR	(N' ')	Yes		XBGBB	Allow NULL?
153	TPKNZ	Transfer Price Indicator	char	1	0	NUMC	(N'0')	Yes		TPKNZ	Allow NULL?
154	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
155	AUFPS	Order Item Number	nvarchar	4	0	NUMC	(N'0000')	Yes		CO_POSNR	Allow NULL?
156	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
157	PSEGMENT	Partner Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_PSEGMENT	Allow NULL?
158	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
159	AUBEL	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VA	Allow NULL?
160	AUPOS	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VA	Allow NULL?
161	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
162	MEASURE	Funded Program	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_MEASURE	Allow NULL?
163	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
164	POSN2	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VA	Allow NULL?
165	POSNR_SD	Item number of the SD document	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR	Allow NULL?
166	PSOBT	Posting Day	nvarchar	8	0	DATS	(N'00000000')	Yes		PSOBT	Allow NULL?
167	PSOZL	Checkbox	char	1	0	CHAR	(N' ')	Yes		XFELD	Allow NULL?
168	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
169	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
170	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
171	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
172	SHKZG_VA	Returns Item	char	1	0	CHAR	(N' ')	Yes		SHKZG_VA	Allow NULL?
173	STHTX	Tax Amount as Statistical Information in Co. Code Currency	decimal	13	2	CURR	((0))	Yes		STHTX
174	TAXIT	Indicator: Tax Item	char	1	0	CHAR	(N' ')	Yes		TAXIT	Allow NULL?
175	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	*	TXJCD	Allow NULL?
176	VBEL2	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VA	Allow NULL?
177	XAUTO	Indicator: Line item automatically created	char	1	0	CHAR	(N' ')	Yes		XAUTO	Allow NULL?
178	XREF2	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF2	Allow NULL?
179	XREF3	Reference key for line item	nvarchar	20	0	CHAR	(N' ')	Yes		XREF3	Allow NULL?
180	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
181	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
182	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
183	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
184	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
185	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
186	FMXDOCNR	FM Reference Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		FM_XDOCNR	Allow NULL?
187	FMXYEAR	FM Reference Year	nvarchar	4	0	NUMC	(N'0000')	Yes		FM_XYEAR	Allow NULL?
188	FMXDOCLN	FM Reference Line Item	nvarchar	6	0	NUMC	(N'000000')	Yes		FM_XDOCLN	Allow NULL?
189	FMXZEKKN	FM Reference Sequence Account Assignment	nvarchar	5	0	NUMC	(N'00000')	Yes		FM_XZEKKN	Allow NULL?
190	ANL01	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	ANLH	ANLN1	Allow NULL?
191	ANL02	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	ANLA	ANLN2	Allow NULL?
192	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
193	PRODPER	Production Month (Date to find period and year)	nvarchar	8	0	DATS	(N'00000000')	Yes		JV_PRODPER	Allow NULL?

TOP ERP 6.0 | ACCTIT INDEXES

Name	Primary	Unique	Type	Columns
ACCTIT~0	Yes	Yes	CLUSTERED	POSNR, AWORG, AWREF, AWTYP, MANDT
ACCTIT~1	No	No	NONCLUSTERED	AWTYP, BUKRS, MONAT, GJAHR

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

193 COLUMNS | 2 INDEXES | ERP 6.0 | ACCTIT TABLE

TOP ERP 6.0 | ACCTIT COLUMNS

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

193 COLUMNS | 2 INDEXES | ERP 6.0 | ACCTIT TABLE

TOPERP 6.0 | ACCTIT COLUMNS

TOPERP 6.0 | ACCTIT INDEXES

TOP ERP 6.0 | ACCTIT COLUMNS

TOP ERP 6.0 | ACCTIT INDEXES