SAP ABAP View VVIEXPMFL2OR (Functional Locations for Orders)
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX-BD (Application Component) Basic Data
     RE_EX_PM (Package) RE: Plant Maintenance
Basic Data
View Type D Database View 
Database View VVIEXPMFL2OR  
Short Description Functional Locations for Orders    
Root table AFIH   Maintenance order header 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 AFIH AFIH
2 AUFK AUFK
3 IFLOT  
4 ILOA  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 AFIH MANDT JL EQ 0 0
2 ILOA MANDT JR EQ AND 0 0
3 AFIH ILOAN JL EQ 0 0
4 ILOA ILOAN JR EQ AND 0 0
5 ILOA MANDT JL EQ 0 0
6 IFLOT MANDT JR EQ AND 0 0
7 ILOA TPLNR JL EQ 0 0
8 IFLOT TPLNR JR EQ AND 0 0
9 AFIH MANDT JL EQ 0 0
10 AUFK MANDT JR EQ AND 0 0
11 AFIH AUFNR JL EQ 0 0
12 AUFK AUFNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT ILOA MANDT   MANDT Client
2 AUFNR AUFK AUFNR   AUFNR Order Number
3 TPLNR ILOA TPLNR   TPLNR Functional Location
4 OBJNR_FL IFLOT OBJNR   J_OBJNR Object number
5 OBJNR_OR AUFK OBJNR   J_OBJNR Object number
6 ILOAN ILOA ILOAN   ILOAN Location and account assignment for technical object
7 AUART AUFK AUART   AUFART Order Type
8 AUTYP AUFK AUTYP   AUFTYP Order category
                 
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 600