SAP table FM01 (Financial Management Areas)

SAP table FM01 has 2 primary key fields being MANDT,FIKRS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FIKRS Financial Management Area CHAR 4 0 FIKRS
OBJNR Object number CHAR 22 0 J_OBJNR
FIPOE Unassignable Revenues: Commitment Item CHAR 14 0 FM_NZFPE
FIPOA Unassignable Expenditures: Commitment Item CHAR 14 0 FM_NZFPA
NZSTL Unassignable Revenues/Expenditures: Funds Center CHAR 16 0 FM_NZSTL
FCODE_PERIV_ACTV Fiscal Year Variant Active for Funds (Indicator) CHAR 1 0 FM_PERIV_ACTV
FUND_BLANK Blank Is a Valid Value for Fund CHAR 1 0 FM_FUND_BLANK
FUND_BLANK_TO Fiscal Year Until Which BLANK Is a Valid Value NUMC 4 0 FM_BLANK_TO_YEAR
FUNCTION_BLANK Blank Is Valid Value for the Functional Area CHAR 1 0 FM_FUNCTION_BLANK
FUNCT_BLANK_TO Fiscal Year Until Which BLANK Is a Valid Value NUMC 4 0 FM_BLANK_TO_YEAR
MEASURE_BLANK BLANK Is a Valid Value for the Funded Program CHAR 1 0 FM_MEASURE_BLANK
MEASURE_BLANK_TO Fiscal Year Until Which BLANK Is a Valid Value NUMC 4 0 FM_BLANK_TO_YEAR
GRANT_BLANK BLANK Is a Valid Value for the Grant CHAR 1 0 GM_GRANT_BLANK
GRANT_BLANK_TO Fiscal Year Until Which BLANK Is a Valid Value NUMC 4 0 FM_BLANK_TO_YEAR
F_OBSOLETE Hide Entry in Value Help CHAR 1 0 FM_OBSOLETE_F4
WAERS Financial Management Area Currency CUKY 5 0 TCURC FM_WAERS
SPRAS Language Key LANG 1 0 T002 FM_SPRAS
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
FMAKT Indicator: Cash Budget Management active CHAR 1 0 FM_FMAKT
DATBIS FM: Valid-To Date DATS 8 0 FM_DATBIS
CB_PROFIL Planning Profile CHAR 6 0 TBP1C BP_PPROFIL
CA_PROFIL Budget Profile CHAR 6 0 TBP1C BP_BPROFIL
CA_PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
CA_NUMKR Number range number CHAR 2 0 NRNR
CA_AKTIV Funds Management Active (Indicator) CHAR 1 0 FCA_AKTIV
CO_PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
SP_PROFIL Budget profile for fund CHAR 6 0 TBP1C BP_PROF_SP
CA_STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
FMCARR Active Budget Objects (Indicator) CHAR 1 0 FM_CARR
XFMCS CO Cash budget management: manual master data maintenance CHAR 1 0 XFMCS
SEQUENCE Ranking Order in Generic Search NUMC 1 0 FM_SEQUENC
1 Funds center, commitment item, fund
2 Funds center, fund, commitment item
3 Commitment item, funds center, fund
4 Commitment item, fund, funds center
5 Fund, funds center, commitment item
6 Fund, commitment item, funds center
CO_TIMEDEP Year-dependent assignment CHAR 1 0 FM_TIMEDEP
YEARPOS Year-Dependent Commitment Items CHAR 1 0 FM_YEARPOS
YEARCTR Year-Dependent Funds Centers CHAR 1 0 FM_YEARCTR
FS_PROFIL FM Update Profile CHAR 6 0 FMUP00 FM_PROFIL
FS_PROFIL_AL FM Update Profile CHAR 6 0 FMUP00 FM_PROFIL
CO_INTEGRATION Activate CO Integration with Funds Management CHAR 1 0 FM_CO_INTEGRATION
CO_INT_START_HR Active for HR From DATS 8 0 FM_CO_START_HR
HRBA_PRECOM Funds precommitment document type, HR integration CHAR 2 0 TKBBA FM_HRBA_PRECOM
HRBA_COMMIT Funds commitment document type, HR integration CHAR 2 0 TKBBA FM_HRBA_COMMIT
HRBA_BLOCK Funds block document type, HR integration CHAR 2 0 TKBBA FM_HRBA_BLOCK
VERSACT Budget Version Activation Process NUMC 1 0 FM_VERSACT
0 Year-Independent Budget Version Lock
1 Year-Dependent Budget Version Activation
AUGRP Fund Authorization Group CHAR 10 0 FM_AUTHGRF
ACTMODE Activating Mode for Commitment Items CHAR 1 0 FM_ACTMODE
FSTVARE Funds Reservation Field Status Variant CHAR 4 0 * FSTVARE
DR_NUMKR Number range number CHAR 2 0 NRNR
FIPOE24 Unassignable Revenues: Commitment Item CHAR 24 0 FM_NZFPE24
FIPOA24 Unassignable Expenditures: Commitment Item CHAR 24 0 FM_NZFPA24
FAREA_ACTIVE Functional Area in Funds Management Active CHAR 1 0 FM_FAREA_ACTIVE
NO_HIERARCHY No Budget Hierarchy in Budget Planning CHAR 1 0 FM_NO_HIERARCHY
BUDGETTYPE_RIB Budget Subtype for Automated Procedure Revs Incr. Bdgt CHAR 4 0 * FM_SUBVO_RIB
BUDGETTYPE_COVER Budget Subtype for Automated Procedure Cover Eligibility CHAR 4 0 * FM_SUBVO_COVER
BUDGETTYPE_FYC Budget Subtype for Carryforward CHAR 4 0 * FM_SUBVO_FYC
BUDGETTYPE_HR Budget Subtype for HR Budget CHAR 4 0 * FM_SUBVO_HR
CREATE_VAD Changes to doc. amounts only using value adjustment docs CHAR 1 0 FMHRBA_USE_VAD
Betragsänderungen ändern Originalbetrag
X Betragsänderungen nur über Wertanpassungsbelege
HRBA_PRECOM_NEG Funds precommitment doc. type HR integration for neg. values CHAR 2 0 TKBBA FM_HRBA_PRECOM_NEG
HRBA_COMMIT_NEG Funds cmmt doc. type HR integration for negative values CHAR 2 0 TKBBA FM_HRBA_COMMIT_NEG
BUD_PER_BLANK Blank value is allowed for Budget Period CHAR 1 0 FM_BUD_PER_BLANK
BUD_PER_BLANK_TO Fiscal Year Until Which BLANK Is a Valid Value NUMC 4 0 FM_BLANK_TO_YEAR
REV_CI_POST_OBJ Revenue Acct Assignments can be Defined as Posting Objects CHAR 1 0 FMBS_REV_CI_POSTABLE
CO_PLAN_NO_CHECK No Check for FM in CO Planning CHAR 1 0 FM_CO_PLAN_NO_CHECK
KENNZIFFER FM Area Reference Number NUMC 8 0 FM_KENNZIF
XBGACTIVE Activation Switch for Public-Owned Commercial Operations CHAR 1 0 FMBGACTIVE

FM01 foreign key relationships

Table Field Check Table Check Field
0 FM01 CA_PERIV T009 Fiscal Year Variants MANDT
0 FM01 CA_PERIV T009 Fiscal Year Variants PERIV
1 FM01 CA_PROFIL TBP1C Budget/Plan Profile MANDT
1 FM01 CA_PROFIL TBP1C Budget/Plan Profile PROFIL
1 FM01 CA_PROFIL TBP1C Budget/Plan Profile APPLIK
1 FM01 CA_PROFIL TBP1C Budget/Plan Profile WRTTP
0 FM01 CA_STSMA TJ20 Status profiles MANDT
0 FM01 CA_STSMA TJ20 Status profiles STSMA
1 FM01 CB_PROFIL TBP1C Budget/Plan Profile MANDT
1 FM01 CB_PROFIL TBP1C Budget/Plan Profile PROFIL
1 FM01 CB_PROFIL TBP1C Budget/Plan Profile APPLIK
1 FM01 CB_PROFIL TBP1C Budget/Plan Profile WRTTP
0 FM01 CO_PERIV T009 Fiscal Year Variants MANDT
0 FM01 CO_PERIV T009 Fiscal Year Variants PERIV
1 FM01 FS_PROFIL FMUP00 Update Control (Not Value Type Dependent) PROFIL
1 FM01 FS_PROFIL FMUP00 Update Control (Not Value Type Dependent) ACTIVE
0 FM01 FS_PROFIL_AL FMUP00 Update Control (Not Value Type Dependent) PROFIL
0 FM01 FS_PROFIL_AL FMUP00 Update Control (Not Value Type Dependent) ACTIVE
1 FM01 HRBA_BLOCK TKBBA Document Types MANDT
0 FM01 HRBA_COMMIT TKBBA Document Types MANDT
1 FM01 HRBA_COMMIT_NEG TKBBA Document Types MANDT
0 FM01 HRBA_PRECOM TKBBA Document Types MANDT
1 FM01 HRBA_PRECOM_NEG TKBBA Document Types MANDT
0 FM01 MANDT T000 Clients MANDT
1 FM01 PERIV T009 Fiscal Year Variants MANDT
1 FM01 PERIV T009 Fiscal Year Variants PERIV
0 FM01 SP_PROFIL TBP1C Budget/Plan Profile MANDT
0 FM01 SP_PROFIL TBP1C Budget/Plan Profile PROFIL
0 FM01 SP_PROFIL TBP1C Budget/Plan Profile APPLIK
0 FM01 SP_PROFIL TBP1C Budget/Plan Profile WRTTP
1 FM01 WAERS TCURC Currency Codes MANDT
1 FM01 WAERS TCURC Currency Codes WAERS