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
1 Inpatient Case
2 Outpatient Case
3 Day Patient Case
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
1 male
2 female
3 unknown
TELF1 IS-H: Patient Telephone Number TELF_PAT CHAR 16 0
TODKZ IS-H: Patient Is Deceased PAT_TOD CHAR 1 0
X Yes
NULL No
SOURC IS-H: Application that Created Object ISH_OBJSRC CHAR 1 0
1 IS-H
2 IS-H*MED
3 IS-H via Internet
TMTAG IS-H: Appointment on Given Day ISH_TMTAG CHAR 1 0
X Yes
NULL No
REFID IS-H: Reference Number of Next Appointment ISH_REFTMNID CHAR 10 0
NOTAN IS-H: Emergency Admission Indicator NOTAUF CHAR 1 0
X Yes
NULL No
KRZAN IS-H: Quick Admission Indicator KURZAUF CHAR 1 0
X Yes
NULL No
BEKAT Treatment Category BEKAT TN24 CHAR 6 0
RISKF IS-H: Risk Information Exists for the Patient ISH_RISIKO CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
1 Written
2 Verbal
3 Written and verbal
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
X Yes
NULL No
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
X Yes
NULL No
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
1 User ID
2 Employee Responsible
EMAIL IS-H: Internet Mail (SMTP) Address ISH_SMTPADR CHAR 241 0
BEWTY Movement Category BEWTY CHAR 1 0
1 Admission
2 Discharge
3 Transfer
4 Outpatient Visit
6 Absence From
7 Absence To
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
1 Minutes
2 Hours
3 Days
CYCLE IS-H: Appointment Cycle ISH_APPCYCLE NUMC 3 0
CYCLEUNIT IS-H: Time Unit for Appointment Cycle ISH_APPCYCLE_UNIT NUMC 1 0
1 Day
2 Week
3 Month
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
1 True
0 False
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