SAP ABAP Table N_VNAPP_NPAT (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | N_VNAPP_NPAT | 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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LNRAPP | ISH_LNRAPP | ISH_LNRAPP | CHAR | 10 | 0 | IS-H: Sequence Number of Provisional Appointment | ||
3 | TMNID | ISH_TMNID | ISH_LNRAPP | CHAR | 10 | 0 | IS-H: Identification of Appointment | NTMN | |
4 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | NPAT | |
5 | PZIFF | PZIFF_PAT | PZIFF | CHAR | 1 | 0 | IS-H: Check Digit for Patient | ||
6 | EXTNR | EXT_PATNR | EXT_PATNR | CHAR | 20 | 0 | IS-H: External Patient Identification | ||
7 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
8 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
9 | FZIFF | PZIFF_FALL | PZIFF | CHAR | 1 | 0 | IS-H: Check Digit for Case | ||
10 | FALAR | FALLART | FALLART | CHAR | 1 | 0 | IS-H: Case Type | ||
11 | TMNLB | LFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Sequence Number of Movement | NBEW | |
12 | TMNOE | ISH_TMNOE | ORGID | CHAR | 8 | 0 | IS-H: Planned Organizational Unit | NORG | |
13 | TMNDT | ISH_TMNDT | DATE | DATS | 8 | 0 | IS-H: Date of Appointment | ||
14 | TMNZT | ISH_TMNZT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Appointment | ||
15 | TMNDR | ISH_TMDAUER | ISH_DZEIT | NUMC | 4 | 0 | IS-H: Duration of Appointment | ||
16 | SOURC | ISH_OBJSRC | ISH_OBJSRC | CHAR | 1 | 0 | IS-H: Application that Created Object | ||
17 | TMTAG | ISH_TMTAG | XFELD | CHAR | 1 | 0 | IS-H: Appointment on Given Day | ||
18 | REFID | ISH_REFTMNID | ISH_LNRAPP | CHAR | 10 | 0 | IS-H: Reference Number of Next Appointment | ||
19 | NOTAN | NOTAUF | XFELD | CHAR | 1 | 0 | IS-H: Emergency Admission Indicator | ||
20 | KRZAN | KURZAUF | XFELD | CHAR | 1 | 0 | IS-H: Quick Admission Indicator | ||
21 | BEKAT | BEKAT | BEHKATEG | CHAR | 6 | 0 | Treatment Category | TN24 | |
22 | CLASS | ISH_PAYCL | ISH_PAYCL | CHAR | 4 | 0 | IS-H: Patient Class | TNP01 | |
23 | BNKZ | ISH_APP_NOTI_WANTED | XFELD | CHAR | 1 | 0 | IS-H: Notification of Appointment Desired | ||
24 | BNDT | ISH_BNDT | RI_DATUM | DATS | 8 | 0 | IS-H: Date on which patient was last notified | ||
25 | BNART | ISH_BNART | KOMMART | CHAR | 1 | 0 | IS-H: Type of Notification (Tel., Written) | ||
26 | EINBDT | ISH_EINBDT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Appointment of which Patient Last Notified | ||
27 | EINBZT | ISH_EINBZT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Appointment of which Patient Last Notified | ||
28 | EINBOE | ISH_EINBOE | ORGID | CHAR | 8 | 0 | Nursing Org. Unit of Patient's Last Scheduled Appointment | ||
29 | EINBPER | ISH_EINBPER | RI_KUNNR | CHAR | 10 | 0 | IS-H: Person/Physician of Last Patient Appt Notification | ||
30 | EINBZIM | ISH_EINBZIM | BAUID | CHAR | 8 | 0 | IS-H: Building Unit of Last Patient Notification | ||
31 | BWART | RI_BWART | RI_BWART | CHAR | 2 | 0 | IS-H: Movement Type | ||
32 | TPART | N1TPAE | N1TPAE | CHAR | 2 | 0 | Transport Type | N1TA | |
33 | BWPRIO | N1APRI_D | N1APRI | NUMC | 3 | 0 | Prioritization for Request/Movement (Internal) | ||
34 | MEDTX | N1MEDTX | N1C050 | CHAR | 50 | 0 | Medical Text | ||
35 | TMSTG | ISH_TMSTG | N1STOID | CHAR | 3 | 0 | Cancellation Reason for an Appointment | N1STGR | |
36 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
37 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
38 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
39 | VBUND | ISH_TMVBD | XFELD | CHAR | 1 | 0 | Termin verbundrelevant | ||
40 | BWGR1 | ISH_BWGR1 | ISH_BGRUND | CHAR | 2 | 0 | Movement Reason - 1st and 2nd Positions | TN14G | |
41 | BWGR2 | ISH_BWGR2 | ISH_BGRUND | CHAR | 2 | 0 | Movement Reason - 3rd and 4th Positions | TN14G | |
42 | UARNR | UARNR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Personnel Number of Referring Physician | NGPA | |
43 | TMPDT | ISH_TMPDT | DATE | DATS | 8 | 0 | IS-H: Date Planned for Appointment | ||
44 | TMPZT | ISH_TMPZT | UHRZT | TIMS | 6 | 0 | IS-H: Time Planned for Appointment | ||
45 | GPLVN | N1GPLVN | USNAM | CHAR | 12 | 0 | IS-H*MED: Employee or User who Last Planned Appointment | ||
46 | GPLTY | N1GPLTY | N1GPLTY | CHAR | 1 | 0 | IS-H*MED: Appointment Changed by: Employee/User ID | ||
47 | BEWTY | BEWTY | BEWTY | CHAR | 1 | 0 | IS-H: Movement Category | ||
48 | CHAINID | ISH_APP_CHAINID | ISH_LNRAPP | CHAR | 10 | 0 | IS-H: Link ID for Interdependent Appointments | ||
49 | UNITID | ISH_TREATM_UNITID | NUMC03 | NUMC | 3 | 0 | IS-H: Treatment Unit ID | ||
50 | DISTMIN | ISH_APPDIST_MIN | ISH_APPDIST | NUMC | 3 | 0 | IS-H: Minimum Interval Between Appointments | ||
51 | DISTMAX | ISH_APPDIST_MAX | ISH_APPDIST | NUMC | 3 | 0 | IS-H: Maximum Interval Between Appointments | ||
52 | DISTUNIT | ISH_APPDIST_UNIT | ISH_APPDIST_UNIT | NUMC | 1 | 0 | IS-H: Time Unit for Interval Between Two Appointments | ||
53 | CYCLE | ISH_APPCYCLE | NUMC03 | NUMC | 3 | 0 | IS-H: Appointment Cycle | ||
54 | CYCLEUNIT | ISH_APPCYCLE_UNIT | ISH_APPCYCLE_UNIT | NUMC | 1 | 0 | IS-H: Time Unit for Appointment Cycle | ||
55 | VKGID | N1VKGID | N1VKGID | NUMC | 8 | 0 | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | ||
56 | PAPID | ISH_PAPID | ISH_PAPID | CHAR | 10 | 0 | IS-H: Provisional Patient Number | NPAP | |
57 | ENDPL | N1ENDPL | ISH_TRUE_FALSE | CHAR | 1 | 0 | IS-H: Planning Complete | ||
58 | LFDNR | LFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Sequence Number of Movement | ||
59 | DSPTY | ISH_DSPT | ISH_DSPTC8 | CHAR | 8 | 0 | IS-H: Scheduling Type for Visit Scheduling | ||
60 | PTINP | N1PTINP | ISH_DSPTC8 | CHAR | 8 | 0 | IS-H: Inpatient Scheduling Type | ||
61 | VISTY | ISH_BT | ISH_BT | CHAR | 1 | 0 | IS-H: Code of Visit Category for Visit Scheduling | ||
62 | BWIDT | BWIDT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Movement | ||
63 | BWIZT | BWIZT | UHRZT | TIMS | 6 | 0 | IS-H: Time of Movement | ||
64 | STATU | ISH_ABSTIN | ISH_ABSTIN | CHAR | 2 | 0 | IS-H: Internal Status of Outpatient Visit | ||
65 | STATUS | ISH_ABSTIN | ISH_ABSTIN | CHAR | 2 | 0 | IS-H: Internal Status of Outpatient Visit | ||
66 | ORGFA | NZUWFA | ORGID | CHAR | 8 | 0 | IS-H: OU with Departmental Responsibility for Case | NORG | |
67 | ORGPF | NZUWPF | ORGID | CHAR | 8 | 0 | Organizational Unit Assigned to Case | NORG | |
68 | POBNR | ISH_POBNR | ISH_POBNR | NUMC | 10 | 0 | IS-H: Internal Sequence Number of Planning Object | NPOB | |
69 | PERNR | PERNR_FALL | RI_KUNNR | CHAR | 10 | 0 | IS-H: Person Number | NGPA | |
70 | ZIMMR | ISH_ZIMMID | BAUID | CHAR | 8 | 0 | IS-H: Building ID of Room | NBAU | |
71 | KZTXT | TEXT_BEW | TEXT50 | CHAR | 50 | 0 | Comment on Case Movement | ||
72 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
73 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
74 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
75 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
76 | LGTXT | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
77 | DAUER | ISH_APTIME | ISH_DZEIT | NUMC | 4 | 0 | IS-H: Duration in Minutes for Treatment Appointment | ||
78 | FACHR | FACHRTY5 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Physician Specialty | TNKFA | |
79 | PELOC | ISH_PELOC | RI_KUNNR | CHAR | 10 | 0 | IS-H: Person Being Substituted | ||
80 | STOID | N1BSTOID | N1STOID | CHAR | 3 | 0 | IS-H: Reason for Canceling Movement | ||
81 | GSCHL | GSCHL | GSCHL | CHAR | 1 | 0 | IS-H: Sex Indicator - Internal | ||
82 | NNAME | NNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Last Name | ||
83 | NNAMS | NNAMES_PAT | CHAR30 | CHAR | 30 | 0 | IS-H: Standardized Last Name | ||
84 | VNAME | VNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient First Name | ||
85 | VNAMS | VNAMES_PAT | CHAR30 | CHAR | 30 | 0 | Standardized First Name | ||
86 | TITEL | RI_TITEL | TITEL | CHAR | 15 | 0 | IS-H: Title | ||
87 | NAMZU | RI_NAMZU | TITEL | CHAR | 15 | 0 | IS-H: Name Affix | ||
88 | VORSW | RI_VORSW | TITEL | CHAR | 15 | 0 | IS-H: Name Prefix | ||
89 | GBDAT | RI_GBDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Birthdate | ||
90 | GBNAM | GBNAM | TEXT30 | CHAR | 30 | 0 | IS-H: Birthname | ||
91 | GBNAS | GBNAMS_PAT | CHAR30 | CHAR | 30 | 0 | IS-H: Standardized Birthname | ||
92 | TODKZ | PAT_TOD | XFELD | CHAR | 1 | 0 | IS-H: Patient Is Deceased | ||
93 | RISKF | ISH_RISIKO | XFELD | CHAR | 1 | 0 | IS-H: Risk Information Exists for the Patient | ||
94 | TELF1 | TELF_PAT | TEXT16 | CHAR | 16 | 0 | IS-H: Patient Telephone Number | ||
95 | ISH_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | IS-H: Internet Mail (SMTP) Address | |||
96 | ADRNR | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | NADR | |
97 | ADROB | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |