SAP Table
FMFUSE FIFM: Application of Funds from Secondary Sources
SAP table FMFUSE has 3 primary key fields being MANDT,FIKRS,FINUSE.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
FMFUSE columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||
| KeyFIKRS | Financial Management Area | CHAR | 4 | 0 | FM01 | FIKRS | |||||||||||||
| KeyFINUSE | 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 | ||||||||||||||
|
|||||||||||||||||||