SAP ABAP Table ICSDENTAL (Tooth Notation)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷
FS-CM (Application Component) Claims Management
⤷
ICL_HEALTH (Package) FS-CM: Health Line of Insurance
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | ICSDENTAL |
|
| Short Description | Tooth Notation |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| 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 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 2 | |
ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
| 3 | |
ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | * | |
| 4 | |
ICL_DAMOBJBI | ICL_DAMOBJ | NUMC | 4 | 0 | Injured Person | * | |
| 5 | |
ICL_SUBOBJCAT | ICL_SUBOBJCAT | CHAR | 2 | 0 | Claim Subobject Category | * | |
| 6 | |
ICL_SUBOBJECTD | ICL_SUBOBJECTD | CHAR | 3 | 0 | Damaged Objects Occurrence Subobject | ||
| 7 | |
ICL_DENTALNO | ICL_DENTALNO | NUMC | 3 | 0 | Sequence No. Dental Diagnosis/Treatment in Case | ||
| 8 | |
ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
| 9 | |
0 | 0 | Shadow Tables Versioning: Include for Shade Table | |||||
| 10 | |
ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
| 11 | |
ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
| 12 | |
0 | 0 | Attributes of ICLDENTAL | |||||
| 13 | |
ICL_TOOTH | ICL_TOOTH | NUMC | 2 | 0 | Tooth Number | ||
| 14 | |
ICL_FINDING | ICL_FINDING | CHAR | 5 | 0 | Findings | TICL366 | |
| 15 | |
ICL_SUBSIDIZABLE | ICL_PLANNING | CHAR | 5 | 0 | Treatment Plan | TICL367 | |
| 16 | |
ICL_NOTSUBSIDIZABLE | ICL_PLANNING | CHAR | 5 | 0 | Cost Overrun Agreement | TICL367 | |
| 17 | |
ICL_PDOCCAT | ICL_PDOCCAT | CHAR | 2 | 0 | Claim Item Grouping Category | * | |
| 18 | |
ICL_DIAGSRCID | ICL_DIAGSRCID | CHAR | 20 | 0 | Diagnosis Source ID | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | ICSDENTAL | CHANGEDBY | |
|
|||
| 2 | ICSDENTAL | FINDING | |
|
KEY | 1 | CN |
| 3 | ICSDENTAL | NSUB_PLANNING | |
|
KEY | 1 | CN |
| 4 | ICSDENTAL | SUB_PLANNING | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in | 471 |