SAP ABAP View BW_FI_TV_PLAN (View for Travel Plan Data Collection for BW)
Hierarchy
☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV (Application Component) Travel Management
     ⤷ FTBW (Package) Data Transfer FI-TV to BW
Basic Data
View Type D Database View 
Database View BW_FI_TV_PLAN  
Short Description View for Travel Plan Data Collection for BW    
Root table FTPT_PLAN   General Plan Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 FTPT_PLAN FTPT_PLAN
2 FTPT_VARIANT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 FTPT_VARIANT MANDT JL EQ 0 0
2 FTPT_PLAN MANDT JR EQ AND 0 0
3 FTPT_VARIANT PERNR JL EQ 0 0
4 FTPT_PLAN PERNR JR EQ AND 0 0
5 FTPT_VARIANT REINR JL EQ 0 0
6 FTPT_PLAN REINR JR EQ AND 0 0
7 FTPT_VARIANT PLANNR JL EQ 0 0
8 FTPT_PLAN PLANNR JR EQ AND 0 0
9 FTPT_VARIANT STATUS EQ '2' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT FTPT_PLAN MANDT   MANDT Client
2 PERNR FTPT_PLAN PERNR   PERNR_D Personnel Number
3 REINR FTPT_PLAN REINR   REINR Trip Number
4 PLANNR FTPT_PLAN PLANNR   PLAN_NR Travel Plan Number (Sequential Number)
5 VARIANT_NR FTPT_VARIANT VARIANT   VARIANT_NR Plan variant number (sequential number)
6 VARIANTVRS FTPT_VARIANT VARIANTVRS   VARIANT_VERSION Version of travel plan
7 REC_LOCATOR FTPT_VARIANT REC_LOCATOR   PNR_RECORD_LOCATOR Passenger Name Record Locator
8 VARIANT_STATUS FTPT_VARIANT STATUS   VARIANT_STAT Variant status
9 ACTIVITY_TYPE FTPT_PLAN ACTIVITY_TYPE   PLAN_ACTIVITY Trip Activity Type
10 PLAN_STATUS FTPT_PLAN STATUS   PLAN_STATUS Travel Plan Status
                 
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