SAP FMAAREL Assigned FM Account Assignments Table data and field list

FMAAREL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Assigned FM Account Assignments" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FMAAREL TYPE FMAAREL.

The FMAAREL table consists of various fields, each holding specific information or linking keys about Assigned FM Account Assignments data available in SAP. These include COMMITMENT (Commitment budget), SENDER (FM Account Assignment Subject to Cover), RECEIVER (FM Account Assignment Entitled to Cover), ERHPROZ (% of a Revenue Allotted to Expenditure FM Account Assignment)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FMAAREL structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FMAAREL structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FMAAREL table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
PAYMENT	Payment budget	BP_CAT_PB	CHAR	1			X
COMMITMENT	Commitment budget	BP_CAT_CB	CHAR	1			X
SENDER	FM Account Assignment Subject to Cover	FM_SENDER	CHAR	1			XFELD
RECEIVER	FM Account Assignment Entitled to Cover	FM_RECEIVER	CHAR	1			XFELD
ERHPROZ	% of a Revenue Allotted to Expenditure FM Account Assignment	FM_ERHPROZ	DEC	5(2)			PRZ32
COMPROZ	% of a Revenue Allotted to Expenditure FM Account Assignment	FM_ERHPROZ	DEC	5(2)			PRZ32
SORTKRT	Grouping characteristic in a cover pool	FM_SORTKRT	CHAR	24			FM_SORTKRT
NO_AVAILABLE	Indicator that FM account assignment has no available budget	FM_NO_AVAIABLE	CHAR	1			FM_UDECK
COVER_TYPE	Indicator for Type of Cover Eligibility	FM_COV_TYP	CHAR	2			FM_COV_TYP
COVER_TYPE_TEXT	Type of Cover Eligibility	FM_COV_TYPE_TEXT	CHAR	28			TEXT28
BERECHTIGT	Only authorized participants in cover pool	FM_BERECHT	CHAR	1			XFELD
GJAHR	Fiscal Year of Commitment Item	FM_PGJAHR	NUMC	4		GJAHR	GJAHR	FVJ
FONDS	Fund	BP_GEBER	CHAR	10	FMFINCODE		BP_GEBER	FIC
FNAME	Fund name	FM_FNAME	CHAR	20			TEXT20
FDSCR	Description	FM_BESCHR	CHAR	40			TEXT40
SPONSOR	Customer account number for fund	FM_SPONSOR	CHAR	10	KNA1	ALPHA	KUNNR	KUN
NAME1_FONDS	Source of funds name (customer name 1)	FM_SPONTXT	CHAR	35			NAME
FINUSE	Application of Secondary Source Funds	FM_FINUSE	CHAR	16	FMFUSE		FM_FINUSE	FIU
UNAME	Application of funds description	FM_FUSETXT	CHAR	20			TEXT20
UDSCR	Application of funds description	FM_FUSEBSH	CHAR	40			TEXT40
AUGRP_FONDS	FM: Fund authorization group	FM_AUTHGRF	CHAR	10			CHAR10
FUND_TYPE	FM Fund Type	FM_FUNDTYPE	CHAR	6	FMFUNDTYPE		FM_FUNDTYPE
FUND_TYPET	FM Fund Type Description	FM_FUNDTYPET	CHAR	35			FM_FUNDTYPET
PROFIL	Budget Profile	BP_BPROFIL	CHAR	6	TBP1C		BP_PROFIL	BP1
KZBST	'Balance update' indicator	FM_KZBST	CHAR	1			FM_KZBST
ERFNAME_FONDS	FIFM: Created by	FM_ERFNAME	CHAR	12			USNAM
ERFDAT_FONDS	FIFM: Entry Date	FM_ERFDAT	DATS	8			DATUM
AENNAME_FONDS	FIFM: Name of Last Person to Make a Change	FM_AENNAME	CHAR	12			USNAM
AENDAT_FONDS	FIFM: Changed on	FM_AENDAT	DATS	8			DATUM
DATAB_FONDS	FM: Valid from date	FM_DATAB	DATS	8			DATUM	FM_DATAB
DATBIS_FONDS	FM: Valid to date	FM_DATBIS	DATS	8			DATUM	FM_DATBIS
PERIV	Fiscal Year Variant	PERIV	CHAR	2	Assigned to domain		PERIV
DATE_EXP	Expiration Date	FM_DATE_EXP	DATS	8			DATUM
DATE_CAN	Reversal Date	FM_DATE_CAN	DATS	8			DATUM
LOGSYSTEM_FONDS	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
FDSTR_ID	Subdivision ID of the fund	FM_FDSTR_ID	CHAR	10	FMMDSTRID		CHAR10
FDSUB1	Substring 1 of Fund	FM_FDSUB1	CHAR	10			CHAR10
FDSUB2	Substring 2 of Fund	FM_FDSUB2	CHAR	10			CHAR10
FDSUB1T_SH	Description 1	FM_BESCHR1	CHAR	50			TEXT50
FDSUB1T_LO	Description 2	FM_BESCHR2	CHAR	50			TEXT50
FDSUB2T_SH	Description 1	FM_BESCHR1	CHAR	50			TEXT50
FDSUB2T_LO	Description 2	FM_BESCHR2	CHAR	50			TEXT50
FICTR	Funds Center	FM_FICTR	CHAR	16	FMFCTR		FISTL	FIS
CNAME	Funds center name	FM_CNAME	CHAR	20			TEXT20
CDSCR	Description	FM_BESCHR	CHAR	40			TEXT40
CLEVL	Level in funds center hierarchy	FM_CTRLEVL	INT4	10			INT4
HIVARNT	Hierarchy Variant of Funds Center	FM_HIVARNT	CHAR	4	FMHIVARNT		FM_HIVARNT	FHV
FICTR_UP	Superior funds center	FM_HFICTR	CHAR	16	FMFCTR		FISTL
CTR_OBJNR	Object number	J_OBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
DATBIS	Valid To Date	DATBI	DATS	8			DATUM
DATAB	Valid-From Date	DATAB	DATS	8			DATUM
AUGRP_FICTR	FM: Funds center authorization group	FM_AUTHGRC	CHAR	10			CHAR10
ERFDAT_FICTR	FIFM: Entry Date	FM_ERFDAT	DATS	8			DATUM
ERFNAME_FICTR	FIFM: Created by	FM_ERFNAME	CHAR	12			USNAM
AENDAT_FICTR	FIFM: Changed on	FM_AENDAT	DATS	8			DATUM
AENNAME_FICTR	FIFM: Name of Last Person to Make a Change	FM_AENNAME	CHAR	12			USNAM
WAERS	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
LOGSYSTEM_FICTR	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
BOSS_CODE	FIFM: Code for a Person Responsible	FM_BOSSCOD	NUMC	8	TCJ04		PS_VERNR
BOSSOT	FIFM: Object Type for Funds Center Manager in HR	FM_BOSSOT	CHAR	2	T778O		OTYPE	POT
BOSSID	Funds Center Manager in Organization Model	FM_BOSSID	CHAR	12			HROBJID_12
BOSSNAME	FM: Name of Person Responsible	FM_BOSSNAM	CHAR	20			TEXT20
DFINCODE	Fund (Default Value in a Funds Center)	FM_DFONDS	CHAR	10	FMFINCODE		BP_GEBER	FIC
FCSTR_ID	Subdivision ID of the funds center	FM_FCSTR_ID	CHAR	10	FMMDSTRID		CHAR10
FCSUB1	Substring 1 of Funds Center	FM_FCSUB1	CHAR	10			CHAR10
FCSUB2	Substring 2 of Funds Center	FM_FCSUB2	CHAR	10			CHAR10
FCSUB3	Substring 3 of Funds Center	FM_FCSUB3	CHAR	10			CHAR10
FCSUB1T_SH	Description 1 of Substring 1 of Funds Center	FM_FCSUB1T_SH	CHAR	50			TEXT50
FCSUB1T_LO	Description 2 of Substring 1 of Funds Center	FM_FCSUB1T_LO	CHAR	50			TEXT50
FCSUB2T_SH	Description 1 of Substring 2 of Funds Center	FM_FCSUB2T_SH	CHAR	50			TEXT50
FCSUB2T_LO	Description 2 of Substring 2 of Funds Center	FM_FCSUB2T_LO	CHAR	50			TEXT50
FCSUB3T_SH	Description 1 of Substring 3 of Funds Center	FM_FCSUB3T_SH	CHAR	50			TEXT50
FCSUB3T_LO	Description 2 of Substring 3 of Funds Center	FM_FCSUB3T_LO	CHAR	50			TEXT50
VARNT	Commitment Item Hierarchy Variant	FM_VARNT	CHAR	3	FMCIVARNT		FM_VARNT	FVT
FIPEX	Commitment Item	FM_FIPEX	CHAR	24	FMCI		FM_FIPEX	FPS
PNAME	Commitment item name	FM_PNAME	CHAR	20			TEXT20
TEXT1	Description	FM_BESCHR0	CHAR	50			TEXT50
TEXT2	Description 2	FM_BESCHR2	CHAR	50			TEXT50
TEXT3	Description 3	FM_BESCHR3	CHAR	50			TEXT50
PLEVL	Level in the commitment item hierarchy	FM_POSLEVL	INT4	10			INT4
DFICTR	Funds Center (Default Value in a Commitment Item)	FM_DFICTR	CHAR	16	FMFCTR		FISTL	FIS
VPTYP	Carryforward item category for commitment item	FM_VPTYP	CHAR	2	FMVORTR0		FM_VPTYP
SNTYP	Collective budget adminstration category	FM_COLLTYP	CHAR	1			FM_COLLTYP
SNROL	Use type in collective budget administration	FM_COLLROL	CHAR	1			FM_COLLECT
NDAKZ	Indicator: NDA Budget	FM_NDAB	CHAR	1			FM_NDAB
AZPKZ	Indicator: Accrued Budget	FM_AZPB	CHAR	1			FM_AZPB
KRGRP	Criterion category group	FM_KRGRP	CHAR	4	FMKRG		FM_KRGRP
AUGRP_FIPEX	Authorization Groups of the Commitment Item	FM_AUTHGRP	CHAR	10			CHAR10
STATS	Funds Management Statistical Indicator	FM_STATS	CHAR	1			FM_STATS
NCBUD	No Budget for Future Years	FM_NCBUD	CHAR	1			XFELD
POSIT	Internal commitment item (8 chars)	FM_POSITI	CHAR	8			BP_POSIT
STVAR	Standard variant	FM_STVAR	CHAR	1			XFELD
NEGBUD	Negative Budget Permitted	FM_NEG_BUDGET_FLG	CHAR	1			XFELD
LOGSYSTEM_FIPEX	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
BUTYP	Budget structure element type	BUTYP	CHAR	4	Assigned to domain		PM_BUTYP	PBU
EFICTR	Balance Funds Center	FM_SDFICTR	CHAR	16	FMFCTR		FISTL	FIS
EFIPEX1	Balance Cmmt Item	FM_SDFIPEX	CHAR	24	FMCI	FMCIL	FM_FIPEX	FPS
EFIPEX2	Balance commitment item plan year+1	FM_SDFIPX2	CHAR	24	FMCI	FMCIL	FM_FIPEX	FPS
EFIPEX3	Balance commitment item plan year+2	FM_SDFIPX3	CHAR	24	FMCI	FMCIL	FM_FIPEX	FPS
EFIPEX4	Balance commitment item plan year+3	FM_SDFIPX4	CHAR	24	FMCI	FMCIL	FM_FIPEX	FPS
EFIPEX5	Balance commitment item plan year+4	FM_SDFIPX5	CHAR	24	FMCI	FMCIL	FM_FIPEX	FPS
CISTR_ID	Subdivision ID of the commitment item	FM_CISTR_ID	CHAR	10	FMMDSTRID		CHAR10
CISUB1	Substring 1 of Commitment Item	FM_CISUB1	CHAR	10			CHAR10
CISUB2	Substring 2 of Commitment Item	FM_CISUB2	CHAR	10			CHAR10
CISUB3	Substring 3 of Commitment Item	FM_CISUB3	CHAR	10			CHAR10
CISUB4	Substring 4 of Commitment Item	FM_CISUB4	CHAR	10			CHAR10
CISUB5	Substring 5 of Commitment Item	FM_CISUB5	CHAR	10			CHAR10
CISUB1T_SH	Description 1 of Substring 1 of Commitment Item	FM_CISUB1T_SH	CHAR	50			CHAR50
CISUB1T_LO	Description 2 of Substring 1 of Commitment Item	FM_CISUB1T_LO	CHAR	50			CHAR50
CISUB2T_SH	Description 1 of Substring 2 of Commitment Item	FM_CISUB2T_SH	CHAR	50			CHAR50
CISUB2T_LO	Description 2 of Substring 2 of Commitment Item	FM_CISUB2T_LO	CHAR	50			CHAR50
CISUB3T_SH	Description 1 of Substring 3 of Commitment Item	FM_CISUB3T_SH	CHAR	50			CHAR50
CISUB3T_LO	Description 2 of Substring 3 of Commitment Item	FM_CISUB3T_LO	CHAR	50			CHAR50
CISUB4T_SH	Description 1 of Substring 4 of Commitment Item	FM_CISUB4T_SH	CHAR	50			CHAR50
CISUB4T_LO	Description 2 of Substring 4 of Commitment Item	FM_CISUB4T_LO	CHAR	50			CHAR50
CISUB5T_SH	Description 1 of Substring 5 of Commitment Item	FM_CISUB5T_SH	CHAR	50			CHAR50
CISUB5T_LO	Description 2 of Substring 5 of Commitment Item	FM_CISUB5T_LO	CHAR	50			CHAR50
KATEG	Attribute: Can be Posted To	FM_KATEG	NUMC	1			FM_KATEG
FIVOR	Financial transaction	FM_FIVOR	NUMC	2			FM_FIVOR
POTYP	Commitment Item Category	FM_POTYP	NUMC	1			FM_POTYP
KRTYP	Commitment item criterion category	FM_KRTYP	CHAR	5	FMKRTP		FM_KRTYP	KYP
FPART	Commitment Item Type	FM_FPART	CHAR	3			FM_FPART
FIPOS	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
FIPUP	Superior Commitment Item	FIPEX_UP	CHAR	24	Assigned to domain	FMCIL	FM_FIPEX	FIP	FIPEX
HSART	Commitment Item Type	FM_HSART	CHAR	1	FMHSART		FM_HSART
GKFLG	Relevant to total costs	FM_GKFLG	CHAR	1			XFELD
DRUCK	Not relevant for budget print	FM_DRUCK	CHAR	1			XFELD
CFFLG	Able to carry forward at fiscal year change	FM_CFFLG	CHAR	1			XFELD
CVFLG	(Negative) clearing item	FM_CVFLG	CHAR	1			XFELD
BEZIRK	District	FM_BEZIRK	CHAR	4			CHAR4
BSAMT	Managed position / clearing lower section	FM_BSAMT	CHAR	16	FMFCTR		FISTL	FIS
UBFLG	Local authorities: Budget execution account	FM_UBFLG	CHAR	1			CHAR1
HSFLG	Budget balancing concept	FM_HSFLG	CHAR	1			XFELD
H_ID	Budget structure element (internal number)	FM_BSPEL	CHAR	10			FM_INTCNT
POST_CARRIER	Indicator: posting object	BP_ACCAR	CHAR	1			X
BUDGET_CARRIER	Budget Object	BP_BPCAR	CHAR	1			X
FAREA	Functional Area	FM_FAREA	CHAR	16	TFKB		FKBER	FBE
FTEXT	Name of the functional area	FKBTX	CHAR	25			TEXT25
FNSTR_ID	Subdivision ID of functional area	FM_FNSTR_ID	CHAR	10	FMMDSTRID		CHAR10
FNSUB1	Substring 1 of Functional Area	FM_FNSUB1	CHAR	10			CHAR10
FNSUB2	Substring 2 of Functional Area	FM_FNSUB2	CHAR	10			CHAR10
FNSUB3	Substring 3 of Functional Area	FM_FNSUB3	CHAR	10			CHAR10
FNSUB1T_SH	Description 1 of Substring 1 of Functional Area	FM_FNSUB1T_SH	CHAR	50			CHAR50
FNSUB1T_LO	Description 2 of Substring 1 of Functional Area	FM_FNSUB1T_LO	CHAR	50			CHAR50
FNSUB2T_SH	Description 1 of Substring 2 of Functional Area	FM_FNSUB2T_SH	CHAR	50			CHAR50
FNSUB2T_LO	Description 2 of Substring 2 of Functional Area	FM_FNSUB2T_LO	CHAR	50			CHAR50
FNSUB3T_SH	Description 1 of Substring 3 of Functional Area	FM_FNSUB3T_SH	CHAR	50			CHAR50
FNSUB3T_LO	Description 2 of Substring 3 of Functional Area	FM_FNSUB3T_LO	CHAR	50			CHAR50
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
FP_CATEGORY	Funded Program Category	PSM_FP_CATEGORY	CHAR	3			PSM_FP_CATEGORY
FP_TYPE	Funded Program Type	PSM_FP_TYPE	CHAR	4	Assigned to domain		PSM_FP_TYPE
ME_VALID_FROM	FM: Valid from date	FM_DATAB	DATS	8			DATUM	FM_DATAB
ME_VALID_TO	FM: Valid to date	FM_DATBIS	DATS	8			DATUM	FM_DATBIS
ME_AUTHGRP	FM: Funded Program Authorization Group	FM_AUTHGR_MEASURE	CHAR	10			CHAR10
ME_SHORT_DESC	Name of Funded Program (20-character)	FM_ME_NAME	CHAR	20			TEXT20
ME_DESCRIPTION	Description of Funded Program (50 character)	FM_ME_DESC	CHAR	50			TEXT50
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
GM_VALID_FROM	Valid-from Date	GM_FROM_DATE	DATS	8			DATUM
GM_VALID_TO	Valid-to Date	GM_TO_DATE	DATS	8			DATUM
GRANT_TYPE	Grant Type	GM_GRANT_TYPE	CHAR	2	Assigned to domain		GM_GRANT_TYPE	GM_GRANT_TYPE	GMGRANTTYPES
GM_AUTHGR	Grants Management: Authorization Groups	GM_AUTHGR	CHAR	10	Assigned to domain		GM_AUTHGR		GMAUTHGRP
GM_SHORT_DESC	Name of Grant	FM_GM_NAME	CHAR	20			TEXT20
GM_DESCRIPTION	Grant Description	FM_GM_DESC	CHAR	80			TEXT80
DECKRNG	Cover pool	FM_DECKRNG	CHAR	16	Assigned to domain		FM_DECKRNG
DNAME	Description	FM_BESCHR	CHAR	40			TEXT40
DEAKTIV	Deactivation Indicator	FM_DEAKTIV	CHAR	1			XFELD
HVMTNR	Budget memo	FM_HVMTNR	CHAR	10	Assigned to domain		FM_HVMTNR
REV_EXP_CVP	Revenues or Expenditures Cover Pool	FM_REV_EXP_CVP	CHAR	1			FM_REV_EXP_CVP
REV_EXP_CVPT	Revenue/Expenditure	REV_EXP_CVPT	CHAR	41			TEXT41
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
BUDGET_PD_NAME	FM: Budget Period Name	FM_BUDGET_PERIOD_NAME	CHAR	35			NAME
DATAB_BUDPER	FM: Budget Period Valid From date	FM_BPD_DATAB	DATS	8			DATUM
DATBIS_BUDPER	FM: Budget Period Valid To date	FM_BPD_DATBIS	DATS	8			DATUM
AUTHGRP_BUDPER	FM: Authorization group for Fund to Budget Period assignment	FM_BPD_AUTHGRF	CHAR	10			CHAR10
DATE_EXP_BUDPER	FM: Budget Period Expiration Date	FM_BPD_DATE_EXP	DATS	8			DATUM
DATE_CAN_BUDPER	FM: Budget Period Reversal Date	FM_BPD_DATE_CAN	DATS	8			DATUM

Key field

Non-key field

< FMAAINC - FM Account Assignment Without Master Data FMAA_AVC - FM account assignment - AVC objects >

How do I retrieve data from SAP structure FMAAREL using ABAP code?

As FMAAREL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMAAREL as there is no data to select.

How to access SAP table FMAAREL

Within an ECC or HANA version of SAP you can also view further information about FMAAREL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to FMAAREL

    FKRS - Financial Management Areas
        FMF_SEL_SCREEN - General Selection Criteria for FMF
            FVSN - Budget Versions
                BPBTX - Totals records: overall budget for fund
                    EPBT - Line Items: Overall Budget
                    VEPT - Line items: Commitment/actual for annual budget
                BPBYX - Totals records: annual budget
                    EPBY - Annual budget line items
                    VEPY - Line items: Commitment/actual for annual budget
                BPBPX - Totals Records: Period Budget
                    EPBP - Line Items: Period Budget
            FMTOX - Totals Records: Commitment and Actual
            FFND - Fund
            FMOIX - Line Items
            FMFIX - Line Items from FI Documents
                FMBKPF - FI Documents: Relevant Fields in Document Header
            FMCOX - Line Items from CO Postings
            FMCFX - Year-End Closing
                FMRU - Carryforward Rules for Year-End Closing
            FCTR - Funds Centers
            FPOS - Commitment Items
            FNCT - Functional Area
            FMAA - FM Account Assignments
                FMAAREL - Assigned FM Account Assignments
                    FMFUDRULE - Rules for Revenues Increasing Budget
                FMSNREL - Assigned FM Acct Asst to Collective Expenditures