SAP Table NTMN
IS-H: Patient-Specific Appointments (Header Table for NAPP)
NTMN (IS-H: Patient-Specific Appointments (Header Table for NAPP)) 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 NTMN to other SAP tables.
NTMN 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 | |||||||||||||||
EINRI | Institution | EINRI | TN01 | CHAR | 4 | 0 | ||||||||||||||
PATNR | IS-H: Patient Number | PATNR | NPAT | CHAR | 10 | 0 | ||||||||||||||
PZIFF | Check Digit for Patient | PZIFF_PAT | CHAR | 1 | 0 | |||||||||||||||
EXTNR | IS-H: External Patient Identification | EXT_PATNR | CHAR | 20 | 0 | |||||||||||||||
FALNR | IS-H: Case Number | FALNR | NFAL | CHAR | 10 | 0 | ||||||||||||||
FZIFF | Check Digit for Case | PZIFF_FALL | CHAR | 1 | 0 | |||||||||||||||
FALAR | IS-H: Case Type | FALLART | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
TMNLB | IS-H: Sequence Number of Movement | LFDBEW | NBEW | NUMC | 5 | 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 | |||||||||||||||
NNAME | Patient Last Name | NNAME_PAT | CHAR | 30 | 0 | |||||||||||||||
VNAME | IS-H: Patient First Name | VNAME_PAT | CHAR | 30 | 0 | |||||||||||||||
NNAMS | IS-H: Standardized Last Name | NNAMES_PAT | CHAR | 30 | 0 | |||||||||||||||
VNAMS | Standardized First Name | VNAMES_PAT | CHAR | 30 | 0 | |||||||||||||||
TITEL | IS-H: Title | RI_TITEL | CHAR | 15 | 0 | |||||||||||||||
NAMZU | IS-H: Name Affix | RI_NAMZU | CHAR | 15 | 0 | |||||||||||||||
VORSW | IS-H: Name Prefix | RI_VORSW | CHAR | 15 | 0 | |||||||||||||||
GBNAM | IS-H: Birthname | GBNAM | CHAR | 30 | 0 | |||||||||||||||
GBNAS | IS-H: Standardized Birthname | GBNAMS_PAT | CHAR | 30 | 0 | |||||||||||||||
GBDAT | IS-H: Birthdate | RI_GBDAT | DATS | 8 | 0 | |||||||||||||||
GSCHL | IS-H: Sex Indicator - Internal | GSCHL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
TELF1 | IS-H: Patient Telephone Number | TELF_PAT | CHAR | 16 | 0 | |||||||||||||||
TODKZ | IS-H: Patient Is Deceased | PAT_TOD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
SOURC | IS-H: Application that Created Object | ISH_OBJSRC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
TMTAG | IS-H: Appointment on Given Day | ISH_TMTAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
REFID | IS-H: Reference Number of Next Appointment | ISH_REFTMNID | CHAR | 10 | 0 | |||||||||||||||
NOTAN | IS-H: Emergency Admission Indicator | NOTAUF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
KRZAN | IS-H: Quick Admission Indicator | KURZAUF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
BEKAT | Treatment Category | BEKAT | TN24 | CHAR | 6 | 0 | ||||||||||||||
RISKF | IS-H: Risk Information Exists for the Patient | ISH_RISIKO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
CLASS | IS-H: Patient Class | ISH_PAYCL | TNP01 | CHAR | 4 | 0 | ||||||||||||||
BNKZ | IS-H: Notification of Appointment Desired | ISH_APP_NOTI_WANTED | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
BNDT | IS-H: Date on which patient was last notified | ISH_BNDT | DATS | 8 | 0 | |||||||||||||||
BNART | IS-H: Type of Notification (Tel., Written) | ISH_BNART | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
EINBDT | IS-H: Date of Appointment of which Patient Last Notified | ISH_EINBDT | DATS | 8 | 0 | |||||||||||||||
EINBZT | IS-H: Time of Appointment of which Patient Last Notified | ISH_EINBZT | TIMS | 6 | 0 | |||||||||||||||
EINBOE | Nursing Org. Unit of Patient's Last Scheduled Appointment | ISH_EINBOE | CHAR | 8 | 0 | |||||||||||||||
EINBPER | IS-H: Person/Physician of Last Patient Appt Notification | ISH_EINBPER | CHAR | 10 | 0 | |||||||||||||||
EINBZIM | IS-H: Building Unit of Last Patient Notification | ISH_EINBZIM | CHAR | 8 | 0 | |||||||||||||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | 0 | |||||||||||||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | 0 | |||||||||||||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | 0 | |||||||||||||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | 0 | |||||||||||||||
FATYP | Case Category | ISH_CASETYPE | TN15C | CHAR | 2 | 0 | ||||||||||||||
BWART | IS-H: Movement Type | RI_BWART | CHAR | 2 | 0 | |||||||||||||||
TPART | Transport Type | N1TPAE | N1TA | CHAR | 2 | 0 | ||||||||||||||
BWPRIO | Prioritization for Request/Movement (Internal) | N1APRI_D | NUMC | 3 | 0 | |||||||||||||||
MEDTX | Medical Text | N1MEDTX | CHAR | 50 | 0 | |||||||||||||||
TMSTG | Cancellation Reason for an Appointment | ISH_TMSTG | N1STGR | CHAR | 3 | 0 | ||||||||||||||
STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | 0 | |||||||||||||||
STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | 0 | |||||||||||||||
VBUND | ISH_TMVBD | CHAR | 1 | 0 |
Possible values
|
|||||||||||||||
BWGR1 | Movement Reason - 1st and 2nd Positions | ISH_BWGR1 | TN14G | CHAR | 2 | 0 | ||||||||||||||
BWGR2 | Movement Reason - 3rd and 4th Positions | ISH_BWGR2 | TN14G | CHAR | 2 | 0 | ||||||||||||||
UARNR | IS-H: Personnel Number of Referring Physician | UARNR | NGPA | CHAR | 10 | 0 | ||||||||||||||
TMPDT | IS-H: Date Planned for Appointment | ISH_TMPDT | DATS | 8 | 0 | |||||||||||||||
TMPZT | IS-H: Time Planned for Appointment | ISH_TMPZT | TIMS | 6 | 0 | |||||||||||||||
GPLVN | IS-H*MED: Employee or User who Last Planned Appointment | N1GPLVN | CHAR | 12 | 0 | |||||||||||||||
GPLTY | IS-H*MED: Appointment Changed by: Employee/User ID | N1GPLTY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
IS-H: Internet Mail (SMTP) Address | ISH_SMTPADR | CHAR | 241 | 0 | ||||||||||||||||
BEWTY | Movement Category | BEWTY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
CHAINID | IS-H: Link ID for Interdependent Appointments | ISH_APP_CHAINID | CHAR | 10 | 0 | |||||||||||||||
UNITID | IS-H: Treatment Unit ID | ISH_TREATM_UNITID | NUMC | 3 | 0 | |||||||||||||||
DISTMIN | IS-H: Minimum Interval Between Appointments | ISH_APPDIST_MIN | NUMC | 3 | 0 | |||||||||||||||
DISTMAX | IS-H: Maximum Interval Between Appointments | ISH_APPDIST_MAX | NUMC | 3 | 0 | |||||||||||||||
DISTUNIT | IS-H: Time Unit for Interval Between Two Appointments | ISH_APPDIST_UNIT | NUMC | 1 | 0 |
Possible values
|
||||||||||||||
CYCLE | IS-H: Appointment Cycle | ISH_APPCYCLE | NUMC | 3 | 0 | |||||||||||||||
CYCLEUNIT | IS-H: Time Unit for Appointment Cycle | ISH_APPCYCLE_UNIT | NUMC | 1 | 0 |
Possible values
|
||||||||||||||
VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | N1VKGID | NUMC | 8 | 0 | |||||||||||||||
PAPID | IS-H: Provisional Patient Number | ISH_PAPID | NPAP | CHAR | 10 | 0 | ||||||||||||||
APCNID | IS-H: Identification of an Appointment Template | N1APCNID | CHAR | 32 | 0 | |||||||||||||||
ENDPL | IS-H: Planning Complete | N1ENDPL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
TIMESTAMP | Timestamp in Short Form (YYYYMMDDhhmmss) | ISH_TIMESTAMP | DEC | 15 | 0 | |||||||||||||||
CAUSECHNG | Reason for Change | N1CAUSECHNG | CHAR | 50 | 0 | |||||||||||||||
CSECHGID | Reason for Change ID | N1CSECHGID | NUMC | 3 | 0 |
NTMN foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
NTMN | BEKAT | NTMN | EINRI | TN24 | IS-H: Treatment Categories | EINRI |
NTMN | BEKAT | NTMN | BEKAT | TN24 | IS-H: Treatment Categories | BEKAT |
NTMN | BEKAT | NTMN | MANDT | TN24 | IS-H: Treatment Categories | MANDT |
NTMN | BWGR1 | '4' | TN14G | IS-H: Movement Reasons (EDI) | BEWTY | |
NTMN | BWGR1 | '1' | TN14G | IS-H: Movement Reasons (EDI) | POSIT | |
NTMN | BWGR1 | NTMN | BWGR1 | TN14G | IS-H: Movement Reasons (EDI) | GRUND |
NTMN | BWGR1 | NTMN | MANDT | TN14G | IS-H: Movement Reasons (EDI) | MANDT |
NTMN | BWGR2 | '3' | TN14G | IS-H: Movement Reasons (EDI) | POSIT | |
NTMN | BWGR2 | NTMN | BWGR2 | TN14G | IS-H: Movement Reasons (EDI) | GRUND |
NTMN | BWGR2 | NTMN | MANDT | TN14G | IS-H: Movement Reasons (EDI) | MANDT |
NTMN | BWGR2 | '4' | TN14G | IS-H: Movement Reasons (EDI) | BEWTY | |
NTMN | CLASS | NTMN | MANDT | TNP01 | IS-H: Patient Classes | MANDT |
NTMN | CLASS | NTMN | EINRI | TNP01 | IS-H: Patient Classes | EINRI |
NTMN | CLASS | NTMN | CLASS | TNP01 | IS-H: Patient Classes | CLASS |
NTMN | EINRI | NTMN | MANDT | TN01 | IS-H: Institutions | MANDT |
NTMN | EINRI | NTMN | EINRI | TN01 | IS-H: Institutions | EINRI |
NTMN | FALNR | NTMN | MANDT | NFAL | IS-H: Cases | MANDT |
NTMN | FALNR | NTMN | EINRI | NFAL | IS-H: Cases | EINRI |
NTMN | FALNR | NTMN | FALNR | NFAL | IS-H: Cases | FALNR |
NTMN | FATYP | NTMN | MANDT | TN15C | IS-H: Case Category | MANDT |
NTMN | FATYP | NTMN | EINRI | TN15C | IS-H: Case Category | EINRI |
NTMN | FATYP | NTMN | FATYP | TN15C | IS-H: Case Category | CASETY |
NTMN | MANDT | NTMN | MANDT | T000 | Clients | MANDT |
NTMN | PAPID | NTMN | MANDT | NPAP | IS-H: Provisional Patient Master Data | MANDT |
NTMN | PAPID | NTMN | PAPID | NPAP | IS-H: Provisional Patient Master Data | PAPID |
NTMN | PATNR | NTMN | PATNR | NPAT | IS-H: Patient Master Data (General) | PATNR |
NTMN | PATNR | NTMN | MANDT | NPAT | IS-H: Patient Master Data (General) | MANDT |
NTMN | TMNLB | NTMN | TMNLB | NBEW | IS-H: Movements for Case | LFDNR |
NTMN | TMNLB | NTMN | MANDT | NBEW | IS-H: Movements for Case | MANDT |
NTMN | TMNLB | NTMN | EINRI | NBEW | IS-H: Movements for Case | EINRI |
NTMN | TMNLB | NTMN | FALNR | NBEW | IS-H: Movements for Case | FALNR |
NTMN | TMNOE | NTMN | MANDT | NORG | IS-H: Organizational Units | MANDT |
NTMN | TMNOE | NTMN | TMNOE | NORG | IS-H: Organizational Units | ORGID |
NTMN | TMSTG | NTMN | MANDT | N1STGR | IS-H: Cancellation Reasons | MANDT |
NTMN | TMSTG | NTMN | EINRI | N1STGR | IS-H: Cancellation Reasons | EINRI |
NTMN | TMSTG | NTMN | TMSTG | N1STGR | IS-H: Cancellation Reasons | STOID |
NTMN | TPART | NTMN | EINRI | N1TA | IS-H*MED: Transport Types | EINRI |
NTMN | TPART | NTMN | TPART | N1TA | IS-H*MED: Transport Types | TPAE |
NTMN | TPART | NTMN | MANDT | N1TA | IS-H*MED: Transport Types | MANDT |
NTMN | UARNR | NTMN | UARNR | NGPA | IS-H: Business Partners | GPART |
NTMN | UARNR | NTMN | MANDT | NGPA | IS-H: Business Partners | MANDT |