1. Home
  2. Resources
  3. SAP Tables
  4. N1FAT - IS-H*MED: Transport Orders

SAP Table N1FAT

IS-H*MED: Transport Orders

N1FAT (IS-H*MED: Transport Orders) 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 N1FAT to other SAP tables.

N1FAT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FATID ID of the Transport Order N1FATID NUMC 8 0
EINRI Institution EINRI TN01 CHAR 4 0
PATNR IS-H: Patient Number PATNR NPAT CHAR 10 0
FHRID ID of Transporter N1FHRID NGPA CHAR 10 0
FSTID Transport Order Status (Internal Display) N1FSTID N1FST NUMC 2 0
ORGFD OU of the Patient Transport Service N1ORGFD NORG CHAR 8 0
TMNAG IS-H: Identification of Appointment ISH_TMNID NTMN CHAR 10 0
ORGAG Pick-Up OU (OU where Pick-Up Takes Place) N1ORGAG NORG CHAR 8 0
BAUAG Pick-up Room for a Transport Order N1BAUAG NBAU CHAR 8 0
DATAG Pick-Up Date for the Transport Order N1DATAG DATS 8 0
UZTAG Pick-Up Time for Transport Order N1UZTAG TIMS 6 0
TMNZL IS-H: Identification of Appointment ISH_TMNID NTMN CHAR 10 0
ORGZL Destination Org. Unit (Drop-Off) for Transport Order N1ORGZL NORG CHAR 8 0
BAUZL Destination (Drop-off) Room for a Transport Order N1BAUZL NBAU CHAR 8 0
DATZL Destination (Drop-Off) Date of a Transport Order N1DATZL DATS 8 0
UZTZL Drop-Off Time of Transport Order N1UZTZL TIMS 6 0
TPTYP Transport Category N1TPTYP NUMC 1 0
1 Initial Transport
2 Return Transport
3 Further Transport
TPAE Transport Type N1TPAE N1TA CHAR 2 0
TPPRI Priority of a Transport Order N1TPPRI NUMC 3 0
REMRK Comment for the Transport Order N1REMRK CHAR 50 0
RELTX Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
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
STOID Cancellation Reason for Patient Transport Service N1STOID_FAT N1STGR CHAR 3 0
BNRET Return Code Messaging N1BNRET CHAR 10 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
PAPID IS-H: Provisional Patient Number ISH_PAPID NPAP CHAR 10 0
FHRID2 ID of Transporter N1FHRID CHAR 10 0
FHRID3 ID of Transporter N1FHRID CHAR 10 0
ERTIM IS-H: Time Record Created RI_ERTIM TIMS 6 0
UPTIM IS-H: Time of Last Change RI_UPTIM TIMS 6 0
TRANS Means of Transport N1TRANSP N1TRANS CHAR 3 0
TRAVA Means of Transport Is Available N1TRANSP_AVAILABLE CHAR 1 0
X Yes
NULL No

N1FAT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
N1FAT BAUAG N1FAT MANDT NBAU IS-H: Building Units MANDT
N1FAT BAUAG N1FAT BAUAG NBAU IS-H: Building Units BAUID
N1FAT BAUZL N1FAT BAUZL NBAU IS-H: Building Units BAUID
N1FAT BAUZL N1FAT MANDT NBAU IS-H: Building Units MANDT
N1FAT EINRI N1FAT MANDT TN01 IS-H: Institutions MANDT
N1FAT EINRI N1FAT EINRI TN01 IS-H: Institutions EINRI
N1FAT FHRID N1FAT MANDT NGPA IS-H: Business Partners MANDT
N1FAT FHRID N1FAT FHRID NGPA IS-H: Business Partners GPART
N1FAT FSTID N1FAT MANDT N1FST IS-H*MED: Transport Orders - Status MANDT
N1FAT FSTID N1FAT FSTID N1FST IS-H*MED: Transport Orders - Status FSTID
N1FAT MANDT N1FAT MANDT T000 Clients MANDT
N1FAT ORGAG N1FAT MANDT NORG IS-H: Organizational Units MANDT
N1FAT ORGAG N1FAT ORGAG NORG IS-H: Organizational Units ORGID
N1FAT ORGFD N1FAT MANDT NORG IS-H: Organizational Units MANDT
N1FAT ORGFD N1FAT ORGFD NORG IS-H: Organizational Units ORGID
N1FAT ORGZL N1FAT MANDT NORG IS-H: Organizational Units MANDT
N1FAT ORGZL N1FAT ORGZL NORG IS-H: Organizational Units ORGID
N1FAT PAPID N1FAT PAPID NPAP IS-H: Provisional Patient Master Data PAPID
N1FAT PAPID N1FAT MANDT NPAP IS-H: Provisional Patient Master Data MANDT
N1FAT PATNR N1FAT MANDT NPAT IS-H: Patient Master Data (General) MANDT
N1FAT PATNR N1FAT PATNR NPAT IS-H: Patient Master Data (General) PATNR
N1FAT STOID N1FAT EINRI N1STGR IS-H: Cancellation Reasons EINRI
N1FAT STOID N1FAT STOID N1STGR IS-H: Cancellation Reasons STOID
N1FAT STOID N1FAT MANDT N1STGR IS-H: Cancellation Reasons MANDT
N1FAT TMNAG N1FAT MANDT NTMN IS-H: Patient-Specific Appointments (Header Table for NAPP) MANDT
N1FAT TMNAG N1FAT TMNAG NTMN IS-H: Patient-Specific Appointments (Header Table for NAPP) TMNID
N1FAT TMNZL N1FAT TMNZL NTMN IS-H: Patient-Specific Appointments (Header Table for NAPP) TMNID
N1FAT TMNZL N1FAT MANDT NTMN IS-H: Patient-Specific Appointments (Header Table for NAPP) MANDT
N1FAT TPAE N1FAT MANDT N1TA IS-H*MED: Transport Types MANDT
N1FAT TPAE N1FAT EINRI N1TA IS-H*MED: Transport Types EINRI
N1FAT TPAE N1FAT TPAE N1TA IS-H*MED: Transport Types TPAE
N1FAT TRANS N1FAT MANDT N1TRANS i.s.h.med: Transport Medium MANDT
N1FAT TRANS N1FAT EINRI N1TRANS i.s.h.med: Transport Medium EINRI
N1FAT TRANS N1FAT TRANS N1TRANS i.s.h.med: Transport Medium TRANS