SAP ABAP Table FMGL_EXTSTRUCT_LEAD (Extraction Structure for the Leading Ledger)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FA (Application Component) Fund Accounting
     ⤷ FMGL (Package) New General Ledger for Public Sector

Basic Data

Table Category	INTTAB	Structure
Structure	FMGL_EXTSTRUCT_LEAD	Table Relationship Diagram
Short Description	Extraction Structure for the Leading Ledger

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	.INCLUDE	☐				0	0	General ledger: Transaction attributes
3	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
4	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
5	.INCLUDE	☐				0	0	RTCUR + RUNIT
6	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
7	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
8	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
9	.INCLUDE	☐				0	0	General ledger: Technical fields
10	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Key of Line Items
11	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
12	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Data Part of Line Items
13	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
14	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
15	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
16	.INCLUDE	☐				0	0	General ledger: Main account assignment
17	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
18	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
19	.INCLUDE	☐				0	0	General ledger: SAP additional account assignment
20	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
21	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
22	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt in Data Part of LIs
23	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
24	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
25	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
26	.INCLUDE	☐				0	0	General Ledger: Sender Additional Acct Assgmt Public Sector
27	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
28	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
29	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
30	SFUND	☐	BP_P_GEBER	BP_GEBER	CHAR	10	0	Partner Fund	*
31	SGRANT_NBR	☐	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant	GMGR
32	.INCLUDE	☐				0	0	General Ledger PS: Fund, Grant and Functional Area
33	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
34	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant	GMGR
35	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
36	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
37	.INCLUDE	☐				0	0	FI-SL: Additional Fields for the TT Extraction Structure
38	QUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
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	UPMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
45	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
46	CURRUNIT	☐	RSCURRENCY	WAERS	CUKY	5	0	Currency Key	*
47	BALANCE	☐	RR_KUMSL	WERTV9	CURR	17	2	Accumulated balance
48	DEBIT	☐	RR_UMSOL	WERTV9	CURR	17	2	Total debit postings
49	CREDIT	☐	RR_UMHAB	WERTV9	CURR	17	2	Total credit postings
50	TURNOVER	☐	RR_SALES	WERTV9	CURR	17	2	Sales of the period
51	QUANTITY	☐	SMEGR9	MENGV9	QUAN	17	3	Consumption Quantity
52	ADQUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
53	ADQUANTITY	☐	SMEGR9	MENGV9	QUAN	17	3	Consumption Quantity

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMGL_EXTSTRUCT_LEAD	ACTIV	T022	ACTIVITY
2	FMGL_EXTSTRUCT_LEAD	AWTYP	TTYP	AWTYP
3	FMGL_EXTSTRUCT_LEAD	COST_ELEM	CSKB	KSTAR
4	FMGL_EXTSTRUCT_LEAD	KOKRS	TKA01	KOKRS
5	FMGL_EXTSTRUCT_LEAD	LOGSYS	TBDLS	LOGSYS
6	FMGL_EXTSTRUCT_LEAD	RACCT	SKB1	SAKNR
7	FMGL_EXTSTRUCT_LEAD	RASSC	T880	RCOMP	KEY	1	CN
8	FMGL_EXTSTRUCT_LEAD	RBUKRS	T001	BUKRS
9	FMGL_EXTSTRUCT_LEAD	RBUSA	TGSB	GSBER
10	FMGL_EXTSTRUCT_LEAD	RFAREA	TFKB	FKBER
11	FMGL_EXTSTRUCT_LEAD	RGRANT_NBR	GMGR	GRANT_NBR
12	FMGL_EXTSTRUCT_LEAD	RLDNR	V_FAGL_T881_DBAL	RLDNR
13	FMGL_EXTSTRUCT_LEAD	RMVCT	T856	TRTYP
14	FMGL_EXTSTRUCT_LEAD	SBUSA	TGSB	GSBER	KEY	1	CN
15	FMGL_EXTSTRUCT_LEAD	SFAREA	TFKB	FKBER	KEY	1	CN
16	FMGL_EXTSTRUCT_LEAD	SGRANT_NBR	GMGR	GRANT_NBR

History

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