SAP table FMFUSE (FIFM: Application of Funds from Secondary Sources)
SAP table FMFUSE has 3 primary key fields being MANDT,FIKRS,FINUSE.
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 | FM01 | FIKRS | |||||||||||||
| FINUSE | Application of Funds | CHAR | 16 | 0 | FM_FINUSE | ||||||||||||||
| DATAB | FM: Valid-From Date | DATS | 8 | 0 | FM_DATAB | ||||||||||||||
| DATBIS | FM: Valid-To Date | DATS | 8 | 0 | FM_DATBIS | ||||||||||||||
| ERFNAME | FIFM: Created By | CHAR | 12 | 0 | FM_ERFNAME | ||||||||||||||
| ERFDAT | FIFM: Entry Date | DATS | 8 | 0 | FM_ERFDAT | ||||||||||||||
| AENNAME | FIFM: Name of Last Person to Make a Change | CHAR | 12 | 0 | FM_AENNAME | ||||||||||||||
| AENDAT | FIFM: Changed On | DATS | 8 | 0 | FM_AENDAT | ||||||||||||||
| DEPT_REG | Department Regular | CHAR | 2 | 0 | FM_DEPT_REG | ||||||||||||||
| DEPT_TRAN | Department Transfer | CHAR | 2 | 0 | FM_DEPT_TRAN | ||||||||||||||
| FISCAL_YR | Undefined range (can be used for patch levels) | CHAR | 4 | 0 | CHAR4 | ||||||||||||||
| MAIN_ACCT | Main Account | CHAR | 4 | 0 | FM_MAIN_ACCT | ||||||||||||||
| SUB_ACCT | Subaccount | CHAR | 3 | 0 | FM_SUB_ACCT | ||||||||||||||
| SPLIT_NUM | Split Sequence Number | CHAR | 3 | 0 | FM_SPLIT_NUM | ||||||||||||||
| FACTSII_REL | FACTS II Relevant | CHAR | 1 | 0 | FMFG_FACTSII_REL |
|
|||||||||||||
| PREPARERID | Preparer ID | CHAR | 8 | 0 | FM_PREPARER | ||||||||||||||
| CERTIFIERID | Certifier ID | CHAR | 8 | 0 | FMFG_CERTIFIERID | ||||||||||||||
| DUMMY_FMAF_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||||||||||||||
| GTAS_REL | GTAS Relevant Indicator | CHAR | 1 | 0 | FMFG_GTAS_REL |
|
|||||||||||||
| SUBLEVL | Sublevel Prefix (SP) | CHAR | 2 | 0 | FMFG_SUBLEVL | ||||||||||||||
| AGENCID | Agency Identifier (AID) | CHAR | 3 | 0 | FMFG_AGENCID | ||||||||||||||
| ALTRAID | Allocation Transfer Agency Identifier (ATA) | CHAR | 3 | 0 | FMFG_ALTRAID | ||||||||||||||
| BEGPER | Beginning Period of Availability (BPOA) | NUMC | 4 | 0 | FMFG_BEGPER | ||||||||||||||
| ENDPER | Ending Period of Availability (EPOA) | NUMC | 4 | 0 | FMFG_ENDPER | ||||||||||||||
| AVTYPE | Availability Type Code (A) | CHAR | 1 | 0 | FMFG_AVTYPE |
|
FMFUSE foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 FMFUSE | FIKRS | FM01 | Financial Management Areas | FIKRS |
| 1 FMFUSE | MANDT | T000 | Clients | MANDT |