The FMISPSUSER table in SAP ERP or S/4HANA stores Special Control Table for FMISPS per User(only SAP internal) data. There are total 18 fields in FMISPSUSER table. The Special Control Table for FMISPS per User(only SAP internal) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMISPSUSER table. It is in FIFM: Basis (FMBS) ABAP package and is part of the Funds Management (FI-FM) module.
SAP FMISPSUSER Table Fields
Following is the list of fields that are available in SAP FMISPSUSER table. The primary key fields of the table are MANDT (Client), UNAME (User Name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| UNAME | User Name | UNAME | CHAR (12) | |
| DA_ACTIVE | ST Active | FM_DA_ACT | CHAR (1) | |
| EU_ACTIVE | Indicator: EU System Active | FM_EU_ACT | CHAR (1) | |
| KOM_ACTIVE | Local Authorities Active | FM_KOM_ACT | CHAR (1) | |
| FUNCTION_ACTIVE | Activate Functional Area | FM_FUNCTION_ACTIVE | CHAR (1) | |
| FUNCTION_STARTHR | Functional area can be assigned to an account in HR from | FM_FUNCTION_START_HR | DATS (8) | |
| FUND_ACTIVE | Activate Fund | FM_FUND_ACTIVE | CHAR (1) | |
| FUND_START_HR | Fund can be assigned to an account in HR from | FM_FUND_START_HR | DATS (8) | |
| MEASURE_ACTIVE | Activate Funded Program | FM_MEASURE_ACTIVE | CHAR (1) | |
| MEASURE_VISIBLE | Funded Program Visible | FM_MEASURE_VISIBLE | CHAR (1) | |
| MEASURE_START_HR | Funded Program is Assignable to Account in HR from | FM_MEASURE_START_HR | DATS (8) | |
| GRANT_ACTIVE | Activate Grant | GM_GRANT_ACTIVE | CHAR (1) | |
| GRANT_START_HR | Grant Assignable to Account in HR from | GM_GRANT_START_HR | DATS (8) | |
| PS_US_ACTIVE | US Federal Government Active | FM_PS_US_ACT | CHAR (1) | |
| VS_ACTIVE | Clearing Control Active | FM_VS_ACT | CHAR (1) | |
| BUD_PER_ACTIVE | Budget Period Mandatory | FM_BUD_PER_ACTIVE | CHAR (1) | |
| BUD_PER_START_HR | Budget Period Start Date in HR | FM_BUD_PER_START_HR | DATS (8) |
