C_InspPlanOperation

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_InspPlanOperation.
-- 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: CINSPPLOP

CREATE VIEW C_InspPlanOperation AS
SELECT
  InspectionPlanGroup,
  InspectionPlan,
  InspectionPlanInternalVersion,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BillOfOperationsType,
  BOOSqncOpAssgmtIntVersionCntr,
  BOOOperationInternalID AS BOORefOperationInternalID,
  BOOOpInternalVersionCounter AS BOORefOpInternalVersion,
  InspectionPlanGroup AS InspectionPlanGroupForEdit,
  InspectionPlan AS InspectionPlanForEdit,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  BOORefOperationIncrementValue,
  _InspPlan.TaskListKeyDateText AS TaskListKeyDateText,
  OperationText,
  ValidityStartDate,
  ValidityEndDate,
  IsValid,
  IsDeleted,
  IsImplicitlyDeleted,
  ChangeNumber,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  Operation,
  Plant,
  WorkCenter,
  OperationReferenceQuantity,
  OperationUnit,
  OperationControlProfile,
  OpQtyToBaseQtyDnmntr,
  OpQtyToBaseQtyNmrtr,
  _InspPlan.BillOfOperationsUnit AS BillOfOperationsUnit,
  BillOfOperationsStatus,
  BillOfOperationsUsage,
  InspSbstCompletionConfirmation,
  BillOfOperationsRefType,
  _InspPlan._BillOfOperationsUnit AS _BillOfOperationsUnit
FROM I_InspPlanOperationTP AS _InspPlanOp
LEFT OUTER JOIN C_InspPlanOpCharc AS _InspPlanCharc ON InspectionPlanGroup = _InspPlanCharc.InspectionPlanGroup AND InspectionPlan = _InspPlanCharc.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanCharc.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanCharc.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanCharc.BOOOpInternalVersionCounter AND BillOfOperationsType = _InspPlanCharc.BillOfOperationsType  -- association [0..*]
LEFT OUTER JOIN C_InspectionPlan AS _InspPlan ON InspectionPlanGroup = _InspPlan.InspectionPlanGroup AND InspectionPlan = _InspPlan.InspectionPlan AND InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion AND BillOfOperationsType = _InspPlan.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN C_InspPlanPRT AS _InspPlanOpPRT ON InspectionPlanGroup = _InspPlanOpPRT.InspectionPlanGroup AND InspectionPlan = _InspPlanOpPRT.InspectionPlan AND InspectionPlanInternalVersion = _InspPlanOpPRT.InspectionPlanInternalVersion AND BOOOperationInternalID = _InspPlanOpPRT.BOOOperationInternalID AND BOOOpInternalVersionCounter = _InspPlanOpPRT.BOOOpInternalVersionCounter AND BillOfOperationsType = _InspPlanOpPRT.BillOfOperationsType  -- association [0..*]
;