SAP ABAP Table VN1PRDIA (IS-H*MED: PATREG: Verbucherstruktur für N1PRDIA (Diagnosen))
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷ IS-HMED (Application Component) Clinical System
⤷ N1PR (Package) IS-H*MED: Patientenregister
⤷ IS-HMED (Application Component) Clinical System
⤷ N1PR (Package) IS-H*MED: Patientenregister
Basic Data
Table Category | INTTAB | Structure |
Structure | VN1PRDIA | Table Relationship Diagram |
Short Description | IS-H*MED: PATREG: Verbucherstruktur für N1PRDIA (Diagnosen) |
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 | IS-H*MED: PATREG: Diagnosen | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | TLNRID | N1PRTLNRID | N1PRTLNRID | CHAR | 10 | 0 | PATREG: Teilnehmer ID | N1PRTLNR | |
4 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | * | |
5 | LFDNR | LFDDIA | LFDDIA | NUMC | 3 | 0 | IS-H: Sequence Number of Diagnosis | ||
6 | LFDBEW | LFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Sequence Number of Movement | * | |
7 | DITXT | ISH_DITEXT | TEXT50 | CHAR | 50 | 0 | IS-H: Free-Text Diagnosis | ||
8 | DIADT | DIADT | RI_DATUM | DATS | 8 | 0 | IS-H: Date on which Diagnosis Was Created | ||
9 | DIAZT | DIAZT | UHRZT | TIMS | 6 | 0 | IS-H: Time at which Diagnosis Created | ||
10 | DKAT1 | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | ||
11 | KATKB1 | KATKB | TEXT10 | CHAR | 10 | 0 | IS-H: Short Text for Catalog | ||
12 | DKEY1 | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | ||
13 | DTEXT11 | DIATXT | TEXT40 | CHAR | 40 | 0 | IS-H: Diagnosis Text | ||
14 | DTEXT12 | DIATXT | TEXT40 | CHAR | 40 | 0 | IS-H: Diagnosis Text | ||
15 | DKAT2 | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | ||
16 | KATKB2 | KATKB | TEXT10 | CHAR | 10 | 0 | IS-H: Short Text for Catalog | ||
17 | DKEY2 | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | ||
18 | DTEXT21 | DIATXT | TEXT40 | CHAR | 40 | 0 | IS-H: Diagnosis Text | ||
19 | DTEXT22 | DIATXT | TEXT40 | CHAR | 40 | 0 | IS-H: Diagnosis Text | ||
20 | DIAPE | DIA_PERS | RI_KUNNR | CHAR | 10 | 0 | IS-H: Identification of Diagnosing Person | * | |
21 | EWDIA | KZ_EINWD | XFELD | CHAR | 1 | 0 | IS-H: Referral Diagnosis Indicator | ||
22 | BHDIA | KZ_BEHLD | XFELD | CHAR | 1 | 0 | IS-H: Treatment Diagnosis Indicator | ||
23 | AFDIA | KZ_AUFND | XFELD | CHAR | 1 | 0 | IS-H: Admission Diagnosis Indicator | ||
24 | ENDIA | KZ_ENTLD | XFELD | CHAR | 1 | 0 | IS-H: "Discharge Diagnosis" Indicator | ||
25 | FHDIA | KZ_FAHPD | XFELD | CHAR | 1 | 0 | IS-H: "Department Main Diagnosis" Indicator | ||
26 | KHDIA | KZ_KHHPD | XFELD | CHAR | 1 | 0 | IS-H: Hospital Main Diagnosis Indicator | ||
27 | OPDIA | KZ_OPERD | XFELD | CHAR | 1 | 0 | IS-H: Surgery Diagnosis Indicator | ||
28 | ARDIA | N2_KZARDIA | XFELD | CHAR | 1 | 0 | Working Diagnosis Indicator | ||
29 | PODIA | N2_KZPODIA | XFELD | CHAR | 1 | 0 | Preoperative Diagnosis Indicator | ||
30 | TUDIA | N2_KZTUDIA | XFELD | CHAR | 1 | 0 | IS-H: Cause of Death Indicator | ||
31 | KZTXT | TEXT_DIA | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Diagnosis | ||
32 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
33 | ERTIM | RI_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Record Created | ||
34 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
35 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
36 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
37 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
38 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
39 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
40 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VN1PRDIA | TLNRID | N1PRTLNR | TLNRID | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |