SAP ABAP Table GLE_STR_ECS_BAL_ITEM_DETAIL (ECS Balance Rec.: Item Details (BSIS + BKPF Fields))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ AC-INT (Application Component) Accounting Interface
     ⤷ AC_INT_ECS_PER_APPL (Package) ECS: Persistence Layer

Basic Data

Table Category	INTTAB	Structure
Structure	GLE_STR_ECS_BAL_ITEM_DETAIL	Table Relationship Diagram
Short Description	ECS Balance Rec.: Item Details (BSIS + BKPF Fields)

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

Foreign Keys

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

History

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