NLEM SAP (IS-H*MED: Medical Service) Table details

Dictionary Type: Table
Description: IS-H*MED: Medical Service




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




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

NLEM is a standard SAP Table which is used to store IS-H*MED: Medical Service data and is available within R/3 SAP systems depending on the version and release level.

The NLEM table consists of various fields, each holding specific information or linking keys about IS-H*MED: Medical Service data available in SAP. These include LNRLS (IS-H: Service Sequence Number), EINRI (Institution), PATNR (IS-H: Patient Number), STOID (Reason for Canceling Medical Object).. 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 or numeric)


SAP NLEM 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 MANDTCLNT3T000MANDT
LNRLSIS-H: Service Sequence Number LNRLSCHAR10ALPHALNRLS
EINRIInstitution EINRICHAR4TN01ALPHAEINRIEIN
PATNRIS-H: Patient Number PATNRCHAR10NPATALPHAPATNRPAT
STOIDReason for Canceling Medical Object N1STOIDCHAR3N1STGRN1STOID
LSSTAEService Status - User-Specific N1LSSTAECHAR3N1LSSTAN1LSSTAE
ANFIDIdentification of a Request (Number) ANFIDNUMC8N1ANFANFID
NTRKZIndicator for Subsequently Added Service NTRKZCHAR1XFELD
WBGDTDesired Start Date of a Service W_BDT_LSDATS8RI_DATUM
WBGZTDesired Start Time of a Service W_BZT_LSTIMS6UHRZT
ERGTXSupplementary Text N1ERGTXCHAR50TEXT50
ERLTXIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
BEFRService Time Limit N1BEFRINT13N1I1
BFEINHUnit for Time Limit N1BEFEHCHAR1N1BEFEH
BFENDDTEnd Date of Service with Time Limit N1BFENDDTDATS8DATS
SORTLEISTSort Number N1_BEWNRNUMC2N1N002
WBZPITime Interpretation - Internal Format N1ZPI_INTCHAR2N1ZPI_INT
DAUERIS-H: Duration in Minutes for Treatment Appointment ISH_APTIMENUMC4ISH_DZEIT
ZIMMRIS-H: Building ID of Room ISH_ZIMMIDCHAR8NBAUALPHABAUID
IFGDegree of Infection - Internal Format N1IFG_INTNUMC2NUMC2
ANERFAnesthetist Required N1ANERFCHAR1XFELD
LSLOKIS-H: Localization of Service N1LSLOKCHAR2TN26EALPHAN2_DIALO
PATEINPatient Consent N1PATEINCHAR1N1PATEIN1
PMEDFGSurgeon's Release N1PMEDFGCHAR1XFELD
PMEDVSPremedication Complete N1PMEDVSCHAR1XFELD
PZMANPlan Time Manually Fixed N1PZMANCHAR1XFELD
ANKLSAnchor Service Indicator N1ANKLSCHAR1N1ANKLS
OPNRSurgery Number N1OPNRCHAR10CHAR10
FALNRIS-H: Case Number FALNRCHAR10Assigned to domainALPHAFALNRFAL
ERBOEIS-H: Organizational Unit that Performs the Service ERBOECHAR8Assigned to domainALPHAORGID
IBGDTIS-H: Date when Service Performance Starts (Actual) I_BDT_LSDATS8RI_DATUM
IBZTIS-H: Time when Service Performance Starts (Actual) I_BZT_LSTIMS6UHRZT
N1MEDLEIMedical Service Indicator N1MEDLEICHAR1XFELD
N1PFLLEINursing Service Indicator N1PFLLEICHAR1XFELD
DOCXSIS-H: Checkbox to Select a Row RI_MARKCHAR1XFELD
TEAMXSIS-H: Checkbox to Select a Row RI_MARKCHAR1XFELD
MATXSIS-H: Checkbox to Select a Row RI_MARKCHAR1XFELD
PATNUEPatient Fasting Indicator N1PATNUECHAR1XFELD
TERMINFAppointment Released Indicator N1TERMINFCHAR1CHAR1
LIDIPosition ID Internal N1LID_INTNUMC3NUM3
VKGIDIS-H: CORD/PREG: ID of an Order Item (Preregistration) N1VKGIDNUMC8N1VKGN1VKGID
LNRAPPIS-H: Sequence Number of Provisional Appointment ISH_LNRAPPCHAR10ALPHAISH_LNRAPP
TMNIDIS-H: Identification of Appointment ISH_TMNIDCHAR10NTMNALPHAISH_LNRAPP
VBUND N1LEMVBDCHAR1XFELD
PAPIDIS-H: Provisional Patient Number ISH_PAPIDCHAR10NPAPALPHAISH_PAPID
HIC_FREE_MEDIndicator for Noncovered Service NWAT_HIC_FREECHAR1ISH_ON_OFF
CYSRVTPLIDCORD: ID of Cyclical Service Template N1CYSRVTPLIDCHAR32SYSUUID_C
CYDATCORD Cycle Date N1CORD_CYDATDATS8N1DATE
CYTIMCORD: Cycle Time N1CORD_CYTIMTIMS6N1TIME
CYDEFIDUnique ID of Cycle Definition N1CYDEFIDNUMC10N1CYDEFID
GENCYIDGeneric Cycle Key N1GENCYKEYNUMC10N1GENCYKEY

Key field Non-key field



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

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

SELECT SINGLE *
FROM NLEM
INTO CORRESPONDING FIELDS OF WA_NLEM
WHERE...

How to access SAP table NLEM

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