N_OrderOperation

@AbapCatalog.sqlViewName: 'NORDEROPERATION'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
//@Analytics.dataCategory: #DIMENSION

@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@ObjectModel.representativeKey: 'OrderOperationInternalID'
@ObjectModel.semanticKey: ['OrderInternalID', 'OrderOperationInternalID']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.auxiliaryEntity.for.entity: 'I_OrderOperation'
@VDM.auxiliaryEntity.usage.type: [#ENTERPRISE_SEARCH]
@AbapCatalog.preserveKey:true
//@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

//@VDM.viewType: #BASIC

@EndUserText.label: 'Order Operation Aux'
define view N_OrderOperation 
as select from afvc as afvg
-- for ESH
 left outer join I_WorkCenterText as _WorkCenterText on  _WorkCenterText.WorkCenterTypeCode = 'A' and _WorkCenterText.WorkCenterInternalID = afvg.arbid 
                                                         and _WorkCenterText.Language = $session.system_language
 association [1..1] to I_OrderInternalID  as _OrderInternalID on $projection.OrderInternalID = _OrderInternalID.OrderInternalID
-- for ESH  
  association [0..1] to I_WorkCenter                  as _WorkCenter      on  $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                                            and $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterCategoryCode 
  association [0..1] to I_OrderOperationLongText      as _LongText        on  $projection.OrderInternalID          = _LongText.OrderInternalID
                                                                            and $projection.OrderOperationInternalID = _LongText.OrderOperationInternalID
{
      // Key

      @ObjectModel.foreignKey.association: '_OrderInternalID'
  key afvg.aufpl as OrderInternalID,
  key afvg.aplzl as OrderOperationInternalID,

      afvg.arbid as WorkCenterInternalID,
      'A' as WorkCenterTypeCode,
      afvg.werks as Plant,
      _WorkCenterText.WorkCenterText,

      // Associations

      _OrderInternalID,
      _WorkCenter,
      _LongText
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERTEXT",
"AFVC"
],
"ASSOCIATED":
[
"I_ORDERINTERNALID",
"I_ORDEROPERATIONLONGTEXT",
"I_WORKCENTER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/