SAP ABAP Table VN1TPORDER (IS-H*MED: Medication; Update Structure for View V_N1TPORD)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	VN1TPORDER	Table Relationship Diagram
Short Description	IS-H*MED: Medication; Update Structure for View V_N1TPORD

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	TPID	☐	N1ME_TPID	N1ME_TPID	CHAR	10	0	Template ID
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
5	MOTX	☐	N1ME_MOTX	N1ME_MOTX	CHAR	60	0	Medication: Description of Order
6	MOSTX	☐	N1ME_MOSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Order - Comment
7	MOLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
8	MOTYPID	☐	N1ME_MOTYP	N1ME_MOTYP	NUMC	2	0	Medication: Type of Order	TN1OTYPE
9	APDEV	☐	N1ME_APDEVID		CHAR	3	0	Medication: Administration Device ID	TN1DEVICE
10	PHFORM	☐	N1ME_PHFORMID		CHAR	3	0	Medication: ID Dosage Form	TN1PHFORM
11	APROU	☐	N1ME_ROUTEID		CHAR	3	0	Medication: ID Administration Route	TN1ROUTE
12	ORDUR	☐	N1ME_ORDUR	N1ME_ORDUR	QUAN	12	3	Medication: Order - Order Duration
13	ORDURU	☐	N1ME_ORDURU	N1ME_ORDURU	UNIT	3	0	Medication: Order Duration Unit
14	MEDGRPID	☐	N1ME_MEDGRPID		CHAR	3	0	Medication: Drug Category Key	TN1MEDGROUP
15	INSTX	☐	N1ME_INSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Order - Preparation Directions
16	INLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
17	MOPRN	☐	N1ME_PRN	N1ME_PRN	CHAR	1	0	Medication: Order - PRN Indicator
18	PRNCSTX	☐	N1ME_PRNCOND	N1ME_PRNCOND	CHAR	80	0	Medication: Order - Check Condition
19	PRNCLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
20	OLDIS	☐	N1ME_OLDIS	N1ME_OLDIS	CHAR	1	0	Medication: Order - Take Home Medication
21	SLDOSE	☐	N1ME_SLDOSE	N1ME_SLDOSE	CHAR	1	0	Medication: Orders - Sliding Dose
22	IVTYPE	☐	N1ME_IVTYPE	N1ME_IVTYPE	CHAR	1	0	Medication: Order - Infusion Type
23	STRGTHDOS	☐	N1ME_STRGTHDOS	N1ME_STRGTHDOS	CHAR	1	0	Medication: Order - Dose Type
24	SELTYP	☐	N1ME_SELTYP	N1ME_SELTYP	CHAR	1	0	Medication: Order - Selection Type
25	PCALOCK	☐	N1ME_PCALOCK	N1ME_QUAN123	QUAN	12	3	Medication: PCA Lock Duration
26	PCALOCKU	☐	N1ME_PCALOCU	N1ME_UNIT	UNIT	3	0	Medication: Order - PCA Lock Duration Unit
27	PCAMAX	☐	N1ME_PCAMAX		INT1	3	0	Medication: PCA Number of Boli
28	PCAPER	☐	N1ME_PCAPER	N1ME_QUAN123	QUAN	12	3	Medication: Time Number of Boli
29	PCAPERU	☐	N1ME_PCAPERU	N1ME_UNIT	UNIT	3	0	Medication: Time Unit Number of Boli
30	COMPDOS	☐	N1ME_COMPDOS	N1ME_COMPDOS	CHAR	1	0	Medication: Dose Type for Compound
31	AL	☐	N1ME_AL	N2_DIALO	CHAR	2	0	Medication: Order - Localization (OBSOLETE)	TN26E
32	RCUSE	☐	N1ME_RCUSE		CHAR	5	0	Order: Medication - Reason for Usage
33	DC_USED	☐	N1ME_DC_USED	XFELD	CHAR	1	0	Medication: Order - Dose Calculator Used
34	VFCOIND	☐	N1ME_VFCOIND	XFELD	CHAR	1	0	Check Condition Indicator
35	ADOUTPAT	☐	N1ME_ADOUTPAT	XFELD	CHAR	1	0	Medication: Administration in IP/OC
36	FIXQUAN	☐	N1ME_FIXQUAN	N1ME_FIXQUAN	CHAR	1	0	Medication: Order Ind. for Fixed Recipe Qty for Compounds
37	ZNR	☐	N1ZNR	N1C010	CHAR	10	0	Cycle Key
38	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
39	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
40	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
41	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
42	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
43	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
44	TPTX	☐	N1ME_TPTX	N1ME_TPTX	CHAR	20	0	Template - Short Name
45	TPSTX	☐	N1ME_TPSTX	N1ME_TEXT_80	CHAR	80	0	Medication: Template - Description
46	TPLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
47	INPATIENT	☐	N1ME_IP_USE	ISH_ON_OFF	CHAR	1	0	Medication: Indicator, Inpatient Use
48	OUTPATIENT	☐	N1ME_OP_USE	ISH_ON_OFF	CHAR	1	0	Medication: Indicator, Outpatient Use
49	NMRF	☐	N1ME_NMRF	N1ME_NMRF	NUMC	4	0	Medication: Number of Repeats
50	IMDOSE	☐	N1ME_IMDOSE	XFELD	CHAR	1	0	Medication: Order - Immediate Dose
51	PURPOSE	☐	N1ME_ORD_PURPOSE	N1ME_ORD_PURPOSE	CHAR	1	0	Medication: Purpose of Order
52	DISPQUAN	☐	N1ME_DISPQUAN	N1ME_QUAN123	QUAN	12	3	Medication: Drug Dispensing Quantity
53	DISPQUANU	☐	N1ME_DISPQUANU	N1ME_UNIT	UNIT	3	0	Medication: Dispensing Quantity Unit
54	LOCID	☐	N1ME_LOCID		NUMC	4	0	ID Localization for Medication
55	.INCLUDE	☐				0	0	Structures for generating change document update programs
56	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VN1TPORDER	AL	TN26E	DIALO
2	VN1TPORDER	APDEV	TN1DEVICE	APDEVID
3	VN1TPORDER	APROU	TN1ROUTE	APROUID
4	VN1TPORDER	MANDT	T000	MANDT	KEY	1	CN
5	VN1TPORDER	MEDGRPID	TN1MEDGROUP	MEDGRPID
6	VN1TPORDER	MOTYPID	TN1OTYPE	MOTYPID
7	VN1TPORDER	PHFORM	TN1PHFORM	PHFORMID

History

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