	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

296 COLUMNS | 1 INDEXES | ERP 6.0 | BSSEG TABLE

ERP EHP7

6.0

296

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, 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 FROM BSSEG

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

TOP ERP 6.0 | BSSEG INDEXES

Name	Primary	Unique	Type	Columns
BSSEG~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

296 COLUMNS | 1 INDEXES | ERP 6.0 | BSSEG TABLE

TOP ERP 6.0 | BSSEG COLUMNS

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

296 COLUMNS | 1 INDEXES | ERP 6.0 | BSSEG TABLE

TOPERP 6.0 | BSSEG COLUMNS

TOPERP 6.0 | BSSEG INDEXES

TOP ERP 6.0 | BSSEG COLUMNS

TOP ERP 6.0 | BSSEG INDEXES