The CRM_PROD_FIN40 table in SAP ERP or S/4HANA stores One-Time Flows data. There are total 15 fields in CRM_PROD_FIN40 table. The One-Time Flows 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 CRM_PROD_FIN40 table. It is in Product Master Financial (CRM_PRODUCT_FINANCE) ABAP package and is part of the Financing Product (CRM-LAM-MD-FPR) module.
SAP CRM_PROD_FIN40 Table Fields
Following is the list of fields that are available in SAP CRM_PROD_FIN40 table. The primary key fields of the table are CLIENT (Client), FRG_GUID (Set GUID), NUMBER_INT (Internal Number of a Payment Step).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| FRG_GUID | Set GUID | COMT_FRG_GUID | RAW (16) | |
| NUMBER_INT | Internal Number of a Payment Step | CRMT_FIN_NUMBER_INT | NUMC (10) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC (15) | |
| VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC (15) | |
| UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR (12) | |
| HISTEX | History Exists | COMT_HISTEX | CHAR (1) | |
| LOGSYS | Original System | COMT_LOGSYS | CHAR (10) | |
| CASHFLOW_TYPE | Flow Category | CRMT_CFLOWTYPE01 | CHAR (4) | |
| SPLIT_PERC | Percentage Rate | CRMT_FINPROD_PROZ01 | DEC (10) | |
| RULE_SETTL | Date Rule | CRMT_FIN_TIMERUNA01 | TIMERUNA | CHAR (12) |
| OFFSET_VAL | Offset | CRMT_FINPROD_OFFS01 | DEC (5) | |
| OFFSET_UNIT | Offset Unit | CRMT_FINPROD_OFFSU01 | * | CHAR (12) |
| FIN_VIEW | View | CRMT_FINPROD_VIEW01 | NUMC (2) | |
| FIXING | Fixing | CRMT_FINPROD_FIX01 | NUMC (2) |
