SAP ABAP View VAFIHST (Completed PM orders)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       IWO1 (Package) Appl. Development R/3 Plant Maintenance Order Processing
Basic Data
View Type D Database View 
Database View VAFIHST  
Short Description Completed PM orders    
Root table AFIH   Maintenance order header 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 AFIH AFIH
2 JEST  
3 AUFK  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 AFIH AUFNR JL EQ 0 0
2 AUFK AUFNR JR EQ AND 0 0
3 AUFK OBJNR JL EQ 0 0
4 JEST OBJNR JR EQ AND 0 0
5 AFIH MANDT JL EQ 0 0
6 AUFK MANDT JR EQ AND 0 0
7 AFIH MANDT JL EQ 0 0
8 JEST MANDT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT AFIH MANDT   MANDT Client
2 AUFNR AFIH AUFNR   AUFNR Order Number
3 STAT JEST STAT   J_STATUS Object status
4 INACT JEST INACT   J_INACT Indicator: Status Is Inactive
5 IPHAS AFIH IPHAS   PM_PHASE Maintenance Processing Phase
6 ADDAT AFIH ADDAT   ADDAT PM Order: Reference Date
7 OBJNR AUFK OBJNR   J_OBJNR Object number
8 IWERK AFIH IWERK   IWERK Maintenance Planning Plant
                 
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