SAP ABAP Table ICL_ICLPROCURE_ALV (ALV Structure for ICLPROCURE)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_ICLPROCURE_ALV | Table Relationship Diagram |
Short Description | ALV Structure for ICLPROCURE |
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 | XSELECT | ICL_EVALCURRNT | XFELD | CHAR | 1 | 0 | Current Evaluation | ||
2 | PARTICIPANT | ICL_PART | BU_PARTNER | CHAR | 10 | 0 | Claim Participant | * | |
3 | DESCRIP | ICL_DESCRIP | CHAR50 | CHAR | 50 | 0 | Participant in Claim: Description | ||
4 | LOSSTYPE | ICL_LOSSTYPE | ICL_LOSSTYPE | CHAR | 4 | 0 | Incident Type of a Claim | * | |
5 | LOSSTYPEN | ICL_LOSSTYPEN | TEXT30 | CHAR | 30 | 0 | Name of Incident Type | ||
6 | CLTYPE | ICL_CLTYPE | ICL_CLTYPE | CHAR | 4 | 0 | Internal Claim Type | * | |
7 | CLTYPEN | ICL_CLTYPEN | TEXT30 | CHAR | 30 | 0 | Internal Claim Type Name | ||
8 | SUBCLTYPE | ICL_SUBCLTYPE | ICL_SUBCLTYPE | CHAR | 4 | 0 | Subclaim Type | * | |
9 | SUBCLTYPEN | ICL_SUBCLTYPEN | TEXT25 | CHAR | 25 | 0 | Subclaim Type Name | ||
10 | CLAIM_APPR | ICL_CLAIM_APPR | ICL_CLAIM | CHAR | 17 | 0 | Approval Number | * | |
11 | SUBCLAIM_APPR | ICL_SUBCL_APPR | ICL_SUBCL | CHAR | 3 | 0 | Subclaim Number as Second Part of Approval Number | * | |
12 | PROCUREMENT_APPR | ICL_PROCUREMENT_APPR | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping as Part of Approval Number | * | |
13 | .INCLUDE | 0 | 0 | Claim Item Groupings | |||||
14 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
15 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
16 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | ICLCLAIM | |
17 | SUBCLAIM | ICL_SUBCLP | ICL_SUBCL | CHAR | 3 | 0 | Subclaim of Payment | ICLSUBCL | |
18 | PROCUREMENT | ICL_PROCUREMENT | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping | * | |
19 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
20 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
21 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
22 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
23 | .INCLUDE | 0 | 0 | Claim Item Grouping | |||||
24 | .INCLUDE | 0 | 0 | Organizational Include (Short Version) | |||||
25 | CREATEDBY | ICL_CREATEDBY | XUBNAME | CHAR | 12 | 0 | Created By | USR02 | |
26 | CREATETIME | ICL_CREATEUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Created: UTC Date+Time | ||
27 | PDOCTYPE | ICL_PDOCTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type for Grouping of Lower Level Benefit Types | * | |
28 | PDOCCAT | ICL_PDOCCAT | ICL_PDOCCAT | CHAR | 2 | 0 | Claim Item Grouping Category | TICL138 | |
29 | ISSUEDATE | ICL_ISSUEDATE1 | DATS | DATS | 8 | 0 | Date Created | ||
30 | RECEIVEDATE | ICL_RECEIVEDATE | DATS | DATS | 8 | 0 | Date Received | ||
31 | DATEFROM | ICL_DATEFROM | DATS | DATS | 8 | 0 | Start Date of Period | ||
32 | TIMEFROM | ICL_TIMEFROM | ICL_TIMEFROM | TIMS | 6 | 0 | Start Time of Claim Item Group | ||
33 | DATETO | ICL_DATETO | DATS | DATS | 8 | 0 | End Date of Period | ||
34 | TIMETO | ICL_TIMETO | ICL_TIMETO | TIMS | 6 | 0 | End Time of Claim Item Group | ||
35 | ISSUEDATE_PRESCR | ICL_ISSUEDATE_PRESCR | DATS | DATS | 8 | 0 | Date Prescription Created Acc. to Invoice | ||
36 | ACQUISITIONDATE | ICL_ACQUISITIONDATE | DATS | DATS | 8 | 0 | Date Entered | ||
37 | AMOUNT1 | ICL_AMOUNT1 | ICL_AMOUNT | CURR | 15 | 2 | General Amount Field | ||
38 | CURRENCY | ICL_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
39 | .INCLUDE | 0 | 0 | External Numbers for Claim Item Groupings | |||||
40 | EXTERNALREF | ICL_EXTERNALREF | ICL_EXTERNALREF | CHAR | 20 | 0 | External Reference of Claim Item Grouping | ||
41 | EXTDOCUMENT | ICL_EXTDOCUMENT | ICL_EXTDOCUMENT | CHAR | 16 | 0 | External Document Number | ||
42 | EXTCASENO | ICLH_EXTCASENO | ICLH_EXTCASENO | CHAR | 15 | 0 | Hospital-Internal ID | ||
43 | EXTFILENO | ICLH_EXTFILENO | ICLH_EXTFILENO | CHAR | 20 | 0 | HI: External Data Set Identification | ||
44 | PROC_REF | ICL_PROCUREMENT | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping | ICLPROCURE | |
45 | DISCOUNTAMOUNT | ICL_DISCOUNTAMOUNT | ICL_AMOUNT | CURR | 15 | 2 | Discount on Invoice Amount | ||
46 | DISCOUNTPERCENT | ICL_DISCOUNTPERCENT | ICL_PERCENT | DEC | 5 | 2 | Discount on Total Invoice Amount in Percent | ||
47 | .INCLUDE | 0 | 0 | Accident or Subro/Recovery Indicator | |||||
48 | ACCIDENT | ICL_ACCIDENT | ICL_ACCIDENT | CHAR | 2 | 0 | Accident or Other Reason for Possible Recovery | TICL158 | |
49 | SUBROGATION | ICL_SUBROGATION | ICL_SUBROGATION | CHAR | 2 | 0 | Indication Whether Recovery Claim Might Be Involved | TICL157 | |
50 | DUEDATE | ICL_DUEDATE | DATE | DATS | 8 | 0 | Due Date | ||
51 | DUEDATE_ORIG | ICL_DUEDATE_ORIG | DATE | DATS | 8 | 0 | Origin of Due Date | ||
52 | STATUS | ICL_PROCSTATUS | ICL_STATUS | CHAR | 2 | 0 | Status of a Claim Item Grouping | TICL140 | |
53 | STATREASON | ICL_FORMSET | ICL_FORMSET | CHAR | 2 | 0 | Reason for Changing the Status | TICL018 | |
54 | OWNCONTRIB | ICL_OWNCONTRIB | NUMC03 | NUMC | 3 | 0 | Copayment | ||
55 | REASON | ICL_REASON | ICL_REASON | CHAR | 3 | 0 | Reason for Creating a Claim Item Grouping | TICL152 | |
56 | CAUSE | ICLH_CAUSE | ICLH_CAUSE | CHAR | 2 | 0 | Specification of Reason for Creating Claim Item Grouping | * | |
57 | PDOCCATTYPE | ICL_PDOCCATTYPE | ICL_PDOCCATTYPE | CHAR | 3 | 0 | Type of Claim Item Grouping Category | TICL153 | |
58 | SUBCL_ORIG | ICL_SUBCL_ORIG | ICL_SUBCL | CHAR | 3 | 0 | Original Subclaim Multiple Prescription/Curr.Subclm Appraisl | * | |
59 | PROC_ORIG | ICL_PROC_ORIG | ICL_PROCUREMENT | NUMC | 4 | 0 | Original Claim Item Grouping of Multiple Prescription | * | |
60 | DATASOURCE | ICL_DATASOURCE | ICL_DATASOURCE | CHAR | 2 | 0 | Data Origin | TICL136 | |
61 | SETORDERDATE | ICL_SETORDERDATE | DATS | DATS | 8 | 0 | Set Order Date | ||
62 | COMPLETIONDATE | ICL_COMPLETIONDATE | DATS | DATS | 8 | 0 | Completion Date | ||
63 | .INCLUDE | 0 | 0 | Claim Item Grouping: Dental-Specific Fields | |||||
64 | FEE | ICLH_FEE | ICL_AMOUNT | CURR | 15 | 2 | Fee | ||
65 | MATLABCOST | ICLH_MATLABCOST | ICL_AMOUNT | CURR | 15 | 2 | Material and Laboratory Costs | ||
66 | MATLABCOSTINT | ICLH_MATLABCOSTINT | ICL_AMOUNT | CURR | 15 | 2 | will be deleted. | ||
67 | ADDCOST | ICLH_ADDCOST | ICL_AMOUNT | CURR | 15 | 2 | Other Costs | ||
68 | VALPERUNIT | ICL_SERVCAT_POS_VALPERUNIT | ICL_SERVCAT_POS_VALPERUNIT | DEC | 20 | 12 | Value per Unit of Benefits Catalog Item | ||
69 | SUBSIDYPERCENT | ICLH_SUBSIDYPERCENT | ICL_PERCENT | DEC | 5 | 2 | Subsidy in Percent (%) | ||
70 | SUBSIDYAMOUNT | ICLH_SUBSIDYAMOUNT | ICL_AMOUNT | CURR | 15 | 2 | Subsidy Amount | ||
71 | SENTUTC | ICL_SENTUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Sent: UTC Date and Time | ||
72 | SENT_BY_DME | ICL_SENT_BY_DME | XFELD | CHAR | 1 | 0 | Sent via External Interface (Not Yet Used) | ||
73 | RECEIPT_BY_DME | ICL_RECEIPT_BY_DME | XFELD | CHAR | 1 | 0 | Receipt via External Interface | ||
74 | .INCLUDE | 0 | 0 | Status for Procurement | |||||
75 | CANCEL | ICL_STATUS_CANCEL | XFELD | CHAR | 1 | 0 | Status "Cancelled" | ||
76 | REJECTED | ICL_STATUS_REJECTED | XFELD | CHAR | 1 | 0 | Status "Rejected" | ||
77 | INSUSPENSE | ICL_STATUS_INSUSPENSE | XFELD | CHAR | 1 | 0 | Status "Pending" | ||
78 | INPROCESS | ICL_STATUS_INPROCESS | XFELD | CHAR | 1 | 0 | Status "In Process" | ||
79 | RELEASED | ICL_STATUS_RELEASED | XFELD | CHAR | 1 | 0 | Status "Released" | ||
80 | XFINISHED | ICL_XFINISHED | XFELD | CHAR | 1 | 0 | Complete/Approved/Finished | ||
81 | ORDERED | ICL_STATUS_ORDERED | XFELD | CHAR | 1 | 0 | Status "Commissioned" | ||
82 | TRANSFERRED | ICL_STATUS_TRANSFERRED | XFELD | CHAR | 1 | 0 | Status "Reassigned" | ||
83 | XCLINICCARD | ICLH_CLINIC_CARD | ICLH_CLINIC_CARD | CHAR | 1 | 0 | Flag: Clinic Card | ||
84 | PAYFREQPLAN | ICL_PAYFREQPLAN_REP | PKEY_VK | CHAR | 2 | 0 | Payment Frequency of a Repetitive Payment | TVS010B | |
85 | ASSIGN_GUID | ICL_ASSIGN_GUID | SYSUUID_C | CHAR | 32 | 0 | UUID of Entry to be Linked | ||
86 | XREQUEST | ICL_XREQUEST | XFELD | CHAR | 1 | 0 | Indicator: Receivable | ||
87 | COMPPER_DATEFROM | ICL_COMPPER_DATEFROM_D_PE | ICL_COMPPER_PE | DATS | 8 | 0 | Comparison Period From | ||
88 | COMPPER_DATETO | ICL_COMPPER_DATETO_D_PE | ICL_COMPPER_PE | DATS | 8 | 0 | Comparison Period To | ||
89 | PAYOUT_SCENARIO | ICL_PAYOUT_SCENARIO_D | ICL_PAYOUT_SCENARIO | CHAR | 1 | 0 | Repetitive Payment Scenario |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_ICLPROCURE_ALV | ACCIDENT | TICL158 | ACCIDENT | |||
2 | ICL_ICLPROCURE_ALV | CHANGEDBY | USR02 | BNAME | |||
3 | ICL_ICLPROCURE_ALV | CLAIM | ICLCLAIM | CLAIM | |||
4 | ICL_ICLPROCURE_ALV | CLIENT | T000 | MANDT | |||
5 | ICL_ICLPROCURE_ALV | CREATEDBY | USR02 | BNAME | |||
6 | ICL_ICLPROCURE_ALV | CURRENCY | TCURC | WAERS | KEY | ||
7 | ICL_ICLPROCURE_ALV | DATASOURCE | TICL136 | DATASOURCE | KEY | ||
8 | ICL_ICLPROCURE_ALV | PAYFREQPLAN | TVS010B | PKEY | REF | 1 | CN |
9 | ICL_ICLPROCURE_ALV | PDOCCAT | TICL138 | PDOCCAT | |||
10 | ICL_ICLPROCURE_ALV | PDOCCATTYPE | TICL153 | PDOCCATTYPE | |||
11 | ICL_ICLPROCURE_ALV | PROC_REF | ICLPROCURE | PROCUREMENT | |||
12 | ICL_ICLPROCURE_ALV | REASON | TICL152 | REASON | KEY | 1 | CN |
13 | ICL_ICLPROCURE_ALV | STATREASON | TICL018 | FORMOFSET | |||
14 | ICL_ICLPROCURE_ALV | STATUS | TICL140 | STATUS | |||
15 | ICL_ICLPROCURE_ALV | SUBCLAIM | ICLSUBCL | SUBCLAIM | |||
16 | ICL_ICLPROCURE_ALV | SUBROGATION | TICL157 | SUBROGATION |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 471 |