SAP ABAP Table FMGLFLEXB (Generated Extract Structure for Table FMGLFLEXT)

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	FMGLFLEXB	Table Relationship Diagram
Short Description	Generated Extract Structure for Table FMGLFLEXT

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	☑	GJAHR	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
27	.INCLUDE	☐				0	0
28	.INCLUDE	☐				0	0	General Ledger: Sender Additional Acct Assgmt Public Sector
29	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
30	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
31	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
32	SFUND	☐	BP_P_GEBER	BP_GEBER	CHAR	10	0	Partner Fund	*
33	SGRANT_NBR	☐	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant	GMGR
34	.INCLUDE	☐				0	0	General Ledger PS: Fund, Grant and Functional Area
35	RFUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
36	RGRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant	GMGR
37	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
38	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
39	.INCLUDE	☐				0	0	FI-SL: Additional Fields for the TT Extraction Structure
40	QUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
41	VALUETYPE	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
42	CURTYPE	☐	RSCURTYPE	RSCURTYPE	CHAR	2	0	Currency type
43	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
44	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
45	CHARTACCTS	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
46	UPMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
47	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
48	CURRUNIT	☐	RSCURRENCY	WAERS	CUKY	5	0	Currency Key	*
49	BALANCE	☐	RR_KUMSL	WERTV9	CURR	17	2	Accumulated balance
50	DEBIT	☐	RR_UMSOL	WERTV9	CURR	17	2	Total debit postings
51	CREDIT	☐	RR_UMHAB	WERTV9	CURR	17	2	Total credit postings
52	TURNOVER	☐	RR_SALES	WERTV9	CURR	17	2	Sales of the period
53	QUANTITY	☐	SMEGR9	MENGV9	QUAN	17	3	Consumption Quantity
54	ADQUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
55	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	FMGLFLEXB	ACTIV	T022	ACTIVITY
2	FMGLFLEXB	AWTYP	TTYP	AWTYP
3	FMGLFLEXB	COST_ELEM	CSKB	KSTAR
4	FMGLFLEXB	KOKRS	TKA01	KOKRS
5	FMGLFLEXB	LOGSYS	TBDLS	LOGSYS
6	FMGLFLEXB	RACCT	SKB1	SAKNR
7	FMGLFLEXB	RASSC	T880	RCOMP	KEY	1	CN
8	FMGLFLEXB	RBUKRS	T001	BUKRS
9	FMGLFLEXB	RBUSA	TGSB	GSBER
10	FMGLFLEXB	RFAREA	TFKB	FKBER
11	FMGLFLEXB	RGRANT_NBR	GMGR	GRANT_NBR
12	FMGLFLEXB	RLDNR	V_FAGL_T881_DBAL	RLDNR
13	FMGLFLEXB	RMVCT	T856	TRTYP
14	FMGLFLEXB	SBUSA	TGSB	GSBER	KEY	1	CN
15	FMGLFLEXB	SFAREA	TFKB	FKBER	KEY	1	CN
16	FMGLFLEXB	SGRANT_NBR	GMGR	GRANT_NBR

History

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