P_OrderCategoryObject

@AbapCatalog.sqlViewName: 'PORDERCATOBJ'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_OrderCategoryObject
  as select from I_WBSElement as WBSElement
    //inner join I_InternalOrder  as OrderMD on WBSElement.WBSElementInternalID = OrderMD.WBSElement

    inner join   I_OrderMasterDataWithCrcy         as OrderMD on WBSElement.WBSElementInternalID = OrderMD.WBSElementInternalID
//    left outer join I_OrderHeaderWithOrderId as OrderHdr on OrderMD.OrderID = OrderHdr.OrderID

//    left outer join I_OrderOperationWithCrcy as OrderOpt on OrderHdr.NetworkInternalID = OrderOpt.ProjectNetworkInternalID

//                                                         and OrderHdr.NetworkActivity = OrderOpt.NetworkActivityInternalID

  //association [1..1] to I_OrderCategoryText as _OrderCategoryText on OrderMD.autyp = _OrderCategoryText.OrderCategory

{
  WBSElement.WBSElementInternalID,
  WBSElement.ProjectInternalID,
  WBSElement.WBSElement,
  WBSElement.WBSDescription,
  WBSElement.WBSElementObject,
  WBSElement.ResponsiblePerson,
  WBSElement.ResponsiblePersonName,
  WBSElement.ApplicantCode,
  WBSElement.ApplicantName,
  WBSElement.CompanyCode,
  WBSElement.BusinessArea,
  WBSElement.ControllingArea,
  WBSElement.ProfitCenter,
  WBSElement.ProjectType,
  WBSElement.ReqgCostCenterControllingArea,
  WBSElement.RequestingCostCenter,
  WBSElement.RespCostCenterControllingArea,
  WBSElement.ResponsibleCostCenter,
  WBSElement.PriorityCode,
  WBSElement.Currency,
  WBSElement.Plant,
  WBSElement.FreeDefinedAttribute01,
  WBSElement.FreeDefinedAttribute02,
  WBSElement.FreeDefinedAttribute03,
  WBSElement.FreeDefinedAttribute04,
  WBSElement.FreeDefinedIndicator1,
  WBSElement.FreeDefinedIndicator2,
  WBSElement.FunctionalArea,
  WBSElement.BasicStartDate,
  WBSElement.ActualStartDate,
  WBSElement.BasicEndDate,
  WBSElement.ActualEndDate,
  WBSElement.SchedldBasicEarliestStartDate,
  WBSElement.ScheduledBasicLatestEndDate,
  WBSElement.SchedldBasicLatestStartDate,
  WBSElement.SchedldBasicEarliestEndDate,
  WBSElement.ControllingObjectClass,
  WBSElement.WBSElementHierarchyLevel,
  WBSElement._Project.Project,
  WBSElement._Project.ProjectDescription,
  WBSElement._Project.ProjectObject,
  WBSElement._Project.Currency as ControllingAreaCurrency,
  OrderMD.OrderID,
  OrderMD.OrderCategory,
  OrderMD.OrderDescription,
  OrderMD.ControllingObject,
  substring(ControllingObject, 1, 2)       as ObjectType,
  OrderMD.Currency as ControllingObjectCurrency
//  OrderOpt.NetworkActivityObject

  
 // _OrderCategoryText

  

}
where
     OrderMD.OrderCategory = '01'
  or OrderMD.OrderCategory = '06'
  or OrderMD.OrderCategory = '20'
  or OrderMD.OrderCategory = '30'                         
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDERMASTERDATAWITHCRCY",
"I_PROJECTBYINTERNALKEY",
"I_WBSELEMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/