P_ORDERCATEGORYOBJECT

CDS View

Project Cost Object Order Category

P_ORDERCATEGORYOBJECT is a CDS View in S/4HANA. Project Cost Object Order Category. It contains 45 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 45 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProjectCostObject view union COMPOSITE Project Cost Object

Fields (45)

KeyField CDS FieldsUsed in Views
ActualEndDate ActualEndDate 1
ActualStartDate ActualStartDate 1
ApplicantCode ApplicantCode 1
ApplicantName ApplicantName 1
BasicEndDate BasicEndDate 1
BasicStartDate BasicStartDate 1
BusinessArea BusinessArea 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
ControllingAreaCurrency ControllingAreaCurrency 1
ControllingObject ControllingObject 1
ControllingObjectClass ControllingObjectClass 1
Currency Currency 1
FreeDefinedAttribute01 FreeDefinedAttribute01 1
FreeDefinedAttribute02 FreeDefinedAttribute02 1
FreeDefinedAttribute03 FreeDefinedAttribute03 1
FreeDefinedAttribute04 FreeDefinedAttribute04 1
FreeDefinedIndicator1 FreeDefinedIndicator1 1
FreeDefinedIndicator2 FreeDefinedIndicator2 1
FunctionalArea FunctionalArea 1
ObjectType ObjectType 1
OrderDescription WBSDescription1 1
OrderID Object 1
Plant Plant 1
PriorityCode PriorityCode 1
ProfitCenter ProfitCenter 1
Project Project 1
ProjectDescription ProjectDescription 1
ProjectInternalID ProjectInternalID 1
ProjectObject ProjectObject 1
ProjectType ProjectType 1
ReqgCostCenterControllingArea ReqgCostCenterControllingArea 1
RequestingCostCenter RequestingCostCenter 1
RespCostCenterControllingArea RespCostCenterControllingArea 1
ResponsibleCostCenter ResponsibleCostCenter 1
ResponsiblePerson ResponsiblePerson 1
ResponsiblePersonName ResponsiblePersonName 1
SchedldBasicEarliestEndDate SchedldBasicEarliestEndDate 1
SchedldBasicEarliestStartDate SchedldBasicEarliestStartDate 1
SchedldBasicLatestStartDate SchedldBasicLatestStartDate 1
ScheduledBasicLatestEndDate ScheduledBasicLatestEndDate 1
WBSDescription WBSDescription 1
WBSElement WBSElement 1
WBSElementHierarchyLevel WBSElementHierarchyLevel 1
WBSElementObject WBSElementObject 1 
@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'

Learn More