SAP FMADB_DEFAULT_AA FMADB: Default Account Assignment for Petty Amounts Table data and field list

FMADB_DEFAULT_AA is a standard SAP Table which is used to store FMADB: Default Account Assignment for Petty Amounts data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMADB_DEFAULT_AA table consists of various fields, each holding specific information or linking keys about FMADB: Default Account Assignment for Petty Amounts data available in SAP. These include ADB_ID (ADB_ID: Identifies the ADB Rule), ADB_POOL (ADB: Poolname), FIPOS (Commitment Item), FISTL (Funds Center)... 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. .

FMADB_DEFAULT_AA table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP FMADB_DEFAULT_AA table 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 FMADB_DEFAULT_AA 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
ADB_ID	ADB_ID: Identifies the ADB Rule	FMADB_ID	CHAR	20	FMADB_HEADER		CHAR20
ADB_POOL	ADB: Poolname	FMADB_POOL_NAME	CHAR	20	FMADB_POOL		CHAR20
FIPOS	Commitment Item	FIPOS	CHAR	14	FMFXPO		FIPOS	FIP
FISTL	Funds Center	FISTL	CHAR	16	FMFCTR		FISTL	FIS
FONDS	Fund	FM_FUND	CHAR	10	FMFINCODE		BP_GEBER	FIC
BUDGET	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	FMFUNDBPD		FM_BUDGET_PERIOD	BUDPER
FAREA	Functional Area	FM_FAREA	CHAR	16	TFKB		FKBER	FBE
MEASURE	Funded Program	FM_MEASURE	CHAR	24	FMMEASURE		FM_MEASURE	FM_MEASURE
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT	CHAR	10	FAGL_SEGM	ALPHA	FB_SEGMENT
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY

Key field

Non-key field

< FMADB_ACT_ENTITY - FMADB: Active Entities FMADB_DOC - ADB: Document Generation >

How do I retrieve data from SAP table FMADB_DEFAULT_AA using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMADB_DEFAULT_AA to SELECT all data from the table
DATA: WA_FMADB_DEFAULT_AA TYPE FMADB_DEFAULT_AA.

SELECT SINGLE *
FROM FMADB_DEFAULT_AA
INTO CORRESPONDING FIELDS OF WA_FMADB_DEFAULT_AA
WHERE...

How to access SAP table FMADB_DEFAULT_AA

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

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