ICL_LOAN_HDR - Loan
Loan information is stored in SAP table ICL_LOAN_HDR.
It is part of development package ICLL_LOAN_DB in software component FS-CM. This development package consists of objects that can be grouped under "Claims: Life - Loan".
It is part of development package ICLL_LOAN_DB in software component FS-CM. This development package consists of objects that can be grouped under "Claims: Life - Loan".
Fields for table ICL_LOAN_HDR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | * |
| ACTIVE | Table entry is active (A) or in suspense (S) | X | ICL_ACTIVE | CHAR | 2 | |
| CLAIM | Number of Claim | X | ICL_CLAIM | CHAR | 34 | * |
| LOAN_HDR_ID | Object GUID | X | ICL_SUBOBJECT_UUID_D | CHAR | 64 | |
| .INCLUDE | ICL_INCL_VER5 | 0 | ||||
| CHANGETIME | Changed: Date + Time | ICL_CHANGEUTC1 | DEC | 8 | ||
| CHANGEDBY | Changed By | ICL_CHANGEDBY | CHAR | 24 | USR02 | |
| DELETED | Database Line Status (Original, Changed, Deleted) | ICL_RECSTATUS | CHAR | 2 | ||
| .INCLUDE | DATA | ICL_LOAN_HDR_S_DB | 0 | |||
| LOAN_HDR_NUM | Internal Loan Number | ICL_LOAN_HDR_NUM_D | NUMC | 6 | ||
| LOAN_EXT_NUM | Loan Number from Insurance Contract | ICL_LOAN_EXT_NUM_D | CHAR | 40 | ||
| AMOUNT | Total Amount of Policy Loan | ICL_LOANAMOUNT_D | CURR | 8 | ||
| INTEREST | Open Loan Interest | ICL_INTEREST_D | CURR | 8 | ||
| INTERESTRATE_AGR | Agreed Loan Interest Rate in Percent | ICL_INTERESTRATE_AGR_D | DEC | 6 | ||
| INTERESTRATE_EFF | Effective Loan Interest Rate in Percent | ICL_INTERESTRATE_EFF_D | DEC | 6 | ||
| INTERESTRATE_NOM | Nominal Loan Interest Rate in Percent | ICL_INTERESTRATE_NOM_D | DEC | 6 | ||
| REPAYMENT | Desired Repayment Amount for Policy Loan | ICL_REPAYMENT_D | CURR | 8 | ||
| OFFSETINTEREST | Loan Interest to Be Offset with Repayment | ICL_OFFSETINTEREST_D | CURR | 8 | ||
| LOANCURR | Currency of Loan | ICL_LOANCURR_D | CUKY | 10 | * | |
| SETTLEMENT_DT | Date of Loan Settlement | ICL_SETTLEMENT_DT_D | DATS | 16 | ||
| CML_ACTIVE | Policy Loan Management via Connection of FS-PM to FS-CML | ICL_LOAN_CML_ACTIVE_D | CHAR | 2 | ||
| INSOBJECT_ID | ID of PM Insurance Object in CD | ICL_POLOBJ_CD | CHAR | 40 | * | |
| MAINBORROWER_ID | Claim Participant | ICL_PART | CHAR | 20 | * |