	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

345 COLUMNS | 1 INDEXES | ERP 6.0 | BSEG TABLE

ERP EHP7

6.0

345

Accounting Document Segment

SQL: selectupdate insert create

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

SELECT MANDT, BUKRS, BELNR, GJAHR, BUZEI, BUZID, AUGDT, AUGCP, AUGBL, BSCHL, KOART, UMSKZ, UMSKS, ZUMSK, SHKZG, GSBER, PARGB, MWSKZ, QSSKZ, ZZSPREG, ZZBUSPARTN, ZZCHAN, ZZPRODUCT, ZZLOCA, ZZLOB, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZSTATE, ZZREGION, DMBTR, WRBTR, KZBTR, PSWBT, PSWSL, TXBHW, TXBFW, MWSTS, WMWST, HWBAS, FWBAS, HWZUZ, FWZUZ, SHZUZ, STEKZ, MWART, TXGRP, KTOSL, QSSHB, KURSR, GBETR, BDIFF, BDIF2, VALUT, ZUONR, SGTXT, ZINKZ, VBUND, BEWAR, ALTKT, VORGN, FDLEV, FDGRP, FDWBT, FDTAG, FKONT, KOKRS, KOSTL, PROJN, AUFNR, VBELN, VBEL2, POSN2, ETEN2, ANLN1, ANLN2, ANBWA, BZDAT, PERNR, XUMSW, XHRES, XKRES, XOPVW, XCPDD, XSKST, XSAUF, XSPRO, XSERG, XFAKT, XUMAN, XANET, XSKRL, XINVE, XPANZ, XAUTO, XNCOP, XZAHL, SAKNR, HKONT, KUNNR, LIFNR, FILKD, XBILK, GVTYP, HZUON, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, NEBTR, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, REBZG, REBZJ, REBZZ, REBZT, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, SAMNR, ABPER, VRSKZ, VRSDT, DISBN, DISBJ, DISBZ, WVERW, ANFBN, ANFBJ, ANFBU, ANFAE, BLNBT, BLNKZ, BLNPZ, MSCHL, MANSP, MADAT, MANST, MABER, ESRNR, ESRRE, ESRPZ, KLIBT, QSZNR, QBSHB, QSFBT, NAVHW, NAVFW, MATNR, WERKS, MENGE, MEINS, ERFMG, ERFME, BPMNG, BPRME, EBELN, EBELP, ZEKKN, ELIKZ, VPRSV, PEINH, BWKEY, BWTAR, BUSTW, REWRT, REWWR, BONFB, BUALT, PSALT, NPREI, TBTKZ, SPGRP, SPGRM, SPGRT, SPGRG, SPGRV, SPGRQ, STCEG, EGBLD, EGLLD, RSTGR, RYACQ, RPACQ, RDIFF, RDIF2, PRCTR, XHKOM, VNAME, RECID, EGRUP, VPTNR, VERTT, VERTN, VBEWA, DEPOT, TXJCD, IMKEY, DABRZ, POPTS, FIPOS, KSTRG, NPLNR, AUFPL, APLZL, PROJK, PAOBJNR, PASUBNR, SPGRS, SPGRC, BTYPE, ETYPE, XEGDR, LNRAN, HRKFT, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, MWST2, MWST3, NAVH2, NAVH3, SKNT2, SKNT3, BDIF3, RDIF3, HWMET, GLUPM, XRAGL, UZAWE, LOKKT, FISTL, GEBER, STBUK, TXBH2, TXBH3, PPRCT, XREF1, XREF2, KBLNR, KBLPOS, STTAX, FKBER, OBZEI, XNEGP, RFZEI, CCBTC, KKBER, EMPFB, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, GRICD, GRIRG, GITYP, XPYPR, KIDNO, ABSBT, IDXSP, LINFV, KONTT, KONTL, TXDAT, AGZEI, PYCUR, PYAMT, BUPLA, SECCO, LSTAR, CESSION_KZ, PRZNR, PPDIFF, PPDIF2, PPDIF3, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PENRC, GRANT_NBR, SCTAX, FKBER_LONG, GMVKZ, SRTYPE, INTRENO, MEASURE, AUGGJ, PPA_EX_IND, DOCLN, SEGMENT, PSEGMENT, PFKBER, HKTID, KSTAR, XLGCLR, TAXPS, PAYS_PROV, PAYS_TRAN, MNDID, XFRGE_BSEG, RE_BUKRS, RE_ACCOUNT, PGEBER, PGRANT_NBR, BUDGET_PD, PBUDGET_PD, J_1TPBUPL, PEROP_BEG, PEROP_END, FASTPAY, IGNR_IVREF, FMFGUS_KEY, FMXDOCNR, FMXYEAR, FMXDOCLN, FMXZEKKN, PRODPER FROM BSEG

TOP ERP 6.0 | BSEG COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
3	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	No		BELNR_D	Allow NULL?
4	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
5	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	No		BUZEI	Allow NULL?
6	BUZID	Identification of the Line Item	char	1	0	CHAR	(N' ')	Yes		BUZID	Allow NULL?
7	AUGDT	Clearing Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGDT	Allow NULL?
8	AUGCP	Clearing Entry Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGCP	Allow NULL?
9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	CHAR	(N' ')	Yes		AUGBL	Allow NULL?
10	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
11	KOART	Account Type	char	1	0	CHAR	(N' ')	Yes		KOART	Allow NULL?
12	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	T074U	UMSKZ	Allow NULL?
13	UMSKS	Special G/L Transaction Type	char	1	0	CHAR	(N' ')	Yes		UMSKS	Allow NULL?
14	ZUMSK	Target Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	T074U	DZUMSK	Allow NULL?
15	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
16	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
17	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	PARGB	Allow NULL?
18	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ	Allow NULL?
19	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	T059Q	QSSKZ	Allow NULL?
20	ZZSPREG	Special Region	nvarchar	5	0	CHAR	(N' ')	Yes	*	ZREGION	Allow NULL?
21	ZZBUSPARTN	Business partner	nvarchar	10	0	CHAR	(N' ')	Yes		ZZBUSPARTN	Allow NULL?
22	ZZCHAN	Distribution channel	nvarchar	4	0	CHAR	(N' ')	Yes		ZZCHAN	Allow NULL?
23	ZZPRODUCT	Product group	nvarchar	10	0	CHAR	(N' ')	Yes		ZZPRODUCT	Allow NULL?
24	ZZLOCA	City	nvarchar	4	0	CHAR	(N' ')	Yes		ZZLOCA	Allow NULL?
25	ZZLOB	BUSINESS LINE	nvarchar	7	0	CHAR	(N' ')	Yes	*	ZZLOB	Allow NULL?
26	ZZUSERFLD1	Territory	nvarchar	9	0	CHAR	(N' ')	Yes		ZZUSERFLD1	Allow NULL?
27	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	CHAR	(N' ')	Yes		ZZUSERFLD2	Allow NULL?
28	ZZUSERFLD3	Vein	nvarchar	22	0	CHAR	(N' ')	Yes		ZZUSERFLD3	Allow NULL?
29	ZZSTATE	State/Province Code	nvarchar	3	0	CHAR	(N' ')	Yes	*	ZZSTATE	Allow NULL?
30	ZZREGION	Location	nvarchar	3	0	CHAR	(N' ')	Yes		ZZREGION	Allow NULL?
31	DMBTR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
32	WRBTR	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
33	KZBTR	Original Reduction Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		KZBTR_FI
34	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWBT
35	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PSWSL	Allow NULL?
36	TXBHW	Original Tax Base Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		TXBHW
37	TXBFW	Original Tax Base Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		TXBFW
38	MWSTS	Tax Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		MWSTS
39	WMWST	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		WMWST
40	HWBAS	Tax Base Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		HWBAS
41	FWBAS	Tax Base Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		FWBAS
42	HWZUZ	Provision Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		HWZUZ
43	FWZUZ	Additional Tax in Document Currency	decimal	13	2	CURR	((0))	Yes		FWZUZ
44	SHZUZ	Debit/Credit Addition for Cash Discount	char	1	0	CHAR	(N' ')	Yes		SHZUZ	Allow NULL?
45	STEKZ	Version Number Component	nvarchar	2	0	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
46	MWART	Tax Type	char	1	0	CHAR	(N' ')	Yes		MWART	Allow NULL?
47	TXGRP	Group Indicator for Tax Line Items	nvarchar	3	0	NUMC	(N'000')	Yes		TXGRP	Allow NULL?
48	KTOSL	Transaction Key	nvarchar	3	0	CHAR	(N' ')	Yes		KTOSL	Allow NULL?
49	QSSHB	Withholding Tax Base Amount	decimal	13	2	CURR	((0))	Yes		QSSHB
50	KURSR	Hedged Exchange Rate	decimal	9	5	DEC	((0))	Yes		KURSR
51	GBETR	Hedged Amount in Foreign Currency	decimal	13	2	CURR	((0))	Yes		GBETR
52	BDIFF	Valuation Difference	decimal	13	2	CURR	((0))	Yes		BDIFF
53	BDIF2	Valuation Difference for the Second Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF2
54	VALUT	Value date	nvarchar	8	0	DATS	(N'00000000')	Yes		VALUT	Allow NULL?
55	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
56	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
57	ZINKZ	Exempted from interest calculation	nvarchar	2	0	CHAR	(N' ')	Yes		DZINKZ	Allow NULL?
58	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
59	BEWAR	Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	T856	RMVCT	Allow NULL?
60	ALTKT	Group account number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BILKT_SKA1	Allow NULL?
61	VORGN	Transaction Type for General Ledger	nvarchar	4	0	CHAR	(N' ')	Yes		VORGN	Allow NULL?
62	FDLEV	Planning level	nvarchar	2	0	CHAR	(N' ')	Yes	T036	FDLEV	Allow NULL?
63	FDGRP	Planning Group	nvarchar	10	0	CHAR	(N' ')	Yes	T035	FDGRP	Allow NULL?
64	FDWBT	Planning amount in document currency	decimal	13	2	CURR	((0))	Yes		FDWBT
65	FDTAG	Planning date	nvarchar	8	0	DATS	(N'00000000')	Yes		FDTAG	Allow NULL?
66	FKONT	Financial Budget Item	nvarchar	3	0	NUMC	(N'000')	Yes		FIPLS	Allow NULL?
67	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
68	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
69	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	CHAR	(N' ')	Yes		PROJN	Allow NULL?
70	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
71	VBELN	Billing Document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELN_VF	Allow NULL?
72	VBEL2	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELN_VA	Allow NULL?
73	POSN2	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	POSNR_VA	Allow NULL?
74	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	NUMC	(N'0000')	Yes	VBEP	ETENR	Allow NULL?
75	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	ANLH	ANLN1	Allow NULL?
76	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	ANLA	ANLN2	Allow NULL?
77	ANBWA	Asset Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	TABW	ANBWA	Allow NULL?
78	BZDAT	Asset value date	nvarchar	8	0	DATS	(N'00000000')	Yes		BZDAT	Allow NULL?
79	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		PERNR_D	Allow NULL?
80	XUMSW	Indicator: Sales-related item ?	char	1	0	CHAR	(N' ')	Yes		XUMSW	Allow NULL?
81	XHRES	Indicator: Resident G/L account?	char	1	0	CHAR	(N' ')	Yes		XHRES	Allow NULL?
82	XKRES	Indicator: Can Line Items Be Displayed by Account?	char	1	0	CHAR	(N' ')	Yes		XKRES	Allow NULL?
83	XOPVW	Indicator: Open Item Management?	char	1	0	CHAR	(N' ')	Yes		XOPVW	Allow NULL?
84	XCPDD	Indicator: Address and bank data set individually	char	1	0	CHAR	(N' ')	Yes		XCPDD	Allow NULL?
85	XSKST	Indicator: Statistical posting to cost center	char	1	0	CHAR	(N' ')	Yes		XSKST	Allow NULL?
86	XSAUF	Indicator: Posting to order is statistical	char	1	0	CHAR	(N' ')	Yes		XSAUF	Allow NULL?
87	XSPRO	Indicator: Posting to project is statistical	char	1	0	CHAR	(N' ')	Yes		XSPRO	Allow NULL?
88	XSERG	Indicator: Posting to prof.analysis is statistical	char	1	0	CHAR	(N' ')	Yes		XSERG	Allow NULL?
89	XFAKT	Indicator: Billing document update successful ?	char	1	0	CHAR	(N' ')	Yes		XFAKT	Allow NULL?
90	XUMAN	Indicator: Transfer posting from down payment ?	char	1	0	CHAR	(N' ')	Yes		XUMAN	Allow NULL?
91	XANET	Indicator: Down payment in net procedure ?	char	1	0	CHAR	(N' ')	Yes		XANET	Allow NULL?
92	XSKRL	Indicator: Line item not liable to cash discount?	char	1	0	CHAR	(N' ')	Yes		XSKRL	Allow NULL?
93	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
94	XPANZ	Display item	char	1	0	CHAR	(N' ')	Yes		XPANZ	Allow NULL?
95	XAUTO	Indicator: Line item automatically created	char	1	0	CHAR	(N' ')	Yes		XAUTO	Allow NULL?
96	XNCOP	Indicator: Items cannot be copied?	char	1	0	CHAR	(N' ')	Yes		XNCOP	Allow NULL?
97	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	CHAR	(N' ')	Yes		XZAHL	Allow NULL?
98	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	SAKNR	Allow NULL?
99	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	HKONT	Allow NULL?
100	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNNR	Allow NULL?
101	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
102	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
103	XBILK	Indicator: Account is a balance sheet account?	char	1	0	CHAR	(N' ')	Yes		XBILK	Allow NULL?
104	GVTYP	P&L statement account type	nvarchar	2	0	CHAR	(N' ')	Yes		GVTYP	Allow NULL?
105	HZUON	Assignment Number for Special G/L Accounts	nvarchar	18	0	CHAR	(N' ')	Yes		HZUON	Allow NULL?
106	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
107	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
108	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
109	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
110	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
111	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
112	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
113	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2	CURR	((0))	Yes		SKFBT
114	SKNTO	Cash discount amount in local currency	decimal	13	2	CURR	((0))	Yes		SKNTO
115	WSKTO	Cash discount amount in document currency	decimal	13	2	CURR	((0))	Yes		WSKTO
116	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	SCHZW_BSEG	Allow NULL?
117	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
118	ZBFIX	Fixed Payment Terms	char	1	0	CHAR	(N' ')	Yes		DZBFIX	Allow NULL?
119	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
120	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
121	NEBTR	Net Payment Amount	decimal	13	2	CURR	((0))	Yes		NEBTR
122	MWSK1	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKX	Allow NULL?
123	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
124	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
125	MWSK2	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKX	Allow NULL?
126	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
127	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
128	MWSK3	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKX	Allow NULL?
129	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
130	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
131	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
132	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
133	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
134	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
135	ZOLLT	Customs Tariff Number	nvarchar	8	0	CHAR	(N' ')	Yes		DZOLLT	Allow NULL?
136	ZOLLD	Customs Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DZOLLD	Allow NULL?
137	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
138	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
139	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	CHAR	(N' ')	Yes		DIEKZ	Allow NULL?
140	SAMNR	Invoice List Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SAMNR	Allow NULL?
141	ABPER	Settlement period	nvarchar	6	0	ACCP	(N' ')	Yes		ABPER_RF	Allow NULL?
142	VRSKZ	Insurance indicator	char	1	0	CHAR	(N' ')	Yes		VRSKZ	Allow NULL?
143	VRSDT	Insurance date	nvarchar	8	0	DATS	(N'00000000')	Yes		VRSDT	Allow NULL?
144	DISBN	Number of Bill of Exchange Usage Document (Discount Doc.)	nvarchar	10	0	CHAR	(N' ')	Yes		DISBN	Allow NULL?
145	DISBJ	Fiscal Year of Bill of Exchange Usage Document	nvarchar	4	0	NUMC	(N'0000')	Yes		DISBJ	Allow NULL?
146	DISBZ	Line Item within the Bill of Exchange Usage Document	nvarchar	3	0	NUMC	(N'000')	Yes		DISBZ	Allow NULL?
147	WVERW	Bill of exchange usage type	char	1	0	CHAR	(N' ')	Yes		WVERW	Allow NULL?
148	ANFBN	Document Number of the Bill of Exchange Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes		ANFBN	Allow NULL?
149	ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	nvarchar	4	0	NUMC	(N'0000')	Yes		ANFBJ	Allow NULL?
150	ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	nvarchar	4	0	CHAR	(N' ')	Yes	T001	ANFBU	Allow NULL?
151	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ANFAE	Allow NULL?
152	BLNBT	Base Amount for Determining the Preference Amount	decimal	13	2	CURR	((0))	Yes		BLNBT
153	BLNKZ	Subsidy indicator for determining the reduction rates	nvarchar	2	0	CHAR	(N' ')	Yes	*	BLNKZ	Allow NULL?
154	BLNPZ	Preference Percentage Rate	decimal	7	2	DEC	((0))	Yes		BLNPZ
155	MSCHL	Dunning key	char	1	0	CHAR	(N' ')	Yes	T040	MSCHL	Allow NULL?
156	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	T040S	MANSP	Allow NULL?
157	MADAT	Last dunned on	nvarchar	8	0	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
158	MANST	Dunning level	char	1	0	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
159	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	T047M	MABER	Allow NULL?
160	ESRNR	ISR Subscriber Number	nvarchar	11	0	CHAR	(N' ')	Yes		ESRNR	Allow NULL?
161	ESRRE	ISR Reference Number	nvarchar	27	0	CHAR	(N' ')	Yes		ESRRE	Allow NULL?
162	ESRPZ	ISR Check Digit	nvarchar	2	0	CHAR	(N' ')	Yes		ESRPZ	Allow NULL?
163	KLIBT	Credit Control Amount	decimal	13	2	CURR	((0))	Yes		KLIBT
164	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	CHAR	(N' ')	Yes		QSZNR	Allow NULL?
165	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QBSHB
166	QSFBT	Withholding Tax-Exempt Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QSFBT
167	NAVHW	Non-Deductible Input Tax (in Local Currency)	decimal	13	2	CURR	((0))	Yes		NAVHW
168	NAVFW	Non-Deductible Input Tax (in Document Currency)	decimal	13	2	CURR	((0))	Yes		NAVFW
169	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
170	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
171	MENGE	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
172	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
173	ERFMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
174	ERFME	Unit of Entry	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ERFME	Allow NULL?
175	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPMNG
176	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BPRME	Allow NULL?
177	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	EBELN	Allow NULL?
178	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
179	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		DZEKKN	Allow NULL?
180	ELIKZ	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
181	VPRSV	Price control indicator	char	1	0	CHAR	(N' ')	Yes		VPRSV	Allow NULL?
182	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		PEINH
183	BWKEY	Valuation Area	nvarchar	4	0	CHAR	(N' ')	Yes	T001K	BWKEY	Allow NULL?
184	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
185	BUSTW	Posting string for values	nvarchar	4	0	CHAR	(N' ')	Yes		BUSTW	Allow NULL?
186	REWRT	Invoice Value Entered (in Local Currency)	decimal	13	2	CURR	((0))	Yes		REEWR
187	REWWR	Invoice value in foreign currency	decimal	13	2	CURR	((0))	Yes		REFWR
188	BONFB	Amount Qualifying for Bonus in Local Currency	decimal	13	2	CURR	((0))	Yes		BONFB
189	BUALT	Amount posted in alternative price control	decimal	13	2	CURR	((0))	Yes		BUALT
190	PSALT	Alternative Price Control	char	1	0	CHAR	(N' ')	Yes		PSALT	Allow NULL?
191	NPREI	New price	decimal	11	2	CURR	((0))	Yes		NPREI
192	TBTKZ	Indicator: subsequent debit/credit	char	1	0	CHAR	(N' ')	Yes		TBTKZ	Allow NULL?
193	SPGRP	Blocking reason: price	char	1	0	CHAR	(N' ')	Yes		SPGRP	Allow NULL?
194	SPGRM	Blocking reason: quantity	char	1	0	CHAR	(N' ')	Yes		SPGRM	Allow NULL?
195	SPGRT	Blocking Reason: Date	char	1	0	CHAR	(N' ')	Yes		SPGRT	Allow NULL?
196	SPGRG	Blocking reason: order price quantity	char	1	0	CHAR	(N' ')	Yes		SPGRG	Allow NULL?
197	SPGRV	Blocking reason: project budget	char	1	0	CHAR	(N' ')	Yes		SPGRV	Allow NULL?
198	SPGRQ	Manual Blocking Reason	char	1	0	CHAR	(N' ')	Yes		SPGRQ	Allow NULL?
199	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
200	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	T005	EGBLD	Allow NULL?
201	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	T005	EGLLD	Allow NULL?
202	RSTGR	Reason Code for Payments	nvarchar	3	0	CHAR	(N' ')	Yes	T053R	RSTGR	Allow NULL?
203	RYACQ	Year of acquisition	nvarchar	4	0	CHAR	(N' ')	Yes		RYACQ	Allow NULL?
204	RPACQ	Period of Acquisition	nvarchar	3	0	NUMC	(N'000')	Yes		RPACQ	Allow NULL?
205	RDIFF	Exchange Rate Gain/Loss Realized	decimal	13	2	CURR	((0))	Yes		RDIFF
206	RDIF2	Exchange Rate Difference Realized for Second Local Currency	decimal	13	2	CURR	((0))	Yes		RDIF2
207	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
208	XHKOM	Indicator: G/L account assigned manually ?	char	1	0	CHAR	(N' ')	Yes		XHKOM	Allow NULL?
209	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	Yes	T8JV	JV_NAME	Allow NULL?
210	RECID	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	T8JJ	JV_RECIND	Allow NULL?
211	EGRUP	Equity group	nvarchar	3	0	CHAR	(N' ')	Yes	T8JF	JV_EGROUP	Allow NULL?
212	VPTNR	Partner account number	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	JV_PART	Allow NULL?
213	VERTT	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
214	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
215	VBEWA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWART	Allow NULL?
216	DEPOT	Securities Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	RLDEPO	Allow NULL?
217	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
218	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
219	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
220	POPTS	Real estate option rate	decimal	9	6	DEC	((0))	Yes		POPTSATZ
221	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
222	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	*	KSTRG	Allow NULL?
223	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
224	AUFPL	Task list number for operations in order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		AUFPL_CH	Allow NULL?
225	APLZL	General counter for order	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	APLZL_CH	Allow NULL?
226	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
227	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
228	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	Yes		RKESUBNR	Allow NULL?
229	SPGRS	Blocking Reason: Item Amount	char	1	0	CHAR	(N' ')	Yes		SPGRS	Allow NULL?
230	SPGRC	Block.reason: quality	char	1	0	CHAR	(N' ')	Yes		SPGRC	Allow NULL?
231	BTYPE	Payroll Type	nvarchar	2	0	CHAR	(N' ')	Yes	T8JA	JV_BILIND	Allow NULL?
232	ETYPE	Equity type	nvarchar	3	0	CHAR	(N' ')	Yes	T8JE	JV_ETYPE	Allow NULL?
233	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	CHAR	(N' ')	Yes		XEGDR	Allow NULL?
234	LNRAN	Sequence number of asset line items in fiscal year	nvarchar	5	0	NUMC	(N'00000')	Yes	*	LNRAN	Allow NULL?
235	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	CHAR	(N' ')	Yes	*	HRKFT	Allow NULL?
236	DMBE2	Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE2
237	DMBE3	Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE3
238	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
239	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
240	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
241	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
242	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
243	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
244	MWST2	Tax Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		MWST2
245	MWST3	Tax Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		MWST3
246	NAVH2	Non-Deductible Input Tax in Second Local Currency	decimal	13	2	CURR	((0))	Yes		NAVH2
247	NAVH3	Non-Deductible Input Tax in Third Local Currency	decimal	13	2	CURR	((0))	Yes		NAVH3
248	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT2
249	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT3
250	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF3
251	RDIF3	Exchange Rate Difference Realized for Third Local Currency	decimal	13	2	CURR	((0))	Yes		RDIF3
252	HWMET	Method with Which the Local Currency Amount Was Determined	char	1	0	CHAR	(N' ')	Yes		HWMET	Allow NULL?
253	GLUPM	Update Method for FM - FI-CA Integration	char	1	0	CHAR	(N' ')	Yes		GLUPM	Allow NULL?
254	XRAGL	Indicator: Clearing was Reversed	char	1	0	CHAR	(N' ')	Yes		XRAGL	Allow NULL?
255	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
256	LOKKT	Alternative account number in company code	nvarchar	10	0	CHAR	(N' ')	Yes	*	ALTKT_SKB1	Allow NULL?
257	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
258	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
259	STBUK	Tax Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	STBUK	Allow NULL?
260	TXBH2	Tax Base/Original Tax Base in Second Local Currency	decimal	13	2	CURR	((0))	Yes		TXBH2
261	TXBH3	Tax Base/Original Tax Base in Third Local Currency	decimal	13	2	CURR	((0))	Yes		TXBH3
262	PPRCT	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PPRCTR	Allow NULL?
263	XREF1	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF1	Allow NULL?
264	XREF2	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF2	Allow NULL?
265	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	KBLK	KBLNR_FI	Allow NULL?
266	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	KBLP	KBLPOS	Allow NULL?
267	STTAX	Tax amount as statistical information in document currency	decimal	13	2	CURR	((0))	Yes		STTAX
268	FKBER	Functional Area	nvarchar	4	0	CHAR	(N' ')	Yes		FKBER_SHORT	Allow NULL?
269	OBZEI	Number of Line Item in Original Document	nvarchar	3	0	NUMC	(N'000')	Yes		OBZEI	Allow NULL?
270	XNEGP	Indicator: Negative posting	char	1	0	CHAR	(N' ')	Yes		XNEGP	Allow NULL?
271	RFZEI	Payment Card Item	nvarchar	3	0	NUMC	(N'000')	Yes		RFZEI_CC	Allow NULL?
272	CCBTC	Payment cards: Settlement run	nvarchar	10	0	CHAR	(N' ')	Yes		CCBTC	Allow NULL?
273	KKBER	Credit control area	nvarchar	4	0	CHAR	(N' ')	Yes	T014	KKBER	Allow NULL?
274	EMPFB	Payee/Payer	nvarchar	10	0	CHAR	(N' ')	Yes		EMPFB	Allow NULL?
275	XREF3	Reference key for line item	nvarchar	20	0	CHAR	(N' ')	Yes		XREF3	Allow NULL?
276	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT16	Allow NULL?
277	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT17	Allow NULL?
278	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT18	Allow NULL?
279	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT19	Allow NULL?
280	GRICD	Activity Code for Gross Income Tax	nvarchar	2	0	CHAR	(N' ')	Yes	J_1AGICD	J_1AGICD_D	Allow NULL?
281	GRIRG	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
282	GITYP	Distribution Type for Employment Tax	nvarchar	2	0	CHAR	(N' ')	Yes	J_1ADTYP	J_1ADTYP_D	Allow NULL?
283	XPYPR	Indicator: Items from Payment Program Blocked	char	1	0	CHAR	(N' ')	Yes		XPYPR	Allow NULL?
284	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
285	ABSBT	Credit management: Hedged amount	decimal	13	2	CURR	((0))	Yes		ABSBT
286	IDXSP	Inflation Index	nvarchar	5	0	CHAR	(N' ')	Yes	J_1AINFT20	J_1AINDXSP	Allow NULL?
287	LINFV	Last Adjustment Date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_1ALINFVL	Allow NULL?
288	KONTT	Account Assignment Category for Industry Solution	nvarchar	2	0	CHAR	(N' ')	Yes		KONTT_FI	Allow NULL?
289	KONTL	Acct assignment string for industry-specific acct assignmnts	nvarchar	50	0	CHAR	(N' ')	Yes		KONTL_FI	Allow NULL?
290	TXDAT	Date for defining tax rates	nvarchar	8	0	DATS	(N'00000000')	Yes		TXDAT	Allow NULL?
291	AGZEI	Clearing Item	decimal	5	0	DEC	((0))	Yes		AGZEI
292	PYCUR	Currency for Automatic Payment	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PYCUR	Allow NULL?
293	PYAMT	Amount in Payment Currency	decimal	13	2	CURR	((0))	Yes		PYAMT
294	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	J_1BBRANCH	BUPLA	Allow NULL?
295	SECCO	Section Code	nvarchar	4	0	CHAR	(N' ')	Yes	SECCODE	SECCO	Allow NULL?
296	LSTAR	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	*	LSTAR	Allow NULL?
297	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TCESSION	CESSION_KZ	Allow NULL?
298	PRZNR	Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_PRZNR	Allow NULL?
299	PPDIFF	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIFF
300	PPDIF2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIF2
301	PPDIF3	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIF3
302	PENLC1	Penalty charge amount in first local currency	decimal	13	2	CURR	((0))	Yes		PENALTY1
303	PENLC2	Penalty charge amount in second local currency	decimal	13	2	CURR	((0))	Yes		PENALTY2
304	PENLC3	Penalty Charge Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		PENALTY3
305	PENFC	Penalty charge amount in document currency	decimal	13	2	CURR	((0))	Yes		PENALTY
306	PENDAYS	Number of days for penalty charge calculation	int	10	0	INT4	((0))	Yes		PDAYS	Allow NULL?
307	PENRC	Reason for late payment	nvarchar	2	0	CHAR	(N' ')	Yes		PENRC	Allow NULL?
308	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
309	SCTAX	Tax portion FI-CA local currency	decimal	13	2	CURR	((0))	Yes		SCTAX
310	FKBER_LONG	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
311	GMVKZ	Item is in Execution	char	1	0	CHAR	(N' ')	Yes		FM_GMVKZ	Allow NULL?
312	SRTYPE	Type of Additional Receivable	nvarchar	2	0	CHAR	(N' ')	Yes		FM_SRTYPE	Allow NULL?
313	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	CHAR	(N' ')	Yes		VVINTRENO	Allow NULL?
314	MEASURE	Funded Program	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_MEASURE	Allow NULL?
315	AUGGJ	Fiscal Year of Clearing Document	nvarchar	4	0	NUMC	(N'0000')	Yes		AUGGJ	Allow NULL?
316	PPA_EX_IND	PPA Exclude Indicator	char	1	0	CHAR	(N' ')	Yes		EXCLUDE_FLG	Allow NULL?
317	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0	CHAR	(N' ')	Yes		DOCLN6	Allow NULL?
318	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
319	PSEGMENT	Partner Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_PSEGMENT	Allow NULL?
320	PFKBER	Partner Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	SFKBER	Allow NULL?
321	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	HKTID	Allow NULL?
322	KSTAR	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	*	KSTAR	Allow NULL?
323	XLGCLR	Clearing Specific to Ledger Groups	char	1	0	CHAR	(N' ')	Yes		XLGCLR	Allow NULL?
324	TAXPS	Tax document item number	nvarchar	6	0	NUMC	(N'000000')	Yes		TAX_POSNR	Allow NULL?
325	PAYS_PROV	Payment Service Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	COM_WEC_PAYMENT_SRV_PROVIDER	Allow NULL?
326	PAYS_TRAN	Payment Reference of Payment Service Provider	nvarchar	35	0	CHAR	(N' ')	Yes		FPS_TRANSACTION	Allow NULL?
327	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	CHAR	(N' ')	Yes		SEPA_MNDID	Allow NULL?
328	XFRGE_BSEG	Payment Is Released	char	1	0	CHAR	(N' ')	Yes		XFRGE_BSEG	Allow NULL?
329	RE_BUKRS	Cash Ledger: Company Code for Expense/Revenue	nvarchar	4	0	CHAR	(N' ')	Yes	*	FAGL_RE_BUKRS	Allow NULL?
330	RE_ACCOUNT	Cash Ledger: Expense or Revenue Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	FAGL_RE_ACCOUNT	Allow NULL?
331	PGEBER	Partner Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_PFUND	Allow NULL?
332	PGRANT_NBR	Partner Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_PARTNER	Allow NULL?
333	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
334	PBUDGET_PD	FM: Partner Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_PBUDGET_PERIOD	Allow NULL?
335	J_1TPBUPL	Branch Code	nvarchar	5	0	CHAR	(N' ')	Yes		BCODE	Allow NULL?
336	PEROP_BEG	Billing Period of Performance Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FM_PEROP_FI_LOW	Allow NULL?
337	PEROP_END	Billing Period of Performance End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		FM_PEROP_FI_HIGH	Allow NULL?
338	FASTPAY	PPA Fast Pay Indicator	char	1	0	CHAR	(N' ')	Yes		FMFG_FASTPAY_FLG	Allow NULL?
339	IGNR_IVREF	FMFG: Ignore the invoice reference during FI doc splitting	char	1	0	CHAR	(N' ')	Yes		FMFG_IGNORE_INV_REF	Allow NULL?
340	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	CHAR	(N' ')	Yes		FMFG_US_KEY	Allow NULL?
341	FMXDOCNR	FM Reference Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		FM_XDOCNR	Allow NULL?
342	FMXYEAR	FM Reference Year	nvarchar	4	0	NUMC	(N'0000')	Yes		FM_XYEAR	Allow NULL?
343	FMXDOCLN	FM Reference Line Item	nvarchar	6	0	NUMC	(N'000000')	Yes		FM_XDOCLN	Allow NULL?
344	FMXZEKKN	FM Reference Sequence Account Assignment	nvarchar	5	0	NUMC	(N'00000')	Yes		FM_XZEKKN	Allow NULL?
345	PRODPER	Production Month (Date to find period and year)	nvarchar	8	0	DATS	(N'00000000')	Yes		JV_PRODPER	Allow NULL?

TOP ERP 6.0 | BSEG INDEXES

Name	Primary	Unique	Type	Columns
BSEG~0	Yes	Yes	CLUSTERED	BUZEI, GJAHR, BELNR, BUKRS, 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

345 COLUMNS | 1 INDEXES | ERP 6.0 | BSEG TABLE

TOP ERP 6.0 | BSEG COLUMNS

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

345 COLUMNS | 1 INDEXES | ERP 6.0 | BSEG TABLE

TOPERP 6.0 | BSEG COLUMNS

TOPERP 6.0 | BSEG INDEXES

TOP ERP 6.0 | BSEG COLUMNS

TOP ERP 6.0 | BSEG INDEXES