	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

387 COLUMNS | 1 INDEXES | ERP 6.0 | GLPOS_C_CT TABLE

ERP EHP7

6.0

387

FI Document: Entry View

SQL: selectupdate insert create

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

SELECT MANDT, DEBIT, CREDIT, TURNOVER, COUNTER, CURTP, CURRUNIT, QUANTITY, QUANUNIT, CURRKEY_00, CURRVAL_00, CURRKEY_0D, CURRVAL_0D, CURRKEY_10, CURRVAL_10, CURRKEY_11, CURRVAL_11, CURRKEY_12, CURRVAL_12, CURRKEY_30, CURRVAL_30, CURRKEY_31, CURRVAL_31, CURRKEY_32, CURRVAL_32, CURRKEY_40, CURRVAL_40, CURRKEY_50, CURRVAL_50, CURRKEY_60, CURRVAL_60, ABPER, ADISC, AEDAT, AGZEI, ALTKT, ANBWA, ANFAE, ANFBJ, ANFBN, ANFBU, ANLN1, ANLN2, APLZL, ARCID, AUFNR, AUFPL, AUGBL, AUGCP, AUGDT, AUGGJ, AUSBK, AWKEY, AWSYS, AWTYP, BELNR, BEWAR, BKTXT, BLART, BLDAT, BLNPZ, BRNCH, BSCHL, BSTAT, BTYPE, BUDAT, BUKRS, BUPLA, BUSTW, BUZEI, BUZID, BVORG, BVTYP, BWKEY, BWTAR, BZDAT, CCBTC, CCINS, CCNUM, CESSION_KZ, CPUDT, CPUTM, DABRZ, DBBLG, DEPOT, DIEKZ, DISBJ, DISBN, DISBZ, DOCCAT, DOKID, DTWS1, DTWS2, DTWS3, DTWS4, DUEFL, EBELN, EBELP, EGBLD, EGLLD, EGRUP, ELIKZ, EMPFB, ESRNR, ESRPZ, ESRRE, ETEN2, ETYPE, FDGRP, FDLEV, FDTAG, FIKRS, FILKD, FIPOS, FISCPER, FISTL, FKBER_LONG, FKONT, GEBER, GITYP, GJAHR, GLUPM, GLVOR, GMVKZ, GRANT_NBR, GRICD, GRIRG, GRPID, GSBER, GVTYP, HBKID, HKONT, HKTID, HRKFT, HWMET, HZUON, IBLAR, IDXSP, IMKEY, INTRENO, KBLNR, KBLPOS, KIDNO, KKBER, KKTPL, KOART, KOKRS, KOSTL, KSTAR, KSTRG, KTOP2, KTOPL, KTOSL, KUNNR, KURSF, KURSR, KURST, LAND1, LANDL, LDGRP, LIFNR, LINFV, LNRAN, LOKKT, LOTKZ, LSTAR, LZBKZ, MABER, MADAT, MANSP, MANST, MATNR, MEASURE, MONAT, MSCHL, MWART, MWSK1, MWSK2, MWSK3, MWSKZ, NPLNR, NUMPG, OBZEI, PARGB, PEINH, PENDAYS, PENRC, PERIV, PERNR, PFKBER, PGEBER, PGRANT_NBR, POPTS, POSN2, PPA_EX_IND, PPNAM, PPRCT, PRCTR, PROJK, PROPMANO, PRZNR, PSALT, PSEGMENT, PYCUR, QSSKZ, QSZNR, REBZG, REBZJ, REBZT, REBZZ, RECID, REINDAT, RFZEI, RLDNR, RPACQ, RSTGR, RYACQ, SAKNR, SAMNR, SECCO, SEGMENT, SGTXT, SHKZG, SHZUZ, SPGRC, SPGRG, SPGRM, SPGRP, SPGRQ, SPGRS, SPGRT, SPGRV, SRTYPE, STBLG, STBUK, STCEG, STEKZ, STGRD, STJAH, STODT, TBTKZ, TCODE, TXDAT, TXGRP, TXJCD, UMSKS, UMSKZ, UPDDT, USNAM, UZAWE, VALUT, VATDATE, VBEL2, VBELN, VBEWA, VBUND, VERTN, VERTT, VNAME, VORGN, VPRSV, VPTNR, VRSDT, VRSKZ, WAERS, WERKS, WVERW, WWERT, XANET, XAUTO, XBILK, XBLNR, XBLNR_ALT, XCPDD, XEGDR, XFAKT, XHKOM, XHRES, XINVE, XKRES, XMWST, XNCOP, XNEGP, XNETB, XOPVW, XPANZ, XPYPR, XRAGL, XREF1, XREF1_HD, XREF2, XREF2_HD, XREF3, XREVERSAL, XRUEB, XSAUF, XSERG, XSKRL, XSKST, XSNET, XSPLIT, XSPRO, XSTOV, XUMAN, XUMSW, XUSVR, XWVOF, XZAHL, ZBD1P, ZBD1T, ZBD2P, ZBD2T, ZBD3T, ZBFIX, ZEKKN, ZFBDT, ZINKZ, ZLSCH, ZLSPR, ZOLLD, ZOLLT, ZTERM, ZUMSK, ZUONR, X_CLEARED_ITEM, NEBTR, NETDT, SK1DT, SK2DT, SKNTO, /SAPF15/STATUS, BATCH, BLIND, BUDGET_PD, CASH_ALLOC, EXCLUDE_FLAG, FASTPAY, FMFGUS_KEY, FMXDOCLN, FMXDOCNR, FMXYEAR, FMXZEKKN, FM_UMART, FOLLOW_ON, IGNR_IVREF, INTDATE, INTFORM, KNUMV, MNDID, OFFSET_REFER_DAT, OFFSET_STATUS, PAYS_PROV, PAYS_TRAN, PBUDGET_PD, PEROP_BEG, PEROP_END, PRODPER, PSOAK, PSOBT, PSODT, PSOFN, PSOKS, PSOSG, PSOTM, PSOTY, PSOZL, RE_ACCOUNT, RE_BUKRS, SAMPLED, SNAME, SSBLK, TAXPS, XFRGE_BSEG, XLGCLR, XMCA, XREORG, ZZBUSPARTN, ZZCHAN, ZZLOB, ZZLOCA, ZZPRODUCT, ZZREGION, ZZSPREG, ZZSTATE, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3 FROM GLPOS_C_CT

TOP ERP 6.0 | GLPOS_C_CT 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	DEBIT	Total Debit Postings	decimal	23	2	CURR	((0))	Yes		FAGL_UMSOL
3	CREDIT	Total Credit Postings	decimal	23	2	CURR	((0))	Yes		FAGL_UMHAB
4	TURNOVER	Balance	decimal	23	2	CURR	((0))	Yes		FAGL_SALES
5	COUNTER	Processed Database Table Rows	int	10	0	INT4	((0))	Yes		SYDBCNT	Allow NULL?
6	CURTP	Currency Type and Valuation View	nvarchar	2	0	CHAR	(N' ')	Yes		CURTP	Allow NULL?
7	CURRUNIT	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	RSCURRENCY	Allow NULL?
8	QUANTITY	Quantity	decimal	23	3	QUAN	((0))	Yes		QUAN1_12
9	QUANUNIT	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	ROUNIT	Allow NULL?
10	CURRKEY_00	Update Currency for General Ledger Totals Data	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_00	Allow NULL?
11	CURRVAL_00	Update Currency Value for General Ledger Totals Data	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_00
12	CURRKEY_0D	Document Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_0D	Allow NULL?
13	CURRVAL_0D	Document Currency Value	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_0D
14	CURRKEY_10	Company Code Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_10	Allow NULL?
15	CURRVAL_10	Company Code Currency Value	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_10
16	CURRKEY_11	Company Code Currency Key, Group Valuation	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_11	Allow NULL?
17	CURRVAL_11	Company Code Currency Value, Group Valuation	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_11
18	CURRKEY_12	Company Code Currency Key, Profit Center Valuation	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_12	Allow NULL?
19	CURRVAL_12	Company Code Currency Value, Profit Center Valuation	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_12
20	CURRKEY_30	Group Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_30	Allow NULL?
21	CURRVAL_30	Group Currency Value	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_30
22	CURRKEY_31	Group Currency Key, Group Valuation	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_31	Allow NULL?
23	CURRVAL_31	Group Currency Value, Group Valuation	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_31
24	CURRKEY_32	Group Currency Key, Profit Center Valuation	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_32	Allow NULL?
25	CURRVAL_32	Group Currency Value, Profit Center Valuation	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_32
26	CURRKEY_40	Hard Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_40	Allow NULL?
27	CURRVAL_40	Hard Currency Value	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_40
28	CURRKEY_50	Index Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_50	Allow NULL?
29	CURRVAL_50	Index Currency Value	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_50
30	CURRKEY_60	Global Company Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	FAGL_CURRKEY_60	Allow NULL?
31	CURRVAL_60	Global Company Currency Value	decimal	23	2	CURR	((0))	Yes		FAGL_CURRVAL_60
32	ABPER	Settlement Period	nvarchar	6	0	NUMC	(N'000000')	Yes		FAGL_SETTLEMENT_PERIOD	Allow NULL?
33	ADISC	Indicator: entry represents a discount document	char	1	0	CHAR	(N' ')	Yes		J_1ADISC	Allow NULL?
34	AEDAT	Date of the Last Document Change by Transaction	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT_BKPF	Allow NULL?
35	AGZEI	Clearing Item	decimal	5	0	DEC	((0))	Yes		AGZEI
36	ALTKT	Group account number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BILKT_SKA1	Allow NULL?
37	ANBWA	Asset Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	TABW	ANBWA	Allow NULL?
38	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ANFAE	Allow NULL?
39	ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	nvarchar	4	0	NUMC	(N'0000')	Yes		ANFBJ	Allow NULL?
40	ANFBN	Document Number of the Bill of Exchange Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes		ANFBN	Allow NULL?
41	ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	nvarchar	4	0	CHAR	(N' ')	Yes	T001	ANFBU	Allow NULL?
42	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	ANLH	ANLN1	Allow NULL?
43	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	ANLA	ANLN2	Allow NULL?
44	APLZL	General counter for order	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	APLZL_CH	Allow NULL?
45	ARCID	Extract ID Document Header	nvarchar	10	0	CHAR	(N' ')	Yes		EXTID_BKPF	Allow NULL?
46	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
47	AUFPL	Task list number for operations in order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		AUFPL_CH	Allow NULL?
48	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	CHAR	(N' ')	Yes		AUGBL	Allow NULL?
49	AUGCP	Clearing Entry Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGCP	Allow NULL?
50	AUGDT	Clearing Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGDT	Allow NULL?
51	AUGGJ	Fiscal Year of Clearing Document	nvarchar	4	0	NUMC	(N'0000')	Yes		AUGGJ	Allow NULL?
52	AUSBK	Source Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	AUSBK	Allow NULL?
53	AWKEY	Reference Key	nvarchar	20	0	CHAR	(N' ')	Yes		AWKEY	Allow NULL?
54	AWSYS	Logical System	nvarchar	10	0	CHAR	(N' ')	Yes	*	LOGSYSTEM	Allow NULL?
55	AWTYP	Reference Transaction	nvarchar	5	0	CHAR	(N' ')	Yes	TTYP	AWTYP	Allow NULL?
56	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
57	BEWAR	Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	T856	RMVCT	Allow NULL?
58	BKTXT	Document Header Text	nvarchar	25	0	CHAR	(N' ')	Yes		BKTXT	Allow NULL?
59	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	T003	BLART	Allow NULL?
60	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
61	BLNPZ	Preference Percentage Rate	decimal	7	2	DEC	((0))	Yes		BLNPZ
62	BRNCH	Branch Number	nvarchar	4	0	CHAR	(N' ')	Yes	*	J_1ABRNCH	Allow NULL?
63	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
64	BSTAT	Document Status	char	1	0	CHAR	(N' ')	Yes		BSTAT_D	Allow NULL?
65	BTYPE	Payroll Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_BILIND	Allow NULL?
66	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
67	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
68	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
69	BUSTW	Posting string for values	nvarchar	4	0	CHAR	(N' ')	Yes		BUSTW	Allow NULL?
70	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
71	BUZID	Identification of the Line Item	char	1	0	CHAR	(N' ')	Yes		BUZID	Allow NULL?
72	BVORG	Number of Cross-Company Code Posting Transaction	nvarchar	16	0	CHAR	(N' ')	Yes		BVORG	Allow NULL?
73	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
74	BWKEY	Valuation Area	nvarchar	4	0	CHAR	(N' ')	Yes	T001K	BWKEY	Allow NULL?
75	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
76	BZDAT	Asset value date	nvarchar	8	0	DATS	(N'00000000')	Yes		BZDAT	Allow NULL?
77	CCBTC	Payment cards: Settlement run	nvarchar	10	0	CHAR	(N' ')	Yes		CCBTC	Allow NULL?
78	CCINS	Payment cards: Card type	nvarchar	4	0	CHAR	(N' ')	Yes	TCRIN	CCINS_30F	Allow NULL?
79	CCNUM	Payment cards: Card number	nvarchar	25	0	CHAR	(N' ')	Yes		CCNUM_30F	Allow NULL?
80	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TCESSION	CESSION_KZ	Allow NULL?
81	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	DATS	(N'00000000')	Yes		CPUDT	Allow NULL?
82	CPUTM	Time of Entry	nvarchar	6	0	TIMS	(N'000000')	Yes		CPUTM	Allow NULL?
83	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
84	DBBLG	Recurring Entry Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		DBBLG	Allow NULL?
85	DEPOT	Securities Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	RLDEPO	Allow NULL?
86	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	CHAR	(N' ')	Yes		DIEKZ	Allow NULL?
87	DISBJ	Fiscal Year of Bill of Exchange Usage Document	nvarchar	4	0	NUMC	(N'0000')	Yes		DISBJ	Allow NULL?
88	DISBN	Number of Bill of Exchange Usage Document (Discount Doc.)	nvarchar	10	0	CHAR	(N' ')	Yes		DISBN	Allow NULL?
89	DISBZ	Line Item within the Bill of Exchange Usage Document	nvarchar	3	0	NUMC	(N'000')	Yes		DISBZ	Allow NULL?
90	DOCCAT	Classification of an FI Document	nvarchar	6	0	CHAR	(N' ')	Yes		DOCUMENT_CATEGORY	Allow NULL?
91	DOKID	Document Name in the Archive System	nvarchar	40	0	CHAR	(N' ')	Yes		DOKID_BKPF	Allow NULL?
92	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT16	Allow NULL?
93	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT17	Allow NULL?
94	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT18	Allow NULL?
95	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT19	Allow NULL?
96	DUEFL	Status of Data Transfer into Subsequent Release	char	1	0	CHAR	(N' ')	Yes		DUEFL_BKPF	Allow NULL?
97	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	EBELN	Allow NULL?
98	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	*	EBELP	Allow NULL?
99	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	T005	EGBLD	Allow NULL?
100	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	T005	EGLLD	Allow NULL?
101	EGRUP	Equity group	nvarchar	3	0	CHAR	(N' ')	Yes	*	JV_EGROUP	Allow NULL?
102	ELIKZ	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
103	EMPFB	Payee/Payer	nvarchar	10	0	CHAR	(N' ')	Yes		EMPFB	Allow NULL?
104	ESRNR	ISR Subscriber Number	nvarchar	11	0	CHAR	(N' ')	Yes		ESRNR	Allow NULL?
105	ESRPZ	ISR Check Digit	nvarchar	2	0	CHAR	(N' ')	Yes		ESRPZ	Allow NULL?
106	ESRRE	ISR Reference Number	nvarchar	27	0	CHAR	(N' ')	Yes		ESRRE	Allow NULL?
107	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	NUMC	(N'0000')	Yes	*	ETENR	Allow NULL?
108	ETYPE	Equity type	nvarchar	3	0	CHAR	(N' ')	Yes	*	JV_ETYPE	Allow NULL?
109	FDGRP	Planning Group	nvarchar	10	0	CHAR	(N' ')	Yes	T035	FDGRP	Allow NULL?
110	FDLEV	Planning level	nvarchar	2	0	CHAR	(N' ')	Yes	T036	FDLEV	Allow NULL?
111	FDTAG	Planning date	nvarchar	8	0	DATS	(N'00000000')	Yes		FDTAG	Allow NULL?
112	FIKRS	Financial Management Area	nvarchar	4	0	CHAR	(N' ')	Yes	FM01	FIKRS	Allow NULL?
113	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
114	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
115	FISCPER	Fiscal year / period	nvarchar	7	0	NUMC	(N'0000000')	Yes		RSFISCPER	Allow NULL?
116	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	FMFCTR	FISTL	Allow NULL?
117	FKBER_LONG	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	TFKB	FKBER	Allow NULL?
118	FKONT	Financial Budget Item	nvarchar	3	0	NUMC	(N'000')	Yes		FIPLS	Allow NULL?
119	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	FMFINCODE	BP_GEBER	Allow NULL?
120	GITYP	Distribution Type for Employment Tax	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1ADTYP_D	Allow NULL?
121	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
122	GLUPM	Update Method for FM - FI-CA Integration	char	1	0	CHAR	(N' ')	Yes		GLUPM	Allow NULL?
123	GLVOR	Business Transaction	nvarchar	4	0	CHAR	(N' ')	Yes		GLVOR	Allow NULL?
124	GMVKZ	Item is in Execution	char	1	0	CHAR	(N' ')	Yes		FM_GMVKZ	Allow NULL?
125	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
126	GRICD	Activity Code for Gross Income Tax	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1AGICD_D	Allow NULL?
127	GRIRG	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
128	GRPID	Batch Input Session Name	nvarchar	12	0	CHAR	(N' ')	Yes		GRPID_BKPF	Allow NULL?
129	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
130	GVTYP	P&L statement account type	nvarchar	2	0	CHAR	(N' ')	Yes		GVTYP	Allow NULL?
131	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
132	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	FAGL_HKONT	Allow NULL?
133	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	HKTID	Allow NULL?
134	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	CHAR	(N' ')	Yes	TKKH1	HRKFT	Allow NULL?
135	HWMET	Method with Which the Local Currency Amount Was Determined	char	1	0	CHAR	(N' ')	Yes		HWMET	Allow NULL?
136	HZUON	Assignment Number for Special G/L Accounts	nvarchar	18	0	CHAR	(N' ')	Yes		HZUON	Allow NULL?
137	IBLAR	Internal Document Type for Document Control	nvarchar	2	0	CHAR	(N' ')	Yes		IBLAR	Allow NULL?
138	IDXSP	Inflation Index	nvarchar	5	0	CHAR	(N' ')	Yes	*	J_1AINDXSP	Allow NULL?
139	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
140	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	CHAR	(N' ')	Yes		VVINTRENO	Allow NULL?
141	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	KBLK	KBLNR_FI	Allow NULL?
142	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
143	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
144	KKBER	Credit control area	nvarchar	4	0	CHAR	(N' ')	Yes	T014	KKBER	Allow NULL?
145	KKTPL	Group Chart of Accts	nvarchar	4	0	CHAR	(N' ')	Yes	T004	KKTPL	Allow NULL?
146	KOART	Account Type	char	1	0	CHAR	(N' ')	Yes		KOART	Allow NULL?
147	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
148	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
149	KSTAR	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	KSTAR	Allow NULL?
150	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	CKPH	KSTRG	Allow NULL?
151	KTOP2	Chart of Accounts According to Country Legislation	nvarchar	4	0	CHAR	(N' ')	Yes	T004	KTOP2	Allow NULL?
152	KTOPL	Chart of Accounts	nvarchar	4	0	CHAR	(N' ')	Yes	T004	KTOPL	Allow NULL?
153	KTOSL	Transaction Key	nvarchar	3	0	CHAR	(N' ')	Yes		KTOSL	Allow NULL?
154	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
155	KURSF	Exchange rate	decimal	9	5	DEC	((0))	Yes		KURSF
156	KURSR	Hedged Exchange Rate	decimal	9	5	DEC	((0))	Yes		KURSR
157	KURST	Exchange Rate Type	nvarchar	4	0	CHAR	(N' ')	Yes	TCURV	KURST	Allow NULL?
158	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
159	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
160	LDGRP	Ledger Group	nvarchar	4	0	CHAR	(N' ')	Yes	FAGL_TLDGRP	FAGL_LDGRP	Allow NULL?
161	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	*	LIFNR	Allow NULL?
162	LINFV	Last Adjustment Date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_1ALINFVL	Allow NULL?
163	LNRAN	Sequence number of asset line items in fiscal year	nvarchar	5	0	NUMC	(N'00000')	Yes	ANEK	LNRAN	Allow NULL?
164	LOKKT	Alternative account number in company code	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	ALTKT_SKB1	Allow NULL?
165	LOTKZ	Lot Number for Requests	nvarchar	10	0	CHAR	(N' ')	Yes		PSO_LOTKZ	Allow NULL?
166	LSTAR	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	*	LSTAR	Allow NULL?
167	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
168	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	T047M	MABER	Allow NULL?
169	MADAT	Last dunned on	nvarchar	8	0	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
170	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	T040S	MANSP	Allow NULL?
171	MANST	Dunning level	char	1	0	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
172	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
173	MEASURE	Funded Program	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_MEASURE	Allow NULL?
174	MONAT	Fiscal Period	nvarchar	2	0	NUMC	(N'00')	Yes		MONAT	Allow NULL?
175	MSCHL	Dunning key	char	1	0	CHAR	(N' ')	Yes	T040	MSCHL	Allow NULL?
176	MWART	Tax Type	char	1	0	CHAR	(N' ')	Yes		MWART	Allow NULL?
177	MWSK1	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
178	MWSK2	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
179	MWSK3	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
180	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
181	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	NPLNR	Allow NULL?
182	NUMPG	Number of pages of invoice	nvarchar	3	0	NUMC	(N'000')	Yes		J_1ANOPG	Allow NULL?
183	OBZEI	Number of Line Item in Original Document	nvarchar	3	0	NUMC	(N'000')	Yes		OBZEI	Allow NULL?
184	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	PARGB	Allow NULL?
185	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		PEINH
186	PENDAYS	Number of days for penalty charge calculation	int	10	0	INT4	((0))	Yes		PDAYS	Allow NULL?
187	PENRC	Reason for late payment	nvarchar	2	0	CHAR	(N' ')	Yes		PENRC	Allow NULL?
188	PERIV	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	Yes	T009	PERIV	Allow NULL?
189	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		PERNR_D	Allow NULL?
190	PFKBER	Partner Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	TFKB	SFKBER	Allow NULL?
191	PGEBER	Partner Fund	nvarchar	10	0	CHAR	(N' ')	Yes	FMFINCODE	FM_PFUND	Allow NULL?
192	PGRANT_NBR	Partner Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_PARTNER	Allow NULL?
193	POPTS	Real estate option rate	decimal	9	6	DEC	((0))	Yes		POPTSATZ
194	POSN2	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VA	Allow NULL?
195	PPA_EX_IND	PPA Exclude Indicator	char	1	0	CHAR	(N' ')	Yes		EXCLUDE_FLG	Allow NULL?
196	PPNAM	Name of User Who Parked this Document	nvarchar	12	0	CHAR	(N' ')	Yes	USR02	PPNAM	Allow NULL?
197	PPRCT	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PPRCTR	Allow NULL?
198	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
199	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
200	PROPMANO	Real Estate Management Mandate	nvarchar	13	0	CHAR	(N' ')	Yes		RE_MANDAT	Allow NULL?
201	PRZNR	Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	CBPR	CO_PRZNR	Allow NULL?
202	PSALT	Alternative Price Control	char	1	0	CHAR	(N' ')	Yes		PSALT	Allow NULL?
203	PSEGMENT	Partner Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	FAGL_SEGM	FB_PSEGMENT	Allow NULL?
204	PYCUR	Currency for Automatic Payment	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PYCUR	Allow NULL?
205	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	T059Q	QSSKZ	Allow NULL?
206	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	CHAR	(N' ')	Yes		QSZNR	Allow NULL?
207	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
208	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
209	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
210	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
211	RECID	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_RECIND	Allow NULL?
212	REINDAT	Invoice Receipt Date	nvarchar	8	0	DATS	(N'00000000')	Yes		REINDAT	Allow NULL?
213	RFZEI	Payment Card Item	nvarchar	3	0	NUMC	(N'000')	Yes		RFZEI_CC	Allow NULL?
214	RLDNR	Ledger in General Ledger Accounting	nvarchar	2	0	CHAR	(N' ')	Yes	*	FAGL_RLDNR	Allow NULL?
215	RPACQ	Period of Acquisition	nvarchar	3	0	NUMC	(N'000')	Yes		RPACQ	Allow NULL?
216	RSTGR	Reason Code for Payments	nvarchar	3	0	CHAR	(N' ')	Yes	T053R	RSTGR	Allow NULL?
217	RYACQ	Year of acquisition	nvarchar	4	0	CHAR	(N' ')	Yes		RYACQ	Allow NULL?
218	SAKNR	Reconciliation Account from Master Data	nvarchar	10	0	CHAR	(N' ')	Yes	*	FAGL_SAKNR	Allow NULL?
219	SAMNR	Invoice List Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SAMNR	Allow NULL?
220	SECCO	Section Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	SECCO	Allow NULL?
221	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	FAGL_SEGM	FB_SEGMENT	Allow NULL?
222	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
223	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
224	SHZUZ	Debit/Credit Addition for Cash Discount	char	1	0	CHAR	(N' ')	Yes		SHZUZ	Allow NULL?
225	SPGRC	Block.reason: quality	char	1	0	CHAR	(N' ')	Yes		SPGRC	Allow NULL?
226	SPGRG	Blocking reason: order price quantity	char	1	0	CHAR	(N' ')	Yes		SPGRG	Allow NULL?
227	SPGRM	Blocking reason: quantity	char	1	0	CHAR	(N' ')	Yes		SPGRM	Allow NULL?
228	SPGRP	Blocking reason: price	char	1	0	CHAR	(N' ')	Yes		SPGRP	Allow NULL?
229	SPGRQ	Manual Blocking Reason	char	1	0	CHAR	(N' ')	Yes		SPGRQ	Allow NULL?
230	SPGRS	Blocking Reason: Item Amount	char	1	0	CHAR	(N' ')	Yes		SPGRS	Allow NULL?
231	SPGRT	Blocking Reason: Date	char	1	0	CHAR	(N' ')	Yes		SPGRT	Allow NULL?
232	SPGRV	Blocking reason: project budget	char	1	0	CHAR	(N' ')	Yes		SPGRV	Allow NULL?
233	SRTYPE	Type of Additional Receivable	nvarchar	2	0	CHAR	(N' ')	Yes		FM_SRTYPE	Allow NULL?
234	STBLG	Reverse Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		STBLG	Allow NULL?
235	STBUK	Tax Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	STBUK	Allow NULL?
236	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
237	STEKZ	Version Number Component	nvarchar	2	0	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
238	STGRD	Reason for Reversal	nvarchar	2	0	CHAR	(N' ')	Yes	T041C	STGRD	Allow NULL?
239	STJAH	Reverse document fiscal year	nvarchar	4	0	NUMC	(N'0000')	Yes		STJAH	Allow NULL?
240	STODT	Planned Date for the Reverse Posting	nvarchar	8	0	DATS	(N'00000000')	Yes		STODT	Allow NULL?
241	TBTKZ	Indicator: subsequent debit/credit	char	1	0	CHAR	(N' ')	Yes		TBTKZ	Allow NULL?
242	TCODE	Transaction Code	nvarchar	20	0	CHAR	(N' ')	Yes	TSTC	TCODE	Allow NULL?
243	TXDAT	Date for defining tax rates	nvarchar	8	0	DATS	(N'00000000')	Yes		TXDAT	Allow NULL?
244	TXGRP	Group Indicator for Tax Line Items	nvarchar	3	0	NUMC	(N'000')	Yes		TXGRP	Allow NULL?
245	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
246	UMSKS	Special G/L Transaction Type	char	1	0	CHAR	(N' ')	Yes		UMSKS	Allow NULL?
247	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	T074U	UMSKZ	Allow NULL?
248	UPDDT	Date of the Last Document Update	nvarchar	8	0	DATS	(N'00000000')	Yes		UPDDT	Allow NULL?
249	USNAM	User name	nvarchar	12	0	CHAR	(N' ')	Yes	USR02	USNAM	Allow NULL?
250	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
251	VALUT	Value date	nvarchar	8	0	DATS	(N'00000000')	Yes		VALUT	Allow NULL?
252	VATDATE	Tax Reporting Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VATDATE	Allow NULL?
253	VBEL2	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELN_VA	Allow NULL?
254	VBELN	Billing Document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELN_VF	Allow NULL?
255	VBEWA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	TZB0A	SBEWART	Allow NULL?
256	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
257	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
258	VERTT	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
259	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	Yes	T8JV	JV_NAME	Allow NULL?
260	VORGN	Transaction Type for General Ledger	nvarchar	4	0	CHAR	(N' ')	Yes		VORGN	Allow NULL?
261	VPRSV	Price control indicator	char	1	0	CHAR	(N' ')	Yes		VPRSV	Allow NULL?
262	VPTNR	Partner account number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	JV_PART	Allow NULL?
263	VRSDT	Insurance date	nvarchar	8	0	DATS	(N'00000000')	Yes		VRSDT	Allow NULL?
264	VRSKZ	Insurance indicator	char	1	0	CHAR	(N' ')	Yes		VRSKZ	Allow NULL?
265	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
266	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
267	WVERW	Bill of exchange usage type	char	1	0	CHAR	(N' ')	Yes		WVERW	Allow NULL?
268	WWERT	Translation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WWERT_D	Allow NULL?
269	XANET	Indicator: Down payment in net procedure ?	char	1	0	CHAR	(N' ')	Yes		XANET	Allow NULL?
270	XAUTO	Indicator: Line item automatically created	char	1	0	CHAR	(N' ')	Yes		XAUTO	Allow NULL?
271	XBILK	Indicator: Account is a balance sheet account?	char	1	0	CHAR	(N' ')	Yes		XBILK	Allow NULL?
272	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
273	XBLNR_ALT	Alternative Reference Number	nvarchar	26	0	CHAR	(N' ')	Yes		XBLNR_ALT	Allow NULL?
274	XCPDD	Indicator: Address and bank data set individually	char	1	0	CHAR	(N' ')	Yes		XCPDD	Allow NULL?
275	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	CHAR	(N' ')	Yes		XEGDR	Allow NULL?
276	XFAKT	Indicator: Billing document update successful ?	char	1	0	CHAR	(N' ')	Yes		XFAKT	Allow NULL?
277	XHKOM	Indicator: G/L account assigned manually ?	char	1	0	CHAR	(N' ')	Yes		XHKOM	Allow NULL?
278	XHRES	Indicator: Resident G/L account?	char	1	0	CHAR	(N' ')	Yes		XHRES	Allow NULL?
279	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
280	XKRES	Indicator: Can Line Items Be Displayed by Account?	char	1	0	CHAR	(N' ')	Yes		XKRES	Allow NULL?
281	XMWST	Calculate tax automatically	char	1	0	CHAR	(N' ')	Yes		XMWST	Allow NULL?
282	XNCOP	Indicator: Items cannot be copied?	char	1	0	CHAR	(N' ')	Yes		XNCOP	Allow NULL?
283	XNEGP	Indicator: Negative posting	char	1	0	CHAR	(N' ')	Yes		XNEGP	Allow NULL?
284	XNETB	Indicator: Document posted net ?	char	1	0	CHAR	(N' ')	Yes		XNETB	Allow NULL?
285	XOPVW	Indicator: Open Item Management?	char	1	0	CHAR	(N' ')	Yes		XOPVW	Allow NULL?
286	XPANZ	Display item	char	1	0	CHAR	(N' ')	Yes		XPANZ	Allow NULL?
287	XPYPR	Indicator: Items from Payment Program Blocked	char	1	0	CHAR	(N' ')	Yes		XPYPR	Allow NULL?
288	XRAGL	Indicator: Clearing was Reversed	char	1	0	CHAR	(N' ')	Yes		XRAGL	Allow NULL?
289	XREF1	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF1	Allow NULL?
290	XREF1_HD	Reference Key 1 Internal for Document Header	nvarchar	20	0	CHAR	(N' ')	Yes		XREF1_HD	Allow NULL?
291	XREF2	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF2	Allow NULL?
292	XREF2_HD	Reference Key 2 Internal for Document Header	nvarchar	20	0	CHAR	(N' ')	Yes		XREF2_HD	Allow NULL?
293	XREF3	Reference key for line item	nvarchar	20	0	CHAR	(N' ')	Yes		XREF3	Allow NULL?
294	XREVERSAL	Specifies whether doc. is reversal doc. or reversed doc.	char	1	0	CHAR	(N' ')	Yes		XREVERSAL	Allow NULL?
295	XRUEB	Indicator: Document is posted to a previous period	char	1	0	CHAR	(N' ')	Yes		XRUEB	Allow NULL?
296	XSAUF	Indicator: Posting to order is statistical	char	1	0	CHAR	(N' ')	Yes		XSAUF	Allow NULL?
297	XSERG	Indicator: Posting to prof.analysis is statistical	char	1	0	CHAR	(N' ')	Yes		XSERG	Allow NULL?
298	XSKRL	Indicator: Line item not liable to cash discount?	char	1	0	CHAR	(N' ')	Yes		XSKRL	Allow NULL?
299	XSKST	Indicator: Statistical posting to cost center	char	1	0	CHAR	(N' ')	Yes		XSKST	Allow NULL?
300	XSNET	G/L account amounts entered exclude tax	char	1	0	CHAR	(N' ')	Yes		XSNET	Allow NULL?
301	XSPLIT	FI Document Originates from Split Posting (Indicator)	char	1	0	CHAR	(N' ')	Yes		SPLIT_POSTING	Allow NULL?
302	XSPRO	Indicator: Posting to project is statistical	char	1	0	CHAR	(N' ')	Yes		XSPRO	Allow NULL?
303	XSTOV	Indicator: Document is flagged for reversal	char	1	0	CHAR	(N' ')	Yes		XSTOV	Allow NULL?
304	XUMAN	Indicator: Transfer posting from down payment ?	char	1	0	CHAR	(N' ')	Yes		XUMAN	Allow NULL?
305	XUMSW	Indicator: Sales-related item ?	char	1	0	CHAR	(N' ')	Yes		XUMSW	Allow NULL?
306	XUSVR	Indicator: US taxes changed at detail level ?	char	1	0	CHAR	(N' ')	Yes		XUSVR_BKPF	Allow NULL?
307	XWVOF	Indicator: Customer bill of exchange payment before due date	char	1	0	CHAR	(N' ')	Yes		XWVOF	Allow NULL?
308	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	CHAR	(N' ')	Yes		XZAHL	Allow NULL?
309	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
310	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
311	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
312	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
313	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
314	ZBFIX	Fixed Payment Terms	char	1	0	CHAR	(N' ')	Yes		DZBFIX	Allow NULL?
315	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		DZEKKN	Allow NULL?
316	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
317	ZINKZ	Exempted from interest calculation	nvarchar	2	0	CHAR	(N' ')	Yes		DZINKZ	Allow NULL?
318	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	SCHZW_BSEG	Allow NULL?
319	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
320	ZOLLD	Customs Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DZOLLD	Allow NULL?
321	ZOLLT	Customs Tariff Number	nvarchar	8	0	CHAR	(N' ')	Yes		DZOLLT	Allow NULL?
322	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
323	ZUMSK	Target Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	T074U	DZUMSK	Allow NULL?
324	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
325	X_CLEARED_ITEM	Cleared Item	char	1	0	CHAR	(N' ')	Yes		FAGL_X_CLEARED_ITEM	Allow NULL?
326	NEBTR	Net Payment Amount	decimal	13	2	CURR	((0))	Yes		NEBTR
327	NETDT	Due Date for Net Payment	nvarchar	8	0	DATS	(N'00000000')	Yes		NETDT	Allow NULL?
328	SK1DT	Due Date for Cash Discount 1	nvarchar	8	0	DATS	(N'00000000')	Yes		SK1DT	Allow NULL?
329	SK2DT	Due Date for Cash Discount 2	nvarchar	8	0	DATS	(N'00000000')	Yes		SK2DT	Allow NULL?
330	SKNTO	Cash discount amount in local currency	decimal	13	2	CURR	((0))	Yes		SKNTO
331	/SAPF15/STATUS		char	1	0		(N' ')	Yes			Allow NULL?
332	BATCH	Lot Number for Documents	nvarchar	10	0	CHAR	(N' ')	Yes		LOTKZ	Allow NULL?
333	BLIND	Budgetary Ledger Indicator	char	1	0	CHAR	(N' ')	Yes		FM_BLIND	Allow NULL?
334	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
335	CASH_ALLOC	Cash-Relevant Document	char	1	0	CHAR	(N' ')	Yes		FAGL_CASH_ALLOC	Allow NULL?
336	EXCLUDE_FLAG	PPA Exclude Indicator	char	1	0	CHAR	(N' ')	Yes		EXCLUDE_FLG	Allow NULL?
337	FASTPAY	PPA Fast Pay Indicator	char	1	0	CHAR	(N' ')	Yes		FMFG_FASTPAY_FLG	Allow NULL?
338	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	CHAR	(N' ')	Yes		FMFG_US_KEY	Allow NULL?
339	FMXDOCLN	FM Reference Line Item	nvarchar	6	0	NUMC	(N'000000')	Yes		FM_XDOCLN	Allow NULL?
340	FMXDOCNR	FM Reference Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		FM_XDOCNR	Allow NULL?
341	FMXYEAR	FM Reference Year	nvarchar	4	0	NUMC	(N'0000')	Yes		FM_XYEAR	Allow NULL?
342	FMXZEKKN	FM Reference Sequence Account Assignment	nvarchar	5	0	NUMC	(N'00000')	Yes		FM_XZEKKN	Allow NULL?
343	FM_UMART	Type of Payment Transfer	char	1	0	CHAR	(N' ')	Yes		FM_UMART	Allow NULL?
344	FOLLOW_ON	Follow-on document indicator	char	1	0	CHAR	(N' ')	Yes		FAGL_FOLLOW_ON	Allow NULL?
345	IGNR_IVREF	FMFG: Ignore the invoice reference during FI doc splitting	char	1	0	CHAR	(N' ')	Yes		FMFG_IGNORE_INV_REF	Allow NULL?
346	INTDATE	Interest Calc. Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FM_INTDATE	Allow NULL?
347	INTFORM	Interest Formula	nvarchar	4	0	CHAR	(N' ')	Yes		FM_INTFORM	Allow NULL?
348	KNUMV	Number of the document condition	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMV	Allow NULL?
349	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	CHAR	(N' ')	Yes		SEPA_MNDID	Allow NULL?
350	OFFSET_REFER_DAT	Date Record Referred to Treasury	nvarchar	8	0	DATS	(N'00000000')	Yes		FMFG_REFERRED_OFFSET_DAT	Allow NULL?
351	OFFSET_STATUS	Treasury Offset Status	nvarchar	2	0	CHAR	(N' ')	Yes		FMFG_OFFSET_STATUS	Allow NULL?
352	PAYS_PROV	Payment Service Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	COM_WEC_PAYMENT_SRV_PROVIDER	Allow NULL?
353	PAYS_TRAN	Payment Reference of Payment Service Provider	nvarchar	35	0	CHAR	(N' ')	Yes		FPS_TRANSACTION	Allow NULL?
354	PBUDGET_PD	FM: Partner Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_PBUDGET_PERIOD	Allow NULL?
355	PEROP_BEG	Billing Period of Performance Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FM_PEROP_FI_LOW	Allow NULL?
356	PEROP_END	Billing Period of Performance End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FM_PEROP_FI_HIGH	Allow NULL?
357	PRODPER	Production Month (Date to find period and year)	nvarchar	8	0	DATS	(N'00000000')	Yes		JV_PRODPER	Allow NULL?
358	PSOAK	Reason	nvarchar	10	0	CHAR	(N' ')	Yes	*	PSOAK	Allow NULL?
359	PSOBT	Posting Day	nvarchar	8	0	DATS	(N'00000000')	Yes		PSOBT	Allow NULL?
360	PSODT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
361	PSOFN	IS-PS: File number	nvarchar	30	0	CHAR	(N' ')	Yes		PSOFN	Allow NULL?
362	PSOKS	Region	nvarchar	10	0	CHAR	(N' ')	Yes	*	PSOKS	Allow NULL?
363	PSOSG	Reason for reversal - IS-PS requests	char	1	0	CHAR	(N' ')	Yes		PSOSG	Allow NULL?
364	PSOTM	Last changed at	nvarchar	6	0	TIMS	(N'000000')	Yes		PSOTM	Allow NULL?
365	PSOTY	Document category payment requests	nvarchar	2	0	CHAR	(N' ')	Yes	*	PSOTY_D	Allow NULL?
366	PSOZL	Actual posting	char	1	0	CHAR	(N' ')	Yes		PSOZL	Allow NULL?
367	RE_ACCOUNT	Cash Ledger: Expense or Revenue Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	FAGL_RE_ACCOUNT	Allow NULL?
368	RE_BUKRS	Cash Ledger: Company Code for Expense/Revenue	nvarchar	4	0	CHAR	(N' ')	Yes	*	FAGL_RE_BUKRS	Allow NULL?
369	SAMPLED	Sampled Invoice by Payment Certification	char	1	0	CHAR	(N' ')	Yes		SAMPLED	Allow NULL?
370	SNAME	User Name	nvarchar	12	0	CHAR	(N' ')	Yes		UNAME	Allow NULL?
371	SSBLK	Payment Statistical Sampling Block	char	1	0	CHAR	(N' ')	Yes		SSBLK	Allow NULL?
372	TAXPS	Tax document item number	nvarchar	6	0	NUMC	(N'000000')	Yes		TAX_POSNR	Allow NULL?
373	XFRGE_BSEG	Payment Is Released	char	1	0	CHAR	(N' ')	Yes		XFRGE_BSEG	Allow NULL?
374	XLGCLR	Clearing Specific to Ledger Groups	char	1	0	CHAR	(N' ')	Yes		XLGCLR	Allow NULL?
375	XMCA	Document Originates from Multi Currency Accounting	char	1	0	CHAR	(N' ')	Yes		GLE_DTE_MCA_XMCA	Allow NULL?
376	XREORG	Doc. Contains Open Item that Was Transferred During Reorg.	char	1	0	CHAR	(N' ')	Yes		FAGL_R_XDOC_REORG	Allow NULL?
377	ZZBUSPARTN	Business partner	nvarchar	10	0	CHAR	(N' ')	Yes		ZZBUSPARTN	Allow NULL?
378	ZZCHAN	Distribution channel	nvarchar	4	0	CHAR	(N' ')	Yes		ZZCHAN	Allow NULL?
379	ZZLOB	BUSINESS LINE	nvarchar	7	0	CHAR	(N' ')	Yes	*	ZZLOB	Allow NULL?
380	ZZLOCA	City	nvarchar	4	0	CHAR	(N' ')	Yes		ZZLOCA	Allow NULL?
381	ZZPRODUCT	Product group	nvarchar	10	0	CHAR	(N' ')	Yes		ZZPRODUCT	Allow NULL?
382	ZZREGION	Location	nvarchar	3	0	CHAR	(N' ')	Yes		ZZREGION	Allow NULL?
383	ZZSPREG	Special Region	nvarchar	5	0	CHAR	(N' ')	Yes	*	ZREGION	Allow NULL?
384	ZZSTATE	State/Province Code	nvarchar	3	0	CHAR	(N' ')	Yes	*	ZZSTATE	Allow NULL?
385	ZZUSERFLD1	Territory	nvarchar	9	0	CHAR	(N' ')	Yes		ZZUSERFLD1	Allow NULL?
386	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	CHAR	(N' ')	Yes		ZZUSERFLD2	Allow NULL?
387	ZZUSERFLD3	Vein	nvarchar	22	0	CHAR	(N' ')	Yes		ZZUSERFLD3	Allow NULL?

TOP ERP 6.0 | GLPOS_C_CT INDEXES

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

387 COLUMNS | 1 INDEXES | ERP 6.0 | GLPOS_C_CT TABLE

TOP ERP 6.0 | GLPOS_C_CT COLUMNS

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

387 COLUMNS | 1 INDEXES | ERP 6.0 | GLPOS_C_CT TABLE

TOPERP 6.0 | GLPOS_C_CT COLUMNS

TOPERP 6.0 | GLPOS_C_CT INDEXES

TOP ERP 6.0 | GLPOS_C_CT COLUMNS

TOP ERP 6.0 | GLPOS_C_CT INDEXES