SAP ABAP Table N1PRLEM (IS-H*MED: PATREG: Leistungen)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ N1PR (Package) IS-H*MED: Patientenregister

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N1PRLEM	Table Relationship Diagram
Short Description	IS-H*MED: PATREG: Leistungen

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	TLNRID	☑	N1PRTLNRID	N1PRTLNRID	CHAR	10	0	PATREG: Teilnehmer ID	N1PRTLNR
3	LNRLS	☑	LNRLS	LNRLS	CHAR	10	0	IS-H: Service Sequence Number
4	ORGID	☐	ORGID_LS	ORGID	CHAR	8	0	IS-H: Org. Unit (for OU-Related Service Entry Only)	*
5	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	N1PRPATZUO
6	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	N1PRFAL
7	LEIST	☐	TARLS	TARLS	CHAR	10	0	IS-H: Service in Service Catalog	*
8	ANFOE	☐	ANFOE	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit Requesting Service	*
9	ANFON	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
10	ERBOE	☐	ERBOE	ORGID	CHAR	8	0	IS-H: Organizational Unit that Performs the Service	*
11	ERBON	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
12	HAUST	☐	TARID	TARID	CHAR	2	0	IS-H: Service Catalog Identification Key	*
13	IMENG	☐	I_MENG_LS	LEISMENGE	NUMC	4	0	Service Quantity
14	IBGDT	☐	I_BDT_LS	RI_DATUM	DATS	8	0	IS-H: Date when Service Performance Starts (Actual)
15	IENDT	☐	I_EDT_LS	RI_DATUM	DATS	8	0	IS-H: Date when Service Performance Ends (Actual)
16	IBZT	☐	I_BZT_LS	UHRZT	TIMS	6	0	IS-H: Time when Service Performance Starts (Actual)
17	IEZT	☐	I_EZT_LS	UHRZT	TIMS	6	0	IS-H: Time Service Performance Ends (Actual)
18	PMENG	☐	P_MENG_LS	LEISMENGE	NUMC	4	0	IS-H: Service Quantity (Planned)
19	PBGDT	☐	P_BDT_LS	RI_DATUM	DATS	8	0	IS-H: Start Date of Service Performance (PLANNED)
20	PENDT	☐	P_EDT_LS	RI_DATUM	DATS	8	0	IS-H: Date Service Performance Ends (PLANNED)
21	PBZT	☐	P_BZT_LS	UHRZT	TIMS	6	0	IS-H: Time Service Performance Starts (PLANNED)
22	PEZT	☐	P_EZT_LS	UHRZT	TIMS	6	0	IS-H: Time Service Performance Ends (PLANNED)
23	LEITX	☐	TEXT_LEI	LEIKTXT	CHAR	40	0	IS-H: Service Short Text (may Differ from Service Master)
24	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
25	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
26	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
27	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
28	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
29	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
30	REMRK	☐	ISH_REMRK	ISH_REMRK	CHAR	40	0	IS-H: User's Comment on Service
31	ANPOE	☐	ANPOE	ORGID	CHAR	8	0	IS-H: Nursing Org. Unit Requesting Service	*
32	ANPON	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
33	OTYPL	☐	ISH_OTYPL	ISH_OTYPL	CHAR	1	0	IS-H: Object Type of Service
34	STOID	☐	N1STOID	N1STOID	CHAR	3	0	Reason for Canceling Medical Object	*
35	STOTX	☐	N1STOTX	N1C015	CHAR	15	0	Text for Cancellation Reason
36	LSSTAE	☐	N1LSSTAE	N1LSSTAE	CHAR	3	0	Service Status - User-Specific	*
37	LSSTA	☐	N1LSSTA_D	N1LSSTA	CHAR	3	0	Service Status
38	LSTTX	☐	N1LSSTTXT	N1C010	CHAR	10	0	Service Status Text
39	ANFID	☐	ANFID	ANFID	NUMC	8	0	Identification of a Request (Number)	*
40	NTRKZ	☐	NTRKZ	XFELD	CHAR	1	0	Indicator for Subsequently Added Service
41	WBGDT	☐	W_BDT_LS	RI_DATUM	DATS	8	0	Desired Start Date of a Service
42	WBGZT	☐	W_BZT_LS	UHRZT	TIMS	6	0	Desired Start Time of a Service
43	ERGTX	☐	N1ERGTX	TEXT50	CHAR	50	0	Supplementary Text
44	ERLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
45	WBZPI	☐	N1ZPI_INT	N1ZPI_INT	CHAR	2	0	Time Interpretation - Internal Format
46	WBZPE	☐	N1ZPIE	N1ZPIE	CHAR	5	0	Time Interpretation - External Format
47	WBZTX	☐	N1ZPITXT	N1ZPITXT	CHAR	30	0	Text for Time Interpretation
48	DAUER	☐	ISH_APTIME	ISH_DZEIT	NUMC	4	0	IS-H: Duration in Minutes for Treatment Appointment
49	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	*
50	IFG	☐	N1IFG_INT	NUMC2	NUMC	2	0	Degree of Infection - Internal Format
51	IFGTX	☐	N1IFGTXT	N1IFGTXT	CHAR	15	0	Description of Degree of Infection
52	ANERF	☐	N1ANERF	XFELD	CHAR	1	0	Anesthetist Required
53	LSLOK	☐	N1LSLOK	N2_DIALO	CHAR	2	0	Localization of Service	*
54	PATEIN	☐	N1PATEIN	N1PATEIN1	CHAR	1	0	Patient Consent
55	PMEDFG	☐	N1PMEDFG	XFELD	CHAR	1	0	Surgeon's Release
56	PMEDVS	☐	N1PMEDVS	XFELD	CHAR	1	0	Premedication Complete
57	ANKLS	☐	N1ANKLS	N1ANKLS	CHAR	1	0	Anchor Service Indicator
58	N1MEDLEI	☐	N1MEDLEI	XFELD	CHAR	1	0	Medical Service Indicator
59	N1PFLLEI	☐	N1PFLLEI	XFELD	CHAR	1	0	Nursing Service Indicator
60	DOCXS	☐	RI_MARK	XFELD	CHAR	1	0	IS-H: Checkbox to Select a Row
61	TEAMXS	☐	RI_MARK	XFELD	CHAR	1	0	IS-H: Checkbox to Select a Row
62	MATXS	☐	RI_MARK	XFELD	CHAR	1	0	IS-H: Checkbox to Select a Row
63	PATNUE	☐	N1PATNUE	XFELD	CHAR	1	0	Patient Fasting Indicator
64	LIDI	☐	N1LID_INT	NUM3	NUMC	3	0	Position ID Internal
65	LGRTX	☐	N2_LAGERUN	N2_LAGERUN	CHAR	50	0	List of Position Types
66	VKGID	☐	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
67	TMNID	☐	ISH_TMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Identification of Appointment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N1PRLEM	FALNR	N1PRFAL	FALNR	KEY	1	CN
2	N1PRLEM	MANDT	T000	MANDT	KEY	1	CN
3	N1PRLEM	PATNR	N1PRPATZUO	PATNR	REF	C	CN
4	N1PRLEM	TLNRID	N1PRTLNR	TLNRID	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in