SAP ABAP Table BSISEXT (Secondary Index BSIS Plus Enhancement Section (BSEGA))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

Table Category	INTTAB	Structure
Structure	BSISEXT	Table Relationship Diagram
Short Description	Secondary Index BSIS Plus Enhancement Section (BSEGA)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Accounting: Secondary Index for G/L Accounts
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
5	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
6	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
7	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
8	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
9	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
10	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
13	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
15	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
16	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
17	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
18	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
21	FKONT	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
22	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
23	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
24	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
25	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
26	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
27	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
28	AUFNR	☐	AUFNR_NEU	AUFNR	CHAR	12	0	Order Number	AUFK
29	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
30	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
31	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
32	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
33	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
34	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
35	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
36	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
37	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
38	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
39	WVERW	☐	WVERW	WVERW	CHAR	1	0	Bill of Exchange Usage Type
40	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
41	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
42	MWST2	☐	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
43	MWST3	☐	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
44	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
45	RDIF3	☐	RDIF3	WRTV7	CURR	13	2	Exchange Rate Difference Realized for Third Local Currency
46	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
47	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
48	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
49	XSTOV	☐	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
50	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
51	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
52	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
53	RFZEI	☐	RFZEI_CC	NUM03	NUMC	3	0	Payment Card Item
54	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
55	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
56	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
57	PPDIFF	☐	PPDIFF	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
58	PPDIF2	☐	PPDIF2	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
59	PPDIF3	☐	PPDIF3	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
60	BEWAR	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
61	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
62	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
63	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
64	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
65	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
66	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
67	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
68	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
69	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
70	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
71	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
72	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
73	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
74	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	*
75	PGEBER	☐	FM_PFUND	BP_GEBER	CHAR	10	0	Partner Fund	*
76	PGRANT_NBR	☐	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant
77	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
78	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
79	PBUDGET_PD	☐	FM_PBUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Partner Budget Period	*
80	.INCLU--AP	☐				0	0	Local Authorities
81	FIPEX	☐	FM_FIPEX_DONT_USE	FM_FIPEX	CHAR	24	0	Commitment item - Do not use field - see note 447805	*
82	.INCLU--AP	☐				0	0	Joint Venture Accounting
83	PRODPER	☐	JVA_PROD_MONTH	BUPER	ACCP	6	0	Produktionsmonat
84	.INCLU--AP	☐				0	0	withholding Tax Code
85	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
86	.INCLU--AP	☐				0	0	Append zur Mandatsverwaltung BSIS
87	.INCLUDE	☐				0	0	Append Struktur für die Mandatsnummer
88	PROPMANO	☐	REHORECNNRM	RECNNR	CHAR	13	0	Mandate, Mandate-Opening Contract
89	.INCLUDE	☐				0	0	Document Segment Enhancement Part
90	DMSOL	☐	DMSOL	WERT7	CURR	13	2	Debit Amount in Local Currency
91	DMHAB	☐	DMHAB	WERT7	CURR	13	2	Credit Amount in Local Currency
92	DMSHB	☐	DMSHB	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
93	WRSOL	☐	WRSOL	WERT7	CURR	13	2	Debit Amount in Document Currency
94	WRHAB	☐	WRHAB	WERT7	CURR	13	2	Credit Amount in Document Currency
95	WRSHB	☐	WRSHB	WRTV7	CURR	13	2	Foreign Currency Amount with Signs (+/-)
96	MDSHB	☐	MDSHB	WRTV7	CURR	13	2	Tax on Sales/Purchases amount in Local Curr. with +/- Sign
97	MWSHB	☐	MWSHB	WRTV7	CURR	13	2	Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign
98	FDSHB	☐	FDSHB	WRTV7	CURR	13	2	Planned Amount in Local Currency with +/- Sign
99	BLSHB	☐	BLSHB	WRTV7	CURR	13	2	Base Amount for Preference ( with +/- Signs )
100	NETDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
101	SK1DT	☐	SK1DT	DATUM	DATS	8	0	Due Date for Cash Discount 1
102	SK2DT	☐	SK2DT	DATUM	DATS	8	0	Due Date for Cash Discount 2
103	MENSH	☐	MENSH	MENSH	QUAN	13	3	Quantity with +/- Sign
104	GKART	☐	GKART	GKART	CHAR	1	0	Offsetting Account Type
105	GKONT	☐	GKONT	GKONT	CHAR	10	0	Offsetting Account Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BSISEXT	AUFNR	AUFK	AUFNR	REF	C	CN
2	BSISEXT	BEWAR	T856	TRTYP	REF	C	CN
3	BSISEXT	BLART	T003	BLART	REF	1	CN
4	BSISEXT	BSCHL	TBSL	BSCHL	REF	1	CN
5	BSISEXT	BUPLA	J_1BBRANCH	BRANCH	KEY	1	CN
6	BSISEXT	GSBER	TGSB	GSBER
7	BSISEXT	MWSKZ	T007A	MWSKZ	REF	C	CN
8	BSISEXT	PROJK	PRPS	PSPNR	REF	C	CN
9	BSISEXT	PSWSL	TCURC	WAERS	REF	1	CN
10	BSISEXT	VBUND	T880	RCOMP	REF	C	CN
11	BSISEXT	WAERS	TCURC	WAERS	REF	1	CN
12	BSISEXT	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in