I_ProjectNetwork

@AbapCatalog.sqlViewName: 'IPROJECTNETWORK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
//@AccessControl.privilegedAssociations:  [ '_Extension' ]

@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Project Network Details'
@ObjectModel.representativeKey: 'ProjectNetwork'
@ObjectModel.semanticKey: ['ProjectNetwork']
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
//@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API


//NOTE: THIS VIEW TO BE USED ONLY FOR OP CASES


define view I_ProjectNetwork
  as select from    I_LogisticsOrder as ProjectNetwork
  //left outer join afvc on ProjectNetwork.OrderInternalBillOfOperations = afvc.aufpl

  //  left outer join cnldst_shorttx on  ProjectNetwork.ObjectInternalID = cnldst_shorttx.objnr

  //                                 and cnldst_shorttx.language         = $session.system_language


  //left outer join stxl on  ProjectNetwork.LongTextName = stxl.tdname and ProjectNetwork.LongTextId = stxl.tdid and ProjectNetwork.LongTextObject = stxl.tdobject and stxl.tdspras = $session.system_language

  association [0..1] to I_OrderCategory           as _OrderCategory           on  $projection.OrderCategory = _OrderCategory.OrderCategory
  association [1..1] to I_WBSElement              as _WBSElementText          on  $projection.WBSElementInternalID = _WBSElementText.WBSElementInternalID
  association [0..1] to I_FunctionalArea          as _FunctionalArea          on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea
  association [0..1] to I_Prioritycode            as _Prioritycode            on  $projection.PriorityCode = _Prioritycode.PriorityCode
  association [0..*] to I_NetworkProfile          as _NetworkProfile          on  $projection.NetworkProfile = _NetworkProfile.NetworkProfile
  association [0..1] to I_ResponsiblePlannerGroup as _ResponsiblePlannerGroup on  $projection.ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup
                                                                              and $projection.Plant                   = _ResponsiblePlannerGroup.Plant
  association [0..1] to I_ControllingObjectClass  as _ControllingObjectClass  on  $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass
  association [0..*] to I_TaxJurisdiction         as _TaxJurisdiction         on  $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction
  association [0..1] to I_OrderType               as _OrderType               on  $projection.ProjectNetworkType = _OrderType.OrderType
  //association [0..*] to I_ProjectNetworkDescText  as _ProjectNetworkLangDescription on  $projection.ProjectNetworkObject = _ProjectNetworkLangDescription.ProjectNetworkObject

  //association [0..1] to I_MRPController        as _MRPController            on  $projection.MRPController          =   _MRPController.MRPController

  association [1..1] to E_LogisticsOrder          as _Extension               on  $projection.ProjectNetwork = _Extension.OrderID
 // Multilanguage Short text

  association [0..1] to I_ProjectObjectShortText  as _NetworkShortText        on  _NetworkShortText.Language   = $session.system_language
                                                                              and _NetworkShortText.ProjectApplicationIdentifier = 'PS'
                                                                              and _NetworkShortText.ProjectObjectType = 'NP'
                                                                              and $projection.ProjectNetworkObject = _NetworkShortText.ProjectObjectNode

{
      //@ObjectModel.text.association: '_ProjectNetworkLangDescription'

      @ObjectModel.text.element: 'ProjectNetworkDescription'
  key cast(ProjectNetwork.OrderID as ps_s4_aufnr preserving type)            as ProjectNetwork,
        /* //Multi Language Short text// */

      @Semantics.text: true
      cast(ProjectNetwork.OrderDescription as ps_s4_auftext preserving type ) as ProjectNetworkDescription,
      //@ObjectModel.foreignKey.association: '_Project'

      ProjectNetwork.ProjectInternalID                                       as ProjectInternalID,
      @ObjectModel.foreignKey.association: '_WBSElement'
      ProjectNetwork.WBSElementInternalID                                    as WBSElementInternalID,
      ProjectNetwork.OrderInternalBillOfOperations                           as ProjectNetworkInternalID,

      // cnldst_shorttx.shorttext                                                   as ProjectNetworkLangDescription,


      @ObjectModel.foreignKey.association: '_BusinessArea'
      ProjectNetwork.BusinessArea                                            as BusinessArea,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      ProjectNetwork.CompanyCode                                             as CompanyCode,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      ProjectNetwork.ControllingArea                                         as ControllingArea,
      @ObjectModel.foreignKey.association: '_ProfitCenter'
      ProjectNetwork.ProfitCenter                                            as ProfitCenter,
      @ObjectModel.foreignKey.association: '_CostCenter'
      cast( ProjectNetwork.CostCenter as ps_s4_fkstl preserving type)        as CostCenter,
      @ObjectModel.foreignKey.association: '_Plant'
      ProjectNetwork.Plant                                                   as Plant,
      @ObjectModel.foreignKey.association: '_SalesOrder'
      ProjectNetwork.SalesOrder                                              as SalesOrder,
      @ObjectModel.foreignKey.association: '_SalesOrderItem'
      ProjectNetwork.SalesOrderItem                                          as SalesOrderItem,

      @ObjectModel.foreignKey.association: '_MRPController'
      ProjectNetwork.MRPController                                           as MRPController,

      // Needs to add the planner group text association [No view found]

      cast (ProjectNetwork.ResponsiblePlannerGroup as cp_s_vagrp)            as ResponsiblePlannerGroup,
      //  ProjectNetwork.EngineeringChangeOrder                                                      as EngineeringChangeOrder,

      ProjectNetwork.ChangeNumber                                            as ChangeNumber,
      ProjectNetwork.PriorityCode                                            as PriorityCode,
      ProjectNetwork.SuperiorProjectNetwork                                  as SuperiorProjectNetwork,
      ProjectNetwork.ProductConfiguration                                    as ProductConfiguration,
      ProjectNetwork.NetworkProfile                                          as NetworkProfile,

      // Dates and Times

      ProjectNetwork.LastScheduledDate                                       as LastScheduledDate,
      ProjectNetwork.ConfirmedEndDate                                        as ConfirmedEndDate,
      ProjectNetwork.ScheduledReleaseDate                                    as ScheduledReleaseDate,

      cast ( ProjectNetwork.ActualReleasedDate as fis_co_ftrmi)              as ActualReleasedDate,
      cast (ProjectNetwork.ActualStartDate as cgpl_actualstartdate)          as ActualStartDate,
      cast (ProjectNetwork.ActualEndDate  as pshlp_actual_finish_de)         as ActualEndDate,

      ProjectNetwork.PlannedStartDate                                        as PlannedStartDate,
      ProjectNetwork.PlannedEndDate                                          as PlannedEndDate,

      ProjectNetwork.ForecastedStartDate                                     as ForecastedStartDate,
      ProjectNetwork.ForecastedEndDate                                       as ForecastedEndDate,

      ProjectNetwork.ScheduledForecastedStartDate                            as ScheduledForecastedStartDate,
      ProjectNetwork.ScheduledForecastedEndDate                              as ScheduledForecastedEndDate,
      ProjectNetwork.ScheduledFcstdReleaseDate                               as ScheduledFcstdReleaseDate,

      ProjectNetwork.ScheduledBasicStartDate                                 as ScheduledBasicStartDate,
      ProjectNetwork.ScheduledBasicEndDate                                   as ScheduledBasicEndDate,

      ProjectNetwork.Reservation                                             as Reservation,
      @Semantics.systemDate.createdAt: true
      ProjectNetwork.CreationDate                                            as CreationDate,
      @Semantics.systemTime.createdAt: true
      ProjectNetwork.CreationTime                                            as CreationTime,
      @Semantics.user.createdBy: true
      cast (ProjectNetwork.CreatedByUser as crcreatus)                       as CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      cast (ProjectNetwork.LastChangeDate as iw_mo_date)                     as LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      ProjectNetwork.LastChangeTime                                          as LastChangeTime,
      @Semantics.user.lastChangedBy: true
      cast (ProjectNetwork.LastChangedByUser  as cvdichuser)                 as LastChangedByUser,
      cast(ProjectNetwork.OrderType  as ps_s4_aufart)                        as ProjectNetworkType,
      ProjectNetwork.OrderCategory                                           as OrderCategory,
      ProjectNetwork.JointVentureOriginalCostObject                          as JointVentureOriginalCostObject,
      ProjectNetwork.JointVentureObjectType                                  as JointVentureObjectType,
      ProjectNetwork.JointVenture                                            as JointVenture,
      ProjectNetwork.JointVentureClass                                       as JointVentureClass,
      ProjectNetwork.JointVentureSubClass                                    as JointVentureSubClass,
      cast( ProjectNetwork.TaxJurisdiction  as wb2_txjcd_busvol)             as TaxJurisdiction,
      ProjectNetwork.CostingSheet                                            as CostingSheet,
      ProjectNetwork.CostElement                                             as CostElement,
      ProjectNetwork.ObjectInternalID                                        as ProjectNetworkObject,
      @Semantics.currencyCode: true
      ProjectNetwork.Currency                                                as Currency,
      ProjectNetwork.OverheadCode                                            as OverheadCode,
      ProjectNetwork.ProjInterestCalcProfile                                 as ProjNtwkInterestCalcProfile,
      ProjectNetwork.MfgOrderConfirmation                                    as NetworkActivityConfirmation,
      ProjectNetwork.IsMarkedForDeletion                                     as IsMarkedForDeletion,
      ProjectNetwork.ActualCostsCostingVariant                               as ActualCostsCostingVariant,
      ProjectNetwork.PlannedCostsCostingVariant                              as PlannedCostsCostingVariant,
      ProjectNetwork.ForecastSchedulingType                                  as ForecastSchedulingType,
      ProjectNetwork.BasicSchedulingType                                     as BasicSchedulingType,
      @Semantics.unitOfMeasure: true
      ProjectNetwork.BaseUnit                                                as BaseUnit,

      //addition

      ProjectNetwork.FunctionalArea                                          as FunctionalArea,
      cast( ProjectNetwork.CapacityRequirement as ps_s4_bedid)               as CapacityRequirement,
      ProjectNetwork.OrderID                                                 as OrderID,
      ProjectNetwork.ControllingObjectClass                                  as ControllingObjectClass,
      ProjectNetwork.OrderIsNotCostedAutomatically                           as OrderIsNotCostedAutomatically,
      ProjectNetwork.OrdIsNotSchedldAutomatically                            as OrdIsNotSchedldAutomatically,
      //afvc.vornr                                             as   SubnetworkActivity,





      /* Calculated Fields */
      cast(
      case when ProjectNetwork.NtwkAccountAssignmentCode = '1' then
          'X'
      else
          ' '
      end   as netzkont)                                                     as NetworkIsAccountAssigned,

      /* Association */
      ProjectNetwork._Project,
      ProjectNetwork._WBSElement,
      ProjectNetwork._BusinessArea,
      ProjectNetwork._CompanyCode,
      ProjectNetwork._ControllingArea,
      ProjectNetwork._ProfitCenter,
      ProjectNetwork._CostCenter,
      ProjectNetwork._Plant,
      ProjectNetwork._SalesOrder,
      ProjectNetwork._SalesOrderItem,
      ProjectNetwork._MRPController,
      ProjectNetwork._BaseUnit,
      ProjectNetwork._Currency,
      _WBSElementText,
      // _ProjectNetworkLangDescription,

      _OrderCategory,
      _FunctionalArea,
      _Prioritycode,
      // _InternalOrder,

      _NetworkProfile,
      _ResponsiblePlannerGroup,
      _ControllingObjectClass,
      _TaxJurisdiction,
      _OrderType,
      //stxl.srtf2  as LengthOfText2,

      //stxl.clustr  as LengthOfText1,


      //stxl.clustd as LongTextDesc

      //Multi Language Short text

      _NetworkShortText
}

where
  ProjectNetwork.OrderCategory = '20'

//  and   stxl.relid = 'TX'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER"
],
"ASSOCIATED":
[
"E_LOGISTICSORDER",
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_CURRENCY",
"I_FUNCTIONALAREA",
"I_MRPCONTROLLER",
"I_NETWORKPROFILE",
"I_ORDERCATEGORY",
"I_ORDERTYPE",
"I_PLANT",
"I_PRIORITYCODE",
"I_PROFITCENTER",
"I_PROJECTBYINTERNALKEY",
"I_PROJECTOBJECTSHORTTEXT",
"I_RESPONSIBLEPLANNERGROUP",
"I_SALESORDER",
"I_SALESORDERITEM",
"I_TAXJURISDICTION",
"I_UNITOFMEASURE",
"I_WBSELEMENT",
"I_WBSELEMENTBYINTERNALKEY"
],
"BASE":
[
"I_LOGISTICSORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/