P_Orderobject

DDL: P_ORDEROBJECT SQL: POBJORDER Type: view COMPOSITE Package: VDM_CPM_WS

Project Cost Object Order

P_Orderobject is a Composite CDS View that provides data about "Project Cost Object Order" in SAP S/4HANA. It reads from 3 data sources (I_OrderOperationWithCrcy, I_OrderHeaderWithOrderId, I_WBSElement) and exposes 50 fields. Part of development package VDM_CPM_WS.

3 data source(s) 50 fields

Data Sources (3)

SourceAliasJoin Type
I_OrderOperationWithCrcy OperationOrder left_outer
I_OrderHeaderWithOrderId OrderHeader left_outer
I_WBSElement WBSElement from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName POBJORDER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (50)

KeyFieldSource TableSource FieldDescription
WBSElementInternalID I_WBSElement WBSElementInternalID
ProjectInternalID I_WBSElement ProjectInternalID
WBSElement I_WBSElement WBSElement
WBSDescription I_WBSElement WBSDescription
WBSElementObject I_WBSElement WBSElementObject
ResponsiblePerson I_WBSElement ResponsiblePerson
ResponsiblePersonName I_WBSElement ResponsiblePersonName
ApplicantCode I_WBSElement ApplicantCode
ApplicantName I_WBSElement ApplicantName
CompanyCode I_WBSElement CompanyCode
BusinessArea I_WBSElement BusinessArea
ControllingArea I_WBSElement ControllingArea
ProfitCenter I_WBSElement ProfitCenter
ProjectType I_WBSElement ProjectType
ReqgCostCenterControllingArea I_WBSElement ReqgCostCenterControllingArea
RequestingCostCenter I_WBSElement RequestingCostCenter
RespCostCenterControllingArea I_WBSElement RespCostCenterControllingArea
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter
PriorityCode I_WBSElement PriorityCode
Currency I_WBSElement Currency
Plant I_WBSElement Plant
FreeDefinedAttribute01 I_WBSElement FreeDefinedAttribute01
FreeDefinedAttribute02 I_WBSElement FreeDefinedAttribute02
FreeDefinedAttribute03 I_WBSElement FreeDefinedAttribute03
FreeDefinedAttribute04 I_WBSElement FreeDefinedAttribute04
FreeDefinedIndicator1 I_WBSElement FreeDefinedIndicator1
FreeDefinedIndicator2 I_WBSElement FreeDefinedIndicator2
FunctionalArea I_WBSElement FunctionalArea
BasicStartDate I_WBSElement BasicStartDate
ActualStartDate I_WBSElement ActualStartDate
BasicEndDate I_WBSElement BasicEndDate
ActualEndDate I_WBSElement ActualEndDate
SchedldBasicEarliestStartDate I_WBSElement SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate I_WBSElement ScheduledBasicLatestEndDate
SchedldBasicLatestStartDate I_WBSElement SchedldBasicLatestStartDate
SchedldBasicEarliestEndDate I_WBSElement SchedldBasicEarliestEndDate
ControllingObjectClass I_WBSElement ControllingObjectClass
WBSElementHierarchyLevel I_WBSElement WBSElementHierarchyLevel
Project
ProjectDescription
ProjectObject
ControllingAreaCurrency
ProjectNetworkInternalID I_OrderOperationWithCrcy ProjectNetworkInternalID
NetworkActivityInternalID I_OrderOperationWithCrcy NetworkActivityInternalID
NetworkActivity I_OrderOperationWithCrcy NetworkActivity
NetworkActivityDescription I_OrderOperationWithCrcy NetworkActivityDescription
NetworkActivityObject I_OrderOperationWithCrcy NetworkActivityObject
ObjectType
OrderID I_OrderHeaderWithOrderId OrderID
NetworkActivityCurrency I_OrderOperationWithCrcy Currency 
@AbapCatalog.sqlViewName: 'POBJORDER'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_Orderobject
  as select from    I_WBSElement as WBSElement
    //left outer join I_NetworkActivity as OperationOrder on WBSElement.WBSElementInternalID = OperationOrder.WBSElementInternalID

    left outer join I_OrderOperationWithCrcy         as OperationOrder on WBSElement.WBSElementInternalID = OperationOrder.WBSElementInternalID
    left outer join I_OrderHeaderWithOrderId         as OrderHeader    on OperationOrder.ProjectNetworkInternalID = OrderHeader.ProjectNetworkInternalID
  //association [0..*] to P_Objecttypetext as _ObjTypeText on $projection.ObjectType = _ObjTypeText.ObjectType

{
  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,
  OperationOrder.ProjectNetworkInternalID,
  OperationOrder.NetworkActivityInternalID,
  OperationOrder.NetworkActivity,
  OperationOrder.NetworkActivityDescription,
  OperationOrder.NetworkActivityObject,
  substring(NetworkActivityObject, 1, 2)       as ObjectType,
  //OperationOrder.ProjectNetwork as OrderID,

  OrderHeader.OrderID,
  OperationOrder.Currency as NetworkActivityCurrency
  
//  OperationOrder.OrderInternalID as ProjectNetworkInternalID,  // aufpl

//  OperationOrder.OrderOperationInternalID as NetworkActivityInternalID, //aplzl

//  OperationOrder.Operation as NetworkActivity,           //vornr

//  OperationOrder.OperationText as NetworkActivityDescription,    //ltxa1

//  OperationOrder.ObjectInternalID as NetworkActivityObject,     //objnr

//  substring(ObjectInternalID, 1, 2)       as ObjectType,

//  //OperationOrder.ProjectNetwork as OrderID,

//  OrderHeader.OrderID,

//  OperationOrder.NetworkActivityCurrency

//  //_ObjTypeText




}

Learn More