N_OrderOperation

DDL: N_ORDEROPERATION Type: view_entity Package: VDM_PP_SFC

Order Operation Aux

N_OrderOperation is a CDS View that provides data about "Order Operation Aux" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterText, afvc) and exposes 9 fields with key fields OrderInternalID, OrderOperationInternalID. It has 3 associations to related views. Part of development package VDM_PP_SFC.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterText _WorkCenterText left_outer
afvc afvg from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_OrderInternalID _OrderInternalID $projection.OrderInternalID = _OrderInternalID.OrderInternalID -- for ESH
[0..1] I_WorkCenter _WorkCenter $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterCategoryCode
[0..1] I_OrderOperationLongText _LongText $projection.OrderInternalID = _LongText.OrderInternalID and $projection.OrderOperationInternalID = _LongText.OrderOperationInternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey OrderOperationInternalID view
Analytics.technicalName NORDEROPERATION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.auxiliaryEntity.for.entity I_OrderOperation view
EndUserText.label Order Operation Aux view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID afvc aufpl
KEY OrderOperationInternalID afvc aplzl
WorkCenterInternalID afvc arbid
WorkCenterTypeCode
Plant afvc werks
WorkCenterText I_WorkCenterText WorkCenterText
_OrderInternalID _OrderInternalID
_WorkCenter _WorkCenter
_LongText _LongText 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
//@Analytics.dataCategory: #DIMENSION

@ObjectModel.representativeKey: 'OrderOperationInternalID'
@Analytics.technicalName: 'NORDEROPERATION'
@ObjectModel.semanticKey: ['OrderInternalID', 'OrderOperationInternalID']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.auxiliaryEntity.for.entity: 'I_OrderOperation'
@VDM.auxiliaryEntity.usage.type: [#ENTERPRISE_SEARCH]
@EndUserText.label: 'Order Operation Aux'
define view entity 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
};

Learn More