P_CATSDATAWITHCATEGORY

@AbapCatalog.sqlViewName: 'PCATSDATA'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality : #D
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.private: true
//@EndUserText.label: 'CATS data with the project category'

define view P_CATSDATAWITHCATEGORY as select from I_TimeSheetRecord as catsdb
  left outer join I_WBSElementBasicData          as WBSElement                  on catsdb.WBSElementInternalID = WBSElement.WBSElementInternalID

  left outer join  I_WorkPackage                 as WorkPackage                 on WorkPackage.WBSElementObject = WBSElement.WBSElementObject
  
//  left outer join I_EngagementProjFinancialPlan as EngagementProjFinancialPlan on WorkPackage.EngagementProjFinPlanUUID = EngagementProjFinancialPlan.EngagementProjFinPlanUUID

//

//  left outer join  I_EngagementProject           as EngagementProject           on EngagementProjFinancialPlan.EngagementProjectUUID = EngagementProject.EngagementProjectUUID

  {
  
    key  catsdb.TimeSheetRecord,
         catsdb.PersonWorkAgreement                   as EmploymentInternalID,
         catsdb.TimeSheetDate                         as CalendarDate,          
         catsdb.TimeSheetTaskType                     as TaskType,
         WorkPackage.WorkPackage                      as WorkPackage,
         WorkPackage.WorkPackageStartDate,
         WorkPackage.WorkPackageEndDate,
         //catsdb.rproj                             as WBSElementInternalID,

         catsdb.ActivityType                           as EngagementProjectResource,
         catsdb.WorkItem,         
         catsdb.RecordedHours,
         catsdb.UnitOfMeasure,
         catsdb.PurchaseOrder,
         catsdb.PurchaseOrderItem,
         catsdb.TimeSheetStatus                         as Status,
         left(catsdb.TimeSheetDate,4)                   as CalendarYear,
         substring(catsdb.TimeSheetDate,5,2)            as CalendarMonth,
         WorkPackage._EngagementProjFinancialPlan._EngagementProject.EngagementProjectCategory    as TaskCategory,
         WorkPackage.EngagementProjFinPlanUUID          as EngagementProjFinPlanUUID,
         catsdb.AccountingIndicatorCode
}
where catsdb.ServiceDocument = '' and catsdb.ServiceDocumentType = '' and catsdb.ServiceDocumentItem = '000000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGAGEMENTPROJECT",
"I_ENGAGEMENTPROJFINANCIALPLAN",
"I_TIMESHEETRECORD",
"I_WBSELEMENTBASICDATA",
"I_WORKPACKAGE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/