SAP ABAP Table ICL_PROCEDURES_S_UI (Procedures)
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_PROCEDURES_S_UI | Table Relationship Diagram |
Short Description | Procedures |
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 | Data on Procedures (incl. Benefits Catalog Data and Texts) | |||||
2 | .INCLUDE | 0 | 0 | Data on Procedures | |||||
3 | .INCLUDE | 0 | 0 | Procedures | |||||
4 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
5 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
6 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | * | |
7 | PROCEDURE_GUID | ICL_PROCEDUREGUID | SYSUUID_C | CHAR | 32 | 0 | Universal Unique Identifier of a Procedure | ||
8 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
9 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
10 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
11 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
12 | .INCLUDE | 0 | 0 | Attributes of ICLPROCEDURES | |||||
13 | .INCLUDE | 0 | 0 | FS-CM: Benefits/Services/Fees Catalogs in ICLITEM | |||||
14 | SCPOSID_INT | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
15 | SERVCAT | ICL_SERVCATID_PROCEDURES | ICL_SERVCATID | CHAR | 10 | 0 | ID of a Benefits, Services and Fees Catalog | * | |
16 | SCPOSID_EXT | ICL_SERVCAT_POSID | ICL_SERVCAT_POSID | CHAR | 20 | 0 | ID of a Benefits Catalog Item | ||
17 | PROCEDURE_NO | ICL_PROCEDURENO | NUMC | 3 | 0 | Sequence Number of a Procedure | |||
18 | PATIENT | ICLH_PROCED_PART | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number of Person Treated | * | |
19 | PRIMPROCED | ICL_PRIMPROCEDURE | ICL_PRIMPROCEDURE_D_PE | CHAR | 1 | 0 | Primary Procedure | ||
20 | PROCEDTIME | ICL_PROCEDURE_TIME | ICL_TIMESTAMP | DEC | 15 | 0 | Time Performed | ||
21 | LOCALIZATION | ICL_LOCALIZATION | ICL_LOCALIZATION | CHAR | 1 | 0 | Side Localization of a Diagnosis | TICL352 | |
22 | DEPARTMENT | ICL_DEPARTMENT | ICL_DEPARTMENT | CHAR | 4 | 0 | Department (Key) | TICL364 | |
23 | USED4CALC | ICL_USED4CALC | CHAR | 1 | 0 | Used for Grouping | |||
24 | .INCLUDE | 0 | 0 | Procedures: Benefits Catalog Data | |||||
25 | SERVCATIDSN | ICL_SERVCATNAME_SHORT | TEXT10 | CHAR | 10 | 0 | Short Name of a Benefits/Services/Fees Catalog | ||
26 | SCPOSN | ICL_SERVCAT_POS_SHORTNAME | TEXT30 | CHAR | 30 | 0 | Short Text of a Benefits Catalog Item | ||
27 | SCPOSLN | ICL_SERVCAT_POS_NAME | TEXT100 | CHAR | 100 | 0 | Long Text of Benefits Catalog Item | ||
28 | SCPOSXLN | ICL_SERVCAT_POS_XLONG_TEXT | TEXT255 | CHAR | 255 | 0 | Description of Benefits Catalog Item | ||
29 | SCPOSHINT | ICL_SERVCAT_POS_HINT_D_UI | ICL_SERVCAT_POS_HINT_D_UI | STRG | 0 | 0 | Note on Covered or Excluded Benefits | ||
30 | SERVCATIDLN | ICL_SERVCATNAME | TEXT30 | CHAR | 30 | 0 | Name of Benefits/Services/Fee Catalog | ||
31 | LOCNAME | ICL_LOCNAME | TEXT20 | CHAR | 20 | 0 | Name of Side Localization of a Diagnosis | ||
32 | DEPARTNAME | ICL_DEPARTNAME | TEXT60 | CHAR | 60 | 0 | Name of Department | ||
33 | PROCEDURE_TIME_UI | ICL_PROCEDURE_TIME_UI | TIMS | 6 | 0 | Time of Procedure | |||
34 | PROCEDURE_DATE_UI | ICL_PROCEDURE_DATE_UI | DATS | 8 | 0 | Date of Procedure |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_PROCEDURES_S_UI | CHANGEDBY | USR02 | BNAME | |||
2 | ICL_PROCEDURES_S_UI | CLIENT | T000 | MANDT | |||
3 | ICL_PROCEDURES_S_UI | DEPARTMENT | TICL364 | DEPARTMENT | |||
4 | ICL_PROCEDURES_S_UI | LOCALIZATION | TICL352 | LOCALIZATION |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 700 |