P_RTPC_REM_ORDER

@AbapCatalog.sqlViewName: 'PRTPCREMORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Event-Based REM orders'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.representativeKey: 'OrderID'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view P_RTPC_REM_Order
  as select from I_ProductCostCtrlgOrder as _Order
    left outer to one join I_ProductCostCtrlgOrderItem as _LeadingOrderItem on  _LeadingOrderItem.OrderID   = _Order.OrderID
                                                                            and _LeadingOrderItem.OrderItem = '0001'
{
  key _Order.OrderID                          as OrderID,
      _Order.OrderDescription                 as OrderDescription,
      _Order.ObjectInternalID                 as ControllingObject,
      _Order.OrderType                        as OrderType,
      _Order.OrderCategory                    as OrderCategory,
      _Order.ControllingArea                  as ControllingArea,
      _Order.CompanyCode                      as CompanyCode,

      _Order.Plant                            as Plant,
      _Order.ProfitCenter                     as ProfitCenter,
      _Order.ResultAnalysisInternalID         as ResultsAnalysisKey,
      
      _Order.TechnicalCompletionDate          as TechCompDate,
      _Order.MfgOrderHasMultipleItems,
      
      _LeadingOrderItem.Material              as Material,
      _LeadingOrderItem.ProductionVersion     as ProductionVersion
}
where
      _Order.OrderIsEventBasedPosting = 'X'
  and _Order.IsMarkedForDeletion      = ''
  and _Order.OrderCategory            = '05'
  
  
  

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTCOSTCTRLGORDER",
"I_PRODUCTCOSTCTRLGORDERITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/