I_InspPlnMatlAssgmtVersion

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_InspPlnMatlAssgmtVersion.
-- 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 I_InspPlnMatlAssgmtVersion AS
SELECT
  Material,
  Plant,
  BillOfOperationsGroup AS InspectionPlanGroup,
  BillOfOperationsVariant AS InspectionPlan,
  BOOToMaterialInternalID AS InspPlanMatlAssignment,
  BOOMatlInternalVersionCounter AS InspPlanMatlAssgmtIntVersion,
  BillOfOperationsType,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  IsDeleted,
  IsImplicitlyDeleted,
  Supplier,
  Customer,
  BOOSearchText,
  MultipleSpecificationObject,
  MultipleSpecificationObjType
FROM I_BOOMaterialAssgmtChangeState
LEFT OUTER JOIN I_InspectionPlan AS _InspectionPlan ON InspectionPlanGroup = _InspectionPlan.InspectionPlanGroup AND InspectionPlan = _InspectionPlan.InspectionPlan  -- association [1..1]
LEFT OUTER JOIN I_InspectionPlanVersion AS _InspectionPlanVersion ON InspectionPlanGroup = _InspectionPlanVersion.InspectionPlanGroup AND InspectionPlan = _InspectionPlanVersion.InspectionPlan AND ValidityStartDate >= _InspectionPlanVersion.ValidityStartDate AND ValidityStartDate <= _InspectionPlanVersion.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_InspPlnMatlAssignment AS _InspPlnMatlAssignment ON Material = _InspPlnMatlAssignment.Material AND Plant = _InspPlnMatlAssignment.Plant AND InspectionPlanGroup = _InspPlnMatlAssignment.InspectionPlanGroup AND InspectionPlan = _InspPlnMatlAssignment.InspectionPlan AND InspPlanMatlAssignment = _InspPlnMatlAssignment.InspPlanMatlAssignment  -- association [1..1]
LEFT OUTER JOIN I_MltplSpecObject AS _MltplSpecObject ON MultipleSpecificationObject = _MltplSpecObject.MultipleSpecificationObject  -- association [1..1]
LEFT OUTER JOIN I_MltplSpecObjectType AS _MltplSpecObjectType ON MultipleSpecificationObjType = _MltplSpecObjectType.MultipleSpecificationObjType  -- association [1..1]
;