P_WORKCENTERACTIVITY2

@AbapCatalog.sqlViewName: 'PWRKCNTRACT2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_WorkCenterActivity2 

  as select from P_WorkCenterActivity1 as wrkctract
  
  // Texts standard value key parameters

  left outer to one join I_StandardWorkFormulaParamText as tc20t1
    on  tc20t1.StandardWorkFormulaParameter = wrkctract.StandardWorkFormulaParam1
    and tc20t1.Language = $session.system_language
  left outer to one join I_StandardWorkFormulaParamText as tc20t2
    on  tc20t2.StandardWorkFormulaParameter = wrkctract.StandardWorkFormulaParam2
    and tc20t2.Language = $session.system_language
  left outer to one join I_StandardWorkFormulaParamText as tc20t3
    on  tc20t3.StandardWorkFormulaParameter = wrkctract.StandardWorkFormulaParam3
    and tc20t3.Language = $session.system_language
  left outer to one join I_StandardWorkFormulaParamText as tc20t4
    on  tc20t4.StandardWorkFormulaParameter = wrkctract.StandardWorkFormulaParam4
    and tc20t4.Language = $session.system_language
  left outer to one join I_StandardWorkFormulaParamText as tc20t5
    on  tc20t5.StandardWorkFormulaParameter = wrkctract.StandardWorkFormulaParam5
    and tc20t5.Language = $session.system_language
  left outer to one join I_StandardWorkFormulaParamText as tc20t6
    on  tc20t6.StandardWorkFormulaParameter = wrkctract.StandardWorkFormulaParam6
    and tc20t6.Language = $session.system_language    
  
  // Text actitivty types

  left outer to one join I_CostCenterActivityTypeText as acttypetxt1
    on  acttypetxt1.ControllingArea     =  ControllingArea1
    and acttypetxt1.CostCtrActivityType =  CostCtrActivityType1
    and acttypetxt1.ValidityEndDate     >= $session.system_date
    and acttypetxt1.ValidityStartDate   <= $session.system_date
    and acttypetxt1.Language            =  $session.system_language
  left outer to one join I_CostCenterActivityTypeText as acttypetxt2
    on  acttypetxt2.ControllingArea     =  ControllingArea2
    and acttypetxt2.CostCtrActivityType =  CostCtrActivityType2
    and acttypetxt2.ValidityEndDate     >= $session.system_date
    and acttypetxt2.ValidityStartDate   <= $session.system_date
    and acttypetxt2.Language            =  $session.system_language
  left outer to one join I_CostCenterActivityTypeText as acttypetxt3
    on  acttypetxt3.ControllingArea     =  ControllingArea3
    and acttypetxt3.CostCtrActivityType =  CostCtrActivityType3
    and acttypetxt3.ValidityEndDate     >= $session.system_date
    and acttypetxt3.ValidityStartDate   <= $session.system_date
    and acttypetxt3.Language            =  $session.system_language
  left outer to one join I_CostCenterActivityTypeText as acttypetxt4
    on  acttypetxt4.ControllingArea     =  ControllingArea4
    and acttypetxt4.CostCtrActivityType =  CostCtrActivityType4
    and acttypetxt4.ValidityEndDate     >= $session.system_date
    and acttypetxt4.ValidityStartDate   <= $session.system_date
    and acttypetxt4.Language            =  $session.system_language
  left outer to one join I_CostCenterActivityTypeText as acttypetxt5
    on  acttypetxt5.ControllingArea     =  ControllingArea5
    and acttypetxt5.CostCtrActivityType =  CostCtrActivityType5
    and acttypetxt5.ValidityEndDate     >= $session.system_date
    and acttypetxt5.ValidityStartDate   <= $session.system_date
    and acttypetxt5.Language            =  $session.system_language
  left outer to one join I_CostCenterActivityTypeText as acttypetxt6
    on  acttypetxt6.ControllingArea     =  ControllingArea6
    and acttypetxt6.CostCtrActivityType =  CostCtrActivityType6
    and acttypetxt6.ValidityEndDate     >= $session.system_date
    and acttypetxt6.ValidityStartDate   <= $session.system_date
    and acttypetxt6.Language            =  $session.system_language

  // Text alternative activity description

  left outer to one join I_ActivityAlternativeText as actalttxt1
    on  actalttxt1.CostCenterActivityAltvDescID = CostCenterActivityAltvDescID1
    and actalttxt1.Language                     = $session.system_language
  left outer to one join I_ActivityAlternativeText as actalttxt2
    on  actalttxt2.CostCenterActivityAltvDescID = CostCenterActivityAltvDescID2
    and actalttxt2.Language                     = $session.system_language
  left outer to one join I_ActivityAlternativeText as actalttxt3
    on  actalttxt3.CostCenterActivityAltvDescID = CostCenterActivityAltvDescID3
    and actalttxt3.Language                     = $session.system_language
  left outer to one join I_ActivityAlternativeText as actalttxt4
    on  actalttxt4.CostCenterActivityAltvDescID = CostCenterActivityAltvDescID4
    and actalttxt4.Language                     = $session.system_language
  left outer to one join I_ActivityAlternativeText as actalttxt5
    on  actalttxt5.CostCenterActivityAltvDescID = CostCenterActivityAltvDescID5
    and actalttxt5.Language                     = $session.system_language
  left outer to one join I_ActivityAlternativeText as actalttxt6
    on  actalttxt6.CostCenterActivityAltvDescID = CostCenterActivityAltvDescID6
    and actalttxt6.Language                     = $session.system_language
{
  
  // Technical key

  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  
  WorkCenterCategoryCode,
  WorkCenter,
  Plant,
  StandardWorkFormulaParamGroup,
  
  StandardWorkFormulaParam1,
  tc20t1.Language as Param1Language,
  tc20t1.StandardWorkFormulaParamName as ParamName1,
  StandardWorkFormulaParam2,
  tc20t2.Language as Param2Language,
  tc20t2.StandardWorkFormulaParamName as ParamName2,
  StandardWorkFormulaParam3,
  tc20t3.Language as Param3Language,
  tc20t3.StandardWorkFormulaParamName as ParamName3,   
  StandardWorkFormulaParam4,
  tc20t4.Language as Param4Language,
  tc20t4.StandardWorkFormulaParamName as ParamName4, 
  StandardWorkFormulaParam5,
  tc20t5.Language as Param5Language,
  tc20t5.StandardWorkFormulaParamName as ParamName5,
  StandardWorkFormulaParam6,
  tc20t6.Language as Param6Language,
  tc20t6.StandardWorkFormulaParamName as ParamName6,    
  
  CostCenterAllocation1,
  ControllingArea1,
  CostCtrActivityType1,
  acttypetxt1.CostCtrActivityTypeName as CostCtrActivityTypeName1,
  ActivityDescOriginType1,
  CostCenterActivityAltvDescID1,
  ValidityStartDate1,
  ValidityEndDate1,
  actalttxt1.CostCenterActivityAltvDesc as CostCenterActivityAltvDesc1,
  
  CostCenterAllocation2,
  ControllingArea2,
  CostCtrActivityType2,
  acttypetxt2.CostCtrActivityTypeName as CostCtrActivityTypeName2,  
  ActivityDescOriginType2,
  CostCenterActivityAltvDescID2,
  ValidityStartDate2,
  ValidityEndDate2,
  actalttxt2.CostCenterActivityAltvDesc as CostCenterActivityAltvDesc2,    
    
  CostCenterAllocation3,
  ControllingArea3,
  CostCtrActivityType3,
  acttypetxt3.CostCtrActivityTypeName as CostCtrActivityTypeName3, 
  ActivityDescOriginType3,
  CostCenterActivityAltvDescID3,
  ValidityStartDate3,
  ValidityEndDate3,
  actalttxt3.CostCenterActivityAltvDesc as CostCenterActivityAltvDesc3,      
    
  CostCenterAllocation4,
  ControllingArea4,
  CostCtrActivityType4,
  acttypetxt4.CostCtrActivityTypeName as CostCtrActivityTypeName4,
  ActivityDescOriginType4,
  CostCenterActivityAltvDescID4, 
  ValidityStartDate4,
  ValidityEndDate4, 
  actalttxt4.CostCenterActivityAltvDesc as CostCenterActivityAltvDesc4,      
  
  CostCenterAllocation5,
  ControllingArea5,
  CostCtrActivityType5,
  acttypetxt5.CostCtrActivityTypeName as CostCtrActivityTypeName5,
  ActivityDescOriginType5, 
  CostCenterActivityAltvDescID5,
  ValidityStartDate5,
  ValidityEndDate5,
  actalttxt5.CostCenterActivityAltvDesc as CostCenterActivityAltvDesc5,  
  
  CostCenterAllocation6,
  ControllingArea6,
  CostCtrActivityType6,
  acttypetxt6.CostCtrActivityTypeName as CostCtrActivityTypeName6,
  ActivityDescOriginType6,
  CostCenterActivityAltvDescID6,
  ValidityStartDate6,
  ValidityEndDate6,
  actalttxt6.CostCenterActivityAltvDesc as CostCenterActivityAltvDesc6,  
  
  // Associations

  _WorkCenter,
  _WorkCenterType,
  _WorkCenterCategory,
  _Plant,
  _StandardWorkFmlaParamGroup  
  
}