1. Home
  2. Resources
  3. SAP Tables
  4. RNPFB - IS-H: Movement Lists

SAP Table RNPFB

IS-H: Movement Lists

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

RNPFB table fields

Field Data element Checktable Datatype Length Decimals
MARK IS-H: Checkbox to Select a Row RI_MARK CHAR 1 0
X Yes
NULL No
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
PATNR IS-H: Patient Number PATNR CHAR 10 0
PZIFF Check Digit for Patient PZIFF_PAT CHAR 1 0
EXTNR IS-H: External Patient Identification EXT_PATNR CHAR 20 0
PNAME IS-H: Patient's Name ISH_PNAM40 CHAR 40 0
NNAMS IS-H: Standardized Last Name NNAMES_PAT CHAR 30 0
VNAMS Standardized First Name VNAMES_PAT CHAR 30 0
GBDAT IS-H: Birthdate RI_GBDAT DATS 8 0
GSCHL IS-H: Sex Indicator - User-Specific GSCHLE TN17G CHAR 1 0
GSTXT IS-H: Sex Specification - User-Specific TEXT_GES CHAR 10 0
LAND IS-H: Country ISH_LAND CHAR 3 0
PSTLZ IS-H: Patient Postal Code PSTLZ_PAT CHAR 10 0
ORT IS-H: City where Patient Resides ISH_PATORT CHAR 40 0
ORT2 IS-H: District of patient's place of residence ISH_PATOTT CHAR 40 0
STRAS IS-H: Patient Street and House Number ISH_PATSTR CHAR 40 0
TELNR IS-H: Patient's telephone number ISH_PATTEL CHAR 30 0
ADRES IS-H: Patient address ISH_PADRES CHAR 50 0
FALNR IS-H: Case Number FALNR NFAL CHAR 10 0
FZIFF Check Digit for Case PZIFF_FALL CHAR 1 0
FALAE IS-H: Case Type - User-Specific FALLARTE TN15A CHAR 1 0
FATXT IS-H: Text for Case Type TEXT_FAA CHAR 14 0
FOREI IS-H: Foreign Case ISH_FOREIG CHAR 1 0
X Yes
NULL No
RESID Indicator That Patient Is Non-Resident ISH_RESID CHAR 1 0
X Yes
NULL No
CHILD IS-H: Number of Children ISH_CHILD CHAR 2 0
FACHR Specialty for Organizational Unit FACHRTY7 CHAR 4 0
FTYTX IS-H: Name of Specialty TEXT_KFA CHAR 30 0
ENDTYP IS-H: Type of Case End ISH_CASEEND CHAR 2 0
LFDNR IS-H: Sequence Number of Movement LFDBEW NBEW NUMC 5 0
AUFDT IS-H: Date of Admission ISH_AUFNDT DATS 8 0
AUFZT IS-H: Time of Admission ISH_AUFNZT TIMS 6 0
PLANA IS-H: Admission Status ISH_AUFNPL CHAR 1 0
NULL Actual
P Planned
W Waiting List
AUFAR IS-H: Admission Type ISH_AUFART TN14B CHAR 2 0
AUFAX IS-H: Text for Admission Type ISH_AUFATX CHAR 15 0
AUFOF IS-H: Admitting departmental organizational unit ISH_AUFOEF CHAR 8 0
AUKOF IS-H: Short text of admitting departmental org. unit ISH_AUFOKF CHAR 12 0
AUFOP IS-H: Admitting nursing organizational unit ISH_AUFOEP CHAR 8 0
AUKOP IS-H: Short text of admitting nursing org. unit ISH_AUFOKP CHAR 12 0
AUFZI IS-H: Admission room ISH_AUFZIM NBAU CHAR 8 0
AUFZK IS-H: Identifier of admission room ISH_AUFZIK CHAR 8 0
AUFZKB ID of Admission Room ISH_AUFZIKB CHAR 12 0
AUFBE IS-H: Admission bed ISH_AUFBET NBAU CHAR 8 0
AUFBK IS-H: Identifier of bed to which patient is admitted ISH_AUFBEK CHAR 8 0
AUFBKB ID of Admission Bed ISH_AUFBEKB CHAR 12 0
AUFOK IS-H: Short Text for Admitting Facility ISH_AUFNOK CHAR 12 0
AUFBEKAT IS-H: Treatment Category of Admission Movement ISH_AUFBEKAT CHAR 6 0
AUFKZ IS-H: Quick Admission Indicator KURZAUF CHAR 1 0
X Yes
NULL No
AUFNZ IS-H: Emergency Admission Indicator NOTAUF CHAR 1 0
X Yes
NULL No
IDBKZ IS-H: Inter-Departmental Bed Assignment ISH_IDBKZ CHAR 1 0
AUKTX IS-H: Comment on admission ISH_AUKTX CHAR 50 0
WLPRI IS-H: Priority for Preregistration/Waiting List Management WLPRI CHAR 2 0
PRTXT IS-H: Text for Priority ISH_PRITXT CHAR 15 0
WLTYP IS-H: Waiting List ISH_WLTYPE CHAR 6 0
WLTTX IS-H: Text for Waiting List ISH_WLTYPETX CHAR 25 0
WLSTA IS-H: Preregistration/Waiting List Status ISH_WLSTATUS CHAR 2 0
WLSTX IS-H: Text for Preregistration Status ISH_WLSTATTX CHAR 20 0
AUFDS IS-H: Latest Admission Date AUFDT_LAST DATS 8 0
ENTDT Discharge Date ISH_ENTLDT DATS 8 0
ENTZT Discharge Time (Formatted Output Format) ISH_ENTLZT5 CHAR 5 0
ENTZT_TIM Discharge Time ISH_ENTLZT TIMS 6 0
PLANE IS-H: Discharge status ISH_ENTLPL CHAR 1 0
NULL Actual
P Planned
W Waiting List
ENTAR Discharge Type ISH_ENTART CHAR 2 0
ENTAX Text for Discharge Type ISH_ENTATX CHAR 15 0
ENTOF IS-H: Departmental organizational unit of discharge ISH_ENTOEF CHAR 8 0
ENKOF IS-H: Short text for departmental org. unit of discharge ISH_ENTOKF CHAR 12 0
ENTOP IS-H: Nursing organizational unit of discharge ISH_ENTOEP CHAR 8 0
ENKOP IS-H: Short text of nursing org. unit of discharge ISH_ENTOKP CHAR 12 0
ENTZI IS-H: Discharge room ISH_ENTZIM CHAR 8 0
ENTZK IS-H: Identifier of the discharge room ISH_ENTZIK CHAR 8 0
ENTZKB ID of Discharge Room ISH_ENTZIKB CHAR 12 0
ENTBE IS-H: Discharge bed ISH_ENTBET CHAR 8 0
ENTBK IS-H: Identifier of the discharge bed ISH_ENTBEK CHAR 8 0
ENTBKB ID of Discharge Bed ISH_ENTBEKB CHAR 12 0
VERDT IS-H: Transfer Date ISH_VERLDT DATS 8 0
VERZT IS-H: Transfer time ISH_VERLZT TIMS 6 0
PLANV IS-H: Transfer status ISH_VERLPL CHAR 1 0
NULL Actual
P Planned
W Waiting List
VERAR IS-H: Transfer Type ISH_VERART CHAR 2 0
VERAX IS-H: Short Text for Transfer Type ISH_VERATX CHAR 15 0
VEROF IS-H: Departmental organizational unit of the transfer ISH_VEROEF CHAR 8 0
VEKOF IS-H: Short text for departmental org. unit of transfer ISH_VEROKF CHAR 12 0
VEROP IS-H: Nursing organizational unit of the transfer ISH_VEROEP CHAR 8 0
VEKOP IS-H: Short text of nursing org. unit of transfer ISH_VEROKP CHAR 12 0
VERZI IS-H: Transfer room ISH_VERZIM CHAR 8 0
VERZK IS-H: Identifier of transfer room ISH_VERZIK CHAR 8 0
VERZKB ID of Transfer Room ISH_VERZIKB CHAR 12 0
VERBE IS-H: Transfer bed ISH_VERBET CHAR 8 0
VERBK IS-H: Identifier of transfer bed ISH_VERBEK CHAR 8 0
VERBKB ID of Transfer Bed ISH_VERBEKB CHAR 12 0
VVOEF IS-H: Dept. org. unit from which patient is transferred ISH_VEVOEF CHAR 8 0
VVKOF IS-H: Short text of dept. OU from which patient transferred ISH_VEVOKF CHAR 12 0
VVOEP IS-H: Nursing org. unit from which patient is transferred ISH_VEVOEP CHAR 8 0
VVKOP IS-H: Short text of nurs. OU from which patient transferred ISH_VEVOKP CHAR 12 0
VVZIM IS-H: Room from which patient is transferred ISH_VEVZIM CHAR 8 0
VVZIK IS-H: Identifier of room from which patient is transferred ISH_VEVZIK CHAR 8 0
VVZIKB ID of Room From Which Patient Is Transferred ISH_VEVZIKB CHAR 12 0
VVBET IS-H: Bed from which the patient is transferred ISH_VEVBET CHAR 8 0
VVBEK IS-H: Identifier of bed from which patient transferred ISH_VEVBEK CHAR 8 0
VVBEKB ID of Bed from Which Patient Is Transferred ISH_VEVBEKB CHAR 12 0
BWIDT IS-H: Date of Movement BWIDT DATS 8 0
BWIZT IS-H: Time of Movement BWIZT TIMS 6 0
PLANB IS-H: Status of the movement ISH_BEWPL CHAR 1 0
NULL Actual
P Planned
W Waiting List
BEWTY Movement Category BEWTY CHAR 1 0
1 Admission
2 Discharge
3 Transfer
4 Outpatient Visit
6 Absence From
7 Absence To
BWTYX IS-H: Text for Movement Category BEWTYPTXT CHAR 15 0
BWART IS-H: Movement Type RI_BWART CHAR 2 0
BWATX IS-H: Text for Movement Type BEWARTXT CHAR 15 0
BEKAT Treatment Category BEKAT CHAR 6 0
TELF_INT IS-H: Telephone Number of Patient in Institution TELF_INT CHAR 16 0
KZTXT Comment on Case Movement TEXT_BEW CHAR 50 0
UNFTX IS-H: Text for Accident Type UNFTXT CHAR 15 0
EXKHX IS-H: Name of External Hospital ISH_EXTKHX CHAR 40 0
DAUAU IS-H: Duration of Patient's Stay ISH_DAUAUF NUMC 6 0
EZTXT Text for Patient's Disposition at Time of Discharge EZTXT CHAR 15 0
KZ24H IS-H: Indicator for case lasting under 24 hours ISH_KZ24H CHAR 1 0
X Yes
NULL No
KZABW IS-H: Indicator that Absences Exist for Case ISH_ABWKZ CHAR 1 0
X Yes
NULL No
KZTOD IS-H: Patient Is Deceased PAT_TOD CHAR 1 0
X Yes
NULL No
TODDT Date of Death From TODDT DATS 8 0
TODZT Time of Death From TODZT TIMS 6 0
TODDB Date of Death To TODDB DATS 8 0
TODZB IS-H: Time of Death To TODZB TIMS 6 0
TODUR IS-H: Cause of Death TODUR CHAR 3 0
TUTXT IS-H: Cause of Death Text TUTXT CHAR 20 0
BANAM IS-H: Name of Attending Physician ISH_BANAM CHAR 40 0
DANAM IS-h: Name of Discharging Physician ISH_DANAM CHAR 40 0
EANAM IS-H: Name of Referring Physician ISH_EANAM CHAR 40 0
FANAM IS-H: Name of Admitting Physician ISH_FANAM CHAR 40 0
HANAM IS-H: Name of Family Physician ISH_HANAM CHAR 40 0
NANAM IS-H: Name of Post-Discharge Physician ISH_NANAM CHAR 40 0
UANAM IS-H: Name of Referring Physician ISH_UANAM CHAR 40 0
MUTTI IS-H: Reference to Admission Number of Patient's Mother ISH_MUTTER CHAR 10 0
MUTAX IS-H: Text for mother's case type ISH_MUTATX CHAR 14 0
EBMOD IS-H: Text for Birth Procedure ISH_EMTXT CHAR 15 0
GBGEW Birth Weight GBGEW QUAN 7 3
GWEIN IS-H: Unit of Measurement ISH_EINH UNIT 3 0
GBGRO Birth Size GBGRO QUAN 5 2
GREIN IS-H: Unit of Measurement ISH_EINH UNIT 3 0
MEHRL Indicator whether Newborn from Multiple Birth ISH_MEHRL CHAR 1 0
X Yes
NULL No
KZTOT IS-H: Stillbirth Indicator KZTOT CHAR 1 0
X Yes
NULL No
ABVDT Start Date of Absence ISH_ABVON DATS 8 0
ABVZT IS-H: Time when absence starts ISH_ABVOZT TIMS 6 0
PLAWB IS-H: Absence status ISH_ABWPL CHAR 1 0
NULL Actual
P Planned
W Waiting List
ABBDT IS-H: End Date of Absence ISH_ABBIS DATS 8 0
ABBZT IS-H: Time when absence ends ISH_ABBIZT TIMS 6 0
PLAWE IS-H: Absence end status ISH_ABWPLE CHAR 1 0
NULL Actual
P Planned
W Waiting List
ABWAX IS-H: Text of Absence Type ISH_ABWATX CHAR 15 0
ABWGN IS-H: Indicator Whether Absence is Approved ('X') ISH_ABWGN CHAR 1 0
X Yes
NULL No
ABGAR IS-H: Physician Approving Absence ISH_ABGARZ CHAR 40 0
PATOF IS-H: Patient's Current Departmental Org. Unit ISH_PATOEF CHAR 8 0
PAKOF IS-H: Short Text for Patient's Current Dept. Org. Unit ISH_PATOKF CHAR 12 0
PATOP Patient's Current Nursing Org. Unit ISH_PATOEP CHAR 8 0
PAKOP Short Text for Patient's Current Nursing Org. Unit ISH_PATOKP CHAR 12 0
PATZI IS-H: Patient's current room ISH_PATZIM CHAR 8 0
PATZK IS-H: Identifier of patient's current room ISH_PATZIK CHAR 8 0
PATZKB ID of Patient's Current Room ISH_PATZIKB CHAR 12 0
PATBE IS-H: Bed currently occupied by the patient ISH_PATBET CHAR 8 0
PATBK IS-H: Identifier of the patient's bed ISH_PATBEK CHAR 8 0
PATBKB ID of Patient's Bed ISH_PATBEKB CHAR 12 0
BESDT IS-H: Date of Visit ISH_BESDT DATS 8 0
BESZT IS-H: Time of Visit ISH_BESZT TIMS 6 0
PLABE IS-H: Visit Status ISH_BESPL CHAR 1 0
NULL Actual
P Planned
W Waiting List
BESAR IS-H: Visit Type ISH_BESART CHAR 2 0
BESAX IS-H: Text for Visit Type ISH_BESATX CHAR 15 0
BESOF IS-H: Departmental organizational unit of the visit ISH_BESOEF CHAR 8 0
BEKOF IS-H: Short text for dept. org. unit of visit ISH_BESOKF CHAR 12 0
BESOP IS-H: Nursing organizational unit of the visit ISH_BESOEP CHAR 8 0
BEKOP IS-H: Short name of nursing organizational unit of visit ISH_BESOKP CHAR 12 0
BEZIM IS-H: Treatment room ISH_BEZIM CHAR 8 0
BEZIK IS-H: Identifier of treatment room ISH_BEZIK CHAR 8 0
BEZIKB ID of Treatment Room ISH_BEZIKB CHAR 12 0
CLASS IS-H: Patient Class ISH_PAYCL CHAR 4 0
RFSRC IS-H: Referral, Postdischarge Treatment Type ISH_REFSRC CHAR 2 0
BWGR1 Movement Reason - 1st and 2nd Positions ISH_BWGR1 CHAR 2 0
BWGR2 Movement Reason - 3rd and 4th Positions ISH_BWGR2 CHAR 2 0
STATU IS-H: Internal Status of Outpatient Visit ISH_ABSTIN CHAR 2 0
10 Waiting List
20 Planned
30 Actual
40 Scheduled
50 Waiting
55 Called
60 Being Treated
70 Treatment Completed
STATU_EX IS-H: External Status of Outpatient Visit ISH_ABSTEX CHAR 2 0
STATU_TXT IS-H: Text for External Status of Outpatient Visit ISH_ABSTTX CHAR 15 0
ABRKZ IS-H: Billing Indicator for Case ABRKZ_FALL CHAR 1 0
NULL Not Billed
1 Interim Billed
2 Final Billed
3 Provisional Billed
PATGEW IS-H: Weight of Patient at Admission ISH_PATGEW QUAN 7 3
PATGWEIN IS-H: Unit of Measurement for Patient Weight ISH_EINGEW UNIT 3 0
PATGRO IS-H: Height of Patient at Admission ISH_PATGRO QUAN 5 2
PATGREIN IS-H: Unit of Measurement for Patient Size ISH_EINGRO UNIT 3 0
KOSTR IS-H: Main Insurance Provider for Case ISH_FKOSTR CHAR 10 0
KTNAM IS-H: Name of Main Insurance Provider for Case ISH_FKTNAM CHAR 40 0
KTADR IS-H: Address of Main Insurance Provider for Case ISH_FKTADR CHAR 40 0
RVNUM IS-H: Social Insurance Number ISH_RVNUM CHAR 20 0
PLSNR IS-H: PRS Number ISH_EXTNR_PLS CHAR 20 0
NWATEREFCD ISH_AT_EREFCD CHAR 5 0
EMAIL IS-H: Internet Mail (SMTP) Address ISH_SMTPADR CHAR 241 0

RNPFB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RNPFB AUFAR '1' TN14B IS-H: Movement types BEWTY
RNPFB AUFAR RNPFB AUFAR TN14B IS-H: Movement types BWART
RNPFB AUFAR RNPFB MANDT TN14B IS-H: Movement types MANDT
RNPFB AUFAR RNPFB EINRI TN14B IS-H: Movement types EINRI
RNPFB AUFBE RNPFB MANDT NBAU IS-H: Building Units MANDT
RNPFB AUFBE RNPFB AUFBE NBAU IS-H: Building Units BAUID
RNPFB AUFZI RNPFB MANDT NBAU IS-H: Building Units MANDT
RNPFB AUFZI RNPFB AUFZI NBAU IS-H: Building Units BAUID
RNPFB EINRI RNPFB MANDT TN01 IS-H: Institutions MANDT
RNPFB EINRI RNPFB EINRI TN01 IS-H: Institutions EINRI
RNPFB FALAE RNPFB MANDT TN15A IS-H: Case Types MANDT
RNPFB FALAE RNPFB EINRI TN15A IS-H: Case Types EINRI
RNPFB FALAE RNPFB FALAE TN15A IS-H: Case Types FALAE
RNPFB FALNR RNPFB MANDT NFAL IS-H: Cases MANDT
RNPFB FALNR RNPFB EINRI NFAL IS-H: Cases EINRI
RNPFB FALNR RNPFB FALNR NFAL IS-H: Cases FALNR
RNPFB GSCHL RNPFB GSCHL TN17G IS-H: Sex Indicator GSCHLE
RNPFB GSCHL RNPFB MANDT TN17G IS-H: Sex Indicator MANDT
RNPFB LFDNR RNPFB FALNR NBEW IS-H: Movements for Case FALNR
RNPFB LFDNR RNPFB LFDNR NBEW IS-H: Movements for Case LFDNR
RNPFB LFDNR RNPFB MANDT NBEW IS-H: Movements for Case MANDT
RNPFB LFDNR RNPFB EINRI NBEW IS-H: Movements for Case EINRI
RNPFB MANDT RNPFB MANDT T000 Clients MANDT