N1CORDER SAP (IS-H: Clinical Order) Table details

Dictionary Type: Table
Description: IS-H: Clinical Order




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




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

N1CORDER is a standard SAP Table which is used to store IS-H: Clinical Order data and is available within R/3 SAP systems depending on the version and release level.

The N1CORDER table consists of various fields, each holding specific information or linking keys about IS-H: Clinical Order data available in SAP. These include CORDERID (IS-H: CORD/PREG: Identification of a Clinical Order), EINRI (Institution), REFTYP (IS-H: CORD/PREG: Ind. Reference Type Patient - Prov. Patient), PATNR (IS-H: Patient Number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP N1CORDER table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
CORDERIDIS-H: CORD/PREG: Identification of a Clinical Order N1CORDIDCHAR32SYSUUID_C
EINRIInstitution EINRICHAR4Assigned to domainALPHAEINRIEIN
REFTYPIS-H: CORD/PREG: Ind. Reference Type Patient - Prov. Patient N1CORDREFTYPCHAR1N1CORDREFTYP
PATNRIS-H: Patient Number PATNRCHAR10Assigned to domainALPHAPATNRPAT
PAPIDIS-H: Provisional Patient Number ISH_PAPIDCHAR10Assigned to domainALPHAISH_PAPID
ETRBYIS-H: CORD/PREG: Clinical Order Initiated By N1CORDETRBYCHAR1N1CORDETRBY
ETROEInitiating Organizational Unit N1CORDETROECHAR8Assigned to domainALPHAORGID
ETRGPInitiating Employee/Business Partner N1CORDETRGPCHAR10Assigned to domainALPHARI_KUNNR
ORDDEPInitiating Department N1CORDDEPCHAR8Assigned to domainALPHAORGID
ORDPRIPrioritization for Request/Movement (Internal) N1APRI_DNUMC3N1APRI
CORDTITLEIS-H: CORD/PREG: Title of Clinical Order N1CORDTITLECHAR30N1CORDTITLE
PRGNROrder Number N1CORDNRCHAR10ALPHAN1CORDNR
RCKRUFClinical Order - Callback Number N1CORDRCKRUFCHAR30N1CORDRCKRUF
KANAMIS-H: CORD/PREG: Short Anamnesis for Clinical Order N1CORDANAMCHAR50TEXT50
KALTXIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
FRAGEIS-H: CORD/PREG: Questions N1CORDFRAGECHAR50TEXT50
FRLTXIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
SCHWKZIndicator that Patient Is Pregnant N1CORDSCHWANGERCHAR1N1SCHWANGER
SCHWOWeek of Pregnancy SCHWOCHENUMC2NUMC02
IFGDegree of Infection - Internal Format N1IFG_INTNUMC2NUMC2
RMCORDComment for Clinical Order N1CORDBMKGCHAR50TEXT50
RMLTXIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
WLPRIIS-H: Priority for Preregistration/Waiting List Management WLPRICHAR2Assigned to domainALPHAWLPRI
WLTYPIS-H: Waiting List ISH_WLTYPECHAR6CHAR6
WLREMIS-H: Preregistration Status 'Inactive' Indicator ISH_WLSTREMOCHAR1XFELD
WLRDTIS-H: Date when Movement Removed From Waiting List ISH_WLRDATDATS8DATUM
WLRRNIS-H: Reason for Removal from Waiting List ISH_WLRRSNCHAR3CHAR3
WLSTAIS-H: Preregistration/Waiting List Status ISH_WLSTATUSCHAR2CHAR2
WLHSPIS-H: Waiting List Postdischarge Hospital ISH_WLHOSPCHAR10Assigned to domainALPHARI_KUNNR
WLADTIS-H: Date when Patient Added to Waiting List ISH_WLADATDATS8DATUM
ABSBDTIS-H: Start Date of Waiting List Absence ISH_ABSBDTDATS8DATE
ABSEDTIS-H: End Date of Waiting List Absence ISH_ABSEDTDATS8DATE
ABSESNIS-H: Reason for Temporary Absence From Waiting List ISH_ABSRSNCHAR3ALPHAISH_ABSRSN
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERTIMIS-H: Time Record Created RI_ERTIMTIMS6UHRZT
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPTIMIS-H: Time of Last Change RI_UPTIMTIMS6UHRZT
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
STORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
STUSRIS-H: Name of User who Canceled Data Record STORN_USERCHAR12USNAM
STDATDate of Cancellation STORN_DATDATS8RI_DATUM
STTIMETime of Cancellation ISH_STORN_TIMTIMS6UHRZT
STOIDIS-H: Reason for Cancellation N1CORDSTOIDCHAR3Assigned to domainN1STOID
USER1IS-H: User-Defined Field 1 ISH_PREGUSER1CHAR20ISH_PREGUSER1
USER2IS-H: User-Defined Field 2 ISH_PREGUSER2CHAR20ISH_PREGUSER2
USER3IS-H: User-Defined Field 3 ISH_PREGUSER3DATS8ISH_PREGUSER3
USER4IS-H: User-Defined Field 4 ISH_PREGUSER4DATS8ISH_PREGUSER4
USER5IS-H: User-Defined Field 5 ISH_PREGUSER5CHAR50ISH_PREGUSER5
USER6IS-H: User-Defined Field 6 ISH_PREGUSER6CHAR1ISH_PREGUSER6
USER7IS-H: User-Defined Field 7 ISH_PREGUSER7CHAR1ISH_PREGUSER7
CREATTYPCORD: Creation Type N1CORDCREATTYPCHAR1N1CORDCREATTYP

Key field Non-key field



How do I retrieve data from SAP table N1CORDER using ABAP code

The following ABAP code Example will allow you to do a basic selection on N1CORDER to SELECT all data from the table
DATA: WA_N1CORDER TYPE N1CORDER.

SELECT SINGLE *
FROM N1CORDER
INTO CORRESPONDING FIELDS OF WA_N1CORDER
WHERE...

How to access SAP table N1CORDER

Within an ECC or HANA version of SAP you can also view further information about N1CORDER 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!