I_InspPlanOperationTP

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 I_InspPlanOperationTP.
-- 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: IINSPPLOPTP

CREATE VIEW I_InspPlanOperationTP AS
SELECT
  _InspPlanOp.InspectionPlanGroup AS InspectionPlanGroup,
  _InspPlanOp.InspectionPlan AS InspectionPlan,
  _InspPlanOp._InspectionPlanVersion.InspectionPlanInternalVersion AS InspectionPlanInternalVersion,
  _InspPlanOp.BOOOperationInternalID AS BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  _InspPlanOp.BillOfOperationsType AS BillOfOperationsType,
  BOOSqncOpAssgmtIntVersionCntr,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  _WorkCenter.WorkCenter AS WorkCenter,
  _InspPlanOp.IsDeleted AS IsDeleted,
  _InspPlanOp.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  OperationExternalID,
  Operation,
  OperationText,
  Plant,
  OperationControlProfile,
  OperationStandardTextCode,
  BillOfOperationsRefType,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  BOORefOperationIncrementValue,
  InspResultRecordingView,
  InspSbstCompletionConfirmation,
  InspSbstHasNoTimeOrQuantity,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyDnmntr,
  OpQtyToBaseQtyNmrtr,
  _InspPlanOp.CreationDate AS CreationDate,
  _InspPlanOp.CreatedByUser AS CreatedByUser,
  _InspPlanOp.LastChangeDate AS LastChangeDate,
  _InspPlanOp.LastChangedByUser AS LastChangedByUser,
  _InspPlanOp.ChangeNumber AS ChangeNumber,
  _InspPlanOp.ValidityStartDate AS ValidityStartDate,
  _InspPlanOp.ValidityEndDate AS ValidityEndDate,
  cast('X' as abap.char( 1 )) AS IsValid,
  _InspPlanOp._InspectionPlanVersion.BillOfOperationsStatus AS BillOfOperationsStatus,
  _InspPlanOp._InspectionPlanVersion.BillOfOperationsUsage AS BillOfOperationsUsage,
  _InspPlanOp._InspectionPlanVersion AS _InspectionPlanVersion
INNER JOIN I_InspPlanOpAssgmtVersion AS _InspPlanOpVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspPlanPRTOpTP 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..*]
LEFT OUTER JOIN I_InspPlanOpCharcTP 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 I_InspectionPlanTP AS _InspPlan ON InspectionPlanGroup = _InspPlan.InspectionPlanGroup AND InspectionPlan = _InspPlan.InspectionPlan AND InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion AND BillOfOperationsType = _InspPlan.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [0..1]
;