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