C_ChgImpactPlngRoutingOp

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_ChgImpactPlngRoutingOp.
-- 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.
-- SQL view name: CCHGIMPLNGROUOP

CREATE VIEW C_ChgImpactPlngRoutingOp AS
SELECT
  RoutingOperation.BillOfOperationsType AS BillOfOperationsType,
  RoutingOperation.BillOfOperationsGroup AS BillOfOperationsGroup,
  RoutingOperation.BOOOperationInternalID AS BOOOperationInternalID,
  RoutingOperation.BillOfOperationsVariant AS BillOfOperationsVariant,
  RoutingOperation.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  RoutingOperation.BillOfOperationsSequence AS BillOfOperationsSequence,
  RoutingOperation.BillOfOperationsVersion AS BillOfOperationsVersion,
  RoutingOperation.WorkCenterInternalID AS WorkCenterInternalID,
  RoutingOperation.WorkCenterTypeCode AS WorkCenterTypeCode,
  RoutingOperation.IsDeleted AS IsDeleted,
  RoutingOperation.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  RoutingOperation.OperationExternalID AS OperationExternalID,
  RoutingOperation.Operation AS Operation,
  RoutingOperation.LongTextLanguageCode AS LongTextLanguageCode,
  RoutingOperation.Plant AS Plant,
  RoutingOperation.OperationControlProfile AS OperationControlProfile,
  RoutingOperation.OperationStandardTextCode AS OperationStandardTextCode,
  RoutingOperation.BillOfOperationsRefGroup AS BillOfOperationsRefGroup,
  RoutingOperation.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  cast( ' ' as abap.char( 1 ) ) AS OpActyHasAssignedComponents,
  RoutingOperation.CreatedByUser AS CreatedByUser,
  RoutingOperation.LastChangeDate AS LastChangeDate,
  RoutingOperation.LastChangedByUser AS LastChangedByUser,
  RoutingOperation.ValidityStartDate AS ValidityStartDate,
  RoutingOperation.ValidityEndDate AS ValidityEndDate,
  cast('' as cc_efft) AS EffectivityType,
  cast('' as text255 ) AS EffectivityParameterDesc,
  cast( ' ' as abap.char( 255 ) ) AS NetChangeAnalysisPath,
  cast(' ' as mpe_mec_cima_isdefinite) AS IsDefinite,
  cast(' ' as mpe_mec_cima_ischanged ) AS IsChanged,
  cast('' as /plmb/cr_id ) AS ChangeRecord
FROM I_ChgImpactPlngRoutingOp AS RoutingOperation
;