C_MfgReworkRoutingOperation

DDL: C_MFGREWORKROUTINGOPERATION Type: view CONSUMPTION Package: MPE_PLAN_RTG_VERS

Operation of rework routing

C_MfgReworkRoutingOperation is a Consumption CDS View that provides data about "Operation of rework routing" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperationsOpBasic) and exposes 20 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BOOOperationInternalID, BOOOpInternalVersionCounter. It has 1 association to related views. Part of development package MPE_PLAN_RTG_VERS.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_BillOfOperationsOpBasic BillOfOperationsOpBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsChangeState _BillOfOperationsChangeState $projection.BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup and $projection.BillOfOperationsVersion = _BillOfOperationsChangeState.BillOfOperationsVersion

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMFGRRO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Operation of rework routing view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType I_BillOfOperationsOpBasic BillOfOperationsType
KEY BillOfOperationsGroup I_BillOfOperationsOpBasic BillOfOperationsGroup
KEY BOOOperationInternalID I_BillOfOperationsOpBasic BOOOperationInternalID
KEY BOOOpInternalVersionCounter I_BillOfOperationsOpBasic BOOOpInternalVersionCounter
BillOfOperationsVersion I_BillOfOperationsOpBasic BillOfOperationsVersion
Operation I_BillOfOperationsOpBasic Operation
OperationExternalID I_BillOfOperationsOpBasic OperationExternalID
OperationText I_BillOfOperationsOpBasic OperationText
Plant I_BillOfOperationsOpBasic Plant
PlantName
WorkCenterInternalID I_BillOfOperationsOpBasic WorkCenterInternalID
WorkCenterTypeCode I_BillOfOperationsOpBasic WorkCenterTypeCode
WorkCenter
_BillOfOperationsType I_BillOfOperationsOpBasic _BillOfOperationsType
_BillOfOperationsGroup I_BillOfOperationsOpBasic _BillOfOperationsGroup
_BOOOperationInternalID I_BillOfOperationsOpBasic _BOOOperationInternalID
_Plant I_BillOfOperationsOpBasic _Plant
_WorkCenter I_BillOfOperationsOpBasic _WorkCenter
_WorkCenterType I_BillOfOperationsOpBasic _WorkCenterType
_BillOfOperationsChangeState _BillOfOperationsChangeState 
@AbapCatalog: {
  sqlViewName: 'CMFGRRO',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Operation of rework routing'
@Metadata.allowExtensions: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #L
  }
@VDM.viewType: #CONSUMPTION
define view C_MfgReworkRoutingOperation
  as select from I_BillOfOperationsOpBasic as BillOfOperationsOpBasic
  
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association [1..1] to I_BillOfOperationsChangeState as _BillOfOperationsChangeState on  $projection.BillOfOperationsType    = _BillOfOperationsChangeState.BillOfOperationsType
                                                                                      and $projection.BillOfOperationsGroup   = _BillOfOperationsChangeState.BillOfOperationsGroup
                                                                                      and $projection.BillOfOperationsVersion = _BillOfOperationsChangeState.BillOfOperationsVersion
  
{

  key BillOfOperationsOpBasic.BillOfOperationsType,
  key BillOfOperationsOpBasic.BillOfOperationsGroup,
  key BillOfOperationsOpBasic.BOOOperationInternalID,
  key BillOfOperationsOpBasic.BOOOpInternalVersionCounter,

      BillOfOperationsOpBasic.BillOfOperationsVersion,

      BillOfOperationsOpBasic.Operation,
      BillOfOperationsOpBasic.OperationExternalID,
      BillOfOperationsOpBasic.OperationText,

      BillOfOperationsOpBasic.Plant,
      BillOfOperationsOpBasic._Plant.PlantName,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_WorkCenterStdVH', element: 'WorkCenterInternalID' } } ]
      BillOfOperationsOpBasic.WorkCenterInternalID,
      BillOfOperationsOpBasic.WorkCenterTypeCode,
      BillOfOperationsOpBasic._WorkCenter.WorkCenter,
      
      BillOfOperationsOpBasic._BillOfOperationsType,
      BillOfOperationsOpBasic._BillOfOperationsGroup,
      BillOfOperationsOpBasic._BOOOperationInternalID,
      BillOfOperationsOpBasic._Plant,
      BillOfOperationsOpBasic._WorkCenter,
      BillOfOperationsOpBasic._WorkCenterType,
      _BillOfOperationsChangeState

}

Learn More