SAP ABAP Table VN1PRLEM (IS-H*MED: PATREG: Verbucher Struktur für N1PRLEM)
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 | VN1PRLEM | Table Relationship Diagram |
Short Description | IS-H*MED: PATREG: Verbucher Struktur für N1PRLEM |
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: Leistungen | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | TLNRID | N1PRTLNRID | N1PRTLNRID | CHAR | 10 | 0 | PATREG: Teilnehmer ID | N1PRTLNR | |
4 | LNRLS | LNRLS | LNRLS | CHAR | 10 | 0 | IS-H: Service Sequence Number | ||
5 | ORGID | ORGID_LS | ORGID | CHAR | 8 | 0 | IS-H: Org. Unit (for OU-Related Service Entry Only) | * | |
6 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | N1PRPATZUO | |
7 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | N1PRFAL | |
8 | LEIST | TARLS | TARLS | CHAR | 10 | 0 | IS-H: Service in Service Catalog | * | |
9 | ANFOE | ANFOE | ORGID | CHAR | 8 | 0 | IS-H: Departmental Org. Unit Requesting Service | * | |
10 | ANFON | ORGKB | TEXT12 | CHAR | 12 | 0 | IS-H: Organizational Unit Short Text | ||
11 | ERBOE | ERBOE | ORGID | CHAR | 8 | 0 | IS-H: Organizational Unit that Performs the Service | * | |
12 | ERBON | ORGKB | TEXT12 | CHAR | 12 | 0 | IS-H: Organizational Unit Short Text | ||
13 | HAUST | TARID | TARID | CHAR | 2 | 0 | IS-H: Service Catalog Identification Key | * | |
14 | IMENG | I_MENG_LS | LEISMENGE | NUMC | 4 | 0 | Service Quantity | ||
15 | IBGDT | I_BDT_LS | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Service Performance Starts (Actual) | ||
16 | IENDT | I_EDT_LS | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Service Performance Ends (Actual) | ||
17 | IBZT | I_BZT_LS | UHRZT | TIMS | 6 | 0 | IS-H: Time when Service Performance Starts (Actual) | ||
18 | IEZT | I_EZT_LS | UHRZT | TIMS | 6 | 0 | IS-H: Time Service Performance Ends (Actual) | ||
19 | PMENG | P_MENG_LS | LEISMENGE | NUMC | 4 | 0 | IS-H: Service Quantity (Planned) | ||
20 | PBGDT | P_BDT_LS | RI_DATUM | DATS | 8 | 0 | IS-H: Start Date of Service Performance (PLANNED) | ||
21 | PENDT | P_EDT_LS | RI_DATUM | DATS | 8 | 0 | IS-H: Date Service Performance Ends (PLANNED) | ||
22 | PBZT | P_BZT_LS | UHRZT | TIMS | 6 | 0 | IS-H: Time Service Performance Starts (PLANNED) | ||
23 | PEZT | P_EZT_LS | UHRZT | TIMS | 6 | 0 | IS-H: Time Service Performance Ends (PLANNED) | ||
24 | LEITX | TEXT_LEI | LEIKTXT | CHAR | 40 | 0 | IS-H: Service Short Text (may Differ from Service Master) | ||
25 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
26 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
27 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
28 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
29 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
30 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
31 | REMRK | ISH_REMRK | ISH_REMRK | CHAR | 40 | 0 | IS-H: User's Comment on Service | ||
32 | ANPOE | ANPOE | ORGID | CHAR | 8 | 0 | IS-H: Nursing Org. Unit Requesting Service | * | |
33 | ANPON | ORGKB | TEXT12 | CHAR | 12 | 0 | IS-H: Organizational Unit Short Text | ||
34 | OTYPL | ISH_OTYPL | ISH_OTYPL | CHAR | 1 | 0 | IS-H: Object Type of Service | ||
35 | STOID | N1STOID | N1STOID | CHAR | 3 | 0 | Reason for Canceling Medical Object | * | |
36 | STOTX | N1STOTX | N1C015 | CHAR | 15 | 0 | Text for Cancellation Reason | ||
37 | LSSTAE | N1LSSTAE | N1LSSTAE | CHAR | 3 | 0 | Service Status - User-Specific | * | |
38 | LSSTA | N1LSSTA_D | N1LSSTA | CHAR | 3 | 0 | Service Status | ||
39 | LSTTX | N1LSSTTXT | N1C010 | CHAR | 10 | 0 | Service Status Text | ||
40 | ANFID | ANFID | ANFID | NUMC | 8 | 0 | Identification of a Request (Number) | * | |
41 | NTRKZ | NTRKZ | XFELD | CHAR | 1 | 0 | Indicator for Subsequently Added Service | ||
42 | WBGDT | W_BDT_LS | RI_DATUM | DATS | 8 | 0 | Desired Start Date of a Service | ||
43 | WBGZT | W_BZT_LS | UHRZT | TIMS | 6 | 0 | Desired Start Time of a Service | ||
44 | ERGTX | N1ERGTX | TEXT50 | CHAR | 50 | 0 | Supplementary Text | ||
45 | ERLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
46 | WBZPI | N1ZPI_INT | N1ZPI_INT | CHAR | 2 | 0 | Time Interpretation - Internal Format | ||
47 | WBZPE | N1ZPIE | N1ZPIE | CHAR | 5 | 0 | Time Interpretation - External Format | ||
48 | WBZTX | N1ZPITXT | N1ZPITXT | CHAR | 30 | 0 | Text for Time Interpretation | ||
49 | DAUER | ISH_APTIME | ISH_DZEIT | NUMC | 4 | 0 | IS-H: Duration in Minutes for Treatment Appointment | ||
50 | ZIMMR | ISH_ZIMMID | BAUID | CHAR | 8 | 0 | IS-H: Building ID of Room | * | |
51 | IFG | N1IFG_INT | NUMC2 | NUMC | 2 | 0 | Degree of Infection - Internal Format | ||
52 | IFGTX | N1IFGTXT | N1IFGTXT | CHAR | 15 | 0 | Description of Degree of Infection | ||
53 | ANERF | N1ANERF | XFELD | CHAR | 1 | 0 | Anesthetist Required | ||
54 | LSLOK | N1LSLOK | N2_DIALO | CHAR | 2 | 0 | Localization of Service | * | |
55 | PATEIN | N1PATEIN | N1PATEIN1 | CHAR | 1 | 0 | Patient Consent | ||
56 | PMEDFG | N1PMEDFG | XFELD | CHAR | 1 | 0 | Surgeon's Release | ||
57 | PMEDVS | N1PMEDVS | XFELD | CHAR | 1 | 0 | Premedication Complete | ||
58 | ANKLS | N1ANKLS | N1ANKLS | CHAR | 1 | 0 | Anchor Service Indicator | ||
59 | N1MEDLEI | N1MEDLEI | XFELD | CHAR | 1 | 0 | Medical Service Indicator | ||
60 | N1PFLLEI | N1PFLLEI | XFELD | CHAR | 1 | 0 | Nursing Service Indicator | ||
61 | DOCXS | RI_MARK | XFELD | CHAR | 1 | 0 | IS-H: Checkbox to Select a Row | ||
62 | TEAMXS | RI_MARK | XFELD | CHAR | 1 | 0 | IS-H: Checkbox to Select a Row | ||
63 | MATXS | RI_MARK | XFELD | CHAR | 1 | 0 | IS-H: Checkbox to Select a Row | ||
64 | PATNUE | N1PATNUE | XFELD | CHAR | 1 | 0 | Patient Fasting Indicator | ||
65 | LIDI | N1LID_INT | NUM3 | NUMC | 3 | 0 | Position ID Internal | ||
66 | LGRTX | N2_LAGERUN | N2_LAGERUN | CHAR | 50 | 0 | List of Position Types | ||
67 | VKGID | N1VKGID | N1VKGID | NUMC | 8 | 0 | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | ||
68 | TMNID | ISH_TMNID | ISH_LNRAPP | CHAR | 10 | 0 | IS-H: Identification of Appointment | ||
69 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
70 | 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 | VN1PRLEM | FALNR | N1PRFAL | FALNR | KEY | 1 | CN |
2 | VN1PRLEM | MANDT | T000 | MANDT | KEY | 1 | CN |
3 | VN1PRLEM | PATNR | N1PRPATZUO | PATNR | REF | C | CN |
4 | VN1PRLEM | TLNRID | N1PRTLNR | TLNRID | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |