SAP ABAP Table BW_HC_DRG (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | BW_HC_DRG |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
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 |  CLIENT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | INSTITUTION |
EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
| 3 | PATCASEID |
FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
| 4 | DRG_CODE |
ISH_DRG_CODE | TARLS | CHAR | 10 | 0 | IS-H: DRG Code | ||
| 5 | MDC_CODE |
ISH_MDC_CODE | DIAID | CHAR | 30 | 0 | IS-H: Code of Major Diagnostic Category (MDC) | NKDI | |
| 6 | DRG_CAT |
ISH_DRG_CAT | TARID | CHAR | 2 | 0 | IS-H: DRG Catalog Used for Coding | TNK01 | |
| 7 | SOI |
ISH_DRG_SOI | ISH_DRG_SOI_TYPE | CHAR | 1 | 0 | IS-H: Severity of Illness (for DRG Purposes) | TN15I | |
| 8 | DRG_REGROUP |
ISH_DRG_REGROUP_ADVISE | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Regrouping Advised | ||
| 9 | DRG_CREAT_DATE |
ISH_DRG_DATE | RI_DATUM | DATS | 8 | 0 | Date when DRG Was Determined | ||
| 10 | DRG_CREAT_TIME |
ISH_DRG_TIME | UHRZT | TIMS | 6 | 0 | Time when DRG Was Determined | ||
| 11 | GROUPING_USER |
ISH_GROUPING_USER | TEXT50 | CHAR | 50 | 0 | IS-H: Information on Operation of DRG System | ||
| 12 | CREATION_DATE |
RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
| 13 | CREATION_TIME |
ISH_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time when Data Record Created | ||
| 14 | CREATION_USER |
RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
| 15 | UPDATE_DATE |
RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
| 16 | UPDATE_TIME |
ISH_UPTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Data Record was Last Changed | ||
| 17 | UPDATE_USER |
RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
| 18 | MDC_CAT |
ISH_MDC_CAT | KATID | CHAR | 2 | 0 | IS-H: Catalog for Major Diagnostic Category (MDC) | TNK00 | |
| 19 | COST_WEIGHT |
ISH_COST_WEIGHT | DEC4_5 | DEC | 9 | 5 | IS-H: Cost Weight for DRGs |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | BW_HC_DRG | CLIENT |  T000 |
MANDT |
|||
| 2 | BW_HC_DRG | DRG_CAT | TNK01 |
KATID |
|||
| 3 | BW_HC_DRG | INSTITUTION | TN01 |
EINRI |
|||
| 4 | BW_HC_DRG | MDC_CAT | TNK00 |
KATID |
|||
| 5 | BW_HC_DRG | MDC_CODE | NKDI |
DKEY |
|||
| 6 | BW_HC_DRG | PATCASEID | NFAL |
FALNR |
|||
| 7 | BW_HC_DRG | SOI | TN15I |
SOI |
History
| Last changed by/on | SAP | 20131127 |
| SAP Release Created in |
