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
⤷ 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 | Table Relationship Diagram |
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 | .INCLUDE | 0 | 0 | FS-CM: Benefits/Services/Fees Catalogs | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | SCPOSID_INT | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
4 | .INCLUDE | 0 | 0 | FS-CM: Attributes for Version of Benefits/Serv/Fee Catalogs | |||||
5 | ACTIVE | ICL_ACTIVE2 | ICL_ACTIVE2 | CHAR | 1 | 0 | Status | ||
6 | CHANGEDBY | ICL_CHANGEBY | XUBNAME | CHAR | 12 | 0 | Version Created By (= Object Changed By) | USR02 | |
7 | CHANGETIME | ICL_CHANGEUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Created: UTC Date+Time | ||
8 | INACTIVETIME | ICL_INACTIUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Deactivated: UTC Date+Time | ||
9 | EFFFROMTIME | ICL_EFFROMUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Valid From: UTC Date+Time | ||
10 | EFFTOTIME | ICL_EFFETOUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Version Valid to: UTC-Date+Time | ||
11 | TERMTIME | ICL_TERMINUTC | ICL_TIMESTAMP | DEC | 15 | 0 | Valid-To Date Set: UTC Date+Time | ||
12 | DELETED | ICL_XDELETE | XFELD | CHAR | 1 | 0 | Flag: Deletion Entry? | ||
13 | OSYSID | ICL_OSYSID | SYCHAR08 | CHAR | 8 | 0 | Original System of Version | ||
14 | OMANDT | ICL_OMANDT | MANDT | CLNT | 3 | 0 | Client in Original System | * | |
15 | SCPOSID_PREV | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
16 | .INCLUDE | 0 | 0 | FS-CM: External Key Attrib. of Benef/Serv/Fee Ctlg Item | |||||
17 | SERVCATID | ICL_SERVCATID | ICL_SERVCATID | CHAR | 10 | 0 | ID of a Benefits, Services and Fees Catalog | TICL401 | |
18 | SC_VARIANT | ICL_SERVCAT_VARIANT | ICL_SERVCAT_VARIANT | CHAR | 4 | 0 | Variant of a Benefits/Services/Fee Catalog | TICL402 | |
19 | SCPOSID_EXT | ICL_SERVCAT_POSID | ICL_SERVCAT_POSID | CHAR | 20 | 0 | ID of a Benefits Catalog Item | ||
20 | SCPOSID_AMNTFROM | ICL_SERVCAT_POSID_AMOUNT_FROM | ICL_AMOUNT | CURR | 15 | 2 | Lower Interval Limit of a Benefits Catalog Item | ||
21 | SCPOSID_AMNTTO | ICL_SERVCAT_POSID_AMOUNT_TO | ICL_AMOUNT | CURR | 15 | 2 | Upper Interval Limit of a Benefits Catalog Item | ||
22 | .INCLUDE | 0 | 0 | FS-CM: General Attributes of Benef/Service/Fee Catalog Item | |||||
23 | SCPOS_CURR | ICL_SERVCAT_POS_CURR | WAERS | CUKY | 5 | 0 | Currency of Benefits/Services/Fees Catalog | TCURC | |
24 | SCPOS_PARENT | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
25 | SCPOS_TYPE | ICL_SERVCAT_POS_TYPE | ICL_SERVCAT_POS_TYPE | CHAR | 4 | 0 | Type of Benefits Catalog Item | TICL404 | |
26 | SCPOS_XSEL | ICL_SERVCAT_POS_SELECTABLE | XFELD | CHAR | 1 | 0 | Entry Lock for Benefits Catalog Item | ||
27 | BENTYPE | ICL_BENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type | TICL055 | |
28 | BENTYPE_EXP | BRF_EXPRESSION | BRF_EXPRESSION | CHAR | 20 | 0 | BRF: Expression | * | |
29 | SCPOS_QUANTITY | ICL_SERVCAT_POS_QUANTITY | ICL_SERVCAT_POS_QUANTITY | QUAN | 10 | 3 | Evaluation Quantity of Benefits Catalog Item | ||
30 | SCPOS_QUANTITYTO | ICL_SERVCAT_POS_QUANTITY_TO | ICL_SERVCAT_POS_QUANTITY | QUAN | 10 | 3 | Evaluation Quantity of Catalog Item (Upper Limit) | ||
31 | SCPOS_QUANUNIT | ICL_SERVCAT_POS_QUANUNIT | MEINS | UNIT | 3 | 0 | Unit of Benefits Catalog Item | T006 | |
32 | SCPOS_VALPERUNIT | ICL_SERVCAT_POS_VALPERUNIT | ICL_SERVCAT_POS_VALPERUNIT | DEC | 20 | 12 | Value per Unit of Benefits Catalog Item | ||
33 | SCPOS_XREIMBURSE | ICL_SERVCAT_POS_REIMBURSABLE | ICL_SERVCAT_POS_REIMBURSABLE | CHAR | 1 | 0 | Reimbursability of a Benefits Catalog Item | ||
34 | SCPOS_XAPPROVAL | ICL_SERVCAT_POS_APPROVAL | XFELD | CHAR | 1 | 0 | Approval Requirement of a Benef/Serv/Fees Catalog Item | ||
35 | .INCLUDE | 0 | 0 | Relative Amount | |||||
36 | RV | ICL_SERVCAT_RV_D_PE | QUAN | 10 | 0 | Relative Value | |||
37 | RVU | ICL_SERVCAT_RVU_D_PE | MEINS | UNIT | 3 | 0 | Unit of Measure of Relative Value | T006 | |
38 | .INCLUDE | 0 | 0 | Hospital Data | |||||
39 | AVLENGTH | ICL_SERVCAT_AVLENG_D_PE | ICL_SERVCAT_RESIDENCETIME_D_PE | DEC | 5 | 2 | Average Length of Stay in Days | ||
40 | DEDUCTION | ICL_SERVCAT_DEDUCTION_D_PE | ICL_SERVCAT_RESIDENCETIME_D_PE | DEC | 5 | 2 | First Day of Markdown | ||
41 | SURCHARGE | ICL_SERVCAT_SURCHARGE_D_PE | ICL_SERVCAT_RESIDENCETIME_D_PE | DEC | 5 | 2 | First Day of Markup | ||
42 | LOCALIZATION | ICL_SERVCATAL_LOCAL_D_PE | ICL_SERVCATAL_LOCAL_D_PE | CHAR | 1 | 0 | Indicator 'Localization Possible' | * | |
43 | CATAID | ICL_CATAID_MDC_D_PE | ICL_CATAID | CHAR | 4 | 0 | Catalog for Major Diagnostic Categories (MDCs) | TICL350 | |
44 | DIAGID | ICL_MDCPOSID_D_PE | ICL_DIAGID | CHAR | 10 | 0 | Code of an MDC Item | TICL351 | |
45 | SCPOSN | ICL_SERVCAT_POS_SHORTNAME | TEXT30 | CHAR | 30 | 0 | Short Text of a Benefits Catalog Item | ||
46 | SCPOSLN | ICL_SERVCAT_POS_NAME | TEXT100 | CHAR | 100 | 0 | Long Text of Benefits Catalog Item | ||
47 | SCPOSXLN | ICL_SERVCAT_POS_XLONG_TEXT | TEXT255 | CHAR | 255 | 0 | Description of Benefits Catalog Item | ||
48 | EFFFROMDA | ICL_EFFROMDA | DATE | DATS | 8 | 0 | Version Valid From Date | ||
49 | EFFFROMTI | ICL_EFFROMTI | TIME | TIMS | 6 | 0 | Version Valid From Time | ||
50 | EFFTODA | ICL_EFFETODA | DATE | DATS | 8 | 0 | Version Valid To Date | ||
51 | EFFTOTI | ICL_EFFETOTI | TIME | TIMS | 6 | 0 | Version Valid To Time | ||
52 | CHANGEDA | ICL_SERVCAT_POS_CHANGE_DATE | DATUM | DATS | 8 | 0 | Date of Last Change to Benefits Catalog Item | ||
53 | CHANGETI | ICL_SERVCAT_POS_CHANGE_TIME | UZEIT | TIMS | 6 | 0 | Time of Last Change to a Benefits Catalog Item | ||
54 | BENTYPEN | ICL_BENTYPEN | ICL_BENTYPEN | CHAR | 80 | 0 | Benefit Type Name | ||
55 | DIAGNAME | ICL_DIAGNAME_SHORT | TEXT30 | CHAR | 30 | 0 | Short Name for Diagnosis in Diagnosis Catalog | ||
56 | DIAGNAME_MEDIUM | ICL_DIAGNAME_MEDIUM | TEXT60 | CHAR | 60 | 0 | Medium-Length Name of Diagnosis in Diagnosis Catalog | ||
57 | DIAGNAME_LONG | ICL_DIAGNAME | TEXT240 | CHAR | 240 | 0 | Long Name of Diagnosis in Diagnosis Catalog | ||
58 | CATANAME | ICL_CATANAME | TEXT40 | CHAR | 40 | 0 | Long Name of a Diagnosis Catalog | ||
59 | CATANAME_SHORT | 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 | TICL055 | BENTYPE | 1 | CN | |
2 | ICL_SERVCAT | CATAID | TICL350 | CATAID | KEY | 1 | CN |
3 | ICL_SERVCAT | CHANGEDBY | USR02 | BNAME | 1 | CN | |
4 | ICL_SERVCAT | CLIENT | T000 | MANDT | KEY | 1 | CN |
5 | ICL_SERVCAT | DIAGID | TICL351 | DIAGID | REF | 1 | CN |
6 | ICL_SERVCAT | RVU | T006 | MSEHI | 1 | CN | |
7 | ICL_SERVCAT | SCPOS_CURR | TCURC | WAERS | 1 | CN | |
8 | ICL_SERVCAT | SCPOS_QUANUNIT | T006 | MSEHI | 1 | CN | |
9 | ICL_SERVCAT | SCPOS_TYPE | TICL404 | SCPOS_TYPE | 1 | CN | |
10 | ICL_SERVCAT | SC_VARIANT | TICL402 | SC_VARIANT | |||
11 | ICL_SERVCAT | SERVCATID | TICL401 | SERVCATID |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 472 |