SAP Table N_VPREG_APP
Generated Table for View
N_VPREG_APP (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link N_VPREG_APP to other SAP tables.
N_VPREG_APP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| TMNID | IS-H: Identification of Appointment | ISH_TMNID | CHAR | 10 | 0 | |||||||||||||||
| LNRAPP | IS-H: Sequence Number of Provisional Appointment | ISH_LNRAPP | CHAR | 10 | 0 | |||||||||||||||
| APCNID | IS-H: Identification of an Appointment Template | N1APCNID | CHAR | 32 | 0 | |||||||||||||||
| TMNOE | IS-H: Planned Organizational Unit | ISH_TMNOE | NORG | CHAR | 8 | 0 | ||||||||||||||
| TMNDT | IS-H: Date of Appointment | ISH_TMNDT | DATS | 8 | 0 | |||||||||||||||
| TMNZT | IS-H: Time of Appointment | ISH_TMNZT | TIMS | 6 | 0 | |||||||||||||||
| TMNDR | IS-H: Duration of Appointment | ISH_TMDAUER | NUMC | 4 | 0 | |||||||||||||||
| PTINP | IS-H: Inpatient Scheduling Type | N1PTINP | CHAR | 8 | 0 | |||||||||||||||
| DSPTY | IS-H: Scheduling Type for Visit Scheduling | ISH_DSPT | CHAR | 8 | 0 | |||||||||||||||
| PERNR | IS-H: Person Number | PERNR_FALL | NGPA | CHAR | 10 | 0 | ||||||||||||||
| ZIMMR | IS-H: Building ID of Room | ISH_ZIMMID | NBAU | CHAR | 8 | 0 | ||||||||||||||
| BEWTY | Movement Category | BEWTY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
N_VPREG_APP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| N_VPREG_APP | MANDT | N_VPREG_APP | MANDT | T000 | Clients | MANDT |
| N_VPREG_APP | PERNR | N_VPREG_APP | MANDT | NGPA | IS-H: Business Partners | MANDT |
| N_VPREG_APP | PERNR | N_VPREG_APP | PERNR | NGPA | IS-H: Business Partners | GPART |
| N_VPREG_APP | TMNOE | N_VPREG_APP | MANDT | NORG | IS-H: Organizational Units | MANDT |
| N_VPREG_APP | TMNOE | N_VPREG_APP | TMNOE | NORG | IS-H: Organizational Units | ORGID |
| N_VPREG_APP | ZIMMR | N_VPREG_APP | MANDT | NBAU | IS-H: Building Units | MANDT |
| N_VPREG_APP | ZIMMR | N_VPREG_APP | ZIMMR | NBAU | IS-H: Building Units | BAUID |
