In this post, I will try and describe everything you need to know about the SAP crmd_fimap table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_FIMAP what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_FIMAP....Right lets get started!
Object Name: CRMD_FIMAP
Dictionary Type: Transparent table
Description: Payment Schedule from FIMA
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| BILLP_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| FINVIEW | CRMT_FIMAN_FINVIEW | NUMC | 2(0) | * | View | CRMT_FIMAN_FINVIEW | CRM | |||||
| NUMBER_INT | CRMT_FIMAPAYMENTS_NUMBER_INT | NUMC | 6(0) | FIMA Payment Schedule: Internal Number (per Financing View) | CRM | |||||||
| RURKONDIND | CRMT_FIMAN_INDEX | NUMC | 10(0) | Reference Index for Conditions/Flows | CRM | |||||||
| RURBEWEIND | CRMT_FIMAN_INDEX | NUMC | 10(0) | Reference Index for Conditions/Flows | CRM | |||||||
| SETTL_FR_T | CRMT_SETTL_FROM | DEC | 15(0) | Start of Settlement for Period | BCOS_TSTMP | CRM | ||||||
| SETTL_TO_T | CRMT_SETTL_TO | DEC | 15(0) | End of Settlement for Period | BCOS_TSTMP | CRM | ||||||
| SETTL_FIMA | CRMT_SETTL_FIMA | DEC | 15(0) | Internal Billing Date for Financial Mathematics | BCOS_TSTMP | CRM | ||||||
| BILL_DATE | CRMT_BILL_DATE | DEC | 15(0) | Billing Date for Billing Index and Printout | BCOS_TSTMP | CRM | ||||||
| VALUE_DATE | CRMT_VALUE_DATE | DEC | 15(0) | Fixed Value Date | BCOS_TSTMP | CRM | ||||||
| CASHFL_TYP | CRMT_FIMAN_CFTYPE | CHAR | 4(0) | Flow Category | CRMT_FIMAN_CFTYPE | CRM | ||||||
| BILL_VALUE | TFM_BLEIST | CURR | 23(2) | Payment Amount (Principle and Interest) | TFM_WRTV12 | CRM | ||||||
| INTEREST | TFM_BZINS | CURR | 23(2) | Interest amount | TFM_WRTV12 | CRM | ||||||
| PRINCIPLE | TFM_BTILG | CURR | 23(2) | Repayment amount | TFM_WRTV12 | CRM | ||||||
| BALANCE | TFM_BSALDO | CURR | 23(2) | Remaining Capital | TFM_WRTV12 | CRM | ||||||
| SETTLED | CRMT_FIMAN_SETTLED | CHAR | 1(0) | Settled Payment Step | CRMT_FIMAN_SETTLED | CRM | ||||||
| BRI_INT_NO | CRMT_ITEM_NO | NUMC | 10(0) | Item Number in Document | CRM_ITEM_NO | CRM |