SAP Table TN14B

IS-H: Movement types

TN14B (IS-H: Movement types) 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 TN14B to other SAP tables.

TN14B table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
BEWTY Movement Category BEWTY CHAR 1 0
1 Admission
2 Discharge
3 Transfer
4 Outpatient Visit
6 Absence From
7 Absence To
BWART IS-H: Movement Type RI_BWART CHAR 2 0
TODKZ IS-H: Indicator for Discharge Type "Deceased" TODKZ CHAR 1 0
X Yes
NULL No
NEUGB IS-H: Indicator for Admission Type "Newborn" ISH_BANEUG CHAR 1 0
X Yes
NULL No
BEGLT IS-H: Indicator for Admission Type "Companion" ISH_BABEGL CHAR 1 0
X Yes
NULL No
AUFKH IS-H: Indicator for Admission Type 'From External Hospital' AUFKH_KZ CHAR 1 0
X Yes
NULL No
ENTKH IS-H: Indicator for 'Discharge to External Hospital' ENTKH_KZ CHAR 1 0
X Yes
NULL No
VSTAT IS-H: Indicator for Visit Type "Preadmission" ISH_VSTAT CHAR 1 0
X Yes
NULL No
NSTAT IS-H: Indicator for Visit Type "Postdischarge" ISH_NSTAT CHAR 1 0
X Yes
NULL No
AMBOP IS-H: Indicator for Visit Type "Outpatient Surgery" ISH_AMBOP CHAR 1 0
X Yes
NULL No
OPERA IS-H: Indicator for Admission Type "Surgery" ISH_OPERA CHAR 1 0
X Yes
NULL No
STASP IS-H: Indicator for Admission Type "Statistics Block" ISH_STASP CHAR 1 0
X Yes
NULL No
KV_SP IS-H: Indicator for Visit Type "PPA Block" ISH_KV_SP 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
TSTAT IS-H: Indicator for Admission Type "Day Hospital" ISH_BATSTA CHAR 1 0
X Yes
NULL No
ENTBI IS-H: Indicator for Admission Type "Delivery" ISH_BAENTB CHAR 1 0
X Yes
NULL No
AHWKH IS-H CH: Admission from higher ranking hospital NCH_AUHWKH CHAR 1 0
X Yes
NULL No
AWEHD IS-H CH: Change main diagnoses (admission movement) NCH_AUWEHD CHAR 1 0
X Yes
NULL No
EINPA IS-H CH: Self-discharge NCH_ENINPA CHAR 1 0
X Yes
NULL No
EINDP IS-H CH: Discharge upon third-party initiative NCH_ENINDP CHAR 1 0
X Yes
NULL No
EWEHD IS-H CH: Change of main diagnosis (discharge movement) NCH_ENWEHD CHAR 1 0
X Yes
NULL No
UNQCD IS-H: Unique Code for Assigning External Codes ISH_UNQCD CHAR 3 0
SHORT IS-H: Indicator for Admission Type "Short Treatment" ISH_BASHORT CHAR 1 0
X Yes
NULL No
SEQKZ IS-H: Technical Admission Due To Case Split ISH_SEQUENCE CHAR 1 0
X Yes
NULL No
VIS1 IS-H: Initial Visit Indicator ISH_VIS1 CHAR 1 0
X Yes
NULL No
NOTKZ IS-H: Emergency Case Indicator RI_NOTKZ CHAR 1 0
X Yes
NULL No
SPERRDT IS-H: Block Date From ISH_SPERRAB DATS 8 0
BEGUT NWAT_BEGUT CHAR 1 0
X Yes
NULL No
SPEND NWAT_SPEND CHAR 1 0
X Yes
NULL No
FREMD NWAT_FREMD CHAR 1 0
X Yes
NULL No
DIALY NWAT_DIALY CHAR 1 0
X Yes
NULL No
CHEMO NWAT_CHEMO CHAR 1 0
X Yes
NULL No
AREHA NWAT_AREHA CHAR 1 0
X Yes
NULL No
UNGNENT IS-H: Indicator for Invalid Visit Type after Discharge ISH_UNGNENT CHAR 1 0
X Yes
NULL No
RBPROPOSE IS-H: Clear Room and Bed Assignment ISH_ROOM_BED_PROPOSE CHAR 1 0
X Yes
NULL No
STPAEXT NWAT_SPEXT CHAR 1 0
X Yes
NULL No
INVITRO NWAT_INVIT CHAR 1 0
X Yes
NULL No
BEGLM IS-H: Indicator for Companion Required for Medical Reasons ISH_BABEGL_MED CHAR 1 0
X Yes
NULL No
EXTAUF IS-H: External Order ISH_EO CHAR 1 0
X Yes
NULL No
DAYHO Indicator for Visit Type: Day Hospital ISH_MOV_DAYHO CHAR 1 0
X Yes
NULL No
REHA Indicator for Admission Type: Rehabilitation ISH_MOV_REHA CHAR 1 0
X Yes
NULL No
LONGT Indicator for Admission Type: Long-Stay Patient ISH_MOV_LT CHAR 1 0
X Yes
NULL No
TREXH ISH_MOV_TREXH CHAR 1 0
X Yes
NULL No
/ISHFR/BTR48 IS-H FR: Retransfer After 48 Hours /ISHFR/BTR48 CHAR 1 0
X Yes
NULL No
/ISHFR/RETRO IS-H FR: Pharmacy Sales /ISHFR/RETROCESSION CHAR 1 0
X Yes
NULL No
/ISHFR/MEDSC Medical Subsequent Case /ISHFR/MEDSC CHAR 1 0
X Yes
NULL No
/ISHFR/AUFTRBEH Cross-Institution Treatment /ISHFR/AUFTRBEH CHAR 1 0
X Yes
NULL No
/ISHFR/ACTREAT Transfer to Inpatient Treatment /ISHFR/ACTREAT CHAR 1 0
X Yes
NULL No
ACASCLOP ISH_ACASCLOP CHAR 1 0
X Yes
NULL No
ECASCLOP ISH_ECASCLOP CHAR 1 0
X Yes
NULL No
BEGENDDT Enter Default Start and End Dates for Case ISH_CASE_BEG_END CHAR 1 0
NULL No Default
1 Quarterly Case
2 Sameday Case

TN14B foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TN14B BWGR1 TN14B MANDT TN14G IS-H: Movement Reasons (EDI) MANDT
TN14B BWGR1 TN14B BEWTY TN14G IS-H: Movement Reasons (EDI) BEWTY
TN14B BWGR1 '1' TN14G IS-H: Movement Reasons (EDI) POSIT
TN14B BWGR1 TN14B BWGR1 TN14G IS-H: Movement Reasons (EDI) GRUND
TN14B BWGR2 TN14B BEWTY TN14G IS-H: Movement Reasons (EDI) BEWTY
TN14B BWGR2 '3' TN14G IS-H: Movement Reasons (EDI) POSIT
TN14B BWGR2 TN14B BWGR2 TN14G IS-H: Movement Reasons (EDI) GRUND
TN14B BWGR2 TN14B MANDT TN14G IS-H: Movement Reasons (EDI) MANDT
TN14B EINRI TN14B MANDT TN01 IS-H: Institutions MANDT
TN14B EINRI TN14B EINRI TN01 IS-H: Institutions EINRI
TN14B MANDT TN14B MANDT T000 Clients MANDT