@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDERHEADERWITHORDERID",
"I_ORDEROPERATIONWITHCRCY",
"I_PROJECTBYINTERNALKEY",
"I_WBSELEMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/