RNFSDO_ITEM SAP (CV IT: Structure: SDO Data for single case) Structure details
Description: CV IT: Structure: SDO Data for single case
Structure field list including key, data, relationships and ABAP select examples
RNFSDO_ITEM 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 "CV IT: Structure: SDO Data for single case" 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_RNFSDO_ITEM TYPE RNFSDO_ITEM.
The RNFSDO_ITEM table consists of various fields, each holding specific information or linking keys about CV IT: Structure: SDO Data for single case data available in SAP. These include EINRI (Institution), FALNR (IS-H: Case Number), COMM_STATUS (IS-H: Detailed Internal Communication Status), PFORT (IS-H: Patient Does not Appear in Public List).. 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 RNFSDO_ITEM 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 |
EINRI | Institution | EINRI | CHAR | 4 | Assigned to domain | ALPHA | EINRI | EIN | |
FALNR | IS-H: Case Number | FALNR | CHAR | 10 | Assigned to domain | ALPHA | FALNR | FAL | |
COMM_STATUS | IS-H: Detailed Internal Communication Status | N_DCSTATI | CHAR | 1 | N_DCSTATI | ||||
PFORT | IS-H: Patient Does not Appear in Public List | PFORT | CHAR | 1 | XFELD | ||||
NEWBORN | IS-H: Indicator for Admission Type 'Newborn' | ISH_BANEUG | CHAR | 1 | XFELD | ||||
NONACCEPT | Rejection Indicator for Newborn (Italy) | ISH_IT_NONACCEPT | CHAR | 1 | ISH_ON_OFF | ||||
MOTHER_FALNR | IS-H: Reference to Admission Number of Patient's Mother | ISH_MUTTER | CHAR | 10 | Assigned to domain | ALPHA | FALNR | ||
INSTNR | IS-H: Institute Indicator | INSTNR | CHAR | 10 | ALPHA | INSTNR | |||
ESTABCODE | Establishment Code | ISH_ESTABCODE | CHAR | 2 | ISH_ESTABCODE | ||||
SDOID | ID of SDO Record for Communication | ISH_IT_SDOID | CHAR | 10 | ALPHA | ISH_IT_SSNID | |||
NNAME | Patient Last Name | NNAME_PAT | CHAR | 30 | TEXT30 | ||||
VNAME | IS-H: Patient First Name | VNAME_PAT | CHAR | 30 | TEXT30 | ||||
GSCHL | IS-H: Sex Indicator - Internal | GSCHL | CHAR | 1 | GSCHL | ||||
GSCHLE | IS-H: Sex Indicator - User-Specific | GSCHLE | CHAR | 1 | Assigned to domain | GSCHLE | |||
GBDAT | IS-H: Birthdate | RI_GBDAT | DATS | 8 | RI_DATUM | ||||
ISTATBPL | ISTAT Code Birthplace | ISH_ISTAT_BP | CHAR | 6 | ISH_ISTAT | ||||
FAMST | Marital Status Key | FAMST | CHAR | 1 | Assigned to domain | FAMST | |||
FAMSTTXT | Marital Status | FATXT | CHAR | 6 | FATXT | ||||
ISTAT_RES | ISTAT Code Place of Residence | ISH_ISTAT_POR | CHAR | 6 | ISH_ISTAT | ||||
NATIO | IS-H: Nationality | RI_NATIO | CHAR | 3 | Assigned to domain | LAND1 | |||
HEALTHID | Patient ID for Data Exchange | ISH_IT_HEALTHID | CHAR | 16 | ISH_IT_HEALTHID | ||||
ITREG | Region | ISH_ITREG | CHAR | 3 | ISH_ITREG | ||||
ITREGTXT | Text for Region | ISH_ITREGTXT | CHAR | 30 | TEXT30 | ||||
KKSNR | ASL Code | ISH_ASL | CHAR | 12 | ALPHA | KKSNUMMER | |||
HOSP_TYPE | IS-H: Case Type | FALLART | CHAR | 1 | FALLART | ||||
CASE_TYPETXT | IS-H: Text for Case Type | TEXT_FAA | CHAR | 14 | TEXT14 | ||||
BWIDT_ADM | IS-H: Date of Admission | ISH_AUFNDT | DATS | 8 | RI_DATUM | ||||
ORGPF_ADM | IS-H: Admitting nursing organizational unit | ISH_ADMPF | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
EXTTY | External Contract Scheme | ISH_EXTTY | CHAR | 2 | Assigned to domain | ISH_EXTTY | |||
RFSCRC | IS-H: Referral, Postdischarge Treatment Type | ISH_REFSRC | CHAR | 2 | Assigned to domain | ALPHA | ISH_REFSRC | ||
ADM_TYPE | IS-H: Admission Reason - 1st and 2nd Positions | ISH_ADM_BWGR1 | CHAR | 2 | Assigned to domain | ISH_BGRUND | |||
UNFKZ | IS-H: Accident Type | UNFART | CHAR | 3 | Assigned to domain | UNFART | |||
UNFTX | IS-H: Text for Accident Type | UNFTXT | CHAR | 15 | TEXT15 | ||||
BWIDT_TRF1 | IS-H: Transfer Date | ISH_VERLDT | DATS | 8 | RI_DATUM | ||||
BWIDT_TRF2 | IS-H: Transfer Date 2 | ISH_VERLDT2 | DATS | 8 | RI_DATUM | ||||
BWIDT_TRF3 | IS-H: Transfer Date 3 | ISH_VERLDT3 | DATS | 8 | RI_DATUM | ||||
ORGPF_TRF1 | IS-H: Nursing organizational unit of the transfer | ISH_VEROEP | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
ORGPF_TRF2 | IS-H: Nursing Organizational Unit for Transfer 2 | ISH_VEROEP2 | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
ORGPF_TRF3 | IS-H: Nursing Organizational Unit for Transfer 3 | ISH_VEROEP3 | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
ORGPF_DCHG | IS-H: Discharging Nursing Organizational Unit | ISH_DISPF | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
BWIDT_DCHG | Discharge Date | ISH_ENTLDT | DATS | 8 | RI_DATUM | ||||
BWART_DCHG | Discharge Type | ISH_ENTART | CHAR | 2 | Assigned to domain | RI_BWART | |||
AUT_IND | Autopsy Indicator | ISH_IT_AUTOPSY | CHAR | 1 | XFELD | ||||
ADM_REASON | IS-H: Admission Reason - 3rd and 4th Positions | ISH_ADM_BWGR2 | CHAR | 2 | Assigned to domain | ISH_BGRUND | |||
NO_DAYHOSP | Number of Days of Day Hospital (Day Patient Case) | ISH_IT_DHDAYS | NUMC | 4 | ISH_IT_DHDAYS | ||||
GBGEW | Birth Weight | GBGEW | QUAN | 7(3) | ISH_GEWICH | ||||
GWEIN | IS-H: Unit of Measurement for Patient Weight | ISH_EINGEW | UNIT | 3 | Assigned to domain | CUNIT | MEINS | N_WEIGHT_UNIT | |
MAIN_DKEY | DRG Principal Diagnosis Code | ISH_PRIN_DIA | CHAR | 30 | DIAID | ||||
SEC_DKEY1 | DRG Secondary Diagnosis Code | ISH_SECO_DIA | CHAR | 30 | DIAID | ||||
SEC_DKEY2 | DRG Secondary Diagnosis Code 2 | ISH_SECO_DIA2 | CHAR | 30 | DIAID | ||||
SEC_DKEY3 | DRG Secondary Diagnosis Code 3 | ISH_SECO_DIA3 | CHAR | 30 | DIAID | ||||
SEC_DKEY4 | DRG Secondary Diagnosis Code 4 | ISH_SECO_DIA4 | CHAR | 30 | DIAID | ||||
SEC_DKEY5 | DRG Secondary Diagnosis Code 5 | ISH_SECO_DIA5 | CHAR | 30 | DIAID | ||||
MAIN_BGDOP | Date of DRG Principal Surgical Procedure | ISH_DATE_PR_PRO | DATS | 8 | RI_DATUM | ||||
MAIN_ICPML | IS-H: ID of a DRG Principal Surgical Procedure Code | ISH_DRG_ICPMLP | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
SEC_BGDOP1 | Date of DRG Secondary Surgical Procedure | ISH_DATE_SE_PRO | DATS | 8 | RI_DATUM | ||||
SEC_BGDOP2 | Date of DRG Secondary Surgical Procedure 2 | ISH_DATE_SE_PRO2 | DATS | 8 | RI_DATUM | ||||
SEC_BGDOP3 | Date of DRG Secondary Surgical Procedure 3 | ISH_DATE_SE_PRO3 | DATS | 8 | RI_DATUM | ||||
SEC_BGDOP4 | Date of DRG Secondary Surgical Procedure 4 | ISH_DATE_SE_PRO4 | DATS | 8 | RI_DATUM | ||||
SEC_BGDOP5 | Date of DRG Secondary Surgical Procedure 5 | ISH_DATE_SE_PRO5 | DATS | 8 | RI_DATUM | ||||
SEC_ICPML1 | DRG Secondary Surgical Procedure Code | ISH_DRG_ICPMLS | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
SEC_ICPML2 | DRG Secondary Surgical Procedure Code 2 | ISH_DRG_ICPMLS2 | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
SEC_ICPML3 | DRG Secondary Surgical Procedure Code 3 | ISH_DRG_ICPMLS3 | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
SEC_ICPML4 | DRG Secondary Surgical Procedure Code 4 | ISH_DRG_ICPMLS4 | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
SEC_ICPML5 | DRG Secondary Surgical Procedure Code 5 | ISH_DRG_ICPMLS5 | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
DRG_CODE | IS-H: DRG Code | ISH_DRG_CODE | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
WLADT | IS-H: Date when Patient Added to Waiting List | ISH_WLADAT | DATS | 8 | DATUM | ||||
WLPRI | IS-H: Priority for Preregistration/Waiting List Management | WLPRI | CHAR | 2 | Assigned to domain | ALPHA | WLPRI | ||
TEAMSTCODE | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
TEAMNNAME | IS-H: EHIC - Patient's Last Name | ISH_EHIC_NNAME | CHAR | 40 | TEXT40 | ||||
TEAMVNAME | IS-H: EHIC - Patient's First Name | ISH_EHIC_VNAME | CHAR | 35 | TEXT35 | ||||
TEAMPERSID | IS-H: Personal ID Number | ISH_EHC_PERSID | CHAR | 20 | |||||
TEAMINSTNR | IS-H: EHIC - Institute Code of Responsible Insurance Carrier | ISH_EHIC_INSTNR | CHAR | 10 | CHAR10 | ||||
TEAMACNYM | IS-H: EHIC - Acronym of Responsible Insurance Carrier | ISH_EHIC_ACNYM | CHAR | 21 | CHAR21 | ||||
TEAMCARDNR | EHIC - Card Number (Alphanumeric) | ISH_EHIC_CARDNR_CHAR | CHAR | 20 | CHAR20 | ||||
TEAMEXPDT | IS-H: EHIC - Validity End | ISH_EHIC_EXPDT | DATS | 8 | RI_DATUM |
Key field | Non-key field |
How do I retrieve data from SAP structure RNFSDO_ITEM using ABAP code?
As RNFSDO_ITEM 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 RNFSDO_ITEM as there is no data to select.How to access SAP table RNFSDO_ITEM
Within an ECC or HANA version of SAP you can also view further information about RNFSDO_ITEM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects