SAP ABAP Table TXI_BSIS (Accounting: Secondary Index for G/L Accounts)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_BSIS	Table Relationship Diagram
Short Description	Accounting: Secondary Index for G/L Accounts

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	DMBTR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
90	WRBTR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
91	MWSTS_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
92	WMWST_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
93	BDIFF_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
94	BDIF2_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
95	DMBE2_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
96	DMBE3_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
97	MWST2_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
98	MWST3_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
99	BDIF3_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
100	RDIF3_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
101	PSWBT_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
102	PPDIFF_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
103	PPDIF2_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
104	PPDIF3_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	606