C_MfgReworkRoutingOperation

DDL: C_MFGREWORKROUTINGOPERATION Type: view CONSUMPTION
20 Fields 1 Data Sources 1 Associations

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.

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 Task List Type
KEY BillOfOperationsGroup I_BillOfOperationsOpBasic BillOfOperationsGroup Group
KEY BOOOperationInternalID I_BillOfOperationsOpBasic BOOOperationInternalID Task list node
KEY BOOOpInternalVersionCounter I_BillOfOperationsOpBasic BOOOpInternalVersionCounter Counter
BillOfOperationsVersion I_BillOfOperationsOpBasic BillOfOperationsVersion Routing Version
Operation I_BillOfOperationsOpBasic Operation Transaction
OperationExternalID I_BillOfOperationsOpBasic OperationExternalID Ext. Oper. ID
OperationText I_BillOfOperationsOpBasic OperationText Description
Plant I_BillOfOperationsOpBasic Plant Valuation Area
PlantName
WorkCenterInternalID I_BillOfOperationsOpBasic WorkCenterInternalID Work Center
WorkCenterTypeCode I_BillOfOperationsOpBasic WorkCenterTypeCode Object Type
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MfgReworkRoutingOperation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MfgReworkRoutingOperation AS
SELECT
  BillOfOperationsOpBasic.BillOfOperationsType AS BillOfOperationsType,
  BillOfOperationsOpBasic.BillOfOperationsGroup AS BillOfOperationsGroup,
  BillOfOperationsOpBasic.BOOOperationInternalID AS BOOOperationInternalID,
  BillOfOperationsOpBasic.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  BillOfOperationsOpBasic.BillOfOperationsVersion AS BillOfOperationsVersion,
  BillOfOperationsOpBasic.Operation AS Operation,
  BillOfOperationsOpBasic.OperationExternalID AS OperationExternalID,
  BillOfOperationsOpBasic.OperationText AS OperationText,
  BillOfOperationsOpBasic.Plant AS Plant,
  BillOfOperationsOpBasic._Plant.PlantName AS PlantName,
  BillOfOperationsOpBasic.WorkCenterInternalID AS WorkCenterInternalID,
  BillOfOperationsOpBasic.WorkCenterTypeCode AS WorkCenterTypeCode,
  BillOfOperationsOpBasic._WorkCenter.WorkCenter AS WorkCenter,
  BillOfOperationsOpBasic._BillOfOperationsType AS _BillOfOperationsType,
  BillOfOperationsOpBasic._BillOfOperationsGroup AS _BillOfOperationsGroup,
  BillOfOperationsOpBasic._BOOOperationInternalID AS _BOOOperationInternalID,
  BillOfOperationsOpBasic._Plant AS _Plant,
  BillOfOperationsOpBasic._WorkCenter AS _WorkCenter,
  BillOfOperationsOpBasic._WorkCenterType AS _WorkCenterType
FROM I_BillOfOperationsOpBasic AS BillOfOperationsOpBasic
LEFT OUTER JOIN I_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVersion = _BillOfOperationsChangeState.BillOfOperationsVersion  -- association [1..1]
;

Learn More