Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

RNF18 SAP (IS-H: Invoice Form: Patient Data/Case/Diagnosis) Structure details

Dictionary Type: Structure
Description: IS-H: Invoice Form: Patient Data/Case/Diagnosis

ABAP Code to SELECT data from RNF18
Related tables to RNF18
Access table RNF18

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

RNF18 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IS-H: Invoice Form: Patient Data/Case/Diagnosis" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_RNF18 TYPE RNF18.

The RNF18 table consists of various fields, each holding specific information or linking keys about IS-H: Invoice Form: Patient Data/Case/Diagnosis data available in SAP. These include AUFDT (IS-H: Date of Movement), AUFZT (IS-H: Time of Movement), ENTDT (IS-H: Date of Movement), ENTZT (IS-H: Time of Movement).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP RNF18 structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
FALNR	IS-H: Case Number	FALNR	CHAR	10	Assigned to domain	ALPHA	FALNR	FAL
AUFDT	IS-H: Date of Movement	BWIDT	DATS	8			RI_DATUM
AUFZT	IS-H: Time of Movement	BWIZT	TIMS	6			UHRZT
ENTDT	IS-H: Date of Movement	BWIDT	DATS	8			RI_DATUM
ENTZT	IS-H: Time of Movement	BWIZT	TIMS	6			UHRZT
AUFOFAKB	IS-H: Organizational Unit Short Text	ORGKB	CHAR	12			TEXT12
AUFOPFKB	IS-H: Organizational Unit Short Text	ORGKB	CHAR	12			TEXT12
ORGFA	Identification Key of Organizational Unit	ORGID	CHAR	8	Assigned to domain	ALPHA	ORGID	OGE
ORGPF	Identification Key of Organizational Unit	ORGID	CHAR	8	Assigned to domain	ALPHA	ORGID	OGE
AUFBWART	IS-H: Movement Type	RI_BWART	CHAR	2	Assigned to domain		RI_BWART
AUFBWATX	IS-H: Text for Movement Type	BEWARTXT	CHAR	15			TEXT15
ENTBWART	IS-H: Movement Type	RI_BWART	CHAR	2	Assigned to domain		RI_BWART
ENTBWATX	IS-H: Text for Movement Type	BEWARTXT	CHAR	15			TEXT15
ENTOFAKB	IS-H: Organizational Unit Short Text	ORGKB	CHAR	12			TEXT12
ENTOPFKB	IS-H: Organizational Unit Short Text	ORGKB	CHAR	12			TEXT12
ENTORGFA	Identification Key of Organizational Unit	ORGID	CHAR	8	Assigned to domain	ALPHA	ORGID	OGE
ENTORGPF	Identification Key of Organizational Unit	ORGID	CHAR	8	Assigned to domain	ALPHA	ORGID	OGE
ENTBWGR1	Movement Reason - 1st and 2nd Positions	ISH_BWGR1	CHAR	2	Assigned to domain		ISH_BGRUND
CONCATPAT	Composite Name of a Person	N_CONC_NAM	CHAR	50			CHAR50
FZIFF	Check Digit for Case	PZIFF_FALL	CHAR	1			PZIFF	PZF
FPEDT	IS-H: Date of Wound Healing	ISH_FPEDT	DATS	8			ISH_FPEDT
TOB	IS-H: Days Without Calculation	ISH_TOB	NUMC	3
CONSENT		ISH_CONSENT	CHAR	1			XFELD
EINDKAT	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2	TNK00		KATID
EINDKEY1	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
EINDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EINDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EINDITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
EINDLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
EINDGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
EINDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
AUFDKAT	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2	TNK00		KATID
AUFDKEY	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
AUFDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUFDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUFDITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
AUFDLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
AUFDGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
AUFDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
EINRDKAT	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
EINRDKEY	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
EINRDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EINRDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EINRDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
AUFRDKAT	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
AUFRDKEY	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
AUFRDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUFRDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUFRDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
EIN2DKAT	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2			KATID
EIN2DKEY1	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
EIN2DIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EIN2DIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EIN2DITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
EIN2DLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
EIN2DGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
EIN2DTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
AUF2DKAT	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2			KATID
AUF2DKEY	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
AUF2DIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUF2DIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUF2DITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
AUF2DLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
AUF2DGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
AUF2DTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
EIN2RDKAT	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
EIN2RDKEY	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
EIN2RDKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EIN2RDKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
EIN2RDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
AUF2RDKAT	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
AUF2RDKEY	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
AUF2RDKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUF2RDKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
AUF2RDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
ENTDKAT	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2	TNK00		KATID
ENTDKEY1	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
ENTDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENTDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENTDITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
ENTDLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
ENTDGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
ENTDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
KHDDKAT	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2	TNK00		KATID
KHDDKEY	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
KHDDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
KHDDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
KHDDITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
KHDDLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
KHDDGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
KHDDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
ENTRDKAT	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
ENTRDKEY	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
ENTRDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENTRDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENTRDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
KHDRDKAT	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
KHDRDKEY	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
KHDRDIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
KHDRDIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
KHDRDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
ENT2DKAT	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2			KATID
ENT2DKEY1	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
ENT2DIKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENT2DIKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENT2DITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
ENT2DLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
ENT2DGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
ENT2DTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
ENT2RDKAT	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
ENT2RDKEY	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
ENT2RDKTXT	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENT2RDKTX2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ENT2RDTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
ICBWIDT	IS-H: Date of Movement	BWIDT	DATS	8			RI_DATUM
ICBWIZT	IS-H: Time of Movement	BWIZT	TIMS	6			UHRZT
ICBWART	IS-H: Movement Type	RI_BWART	CHAR	2	Assigned to domain		RI_BWART
ICBWATX	IS-H: Text for Movement Type	BEWARTXT	CHAR	15			TEXT15
ICORGFA	IS-H: OU with Departmental Responsibility for Case	NZUWFA	CHAR	8	Assigned to domain	ALPHA	ORGID
ICFAKEY	Specialty According to Federal Regulation for Hospitals	FACHRTY1	CHAR	4	Assigned to domain	ALPHA	ISH_FACHR
ICORGPF	Organizational Unit Assigned to Case	NZUWPF	CHAR	8	Assigned to domain	ALPHA	ORGID
ICTARLS	Service in Service Catalog	TARLS	CHAR	10	Assigned to domain	ALPHA	TARLS	TAL
ICTARLSTXT	IS-H: First Short Text for Service	TARKTXT1	CHAR	40			LEIKTXT
ICPMK	IS-H: Identification of Surgical Procedure Coding Catalog	ICPM_ID	CHAR	2	Assigned to domain	ALPHA	TARID
ICPML	IS-H: Surgical Procedure Code (Service)	ICPM_LS	CHAR	10	Assigned to domain	ALPHA	TARLS
ICPTXT	IS-H: Short Text for Surgical Procedure Code	OP_TEXT	CHAR	40			LEIKTXT
ICPHC	IS-H: Main Surgical Procedure Code	ICPM_HCODE	CHAR	1			XFELD
ICDITXT	Free Text for Diagnosis	ISH_DITEXT	CHAR	50			TEXT50
ICDKAT1	IS-H: Identification Key of Diagnosis Coding Catalog	DIAKAT	CHAR	2			KATID
ICDKEY1	IS-H: Diagnosis Code	DIAID	CHAR	30			DIAID
ICDKAT_REF	IS-H: Catalog ID of Reference Catalog for Statistics	REF_DIAKAT	CHAR	2			KATID
ICDKEY_REF	IS-H: Reference Diagnosis Code for Statistics	REF_DIAID	CHAR	30			DIAID
ICDIATXT1	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ICDIATXT2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ICDIATXTR1	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ICDIATXTR2	Diagnosis Text	DIATXT	CHAR	40			TEXT40
ICANZOP	IS-H: Number of Additional Surgeries	ISH_ANZOP	NUMC	3			NUMC3
ICDLO	IS-H: Localization of Diagnosis	N2_DIALO	CHAR	2	Assigned to domain	ALPHA	N2_DIALO
ICDGW	Diagnostic Certainty	N2_DIASI	CHAR	2	Assigned to domain	ALPHA	N2_DIASI
ICD1TYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
ICDREFTYP	Type for ICD-10 Diagnoses	ISH_ICD10_DIATYP	CHAR	1			ISH_DIATYP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
PATNR	IS-H: Patient Number	PATNR	CHAR	10	Assigned to domain	ALPHA	PATNR	PAT
EINRI	Institution	EINRI	CHAR	4	TN01	ALPHA	EINRI	EIN
GSCHL	IS-H: Sex Indicator - Internal	GSCHL	CHAR	1			GSCHL
NNAME	Patient Last Name	NNAME_PAT	CHAR	30			TEXT30
NNAMS	IS-H: Standardized Last Name	NNAMES_PAT	CHAR	30			CHAR30
VNAME	IS-H: Patient First Name	VNAME_PAT	CHAR	30			TEXT30
VNAMS	Standardized First Name	VNAMES_PAT	CHAR	30			CHAR30
TITEL	IS-H: Title	RI_TITEL	CHAR	15	Assigned to domain		TITEL
NAMZU	IS-H: Name Affix	RI_NAMZU	CHAR	15	Assigned to domain		TITEL
VORSW	IS-H: Name Prefix	RI_VORSW	CHAR	15	Assigned to domain		TITEL
NAME2	Pseudonym, Order Name	NAME2_PAT	CHAR	30			TEXT30
GBDAT	IS-H: Birthdate	RI_GBDAT	DATS	8			RI_DATUM
GBNAM	IS-H: Birthname	GBNAM	CHAR	30			TEXT30
GBNAS	IS-H: Standardized Birthname	GBNAMS_PAT	CHAR	30			CHAR30
GLAND	IS-H: Country of Birth	GLAND	CHAR	3	T005		LAND1
TODKZ	IS-H: Patient Is Deceased	PAT_TOD	CHAR	1			XFELD
TODDT	IS-H: Date of Death From	TODDV	DATS	8			RI_DATUM
TODZT	Time of Death From	TODZV	TIMS	6			UHRZT
TODDB	Date of Death To	TODDB	DATS	8			RI_DATUM
TODZB	IS-H: Time of Death To	TODZB	TIMS	6			UHRZT
TODUR	IS-H: Cause of Death	TODUR	CHAR	3	TN18A		TODUR
ANRED	IS-H: Form-of-Address Key	RI_ANRDS	CHAR	2	Assigned to domain		RI_ANRDS
FAMST	IS-H: Marital Status	RI_FAMST	CHAR	1			RI_FAMST
KONFE	IS-H: Religion	RI_KONFE	CHAR	2			RI_KONFE
NATIO	IS-H: Nationality	RI_NATIO	CHAR	3	T005		LAND1
SPRAS	Patient Language	SPRAS_PAT	LANG	1	T002	ISOLA	SPRAS
LAND	IS-H: Country of patient's place of residence	LAND_PAT	CHAR	3	T005		LAND1
PSTLZ	IS-H: Patient Postal Code	PSTLZ_PAT	CHAR	10			PSTLZ
ORT	IS-H: City where Patient Resides	ORT01_PAT	CHAR	25			TEXT25
ORT2	Patient District	ORT02_PAT	CHAR	25			TEXT25
STRAS	IS-H: Street and House Number of Patient	STRAS_PAT	CHAR	30			STRAS
BLAND	IS-H: Region (Federal State, Province, County)	ISH_REGION	CHAR	3	T005S		REGIO
GEBIE	IS-H: Geographical Area	EINZGEBIET	CHAR	9			EINZGEBIET
TELF1	IS-H: Patient Telephone Number	TELF_PAT	CHAR	16			TEXT16
SPEND	Organ Donor Indicator	SPENKZ	CHAR	1			XFELD
SPENT	Explanation for Donor Indicator	SPENTEXT	CHAR	50			TEXT50
SPELT	Indicator that Long Text Exists	RI_LGTXT	CHAR	1			XFELD
VIPKZ	IS-H: VIP Indicator	VIPKZ	CHAR	1			XFELD
ARCHV	IS-H: Archived Data Indicator	ARCHIV	CHAR	1			XFELD
STATU	Patient Status	PAT_STATUS	CHAR	1			PAT_STATUS
EXTNR	IS-H: External Patient Identification	EXT_PATNR	CHAR	20			EXT_PATNR
NOTAN	IS-H: Emergency Admission Indicator	NOTAUF	CHAR	1			XFELD
KRZAN	IS-H: Quick Admission Indicator	KURZAUF	CHAR	1			XFELD
RFPAT	Reference to Patient Number in Merging	RFPAT	CHAR	10	Assigned to domain	ALPHA	PATNR
RFZIF	Check Digit for Patient	PZIFF_PAT	CHAR	1			PZIFF	PZP
BERUF	IS-H: Patient Occupation	BERUF	CHAR	25			TEXT25
AGNUM	IS-H: Patient's Employer	AGNUM_PAT	CHAR	10	NGPA	ALPHA	RI_KUNNR
AGNAM	IS-H: Employer Name	AGNAM	CHAR	30			TEXT30
AGLAN	IS-H: Employer Country	AGLAN	CHAR	3	T005		LAND1
AGPLZ	IS-H: Employer Postal Code	AGPLZ	CHAR	10			PSTLZ
AGORT	IS-H: Employer City	AGORT	CHAR	25			TEXT25
AGSTR	IS-H: Employer Street	AGSTR	CHAR	30			STRAS
AGTEL	IS-H: Employer Telephone Number	AGTEL	CHAR	16			TEXT16
RVNUM	IS-H: Social Insurance Number	ISH_RVNUM	CHAR	20			ISH_SVNUM
ANNA1	IS-H: Last Name of Person to Be Contacted	NNAME_ANG	CHAR	30			TEXT30
ANVN1	IS-H: First Name of Person to Be Contacted	VNAME_ANG	CHAR	30			TEXT30
ANLA1	Country of the Person to Be Contacted	LAND_ANG	CHAR	3	T005		LAND1
ANPL1	IS-H: Postal Code	PSTLZ_ANG	CHAR	10			PSTLZ
ANOR1	IS-H: City where Person to Be Contacted Resides	ORT01_ANG	CHAR	25			TEXT25
ANST1	IS-H: Street and House Number of Person to Be Contacted	STRAS_ANG	CHAR	30			STRAS
ANTE1	IS-H: Telephone Number of Person to Be Contacted	TELF_ANG	CHAR	16			TEXT16
ANVV1	IS-H: Relationship	VERWVH	CHAR	1	TN17B		VERWVH
VMKZ1	IS-H: Legal Representative	VORMUND	CHAR	1			XFELD
ANNA2	IS-H: Last Name of Person to Be Contacted	NNAME_ANG	CHAR	30			TEXT30
ANVN2	IS-H: First Name of Person to Be Contacted	VNAME_ANG	CHAR	30			TEXT30
ANLA2	Country of the Person to Be Contacted	LAND_ANG	CHAR	3	T005		LAND1
ANPL2	IS-H: Postal Code	PSTLZ_ANG	CHAR	10			PSTLZ
ANOR2	IS-H: City where Person to Be Contacted Resides	ORT01_ANG	CHAR	25			TEXT25
ANST2	IS-H: Street and House Number of Person to Be Contacted	STRAS_ANG	CHAR	30			STRAS
ANTE2	IS-H: Telephone Number of Person to Be Contacted	TELF_ANG	CHAR	16			TEXT16
ANVV2	IS-H: Relationship	VERWVH	CHAR	1	TN17B		VERWVH
VMKZ2	IS-H: Legal Representative	VORMUND	CHAR	1			XFELD
KZTXT	IS-H: Comment on Patient	TEXT_PAT	CHAR	50			TEXT50
LGTXT	Indicator that Long Text Exists	RI_LGTXT	CHAR	1			XFELD
BEGDT	IS-H: Valid-From Date of Record	RI_BEGDT	DATS	8			RI_DATUM
ENDDT	IS-H: Valid-To Date of Record	RI_ENDDT	DATS	8			RI_DATUM
HISTK	Indicator that History Records Are Available	RI_HISTK	CHAR	1			XFELD
RISKF	IS-H: Risk Information Exists for the Patient	ISH_RISIKO	CHAR	1			XFELD
TESTP	Test Patient Status	TESTP	CHAR	1			XFELD
PZIFF	Check Digit for Patient	PZIFF_PAT	CHAR	1			PZIFF	PZP
ERDAT	IS-H: Date when Record Created	RI_ERDAT	DATS	8			RI_DATUM
ERUSR	IS-H: Name of Employee who Created Record	RI_ERNAM	CHAR	12			USNAM
UPDAT	IS-H: Date of Last Change	RI_UPDAT	DATS	8			RI_DATUM
UPUSR	IS-H: Name of Person who Last Changed Data	RI_UPNAM	CHAR	12			USNAM
STORN	IS-H: Cancellation Indicator	RI_STORN	CHAR	1			XFELD
STUSR	IS-H: Name of User who Canceled Data Record	STORN_USER	CHAR	12			USNAM
STDAT	Date of Cancellation	STORN_DAT	DATS	8			RI_DATUM
GBORT	IS-H: Patient Birthplace	ISH_GBORT	CHAR	25			TEXT25
HARNR	IS-H: Personnel Number of Family Physician	HARNR	CHAR	10	NGPA	ALPHA	RI_KUNNR
EARNR	IS-H: Personnel Number of Referring Physician	EARNR	CHAR	10	NGPA	ALPHA	RI_KUNNR
UARNR	IS-H: Personnel Number of Referring Physician	UARNR	CHAR	10	NGPA	ALPHA	RI_KUNNR
RACE	IS-H: Race	ISH_RACE	CHAR	2	TN17R	ALPHA	ISH_RACE
RESID	Indicator That Patient Is Non-Resident	ISH_RESID	CHAR	1			XFELD
PASSTY	Type of Identification Document	ISH_PASSTY	CHAR	2	TN17D	ALPHA	ISH_PASSTY
PASSNR	IS-H: Identification Document Number	ISH_PASSNR	CHAR	15		NLJUS	ISH_PASSNR
ADRNR	IS-H: Address Number	ISH_ADRNR	CHAR	10	NADR	ALPHA	ISH_ADRNR
ADROB	IS-H: Address Object	ISH_ADROBJ	CHAR	4			ISH_ADROBJ
ADNAG	IS-H: Address Number	ISH_ADRNR	CHAR	10	NADR	ALPHA	ISH_ADRNR
ADOAG	IS-H: Address Object	ISH_ADROBJ	CHAR	4			ISH_ADROBJ
ADNN1	IS-H: Address Number	ISH_ADRNR	CHAR	10	NADR	ALPHA	ISH_ADRNR
ADON1	IS-H: Address Object	ISH_ADROBJ	CHAR	4			ISH_ADROBJ
ADNN2	IS-H: Address Number	ISH_ADRNR	CHAR	10	NADR	ALPHA	ISH_ADRNR
ADON2	IS-H: Address Object	ISH_ADROBJ	CHAR	4			ISH_ADROBJ
ANEX1	External Identification of Next of Kin	EXTNR_ANG	CHAR	20			EXT_PATNR
ANEX2	External Identification of Next of Kin	EXTNR_ANG	CHAR	20			EXT_PATNR
ADRN2	IS-H: Address Number	ISH_ADRNR	CHAR	10	NADR	ALPHA	ISH_ADRNR
ADRO2	IS-H: Address Object	ISH_ADROBJ	CHAR	4			ISH_ADROBJ
INACT	'Inactive' Indicator	ISH_INACTIVE	CHAR	1			XFELD
USER1	IS-H: User-Defined Field 1	ISH_PATUSER1	CHAR	20			ISH_PATUSER1
USER2	IS-H: User-Defined Field 2	ISH_PATUSER2	CHAR	20			ISH_PATUSER2
USER3	IS-H: User-Defined Field 3	ISH_PATUSER3	DATS	8			ISH_PATUSER3
USER4	IS-H: User-Defined Field 4	ISH_PATUSER4	DATS	8			ISH_PATUSER4
USER5	IS-H: User-Defined Field 5	ISH_PATUSER5	CHAR	50			ISH_PATUSER5
USER6	IS-H: User-Defined Field 6	ISH_PATUSER6	CHAR	1			ISH_PATUSER6
EXTAUFG		EXTAUFG	CHAR	1			XFELD
EXTAUFGA		EXTAUFGA	CHAR	2	TNWCHEA16		EXTAUFGA
EMPSC	IS-H: Employed Since	ISH_EMPDAT	DATS	8			RI_DATUM
UNKNOWN_GBDAT	Birthdate Is Unknown	ISH_UNKNOWN_GBDAT	CHAR	1			ISH_UNKNOWN_GBDAT
MIG_DONE	Indicator Specifying Record Is Migrated to BP Table	ISH_BPMIG_DONE	CHAR	1			ISH_BPMIG_DONE
INSID		ISH_VERS_NR	CHAR	10
ISTAT_BPL	ISTAT Code	ISH_ISTAT	CHAR	6			ISH_ISTAT
TAXNUM	Tax Number of Person	ISH_IT_TAXNUM	CHAR	20			BPTAXNUM
TAXNUM_IND	Tax Number Indicator	ISH_TAXNUM_IND	CHAR	1			XFELD
STP	STP Code	ISH_STP	CHAR	16			ISH_STP
STP_ENDDT	End of Validity of STP Code	ISH_STPEND	DATS	8			RI_DATUM
CONS_PERSDATA	Consent for Processing of Personal Data	ISH_CONS_PERSDATA	CHAR	1			XFELD
/ISHFR/BIRTHRK	IS-H FR: Birth Rank	/ISHFR/ISH_BIRTH_RANK	NUMC	1			/ISHFR/ISH_BIRTH_RANK
DTH_LOC	Location of Death	ISH_DTH_LOC	CHAR	2	TN18L		ISH_LOC
OCCUP	National Occupation Category	ISH_CN_OCCUP	CHAR	5	TN17C		ISH_CN_OCCUP
NARNR_S	Postdischarge Physician for Inpatient Stays	ISH_POSTDIS_PHYS_INP	CHAR	10	Assigned to domain	ALPHA	RI_KUNNR
NARNR_A	Postdischarge Physician for Outpatient Stays	ISH_POSTDIS_PHYS_OUTP	CHAR	10	Assigned to domain	ALPHA	RI_KUNNR

Key field

Non-key field

How do I retrieve data from SAP structure RNF18 using ABAP code?

As RNF18 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RNF18 as there is no data to select.

How to access SAP table RNF18

Within an ECC or HANA version of SAP you can also view further information about RNF18 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!