SAP ABAP Table ICL_SUBROREQ_S_AL (Subrogation/Recovery Receivable: Persistent + Logical Fields)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_SUBROGATION_AL (Package) Claims: Subrogation: Application Logic Layer
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_SUBROGATION_AL (Package) Claims: Subrogation: Application Logic Layer
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_SUBROREQ_S_AL | Table Relationship Diagram |
Short Description | Subrogation/Recovery Receivable: Persistent + Logical Fields |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Claim Payment | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
4 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | ICLCLAIM | |
5 | SUBCLAIM | ICL_SUBCLP | ICL_SUBCL | CHAR | 3 | 0 | Subclaim of Payment | ICLSUBCL | |
6 | PAYMENT | ICL_PAYMENT | ICL_PAYMENT | NUMC | 5 | 0 | Number of Claim Payment | * | |
7 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
8 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
9 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
10 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
11 | .INCLUDE | 0 | 0 | Attributes of ICLPAY | |||||
12 | .INCLUDE | 0 | 0 | Organizational Include (Short Version) | |||||
13 | CREATEDBY | ICL_CREATEDBY | XUBNAME | CHAR | 12 | 0 | Created By | USR02 | |
14 | CREATETIME | ICL_CREATEUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Created: UTC Date+Time | ||
15 | APPROVEDBY | ICL_PAYMENT13 | XUBNAME | CHAR | 12 | 0 | Checked By | USR02 | |
16 | APPROVEDTIME | ICL_PAYMENT15UTC | ICL_TIMESTAMP | DEC | 15 | 0 | Date Checked (UTC Date+Time) | ||
17 | TRANSFERTIME | ICL_PAYMENT17UTC | ICL_TIMESTAMP | DEC | 15 | 0 | Transfer Date (UTC Date+Time) | ||
18 | DOCUMENTREF | ICL_DOCUMENTREF | ICL_DOCUMENTREF | CHAR | 14 | 0 | Reference for Payment Document Created in Subledger | ||
19 | POSTDATE | ICL_POSTDATE | DATE | DATS | 8 | 0 | Posting Date | ||
20 | DOCDATE | ICL_DOCDATE | DATE | DATS | 8 | 0 | Document Date of Payment | ||
21 | DUEDATE | ICL_DUEDATENET | DATE | DATS | 8 | 0 | Due Date for Net Payment | ||
22 | XALREADYPAID | ICL_ALREADYPAID | CHAR1 | CHAR | 1 | 0 | Payment Already Made | ||
23 | PAYCAT | ICL_PAYCAT | ICL_PAYCAT | CHAR | 1 | 0 | Record Type of Payment | ||
24 | PAYTYPE | ICL_PAYTYPE | ICL_PAYTYPE | CHAR | 1 | 0 | Payment Type (Final Payment, Payment After Closure of Claim) | ||
25 | SUBSAL | ICL_SUBSAL | ICL_SUBRO | NUMC | 3 | 0 | Subrogation/Salvage | ||
26 | XPAYEE | ICL_XPAYEE | CHAR1 | CHAR | 1 | 0 | Additional Payee (ICLPAYEE) | ||
27 | ADDRNUMBER | ICL_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Checks | ADRC | |
28 | CRECADDR | ICL_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address Number for Checks | * | |
29 | BKID | ICL_BKID | CHAR4 | CHAR | 4 | 0 | Bank Details ID | BUT0BK | |
30 | CURR | ICL_PAYMENTCUR | WAERS | CUKY | 5 | 0 | Claim Payment Currency | TCURC | |
31 | EXCHRATE | ICL_PAYMENT18 | KURSF | DEC | 9 | 5 | Exchange Rate of Payment Currency into Policy Currency | ||
32 | STATUS | ICL_PAYMENT12 | ICL_PAYMENT12 | CHAR | 2 | 0 | Internal Payment Status (Database Status) | ||
33 | METHOD | ICL_PAYMENT01 | PYMET_KK | CHAR | 1 | 0 | Payment Method | TFK042Z | |
34 | CHECKNUMBER | ICL_CHECK | ICL_CHECK | CHAR | 13 | 0 | Check Number for Manual Check Payments | ||
35 | NOTE | ICL_PAYMENT04 | TEXT50 | CHAR | 50 | 0 | Payment Note | ||
36 | INVOICEREF | ICL_INVOICEREF | CHAR20 | CHAR | 20 | 0 | External Invoice Number | ||
37 | REFCLAIM | ICL_CLAIM_REFPAY | ICL_CLAIM | CHAR | 17 | 0 | Claim Number (Reassignment Reference) | * | |
38 | REFSUBCLAIM | ICL_SUBCL_REFPAY | ICL_SUBCL | CHAR | 3 | 0 | Subclaim (Reassignment Reference) | * | |
39 | REFPAYMENT | ICL_PAYMENT_REFPAY | ICL_PAYMENT | NUMC | 5 | 0 | Claim Payment (Reassignment Reference) | * | |
40 | AMTDONE | ICL_AMOUNT_DONE | ICL_ITAMTS | CURR | 15 | 2 | Amount Paid or Received | ||
41 | LIABRATE | ICL_LIABRATE_NEG | ICL_PERCENT | DEC | 5 | 2 | Negotiated Liability Rate in Percent | ||
42 | AMTNEG | ICL_AMOUNTNEG | ICL_ITAMTS | CURR | 15 | 2 | Amount Negotiated | ||
43 | SUBROSTATUS | ICL_SUBROSTATUS | ICL_SUBROSTATUS | CHAR | 1 | 0 | Legal Status of Subrogation | ||
44 | TAXROLE | ICL_TAXROLE | ICL_TAXROLE | CHAR | 4 | 0 | Tax Role of Claim Payment Recipient | * | |
45 | TAX_RPT | ICL_TAXRPT | XFELD | CHAR | 1 | 0 | Flag for Reportable Payments | ||
46 | XTAXRPTCT | ICL_XTAXRPTCT | XFELD | CHAR | 1 | 0 | Code for Withholding Tax in Statutory Reporting Category | ||
47 | MTAXRPTCT | ICL_TAXRPTCT | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code for Statutory Reporting | * | |
48 | OVRD_TAXRPTCT | ICL_OVRDTAXRPTCT | XFELD | CHAR | 1 | 0 | Manual Withholding Tax Code | ||
49 | FUNDSRECDT | ICL_SALVFUNDREC | ICL_SALVFUNDREC | DATS | 8 | 0 | Salvage: Funds Received | ||
50 | XSALVESTEND | ICL_XSALVESTEND | XFELD | CHAR | 1 | 0 | End Estimation of Salvage Value | ||
51 | OWNERTYPE_GRP | ICL_OWNERTYPE_GRP3 | OTYPE | CHAR | 2 | 0 | Responsible Organization Category | * | |
52 | OWNER_GRP | ICL_OWNER_GRP3 | XUBNAME | CHAR | 12 | 0 | Responsible Organizational Unit | * | |
53 | REASONREJ | ICL_REASONREJ | ICL_REASONREJ | CHAR | 2 | 0 | Rejection Reasons for Payments and Reserves | TICL112 | |
54 | REFEXTSDOC | ICL_REFEXTSDOC | ICL_PAYMENT | NUMC | 5 | 0 | Referenced Statistical Payment Entry | * | |
55 | MOS | ICL_MOS | ICL_MOS | CHAR | 3 | 0 | Method of Settlement | * | |
56 | CL_PAYFREQPLAN | ICL_PAYFREQPLAN | PKEY_VK | CHAR | 2 | 0 | Payment Frequency of Scheduled Payment | TVS010B | |
57 | PMTTO | ICL_PMTTO | DATUM | DATS | 8 | 0 | End Date of a Scheduled Payment | ||
58 | PMTFR | ICL_PMTFR | DATUM | DATS | 8 | 0 | Start Date of a Scheduled Payment | ||
59 | SCHEDTYPE | ICL_SCHEDULE_TYPE | ICL_SCHEDULE_TYPE | CHAR | 2 | 0 | Type of Scheduled Payment | TICL180 | |
60 | NROFINVREQ | ICL_INVOICES_REQUIRED | NUMC2 | NUMC | 2 | 0 | Mininum Number of Inbound Invoices | ||
61 | DAMAGEDOBJ | ICL_DAMOBJ | ICL_DAMOBJ | NUMC | 4 | 0 | Damaged Object | * | |
62 | MIGRATION | ICL_PAYMIGRATION | CHAR1 | CHAR | 1 | 0 | Indicator for Migrated Payments | ||
63 | REQEVALCAT | ICL_REQEVALCAT_D_PE | ICL_REQEVALCAT_PE | CHAR | 1 | 0 | Determination Category of Receivable Amount | ||
64 | ASSIGN_GUID | ICL_ASSIGN_GUID | SYSUUID_C | CHAR | 32 | 0 | UUID of Entry to be Linked | ||
65 | PAYOUT_SCENARIO | ICL_PAYOUT_SCENARIO_D | ICL_PAYOUT_SCENARIO | CHAR | 1 | 0 | Repetitive Payment Scenario | ||
66 | .INCLUDE | 0 | 0 | Claim Payment: GUI Structure for Date Specifications | |||||
67 | CREATEDATE | ICL_CREATEDATE | DATE | DATS | 8 | 0 | Created On | ||
68 | CREATETIMET | ICL_CREATETIME | TIME | TIMS | 6 | 0 | Created At | ||
69 | CHANGEDATE | ICL_CHANGEDATE | DATE | DATS | 8 | 0 | Changed On | ||
70 | CHANGETIMET | ICL_CHANGETIME | TIME | TIMS | 6 | 0 | Changed at | ||
71 | APPROVEDDATE | ICL_PAYMENT14 | DATE | DATS | 8 | 0 | Date Checked | ||
72 | APPROVEDTIMET | ICL_PAYMENT15 | TIME | TIMS | 6 | 0 | Time Checked | ||
73 | TRANSFERDATE | ICL_PAYMENT16 | DATE | DATS | 8 | 0 | Date Transferred to Disbursements | ||
74 | TRANSFERTIMET | ICL_PAYMENT17 | TIME | TIMS | 6 | 0 | Transfer Time | ||
75 | STATUS_GUI | ICL_STATUS_GUI | ICL_STATUS | CHAR | 2 | 0 | Display Status for Payments | * | |
76 | METHODTXT | ICL_METHODTXT | FORMT_PAY | CHAR | 30 | 0 | Name of Payment Method | * | |
77 | INCURREDLOSS | ICL_INCURREDLOSS | ICL_ITAMTS | CURR | 15 | 2 | Losses Incurred To Date | ||
78 | PAMPAID | ICL_PAMPAID | ICL_ITAMTS | CURR | 15 | 2 | Total Sum of Relevant Payment Orders | ||
79 | REQUESTED | ICL_REQUESTED | ICL_ITAMTS | CURR | 15 | 2 | Amount Requested | ||
80 | REQUESTED_ORIG | ICL_REQUESTED_ORIG | ICL_ITAMTS | CURR | 15 | 2 | Original Amount Requested | ||
81 | DESCRIPTION | ICL_BANKDSC | CHAR50 | CHAR | 50 | 0 | Bank details (for payment) | ||
82 | PAYER | ICL_PAYER | BU_PARTNER | CHAR | 10 | 0 | Payer | * | |
83 | PAYERN | ICL_PAYERN_D | CHAR50 | CHAR | 50 | 0 | Description of Payer | ||
84 | PARK_FLAG | ICL_SBRREQ_PARKFLAG_D_AL | CHECKBOX | CHAR | 1 | 0 | Receivable Is Parked | ||
85 | POSTING_STATUS | ICL_POSTINGSTATUS | ICL_POSTINGSTATUS | CHAR | 4 | 0 | Posting Status of Payment to Collections/Disbursem. System | ||
86 | NEGID | ICL_NEGID_D_PE | SYSUUID_C | CHAR | 32 | 0 | Negotiation ID | ICL_NEG | |
87 | NEGNAME | ICL_NEGNAME_D_PE | ICL_NEGNAME_PE | CHAR | 10 | 0 | Unique Technical Name of Negotiation | ||
88 | NEGDESCR | ICL_NEGDESCR_D_PE | TEXT60 | CHAR | 60 | 0 | Description of Negotiation | ||
89 | NEGTYPE | ICL_NEGTYPE_D_PE | ICL_NEGTYPE_PE | CHAR | 1 | 0 | Key of Negotiation Type | * | |
90 | SUBROG_GUID | ICL_SUBROG_GUID_D_PE | SYSUUID_C | CHAR | 32 | 0 | Universal Unique Identifier of Subrogation/Recovery |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_SUBROREQ_S_AL | ADDRNUMBER | ADRC | ADDRNUMBER | |||
2 | ICL_SUBROREQ_S_AL | APPROVEDBY | USR02 | BNAME | |||
3 | ICL_SUBROREQ_S_AL | BKID | BUT0BK | BKVID | |||
4 | ICL_SUBROREQ_S_AL | CHANGEDBY | USR02 | BNAME | |||
5 | ICL_SUBROREQ_S_AL | CLAIM | ICLCLAIM | CLAIM | |||
6 | ICL_SUBROREQ_S_AL | CLIENT | T000 | MANDT | |||
7 | ICL_SUBROREQ_S_AL | CL_PAYFREQPLAN | TVS010B | PKEY | REF | 1 | CN |
8 | ICL_SUBROREQ_S_AL | CREATEDBY | USR02 | BNAME | |||
9 | ICL_SUBROREQ_S_AL | CURR | TCURC | WAERS | |||
10 | ICL_SUBROREQ_S_AL | METHOD | TFK042Z | ZLSCH | |||
11 | ICL_SUBROREQ_S_AL | NEGID | ICL_NEG | NEGID | REF | C | CN |
12 | ICL_SUBROREQ_S_AL | REASONREJ | TICL112 | REASONREJ | |||
13 | ICL_SUBROREQ_S_AL | SCHEDTYPE | TICL180 | SCHEDTYPE | REF | 1 | CN |
14 | ICL_SUBROREQ_S_AL | SUBCLAIM | ICLSUBCL | SUBCLAIM |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |