SAP ABAP Table ENT7579 (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | ENT7579 | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | NDIA | |
Delivery Class | ||
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
3 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
4 | LFDNR | LFDDIA | LFDDIA | NUMC | 3 | 0 | IS-H: Sequence Number of Diagnosis | ||
5 | LFDBEW | LFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Sequence Number of Movement | ||
6 | BELNR | KS_BELNR | KS_BELNR | CHAR | 10 | 0 | IS-H: Document Number of IV Document/Treatment Certificate | NKSK | |
7 | DKAT1 | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | TNK00 | |
8 | DKEY1 | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | NKDI | |
9 | DKAT2 | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | TNK00 | |
10 | DKEY2 | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | NKDI | |
11 | DKAT_REF | REF_DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Catalog ID of Reference Catalog for Statistics | TNK00 | |
12 | DKEY_REF | REF_DIAID | DIAID | CHAR | 30 | 0 | IS-H: Reference Diagnosis Code for Statistics | NKDI | |
13 | DITXT | ISH_DITEXT | TEXT50 | CHAR | 50 | 0 | IS-H: Free-Text Diagnosis | ||
14 | DILTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
15 | DIADT | DIADT | RI_DATUM | DATS | 8 | 0 | IS-H: Date on which Diagnosis Was Created | ||
16 | DIAZT | DIAZT | UHRZT | TIMS | 6 | 0 | IS-H: Time at which Diagnosis Created | ||
17 | DIAPE | DIA_PERS | RI_KUNNR | CHAR | 10 | 0 | IS-H: Identification of Diagnosing Person | NGPA | |
18 | SPERR | RI_SPERR | XFELD | CHAR | 1 | 0 | Blocking Indicator | ||
19 | KZTXT | TEXT_DIA | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Diagnosis | ||
20 | LGTXT | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
21 | DIASI | DIASI | DIASI | CHAR | 1 | 0 | IS-H: Diagnostic Certainty | ||
22 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
23 | ERTIM | RI_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Record Created | ||
24 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
25 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
26 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
27 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
28 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
29 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
30 | ANZOP | ANZOP | NUM02 | NUMC | 2 | 0 | IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis | ||
31 | BHDIA | KZ_BEHLD | XFELD | CHAR | 1 | 0 | IS-H: Treatment Diagnosis Indicator | ||
32 | ENDIA | KZ_ENTLD | XFELD | CHAR | 1 | 0 | IS-H: "Discharge Diagnosis" Indicator | ||
33 | FHDIA | KZ_FAHPD | XFELD | CHAR | 1 | 0 | IS-H: "Department Main Diagnosis" Indicator | ||
34 | AFDIA | KZ_AUFND | XFELD | CHAR | 1 | 0 | IS-H: Admission Diagnosis Indicator | ||
35 | KHDIA | KZ_KHHPD | XFELD | CHAR | 1 | 0 | IS-H: Hospital Main Diagnosis Indicator | ||
36 | OPDIA | KZ_OPERD | XFELD | CHAR | 1 | 0 | IS-H: Surgery Diagnosis Indicator |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ENT7579 | BELNR | NKSK | BELNR | KEY | 1 | CN |
2 | ENT7579 | DIAPE | NGPA | GPART | KEY | 1 | CN |
3 | ENT7579 | DKAT1 | TNK00 | KATID | REF | 1 | CN |
4 | ENT7579 | DKAT2 | TNK00 | KATID | REF | 1 | CN |
5 | ENT7579 | DKAT_REF | TNK00 | KATID | REF | 1 | CN |
6 | ENT7579 | DKEY1 | NKDI | DKEY | REF | 1 | CN |
7 | ENT7579 | DKEY2 | NKDI | DKEY | REF | 1 | CN |
8 | ENT7579 | DKEY_REF | NKDI | DKEY | REF | 1 | CN |
9 | ENT7579 | EINRI | TN01 | EINRI | KEY | 1 | CN |
10 | ENT7579 | FALNR | NFAL | FALNR | KEY | 1 | N |
11 | ENT7579 | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |