SAP ABAP View V_N1TPORD (IS-H*MED: Medication; Template - Order + Text)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_N1TPORD
Short Description	IS-H*MED: Medication; Template - Order + Text
Root table	N1TPMEORDER	IS-H*MED: Medication, Drug Order Template

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	N1TPMEORDER	N1TPMEORDER
2	N1TPMEORDERT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	N1TPMEORDER	MANDT	JL	EQ				0	0
2	N1TPMEORDERT	MANDT	JR	EQ			AND	0	0
3	N1TPMEORDER	TPID	JL	EQ				0	0
4	N1TPMEORDERT	TPID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	N1TPMEORDER	MANDT		☐	MANDT	☐	Client
2	TPID	N1TPMEORDER	TPID		☐	N1ME_TPID	☐	Template ID
3	EINRI	N1TPMEORDER	EINRI		☐	EINRI	☐	IS-H: Institution
4	MOTX	N1TPMEORDER	MOTX		☐	N1ME_MOTX	☐	Medication: Description of Order
5	MOSTX	N1TPMEORDER	MOSTX		☐	N1ME_MOSTX	☐	Medication: Order - Comment
6	MOLTX	N1TPMEORDER	MOLTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
7	MOTYPID	N1TPMEORDER	MOTYPID		☐	N1ME_MOTYP	☐	Medication: Type of Order
8	APDEV	N1TPMEORDER	APDEV		☐	N1ME_APDEVID	☐	Medication: Administration Device ID
9	PHFORM	N1TPMEORDER	PHFORM		☐	N1ME_PHFORMID	☐	Medication: ID Dosage Form
10	APROU	N1TPMEORDER	APROU		☐	N1ME_ROUTEID	☐	Medication: ID Administration Route
11	ORDUR	N1TPMEORDER	ORDUR		☐	N1ME_ORDUR	☐	Medication: Order - Order Duration
12	ORDURU	N1TPMEORDER	ORDURU		☐	N1ME_ORDURU	☐	Medication: Order Duration Unit
13	MEDGRPID	N1TPMEORDER	MEDGRPID		☐	N1ME_MEDGRPID	☐	Medication: Drug Category Key
14	INSTX	N1TPMEORDER	INSTX		☐	N1ME_INSTX	☐	Medication: Order - Preparation Directions
15	INLTX	N1TPMEORDER	INLTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
16	MOPRN	N1TPMEORDER	MOPRN		☐	N1ME_PRN	☐	Medication: Order - PRN Indicator
17	PRNCSTX	N1TPMEORDER	PRNCSTX		☐	N1ME_PRNCOND	☐	Medication: Order - Check Condition
18	PRNCLTX	N1TPMEORDER	PRNCLTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
19	OLDIS	N1TPMEORDER	OLDIS		☐	N1ME_OLDIS	☐	Medication: Order - Take Home Medication
20	SLDOSE	N1TPMEORDER	SLDOSE		☐	N1ME_SLDOSE	☐	Medication: Orders - Sliding Dose
21	IVTYPE	N1TPMEORDER	IVTYPE		☐	N1ME_IVTYPE	☐	Medication: Order - Infusion Type
22	STRGTHDOS	N1TPMEORDER	STRGTHDOS		☐	N1ME_STRGTHDOS	☐	Medication: Order - Dose Type
23	SELTYP	N1TPMEORDER	SELTYP		☐	N1ME_SELTYP	☐	Medication: Order - Selection Type
24	PCALOCK	N1TPMEORDER	PCALOCK		☐	N1ME_PCALOCK	☐	Medication: PCA Lock Duration
25	PCALOCKU	N1TPMEORDER	PCALOCKU		☐	N1ME_PCALOCU	☐	Medication: Order - PCA Lock Duration Unit
26	PCAMAX	N1TPMEORDER	PCAMAX		☐	N1ME_PCAMAX	☐	Medication: PCA Number of Boli
27	PCAPER	N1TPMEORDER	PCAPER		☐	N1ME_PCAPER	☐	Medication: Time Number of Boli
28	PCAPERU	N1TPMEORDER	PCAPERU		☐	N1ME_PCAPERU	☐	Medication: Time Unit Number of Boli
29	COMPDOS	N1TPMEORDER	COMPDOS		☐	N1ME_COMPDOS	☐	Medication: Dose Type for Compound
30	AL	N1TPMEORDER	AL		☐	N1ME_AL	☐	Medication: Order - Localization (OBSOLETE)
31	RCUSE	N1TPMEORDER	RCUSE		☐	N1ME_RCUSE	☐	Order: Medication - Reason for Usage
32	DC_USED	N1TPMEORDER	DC_USED		☐	N1ME_DC_USED	☐	Medication: Order - Dose Calculator Used
33	VFCOIND	N1TPMEORDER	VFCOIND		☐	N1ME_VFCOIND	☐	Check Condition Indicator
34	ADOUTPAT	N1TPMEORDER	ADOUTPAT		☐	N1ME_ADOUTPAT	☐	Medication: Administration in IP/OC
35	FIXQUAN	N1TPMEORDER	FIXQUAN		☐	N1ME_FIXQUAN	☐	Medication: Order Ind. for Fixed Recipe Qty for Compounds
36	ZNR	N1TPMEORDER	ZNR		☐	N1ZNR	☐	Cycle Key
37	ERDAT	N1TPMEORDER	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
38	ERTIM	N1TPMEORDER	ERTIM		☐	RI_ERTIM	☐	IS-H: Time Record Created
39	ERUSR	N1TPMEORDER	ERUSR		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
40	UPDAT	N1TPMEORDER	UPDAT		☐	RI_UPDAT	☐	IS-H: Date of Last Change
41	UPTIM	N1TPMEORDER	UPTIM		☐	RI_UPTIM	☐	IS-H: Time of Last Change
42	UPUSR	N1TPMEORDER	UPUSR		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
43	TPTX	N1TPMEORDERT	TPTX		☐	N1ME_TPTX	☐	Template - Short Name
44	TPSTX	N1TPMEORDERT	TPSTX		☐	N1ME_TPSTX	☐	Medication: Template - Description
45	TPLTX	N1TPMEORDERT	TPLTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
46	INPATIENT	N1TPMEORDER	INPATIENT		☐	N1ME_IP_USE	☐	Medication: Indicator, Inpatient Use
47	OUTPATIENT	N1TPMEORDER	OUTPATIENT		☐	N1ME_OP_USE	☐	Medication: Indicator, Outpatient Use
48	NMRF	N1TPMEORDER	NMRF		☐	N1ME_NMRF	☐	Medication: Number of Repeats
49	IMDOSE	N1TPMEORDER	IMDOSE		☐	N1ME_IMDOSE	☐	Medication: Order - Immediate Dose
50	PURPOSE	N1TPMEORDER	PURPOSE		☐	N1ME_ORD_PURPOSE	☐	Medication: Purpose of Order
51	DISPQUAN	N1TPMEORDER	DISPQUAN		☐	N1ME_DISPQUAN	☐	Medication: Drug Dispensing Quantity
52	DISPQUANU	N1TPMEORDER	DISPQUANU		☐	N1ME_DISPQUANU	☐	Medication: Dispensing Quantity Unit
53	LOCID	N1TPMEORDER	LOCID		☐	N1ME_LOCID	☐	ID Localization for Medication

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	473