RN1_CONN_CORDER_DATA SAP (IS-H: Structure for Clinical Order Connectivity) Structure details
Description: IS-H: Structure for Clinical Order Connectivity
Related tables to RN1_CONN_CORDER_DATA
Access table RN1_CONN_CORDER_DATA
Structure field list including key, data, relationships and ABAP select examples
RN1_CONN_CORDER_DATA 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: Structure for Clinical Order Connectivity" 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_RN1_CONN_CORDER_DATA TYPE RN1_CONN_CORDER_DATA.
The RN1_CONN_CORDER_DATA table consists of various fields, each holding specific information or linking keys about IS-H: Structure for Clinical Order Connectivity data available in SAP. These include MANDT (Client), CORDERID (IS-H: CORD/PREG: Identification of a Clinical Order), EINRI (Institution), REFTYP (IS-H: CORD/PREG: Ind. Reference Type Patient - Prov. Patient).. 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 (Deep)
SAP RN1_CONN_CORDER_DATA 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 |
CORDER | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
CORDERID | IS-H: CORD/PREG: Identification of a Clinical Order | N1CORDID | CHAR | 32 | SYSUUID_C | ||||
EINRI | Institution | EINRI | CHAR | 4 | ALPHA | EINRI | EIN | ||
REFTYP | IS-H: CORD/PREG: Ind. Reference Type Patient - Prov. Patient | N1CORDREFTYP | CHAR | 1 | N1CORDREFTYP | ||||
REFTYP_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | ALPHA | PATNR | PAT | ||
PATNR_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PAPID | IS-H: Provisional Patient Number | ISH_PAPID | CHAR | 10 | ALPHA | ISH_PAPID | |||
PAPID_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ETRBY | IS-H: CORD/PREG: Clinical Order Initiated By | N1CORDETRBY | CHAR | 1 | N1CORDETRBY | ||||
ETRBY_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ETROE | Initiating Organizational Unit | N1CORDETROE | CHAR | 8 | ALPHA | ORGID | |||
ETROE_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ETRGP | Initiating Employee/Business Partner | N1CORDETRGP | CHAR | 10 | ALPHA | RI_KUNNR | |||
ETRGP_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORDDEP | Initiating Department | N1CORDDEP | CHAR | 8 | ALPHA | ORGID | |||
ORDDEP_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORDPRI | Prioritization for Request/Movement (Internal) | N1APRI_D | NUMC | 3 | N1APRI | ||||
ORDPRI_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CORDTITLE | IS-H: CORD/PREG: Title of Clinical Order | N1CORDTITLE | CHAR | 30 | N1CORDTITLE | ||||
CORDTITLE_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRGNR | Order Number | N1CORDNR | CHAR | 10 | ALPHA | N1CORDNR | |||
PRGNR_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
RCKRUF | Clinical Order - Callback Number | N1CORDRCKRUF | CHAR | 30 | N1CORDRCKRUF | ||||
RCKRUF_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
KANAM | IS-H: CORD/PREG: Short Anamnesis for Clinical Order | N1CORDANAM | CHAR | 50 | TEXT50 | ||||
KANAM_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
KALTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
KALTX_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
FRAGE | IS-H: CORD/PREG: Questions | N1CORDFRAGE | CHAR | 50 | TEXT50 | ||||
FRAGE_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
FRLTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
FRLTX_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SCHWKZ | Indicator that Patient Is Pregnant | SCHWANGER | CHAR | 1 | XFELD | ||||
SCHWKZ_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SCHWO | Week of Pregnancy | SCHWOCHE | NUMC | 2 | NUMC02 | ||||
SCHWO_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
IFG | Degree of Infection - Internal Format | N1IFG_INT | NUMC | 2 | NUMC2 | ||||
IFG_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
RMCORD | Comment for Clinical Order | N1CORDBMKG | CHAR | 50 | TEXT50 | ||||
RMCORD_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
RMLTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
RMLTX_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLPRI | IS-H: Priority for Preregistration/Waiting List Management | WLPRI | CHAR | 2 | ALPHA | WLPRI | |||
WLPRI_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLTYP | IS-H: Waiting List | ISH_WLTYPE | CHAR | 6 | CHAR6 | ||||
WLTYP_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLREM | IS-H: Preregistration Status 'Inactive' Indicator | ISH_WLSTREMO | CHAR | 1 | XFELD | ||||
WLREM_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLRDT | IS-H: Date when Movement Removed From Waiting List | ISH_WLRDAT | DATS | 8 | DATUM | ||||
WLRDT_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLRRN | IS-H: Reason for Removal from Waiting List | ISH_WLRRSN | CHAR | 3 | CHAR3 | ||||
WLRRN_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLSTA | IS-H: Preregistration/Waiting List Status | ISH_WLSTATUS | CHAR | 2 | CHAR2 | ||||
WLSTA_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLHSP | IS-H: Waiting List Postdischarge Hospital | ISH_WLHOSP | CHAR | 10 | ALPHA | RI_KUNNR | |||
WLHSP_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WLADT | IS-H: Date when Patient Added to Waiting List | ISH_WLADAT | DATS | 8 | DATUM | ||||
WLADT_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ABSBDT | IS-H: Start Date of Waiting List Absence | ISH_ABSBDT | DATS | 8 | DATE | ||||
ABSBDT_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ABSEDT | IS-H: End Date of Waiting List Absence | ISH_ABSEDT | DATS | 8 | DATE | ||||
ABSEDT_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ABSESN | IS-H: Reason for Temporary Absence From Waiting List | ISH_ABSRSN | CHAR | 3 | ALPHA | ISH_ABSRSN | |||
ABSESN_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
USER1 | IS-H: User-Defined Field 1 | ISH_PREGUSER1 | CHAR | 20 | ISH_PREGUSER1 | ||||
USER1_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
USER2 | IS-H: User-Defined Field 2 | ISH_PREGUSER2 | CHAR | 20 | ISH_PREGUSER2 | ||||
USER2_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
USER3 | IS-H: User-Defined Field 3 | ISH_PREGUSER3 | DATS | 8 | ISH_PREGUSER3 | ||||
USER3_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
USER4 | IS-H: User-Defined Field 4 | ISH_PREGUSER4 | DATS | 8 | ISH_PREGUSER4 | ||||
USER4_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
USER5 | IS-H: User-Defined Field 5 | ISH_PREGUSER5 | CHAR | 50 | ISH_PREGUSER5 | ||||
USER5_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
USER6 | IS-H: User-Defined Field 6 | ISH_PREGUSER6 | CHAR | 1 | ISH_PREGUSER6 | ||||
USER6_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
USER7 | IS-H: User-Defined Field 7 | ISH_PREGUSER7 | CHAR | 1 | ISH_PREGUSER7 | ||||
USER7_X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
KZ | IS-H: Processing Mode for Data Records (I/U/D) | ISH_MODUS | CHAR | 1 | ISH_MODUS | ||||
PAP_KEY | 0 | ||||||||
PAPID | IS-H: Provisional Patient Number | ISH_PAPID | CHAR | 10 | ALPHA | ISH_PAPID | |||
PAP_DATA | 0 | ||||||||
NNAME | Patient Last Name | NNAME_PAT | CHAR | 30 | TEXT30 | ||||
VNAME | IS-H: Patient First Name | VNAME_PAT | CHAR | 30 | TEXT30 | ||||
GBNAM | IS-H: Birthname | GBNAM | CHAR | 30 | TEXT30 | ||||
GBDAT | IS-H: Birthdate | RI_GBDAT | DATS | 8 | RI_DATUM | ||||
GSCHLE | IS-H: Sex Indicator - User-Specific | GSCHLE | CHAR | 1 | GSCHLE | ||||
TITEL | IS-H: Title | RI_TITEL | CHAR | 15 | TITEL | ||||
NAMZU | IS-H: Name Affix | RI_NAMZU | CHAR | 15 | TITEL | ||||
VORSW | IS-H: Name Prefix | RI_VORSW | CHAR | 15 | TITEL | ||||
ANRDE | IS-H: Form-of-Address ID | RI_ANRDE | CHAR | 5 | RI_ANRDE | ||||
EXTNR | IS-H: External Patient Identification | EXT_PATNR | CHAR | 20 | EXT_PATNR | ||||
RVNUM | IS-H: Social Insurance Number | ISH_RVNUM | CHAR | 20 | ISH_SVNUM | ||||
PASSTY | Type of Identification Document | ISH_PASSTY | CHAR | 2 | ALPHA | ISH_PASSTY | |||
PASSNR | IS-H: Identification Document Number | ISH_PASSNR | CHAR | 15 | NLJUS | ISH_PASSNR | |||
PSTLZ | IS-H: Postal Code of City | ISH_PSTLZO | CHAR | 10 | PSTLZ | ||||
LAND | IS-H: Country | ISH_LAND | CHAR | 3 | LAND1 | ||||
REGIO | IS-H: Region (Federal State, Province, County) | ISH_REGION | CHAR | 3 | REGIO | ||||
ORT | IS-H: City | ISH_CITY1 | CHAR | 40 | TEXT40 | ||||
ORT2 | IS-H: District | ISH_CITY2 | CHAR | 40 | TEXT40 | ||||
STRAS | IS-H: Street | ISH_STRASS | CHAR | 40 | TEXT40 | ||||
STRAZ | IS-H: Other Designation Qualifying the Address | ISH_STRASZ | CHAR | 40 | TEXT40 | ||||
EINZG | IS-H: Geographical Area | EINZGEBIET | CHAR | 9 | EINZGEBIET | ||||
PSTLP | IS-H: Postal Code of P.O. Box | ISH_PSTLZP | CHAR | 10 | PSTLZ | ||||
PFACH | IS-H: Post Office Box | ISH_POBOX | CHAR | 10 | ISH_PFACH | ||||
LANPF | Country of Post Office Box | ISH_LANDPB | CHAR | 3 | LAND1 | ||||
ORTPF | IS-H: PO Box City | ISH_CITYPB | CHAR | 40 | TEXT40 | ||||
PSTLF | IS-H: Postal Code of Company (for Major Accounts) | ISH_PSTLZF | CHAR | 10 | PSTLZ | ||||
TELNO | 0 | ||||||||
FAXNR | Fax Number | ISH_FAXNR | CHAR | 30 | CHAR30 | ||||
FAXXT | IS-H: Fax Number - Extension | ISH_FAXEXT | CHAR | 10 | CHAR10 | ||||
TEXNR | IS-H: Telex Number | ISH_TELETX | CHAR | 30 | TEXT30 | ||||
BUILD | IS-H: Block/House | ISH_BUILD | CHAR | 10 | TEXT10 | ||||
FLOOR | IS-H: Block/House Level | ISH_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOM | IS-H: Unit Number | ISH_ROOM | CHAR | 10 | TEXT10 | ||||
IS-H: Internet Mail (SMTP) Address | ISH_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | ||||
HSNM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
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 | ||||
UNKNOWN_GBDAT | Birthdate Is Unknown | ISH_UNKNOWN_GBDAT | CHAR | 1 | ISH_UNKNOWN_GBDAT | ||||
/ISHFR/BIRTHRK | IS-H FR: Birth Rank | /ISHFR/ISH_BIRTH_RANK | NUMC | 1 | /ISHFR/ISH_BIRTH_RANK | ||||
PAP_X | 0 | ||||||||
NNAMEX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VNAMEX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
GBNAMX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
GBDATX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
UNKNOWN_GBDATX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
GSCHLEX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TITELX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NAMZUX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VORSWX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ANRDEX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
EXTNRX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
RVNUMX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PASSTYX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PASSNRX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PSTLZX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
LANDX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
REGIOX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORTX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORT2X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
STRASX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
STRAZX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
EINZGX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PSTLPX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PFACHX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
LANPFX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORTPFX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PSTLFX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TELNOX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
FAXNRX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
FAXXTX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TEXNRX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
BUILDX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
FLOORX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ROOMX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
EMAILX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
HSNM1X | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
/ISHFR/BIRTHRKX | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
POS | 0 | ||||||||
INSURANCE | 0 | ||||||||
PROCED | 0 | ||||||||
DIAG | 0 | ||||||||
ABSENCE | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure RN1_CONN_CORDER_DATA using ABAP code?
As RN1_CONN_CORDER_DATA 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 RN1_CONN_CORDER_DATA as there is no data to select.How to access SAP table RN1_CONN_CORDER_DATA
Within an ECC or HANA version of SAP you can also view further information about RN1_CONN_CORDER_DATA 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