I_ProcessOrderOperation

DDL: I_PROCESSORDEROPERATION SQL: IFIPROCORDOPER Type: view BASIC

Interface View for Process Order Operation

I_ProcessOrderOperation is a Basic CDS View (Dimension) that provides data about "Interface View for Process Order Operation" in SAP S/4HANA. It reads from 2 data sources (afko, afvc) and exposes 8 fields with key fields OrderID, OrderOperation. It has 1 association to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
afko afko inner
afvc afvc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductCostCtrlgOrder _CtrlgOrder $projection.OrderID = _CtrlgOrder.OrderID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFIPROCORDOPER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey OrderOperation view
EndUserText.label Interface View for Process Order Operation view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY OrderID afko aufnr
KEY OrderOperation afvc vornr Operation
OrderType _CtrlgOrder OrderType
OrderCategory _CtrlgOrder OrderCategory
Plant _CtrlgOrder Plant
OperationDescription afvc ltxa1
Language
_CtrlgOrder _CtrlgOrder 
@AbapCatalog.sqlViewName: 'IFIPROCORDOPER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'OrderOperation'
@EndUserText.label: 'Interface View for Process Order Operation'
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}
@Metadata.allowExtensions:true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

define view I_ProcessOrderOperation 
  as select from afvc as afvc
    inner join   afko as afko on  afvc.aufpl = afko.aufpl
                              and afko.plnaw = 'C'

  association [0..1] to I_ProductCostCtrlgOrder as _CtrlgOrder on $projection.OrderID = _CtrlgOrder.OrderID
{
      @ObjectModel.foreignKey.association: '_CtrlgOrder'
  key afko.aufnr                                                                                        as  OrderID,
      @EndUserText.label: 'Operation'
  key afvc.vornr                                                                                        as  OrderOperation,
      _CtrlgOrder.OrderType,
      _CtrlgOrder.OrderCategory,
      _CtrlgOrder.Plant,
      afvc.ltxa1                                                                                        as  OperationDescription,
      cast(afvc.txtsp as spras)                                                                         as  Language,
      _CtrlgOrder

}
where
  afvc.sumnr = '00000000'

Learn More