SAP ABAP Table GLE_MCA_STR_FINSTMT_DATA (MCA: Extraction Structure for Financial Statement (new GL))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-CU-MCA (Application Component) Multi Currency Accounting
     ⤷ FAGL_MCA_AL_RP (Package) FI: MCA Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	GLE_MCA_STR_FINSTMT_DATA	Table Relationship Diagram
Short Description	MCA: Extraction Structure for Financial Statement (new GL)

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	RYEAR	☐	RYEAR	GJAHR	NUMC	4	0	Fiscal year
2	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
3	.INCLUDE	☐				0	0	General ledger: Transaction attributes
4	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
5	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
6	.INCLUDE	☐				0	0	RTCUR + RUNIT
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
8	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
9	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
10	.INCLUDE	☐				0	0	General ledger: Technical fields
11	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Key of Line Items
12	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
13	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Data Part of Line Items
14	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
15	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
16	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
17	.INCLUDE	☐				0	0	General ledger: Main account assignment
18	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
19	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
20	.INCLUDE	☐				0	0	General ledger: SAP additional account assignment
21	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
22	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
23	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt in Data Part of LIs
24	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
25	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
26	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
27	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
28	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
29	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
30	.INCLUDE	☐				0	0	General ledger: Sender SAP additional account assignment
31	SCNTR	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
32	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
33	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
34	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
35	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
36	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
37	.INCLUDE	☐				0	0	MCA: Add. fields for the fin. stmt. extractor (classic GL)
38	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
39	VALUETYPE	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
40	CURTYPE	☐	RSCURTYPE	RSCURTYPE	CHAR	2	0	Currency type
41	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
42	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
43	CHARTACCTS	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
44	TRGT_CURR	☐	BILAWAER	WAERS	CUKY	5	0	Display Currency	*
45	FSTYPE	☐	BILABTYP	BILA_BTYP	CHAR	1	0	Balance Sheet Type
46	FSVERSN	☐	VERSN_011	VERSN_011	CHAR	4	0	Financial Statement Version	*
47	RATE_TYPE	☐	KURST_CURR	KURST	CHAR	4	0	Exchange rate type	*
48	TRANS_DATE	☐	BILASTID	DATUM	DATS	8	0	Key Date for Translation
49	FLAG_MDERTS	☐	GLE_MCA_DTE_FLAG_MDERTS	XFELD	CHAR	1	0	Indicator: Use Market Data Exchange Rates
50	GLACCEXT	☐	FAGL_GLACCEXT	FAGL_GLACCEXT	CHAR	18	0	Financial Statement Item
51	BALANCE	☐	RR_KUMSL	WERTV9	CURR	17	2	Accumulated balance
52	DEBIT	☐	RR_UMSOL	WERTV9	CURR	17	2	Total debit postings
53	CREDIT	☐	RR_UMHAB	WERTV9	CURR	17	2	Total credit postings
54	VAL_STOCK	☐	GLE_MCA_DTE_VAL_STOCK	WERTV9	CURR	17	2	Accumulated Balance
55	VAL_FLOW	☐	GLE_MCA_DTE_VAL_FLOW	WERTV9	CURR	17	2	Flow of Funds (Period Balance)
56	.INCLUDE	☐				0	0
57	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GLE_MCA_STR_FINSTMT_DATA	ACTIV	T022	ACTIVITY
2	GLE_MCA_STR_FINSTMT_DATA	AWTYP	TTYP	AWTYP
3	GLE_MCA_STR_FINSTMT_DATA	COST_ELEM	CSKB	KSTAR
4	GLE_MCA_STR_FINSTMT_DATA	KOKRS	TKA01	KOKRS
5	GLE_MCA_STR_FINSTMT_DATA	LOGSYS	TBDLS	LOGSYS
6	GLE_MCA_STR_FINSTMT_DATA	PPRCTR	CEPC	PRCTR
7	GLE_MCA_STR_FINSTMT_DATA	PRCTR	CEPC	PRCTR
8	GLE_MCA_STR_FINSTMT_DATA	PSEGMENT	FAGL_SEGM	SEGMENT
9	GLE_MCA_STR_FINSTMT_DATA	RACCT	SKB1	SAKNR
10	GLE_MCA_STR_FINSTMT_DATA	RASSC	T880	RCOMP	KEY	1	CN
11	GLE_MCA_STR_FINSTMT_DATA	RBUKRS	T001	BUKRS
12	GLE_MCA_STR_FINSTMT_DATA	RBUSA	TGSB	GSBER
13	GLE_MCA_STR_FINSTMT_DATA	RCNTR	CSKS	KOSTL
14	GLE_MCA_STR_FINSTMT_DATA	RFAREA	TFKB	FKBER
15	GLE_MCA_STR_FINSTMT_DATA	RLDNR	V_FAGL_T881_DBAL	RLDNR
16	GLE_MCA_STR_FINSTMT_DATA	RMVCT	T856	TRTYP
17	GLE_MCA_STR_FINSTMT_DATA	SBUSA	TGSB	GSBER	KEY	1	CN
18	GLE_MCA_STR_FINSTMT_DATA	SCNTR	CSKS	KOSTL
19	GLE_MCA_STR_FINSTMT_DATA	SEGMENT	FAGL_SEGM	SEGMENT
20	GLE_MCA_STR_FINSTMT_DATA	SFAREA	TFKB	FKBER	KEY	1	CN

History

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