I_InspectionPlanVersion

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_InspectionPlanVersion.
-- 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: IINSPPLV

CREATE VIEW I_InspectionPlanVersion AS
SELECT
  BillOfOperationsGroup AS InspectionPlanGroup,
  BillOfOperationsVariant AS InspectionPlan,
  BOOInternalVersionCounter AS InspectionPlanInternalVersion,
  BillOfOperationsType,
  IsDeleted,
  IsImplicitlyDeleted,
  Plant,
  BillOfOperationsUsage,
  BillOfOperationsStatus,
  ResponsiblePlannerGroup,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  BillOfOperationsUnit,
  ReplacedBillOfOperations,
  IsMarkedForDeletion,
  InspectionPartialLot AS InspectionPartialLotAssignment,
  SmplDrawingProcedure,
  SmplDrawingProcedureVersion,
  InspectionLotDynamicLevel,
  InspLotDynamicRule,
  InspExternalNumberingOfValues,
  InspLotDynamicCriteria,
  InspPlanHasMultipleSpec,
  cast( substring(InspLotDynamicCriteria,1,1) as qmatkz preserving type ) AS MatlIsConsideredForDynModif,
  cast( substring(InspLotDynamicCriteria,2,1) as qlifkz preserving type ) AS SuplrIsConsideredForDynModif,
  cast( substring(InspLotDynamicCriteria,3,1) as qherstkz preserving type ) AS MfrIsConsideredForDynModif,
  cast( substring(InspLotDynamicCriteria,4,1) as qkundkz preserving type ) AS CustIsConsideredForDynModif,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ChangeNumber,
  ValidityStartDate,
  ValidityEndDate,
  ChangedDateTime
FROM I_BillOfOperationsChangeState
LEFT OUTER JOIN I_InspectionPlan AS _InspectionPlan ON InspectionPlanGroup = _InspectionPlan.InspectionPlanGroup AND InspectionPlan = _InspectionPlan.InspectionPlan  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup AND BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
;