SAP Table NLEM

IS-H*MED: Medical Service

NLEM (IS-H*MED: Medical Service) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NLEM to other SAP tables.

NLEM table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

LNRLS

IS-H: Service Sequence Number

LNRLS

CHAR

EINRI

Institution

EINRI

TN01

CHAR

PATNR

IS-H: Patient Number

PATNR

NPAT

CHAR

STOID

Reason for Canceling Medical Object

N1STOID

N1STGR

CHAR

LSSTAE

Service Status - User-Specific

N1LSSTAE

N1LSSTA

CHAR

ANFID

Identification of a Request (Number)

ANFID

N1ANF

NUMC

NTRKZ

Indicator for Subsequently Added Service

NTRKZ

CHAR

Possible values

X	Yes
NULL	No

WBGDT

Desired Start Date of a Service

W_BDT_LS

DATS

WBGZT

Desired Start Time of a Service

W_BZT_LS

TIMS

ERGTX

Supplementary Text

N1ERGTX

CHAR

ERLTX

Indicator that Long Text Exists

RI_LGTXT

CHAR

Possible values

X	Yes
NULL	No

BEFR

Service Time Limit

N1BEFR

INT1

BFEINH

Unit for Time Limit

N1BEFEH

CHAR

Possible values

T	Day
W	Week
M	Month

BFENDDT

End Date of Service with Time Limit

N1BFENDDT

DATS

SORTLEIST

Sort Number

N1_BEWNR

NUMC

WBZPI

Time Interpretation - Internal Format

N1ZPI_INT

CHAR

DAUER

IS-H: Duration in Minutes for Treatment Appointment

ISH_APTIME

NUMC

ZIMMR

IS-H: Building ID of Room

ISH_ZIMMID

NBAU

CHAR

IFG

Degree of Infection - Internal Format

N1IFG_INT

NUMC

ANERF

Anesthetist Required

N1ANERF

CHAR

Possible values

X	Yes
NULL	No

LSLOK

IS-H: Localization of Service

N1LSLOK

TN26E

CHAR

PATEIN

Patient Consent

N1PATEIN

CHAR

Possible values

O	Required
X	Exists
NULL	Not required

PMEDFG

Surgeon's Release

N1PMEDFG

CHAR

Possible values

X	Yes
NULL	No

PMEDVS

Premedication Complete

N1PMEDVS

CHAR

Possible values

X	Yes
NULL	No

PZMAN

Plan Time Manually Fixed

N1PZMAN

CHAR

Possible values

X	Yes
NULL	No

ANKLS

Anchor Service Indicator

N1ANKLS

CHAR

Possible values

NULL	No Anchor Service
X	Main Surgery
N	Secondary Surgery
P	Service Anchor
A	Anesthesia Anchor Service

OPNR

Surgery Number

N1OPNR

CHAR

FALNR

IS-H: Case Number

FALNR

CHAR

ERBOE

IS-H: Organizational Unit that Performs the Service

ERBOE

CHAR

IBGDT

IS-H: Date when Service Performance Starts (Actual)

I_BDT_LS

DATS

IBZT

IS-H: Time when Service Performance Starts (Actual)

I_BZT_LS

TIMS

N1MEDLEI

Medical Service Indicator

N1MEDLEI

CHAR

Possible values

X	Yes
NULL	No

N1PFLLEI

Nursing Service Indicator

N1PFLLEI

CHAR

Possible values

X	Yes
NULL	No

DOCXS

IS-H: Checkbox to Select a Row

RI_MARK

CHAR

Possible values

X	Yes
NULL	No

TEAMXS

IS-H: Checkbox to Select a Row

RI_MARK

CHAR

Possible values

X	Yes
NULL	No

MATXS

IS-H: Checkbox to Select a Row

RI_MARK

CHAR

Possible values

X	Yes
NULL	No

PATNUE

Patient Fasting Indicator

N1PATNUE

CHAR

Possible values

X	Yes
NULL	No

TERMINF

Appointment Released Indicator

N1TERMINF

CHAR

LIDI

Position ID Internal

N1LID_INT

NUMC

VKGID

IS-H: CORD/PREG: ID of an Order Item (Preregistration)

N1VKGID

N1VKG

NUMC

LNRAPP

IS-H: Sequence Number of Provisional Appointment

ISH_LNRAPP

CHAR

TMNID

IS-H: Identification of Appointment

ISH_TMNID

NTMN

CHAR

VBUND

N1LEMVBD

CHAR

Possible values

X	Yes
NULL	No

PAPID

IS-H: Provisional Patient Number

ISH_PAPID

NPAP

CHAR

HIC_FREE_MED

Indicator for Noncovered Service

NWAT_HIC_FREE

CHAR

Possible values

X	On
NULL	Off

CYSRVTPLID

CORD: ID of Cyclical Service Template

N1CYSRVTPLID

CHAR

CYDAT

CORD Cycle Date

N1CORD_CYDAT

DATS

CYTIM

CORD: Cycle Time

N1CORD_CYTIM

TIMS

CYDEFID

Unique ID of Cycle Definition

N1CYDEFID

NUMC

GENCYID

Generic Cycle Key

N1GENCYKEY

NUMC

NLEM foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
NLEM	ANFID	NLEM	MANDT	N1ANF	IS-H*MED: Request	MANDT
NLEM	ANFID	NLEM	EINRI	N1ANF	IS-H*MED: Request	EINRI
NLEM	ANFID	NLEM	ANFID	N1ANF	IS-H*MED: Request	ANFID
NLEM	EINRI	NLEM	MANDT	TN01	IS-H: Institutions	MANDT
NLEM	EINRI	NLEM	EINRI	TN01	IS-H: Institutions	EINRI
NLEM	LSLOK	NLEM	MANDT	TN26E	IS-H: Definition of Medical Localizations	MANDT
NLEM	LSLOK	NLEM	EINRI	TN26E	IS-H: Definition of Medical Localizations	EINRI
NLEM	LSLOK	NLEM	LSLOK	TN26E	IS-H: Definition of Medical Localizations	DIALO
NLEM	LSSTAE	NLEM	EINRI	N1LSSTA	IS-H*MED: Service Status	EINRI
NLEM	LSSTAE	NLEM	LSSTAE	N1LSSTA	IS-H*MED: Service Status	LSSTAE
NLEM	LSSTAE	NLEM	MANDT	N1LSSTA	IS-H*MED: Service Status	MANDT
NLEM	MANDT	NLEM	MANDT	T000	Clients	MANDT
NLEM	PAPID	NLEM	PAPID	NPAP	IS-H: Provisional Patient Master Data	PAPID
NLEM	PAPID	NLEM	MANDT	NPAP	IS-H: Provisional Patient Master Data	MANDT
NLEM	PATNR	NLEM	MANDT	NPAT	IS-H: Patient Master Data (General)	MANDT
NLEM	PATNR	NLEM	PATNR	NPAT	IS-H: Patient Master Data (General)	PATNR
NLEM	STOID	NLEM	MANDT	N1STGR	IS-H: Cancellation Reasons	MANDT
NLEM	STOID	NLEM	EINRI	N1STGR	IS-H: Cancellation Reasons	EINRI
NLEM	STOID	NLEM	STOID	N1STGR	IS-H: Cancellation Reasons	STOID
NLEM	TMNID	NLEM	MANDT	NTMN	IS-H: Patient-Specific Appointments (Header Table for NAPP)	MANDT
NLEM	TMNID	NLEM	TMNID	NTMN	IS-H: Patient-Specific Appointments (Header Table for NAPP)	TMNID
NLEM	VKGID	NLEM	MANDT	N1VKG	IS-H: Item of Clinical Order (Preregistration)	MANDT
NLEM	VKGID	NLEM	VKGID	N1VKG	IS-H: Item of Clinical Order (Preregistration)	VKGID
NLEM	ZIMMR	NLEM	MANDT	NBAU	IS-H: Building Units	MANDT
NLEM	ZIMMR	NLEM	ZIMMR	NBAU	IS-H: Building Units	BAUID