SAP ABAP Table ICL_PAYI (Claim Payment: Payment Items of a Payment)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_CF (Package) FS-CM: Claims Management Financials
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_CF (Package) FS-CM: Claims Management Financials
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_PAYI | Table Relationship Diagram |
Short Description | Claim Payment: Payment Items of a Payment |
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 | SEL | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
2 | .INCLUDE | 0 | 0 | Claim Payment Item | |||||
3 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
5 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | * | |
6 | SUBCLAIM | ICL_SUBCLP | ICL_SUBCL | CHAR | 3 | 0 | Subclaim of Payment | * | |
7 | PAYMENT | ICL_PAYMENT | ICL_PAYMENT | NUMC | 5 | 0 | Number of Claim Payment | * | |
8 | PAYMENTITEM | ICL_PAYMENTITEM | ICL_PAYMENTITEM | NUMC | 3 | 0 | Claim Payment Item | * | |
9 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
10 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
11 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
12 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
13 | .INCLUDE | 0 | 0 | Attributes of ICLPAYI | |||||
14 | ITEMSUBCL | ICL_ITEMSUBCLAIM | CHAR3 | CHAR | 3 | 0 | Subclaim to Which a Payment Item Is Assigned | ||
15 | PAYITEMCAT | ICL_PAYITEMCAT | ICL_PAYITEMCAT | CHAR | 1 | 0 | Claim Payment Item Category | ||
16 | PAMPAID | ICL_SCLITEMAP | ICL_ITAMTS | CURR | 15 | 2 | Payment Amount | ||
17 | BENTYPE | ICL_BENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type | * | |
18 | COVTYPE | ICL_COVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Coverage Type | * | |
19 | PYMTYPE | ICL_PYMTYPE | ICL_PYMTYPE | CHAR | 4 | 0 | Tax Category | TICL551 | |
20 | PAYTYPEI | ICL_PAYTYPE | ICL_PAYTYPE | CHAR | 1 | 0 | Payment Type (Final Payment, Payment After Closure of Claim) | ||
21 | TREASONSET | ICL_PAYREASONSET | ICL_PAYREASONSET | CHAR | 2 | 0 | Payment Reason Group | TICL067 | |
22 | TREASON | ICL_PAYREASON | ICL_PAYREASON | CHAR | 4 | 0 | Payment Reason | TICL066 | |
23 | GROSS_NET | ICL_GROSS_NET | ICL_GROSS_NET | CHAR | 1 | 0 | Tax Category of Amount (Gross/Net) | ||
24 | TXCOD | ICL_TXCOD | MWSKZ | CHAR | 2 | 0 | Tax Code | * | |
25 | REQUESTED | ICL_REQUESTED | ICL_ITAMTS | CURR | 15 | 2 | Amount Requested | ||
26 | POSTDATEI | ICL_POSTDATE | DATE | DATS | 8 | 0 | Posting Date | ||
27 | ITEM | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | * | |
28 | REFNO | ICL_SCLITEMREF | ICL_SCLITEMREF | CHAR | 15 | 0 | External Reference Number | ||
29 | PAYITY | ICL_PAYITY | ICL_PAYITY | CHAR | 10 | 0 | Payment Item Type | TICL291 | |
30 | REPID | ICL_REPID | CHAR | 10 | 0 | Coinsurance Key | |||
31 | VALIDFROM | ICL_PAYVALIDFROM | DATE | DATS | 8 | 0 | Payment Item: Valid From | ||
32 | VALIDTO | ICL_PAYVALIDTO | DATE | DATS | 8 | 0 | Payment Item: Valid To | ||
33 | ASSIGN_GUID | ICL_ASSIGN_GUID | SYSUUID_C | CHAR | 32 | 0 | UUID of Entry to be Linked | ||
34 | CDDOCITEM | ICL_DOCITEM | ICL_DOCITEM | NUMC | 4 | 0 | Item Number in Payment Plan Document | ||
35 | REQUESTED_ORIG | ICL_REQUESTED_ORIG | ICL_ITAMTS | CURR | 15 | 2 | Original Amount Requested | ||
36 | TREASONN | ICL_TREASONN | TEXT60 | CHAR | 60 | 0 | Name of Payment Reason | ||
37 | DESCRIPTION | ICL_CCDESC | TEXT132 | CHAR | 132 | 0 | Description of Compensation Items | ||
38 | BENTYPENAME | ICL_BENTYPEN | ICL_BENTYPEN | CHAR | 80 | 0 | Benefit Type Name | ||
39 | PAMTYPE | ICL_PAMTYPE | ICL_PAMTYPE | CHAR | 1 | 0 | Payment Amount Category of a Payment Item | ||
40 | CURR | ICL_PAYMENTCUR | WAERS | CUKY | 5 | 0 | Claim Payment Currency | * | |
41 | PAID | ICL_PAID | BOOLE | CHAR | 1 | 0 | Has Claim Item Already Been Paid Out (Yes = "X") | ||
42 | FINALP | ICL_FINALP | CHAR1 | CHAR | 1 | 0 | Flag for Final Payment | ||
43 | HIERAR | NUMC3 | NUMC3 | NUMC | 3 | 0 | Numc3, internal use | ||
44 | ITEMSUBCLTXT | ICL_SUBCLTXT | CHAR30 | CHAR | 30 | 0 | Long Text for Subclaim Consisting of Subclaim Type/Claimant | ||
45 | PYMTYPENAME | ICL_PYMDESC | TEXT25 | CHAR | 25 | 0 | Name of Tax Category | ||
46 | BPARTNER | ICL_PPAYEE | BU_PARTNER | CHAR | 10 | 0 | Claim Payment Recipient | * | |
47 | MAINTRANS | ICL_MAINTRANS | ICL_MAINTRANS | CHAR | 4 | 0 | Main Transaction | ||
48 | SUBTRANS | ICL_SUBTRANS | ICL_SUBTRANS | CHAR | 4 | 0 | Subtransaction | ||
49 | TAXRPTCT | ICL_TAXRPTCT | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code for Statutory Reporting | * | |
50 | CURR_LOCAL | ICL_PAYMENTCUR | WAERS | CUKY | 5 | 0 | Claim Payment Currency | * | |
51 | PAMPAID_LOCAL | ICL_PAMPAID | ICL_ITAMTS | CURR | 15 | 2 | Total Sum of Relevant Payment Orders | ||
52 | SKIP_BENTYPE_VALIDATION | ICL_SKIP_VALIDATION | XFELD | CHAR | 1 | 0 | Skip Check | ||
53 | REF_BENTYPE | ICL_REFBENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Referenced Benefit Type | * | |
54 | .INCLUDE | 0 | 0 | Assignment of Payment Item to Subclaim/Coverage Type | |||||
55 | SUBCLTYPE | ICL_SUBCLTYPE | ICL_SUBCLTYPE | CHAR | 4 | 0 | Subclaim Type | * | |
56 | SUBCLTYPE_NAME | ICL_SUBCLTYPEN | TEXT25 | CHAR | 25 | 0 | Subclaim Type Name | ||
57 | SUBCLTYPEDESC | ICL_SUBCLDESCRIP | TEXT20 | CHAR | 20 | 0 | Name of Claim/Subclaim | ||
58 | COVERAGE | ICL_POLM | ICL_POLM | CHAR | 4 | 0 | Coverage | * | |
59 | COVTYPE_NAME | ICL_COVTYPEN | TEXT50 | CHAR | 50 | 0 | Name of Coverage Type | ||
60 | .INCLUDE | 0 | 0 | Subrogation Item - GUI Fields Only (Derived from DB) | |||||
61 | BENTYPE_NAME | ICL_BENTYPEN | ICL_BENTYPEN | CHAR | 80 | 0 | Benefit Type Name | ||
62 | ITEMTYPE | ICL_ITEMTYPE | ICL_IOBTYPE | CHAR | 3 | 0 | Claim Item Object Type | * | |
63 | ITEMTYPE_NAME | ICL_ITEMTYPEN | TEXT30 | CHAR | 30 | 0 | Claim Item Type Description | ||
64 | TREASONSETN | ICL_PAYREASONSEN | TEXT50 | CHAR | 50 | 0 | Name of Transaction Reason Code Class | ||
65 | CLAIMANT | ICL_CLAIMANT | BU_PARTNER | CHAR | 10 | 0 | Claimant | * | |
66 | CLAIMANTN | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
67 | INSCOMP | ICL_INSCOMP | BU_PARTNER | CHAR | 10 | 0 | Insurance Company of Participant | * | |
68 | INSCOMPN | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
69 | XSUBRO | ICL_SUBCL03 | ICL_SUBCL03 | CHAR | 1 | 0 | Subrogation/Recovery Status | ||
70 | PAIDLOSS | ICL_PAIDLOSS | ICL_AMOUNT | CURR | 15 | 2 | Payments Made | ||
71 | DEDUCTIBLE | ICL_DEDUCT | ICL_ITAMTS | CURR | 15 | 2 | Deductible | ||
72 | INCURREDLOSS | ICL_INCURREDLOSS | ICL_ITAMTS | CURR | 15 | 2 | Losses Incurred To Date | ||
73 | INITIAL_RESERVE | ICL_RESERVEFI | ICL_ITAMTS | CURR | 15 | 2 | Initial Reserve | ||
74 | SUBROPOT | ICL_SUBROPOT | ICL_ITAMTS | CURR | 15 | 2 | Subrogation Potential | ||
75 | EXP_REIMB | ICL_EXP_REIMB | ICL_ITAMTS | CURR | 15 | 2 | Expected Deductible to be Reimbursed | ||
76 | SUBRONEG | ICL_SUBRONEG | ICL_ITAMTS | CURR | 15 | 2 | Negotiated Subrogation Amount | ||
77 | PAMRECEIVED | ICL_RECEIVED | ICL_ITAMTS | CURR | 15 | 2 | Amount Received To Date Including Deductible | ||
78 | RECOVERED_LOSS | ICL_RECOVERED_LOSS | ICL_ITAMTS | CURR | 15 | 2 | Recovered Loss | ||
79 | REIMB_DEDUCTIBLE | ICL_REIMB_DED | ICL_ITAMTS | CURR | 15 | 2 | Portion of Deductible to Be Reimbursed |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_PAYI | CHANGEDBY | USR02 | BNAME | |||
2 | ICL_PAYI | CLIENT | T000 | MANDT | |||
3 | ICL_PAYI | PAYITY | TICL291 | PAYITY | |||
4 | ICL_PAYI | PYMTYPE | TICL551 | PYMTYPE | |||
5 | ICL_PAYI | TREASON | TICL066 | TREASON | REF | C | CN |
6 | ICL_PAYI | TREASONSET | TICL067 | TREASONSET | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |