SAP ABAP View N1MEV_INGREDIENT (IS-H*MED : View of Ingredients)
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 N1MEV_INGREDIENT  
Short Description IS-H*MED : View of Ingredients    
Root table N1FOFOTYPEA   IS-H*MED: Usage Type - Drug Assignment 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 N1FOFOTYPEA N1FOFOTYPEA
2 TN1FORMTYPE  
3 TN1FORMTYPET  
4 N1FORMULARY  
5 N1FORMULARYT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 TN1FORMTYPE MANDT JL EQ 0 0
2 N1FOFOTYPEA MANDT JR EQ AND 0 0
3 TN1FORMTYPE FORMTYID JL EQ 0 0
4 N1FOFOTYPEA FORMTYID JR EQ AND 0 0
5 TN1FORMTYPE MANDT JL EQ 0 0
6 TN1FORMTYPET MANDT JR EQ AND 0 0
7 TN1FORMTYPE FORMTYID JL EQ 0 0
8 TN1FORMTYPET FORMTYID JR EQ AND 0 0
9 N1FORMULARY MANDT JL EQ 0 0
10 N1FOFOTYPEA MANDT JR EQ AND 0 0
11 N1FORMULARY DRUGID JL EQ 0 0
12 N1FOFOTYPEA DRUGID JR EQ AND 0 0
13 N1FORMULARY MANDT JL EQ 0 0
14 N1FORMULARYT MANDT JR EQ AND 0 0
15 N1FORMULARY DRUGID JL EQ 0 0
16 N1FORMULARYT DRUGID JR EQ AND 0 0
17 TN1FORMTYPET SPRAS JL EQ 0 0
18 N1FORMULARYT SPRAS JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT N1FOFOTYPEA MANDT   MANDT Client
2 DRUGID N1FOFOTYPEA DRUGID   N1ME_DRUGID Medication: Drug ID
3 FORMTYID N1FOFOTYPEA FORMTYID   N1ME_FORMTYID ID of Drug Type
4 SPRAST TN1FORMTYPET SPRAS   SPRAS Language Key
5 FORMTY TN1FORMTYPET FORMTY   N1ME_FORMTY Drug Type
6 CATID N1FORMULARY CATID   N1ME_CATID Identification of Internal Drug Catalog (Formulary)
7 DRUGNAME N1FORMULARYT DRUGNAME   N1ME_DRUGNAME Mnemonic (Drug Name)
8 SPRASD N1FORMULARYT SPRAS   SPRAS Language Key
9 DESCRLT N1FORMULARYT DESCRLT   N1ME_DRUGIDDESC Medication: Drug Description
                 
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 472