In this post, I will try and describe everything you need to know about the SAP crmd_fs_007ag 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_FS_007AG 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_FS_007AG....Right lets get started!
Object Name: CRMD_FS_007AG
Dictionary Type: Transparent table
Description: EEW: Generated Object (Do Not Process Manually)
| 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 | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| RECORD | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| AGNUMBINT | CRMT_FS_NUMBER_INT | NUMC | 10(0) | Internal Number of a Payment Step | CRMT_FS_NUMBER_INT | CRM | ||||||
| AGRULETO | CRMT_FS_TIMERU_TO | CHAR | 12(0) | Date Rule To | TIMENAME | CRM | ||||||
| AGRULEFROM | CRMT_FS_TIMERU_FROM | CHAR | 12(0) | Date Rule From | TIMENAME | CRM | ||||||
| AGRESAMOUNT_C | CRMT_FS_RESULTAMOUNT_C | CUKY | 5(0) | TCURC | Currency of Result Amount | WAERS | CRM | |||||
| AGRESAMOUNT | CRMT_FS_RESULTAMOUNT | CURR | 23(2) | Result Amount | CRMT_FIMAN_WRTV12 | CRM | ||||||
| AGREFZPROF | CRMT_FS_REFINTPROFIL | CHAR | 12(0) | Reference Interest Profile | CRMT_FS_REFINTPROFIL | CRM | ||||||
| AGPAYMFREQU | CRMT_FS_PAYFREQU | CHAR | 12(0) | * | Payment Frequency | CRMT_FS_PAYFREQU | CRM | |||||
| AGKEYDAY | CRMT_FS_KEY_DAY | NUMC | 2(0) | Key Date Due Date | TFM_SKEYDAY | CRM | ||||||
| AGFLOWCAT | CRMT_FS_FLOWCAT_EXT | CHAR | 10(0) | * | Flow Category Loan | CRMT_FS_FLOWCAT_EXT | CRM | |||||
| AGDUEDATE | CRMT_FS_MANDUEDATE | DEC | 15(0) | Due Date | BCOS_TSTMP | CRM | ||||||
| AGDEFPERC | CRMT_FS_DEFPERC | DEC | 15(10) | Default Percentage | CRMT_FS_DEFPERC | CRM | ||||||
| AGDEFIND | CRMT_FS_DEFAULT | CHAR | 1(0) | Default | CRMT_FS_DEFAULT | CRM | ||||||
| AGDEFAMOUNT_C | CRMT_FS_DEFAMOUNT_C | CUKY | 5(0) | TCURC | Currency | WAERS | CRM | |||||
| AGDEFAMOUNT | CRMT_FS_DEFAMOUNT | CURR | 23(2) | Default Amount | CRMT_FIMAN_WRTV12 | CRM | ||||||
| AGDATETO | CRMT_FS_DATE_TO | DEC | 15(0) | Valid To | BCOS_TSTMP | CRM | ||||||
| AGDATEMAN | CRMT_FS_DATE_MANUAL | CHAR | 1(0) | Manual Date | CRMT_FS_DATE_MANUAL | CRM | ||||||
| AGDATEFROM | CRMT_FS_DATE_FROM | DEC | 15(0) | Valid From | BCOS_TSTMP | CRM | ||||||
| AGCONDMAN | CRMT_FS_CONDMANUAL | CHAR | 1(0) | Manual Condition Value | CRMT_FS_CONDMANUAL | CRM | ||||||
| AGCALCMETH | CRMT_FS_SZBMETH | CHAR | 1(0) | Interest Calculation Method | SZBMETH | CRM |