SAP ABAP Table ICL_SERVCAT (FS-CM: Display Structure Benefits/Services/Fees Catalogs)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷
FS-CM (Application Component) Claims Management
⤷
ICL_SERVICE_CATALOG (Package) FS-CM: Benefits/Services/Fees Catalog
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | ICL_SERVCAT |
|
| Short Description | FS-CM: Display Structure Benefits/Services/Fees Catalogs |
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 | |
0 | 0 | FS-CM: Benefits/Services/Fees Catalogs | |||||
| 2 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 3 | |
ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
| 4 | |
0 | 0 | FS-CM: Attributes for Version of Benefits/Serv/Fee Catalogs | |||||
| 5 | |
ICL_ACTIVE2 | ICL_ACTIVE2 | CHAR | 1 | 0 | Status | ||
| 6 | |
ICL_CHANGEBY | XUBNAME | CHAR | 12 | 0 | Version Created By (= Object Changed By) | USR02 | |
| 7 | |
ICL_CHANGEUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Created: UTC Date+Time | ||
| 8 | |
ICL_INACTIUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Deactivated: UTC Date+Time | ||
| 9 | |
ICL_EFFROMUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Valid From: UTC Date+Time | ||
| 10 | |
ICL_EFFETOUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Valid to: UTC-Date+Time | ||
| 11 | |
ICL_TERMINUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Valid-To Date Set: UTC Date+Time | ||
| 12 | |
ICL_XDELETE | XFELD | CHAR | 1 | 0 | Flag: Deletion Entry? | ||
| 13 | |
ICL_OSYSID | SYCHAR08 | CHAR | 8 | 0 | Original System of Version | ||
| 14 | |
ICL_OMANDT | MANDT | CLNT | 3 | 0 | Client in Original System | * | |
| 15 | |
ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
| 16 | |
0 | 0 | FS-CM: External Key Attrib. of Benef/Serv/Fee Ctlg Item | |||||
| 17 | |
ICL_SERVCATID | ICL_SERVCATID | CHAR | 10 | 0 | ID of a Benefits, Services and Fees Catalog | TICL401 | |
| 18 | |
ICL_SERVCAT_VARIANT | ICL_SERVCAT_VARIANT | CHAR | 4 | 0 | Variant of a Benefits/Services/Fee Catalog | TICL402 | |
| 19 | |
ICL_SERVCAT_POSID | ICL_SERVCAT_POSID | CHAR | 20 | 0 | ID of a Benefits Catalog Item | ||
| 20 | |
ICL_SERVCAT_POSID_AMOUNT_FROM | ICL_AMOUNT | CURR | 15 | 2 | Lower Interval Limit of a Benefits Catalog Item | ||
| 21 | |
ICL_SERVCAT_POSID_AMOUNT_TO | ICL_AMOUNT | CURR | 15 | 2 | Upper Interval Limit of a Benefits Catalog Item | ||
| 22 | |
0 | 0 | FS-CM: General Attributes of Benef/Service/Fee Catalog Item | |||||
| 23 | |
ICL_SERVCAT_POS_CURR | WAERS | CUKY | 5 | 0 | Currency of Benefits/Services/Fees Catalog | TCURC | |
| 24 | |
ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
| 25 | |
ICL_SERVCAT_POS_TYPE | ICL_SERVCAT_POS_TYPE | CHAR | 4 | 0 | Type of Benefits Catalog Item | TICL404 | |
| 26 | |
ICL_SERVCAT_POS_SELECTABLE | XFELD | CHAR | 1 | 0 | Entry Lock for Benefits Catalog Item | ||
| 27 | |
ICL_BENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type | TICL055 | |
| 28 | |
BRF_EXPRESSION | BRF_EXPRESSION | CHAR | 20 | 0 | BRF: Expression | * | |
| 29 | |
ICL_SERVCAT_POS_QUANTITY | ICL_SERVCAT_POS_QUANTITY | QUAN | 10 | 3 | Evaluation Quantity of Benefits Catalog Item | ||
| 30 | |
ICL_SERVCAT_POS_QUANTITY_TO | ICL_SERVCAT_POS_QUANTITY | QUAN | 10 | 3 | Evaluation Quantity of Catalog Item (Upper Limit) | ||
| 31 | |
ICL_SERVCAT_POS_QUANUNIT | MEINS | UNIT | 3 | 0 | Unit of Benefits Catalog Item | T006 | |
| 32 | |
ICL_SERVCAT_POS_VALPERUNIT | ICL_SERVCAT_POS_VALPERUNIT | DEC | 20 | 12 | Value per Unit of Benefits Catalog Item | ||
| 33 | |
ICL_SERVCAT_POS_REIMBURSABLE | ICL_SERVCAT_POS_REIMBURSABLE | CHAR | 1 | 0 | Reimbursability of a Benefits Catalog Item | ||
| 34 | |
ICL_SERVCAT_POS_APPROVAL | XFELD | CHAR | 1 | 0 | Approval Requirement of a Benef/Serv/Fees Catalog Item | ||
| 35 | |
0 | 0 | Relative Amount | |||||
| 36 | |
ICL_SERVCAT_RV_D_PE | QUAN | 10 | 0 | Relative Value | |||
| 37 | |
ICL_SERVCAT_RVU_D_PE | MEINS | UNIT | 3 | 0 | Unit of Measure of Relative Value | T006 | |
| 38 | |
0 | 0 | Hospital Data | |||||
| 39 | |
ICL_SERVCAT_AVLENG_D_PE | ICL_SERVCAT_RESIDENCETIME_D_PE | DEC | 5 | 2 | Average Length of Stay in Days | ||
| 40 | |
ICL_SERVCAT_DEDUCTION_D_PE | ICL_SERVCAT_RESIDENCETIME_D_PE | DEC | 5 | 2 | First Day of Markdown | ||
| 41 | |
ICL_SERVCAT_SURCHARGE_D_PE | ICL_SERVCAT_RESIDENCETIME_D_PE | DEC | 5 | 2 | First Day of Markup | ||
| 42 | |
ICL_SERVCATAL_LOCAL_D_PE | ICL_SERVCATAL_LOCAL_D_PE | CHAR | 1 | 0 | Indicator 'Localization Possible' | * | |
| 43 | |
ICL_CATAID_MDC_D_PE | ICL_CATAID | CHAR | 4 | 0 | Catalog for Major Diagnostic Categories (MDCs) | TICL350 | |
| 44 | |
ICL_MDCPOSID_D_PE | ICL_DIAGID | CHAR | 10 | 0 | Code of an MDC Item | TICL351 | |
| 45 | |
ICL_SERVCAT_POS_SHORTNAME | TEXT30 | CHAR | 30 | 0 | Short Text of a Benefits Catalog Item | ||
| 46 | |
ICL_SERVCAT_POS_NAME | TEXT100 | CHAR | 100 | 0 | Long Text of Benefits Catalog Item | ||
| 47 | |
ICL_SERVCAT_POS_XLONG_TEXT | TEXT255 | CHAR | 255 | 0 | Description of Benefits Catalog Item | ||
| 48 | |
ICL_EFFROMDA | DATE | DATS | 8 | 0 | Version Valid From Date | ||
| 49 | |
ICL_EFFROMTI | TIME | TIMS | 6 | 0 | Version Valid From Time | ||
| 50 | |
ICL_EFFETODA | DATE | DATS | 8 | 0 | Version Valid To Date | ||
| 51 | |
ICL_EFFETOTI | TIME | TIMS | 6 | 0 | Version Valid To Time | ||
| 52 | |
ICL_SERVCAT_POS_CHANGE_DATE | DATUM | DATS | 8 | 0 | Date of Last Change to Benefits Catalog Item | ||
| 53 | |
ICL_SERVCAT_POS_CHANGE_TIME | UZEIT | TIMS | 6 | 0 | Time of Last Change to a Benefits Catalog Item | ||
| 54 | |
ICL_BENTYPEN | ICL_BENTYPEN | CHAR | 80 | 0 | Benefit Type Name | ||
| 55 | |
ICL_DIAGNAME_SHORT | TEXT30 | CHAR | 30 | 0 | Short Name for Diagnosis in Diagnosis Catalog | ||
| 56 | |
ICL_DIAGNAME_MEDIUM | TEXT60 | CHAR | 60 | 0 | Medium-Length Name of Diagnosis in Diagnosis Catalog | ||
| 57 | |
ICL_DIAGNAME | TEXT240 | CHAR | 240 | 0 | Long Name of Diagnosis in Diagnosis Catalog | ||
| 58 | |
ICL_CATANAME | TEXT40 | CHAR | 40 | 0 | Long Name of a Diagnosis Catalog | ||
| 59 | |
ICL_CATANAME_SHORT | TEXT10 | CHAR | 10 | 0 | Description of Diagnosis Catalog |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | ICL_SERVCAT | BENTYPE | |
|
1 | CN | |
| 2 | ICL_SERVCAT | CATAID | |
|
KEY | 1 | CN |
| 3 | ICL_SERVCAT | CHANGEDBY | |
|
1 | CN | |
| 4 | ICL_SERVCAT | CLIENT | |
|
KEY | 1 | CN |
| 5 | ICL_SERVCAT | DIAGID | |
|
REF | 1 | CN |
| 6 | ICL_SERVCAT | RVU | |
|
1 | CN | |
| 7 | ICL_SERVCAT | SCPOS_CURR | |
|
1 | CN | |
| 8 | ICL_SERVCAT | SCPOS_QUANUNIT | |
|
1 | CN | |
| 9 | ICL_SERVCAT | SCPOS_TYPE | |
|
1 | CN | |
| 10 | ICL_SERVCAT | SC_VARIANT | |
|
|||
| 11 | ICL_SERVCAT | SERVCATID | |
|
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in | 472 |