I_ProdnRtgInspCharcsAssgmt

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_ProdnRtgInspCharcsAssgmt.
-- 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_ProdnRtgInspCharcsAssgmt AS
SELECT
  plmk.BillOfOperationsType AS BillOfOperationsType,
  plmk.BillOfOperationsGroup AS BillOfOperationsGroup,
  plas.BillOfOperationsVariant AS BillOfOperationsVariant,
  plas.BillOfOperationsSequence AS BillOfOperationsSequence,
  plmk.BOOOperationInternalID AS BOOOperationInternalID,
  plmk.BOOCharacteristic AS BOOCharacteristic,
  plmk.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  plmk.ValidityStartDate AS ValidityStartDate,
  plmk.ValidityEndDate AS ValidityEndDate,
  plmk.ChangeNumber AS ChangeNumber,
  plmk.IsDeleted AS IsDeleted,
  plmk.InspectionMethodPlant AS InspectionMethodPlant,
  plmk.InspectionMethod AS InspectionMethod,
  plmk.InspectionMethodVersion AS InspectionMethodVersion,
  plmk.InspSpecImportanceCode AS InspSpecImportanceCode,
  plmk.InspectorQualification AS InspectorQualification,
  plmk.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  plmk.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  plmk.InspectionSpecification AS InspectionSpecification,
  plmk.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  plmk.BOOCharcHasInspSpecReference AS BOOCharcHasInspSpecReference,
  case plmk.BOOCharcHasInspSpecReference when 'X' then plmk._InspSpecificationVersion.InspectionScope else plmk.InspectionScope end as InspectionScope AS InspectionScopeendasInspectionScope,
  plmk.InspSpecNumberOfClasses AS InspSpecNumberOfClasses,
  plmk.InspSpecClassWidthQty AS InspSpecClassWidthQty,
  plmk.InspSpecHasClassWidth AS InspSpecHasClassWidth,
  plmk.InspSpecClassMidpointQty AS InspSpecClassMidpointQty,
  plmk.InspSpecHasClassMidpoint AS InspSpecHasClassMidpoint,
  plmk.InspSpecHasFormula AS InspSpecHasFormula,
  plmk.InspSpecFormula1 AS InspSpecFormula1,
  plmk.InspSpecFormula2 AS InspSpecFormula2,
  case plmk.BOOCharcHasInspSpecReference when 'X' then qpmz.SelectedCodeSet else plmk.SelectedCodeSet end as SelectedCodeSet AS SelectedCodeSetendasSelectedCodeSet,
  plmk.SamplingProcedure AS SamplingProcedure,
  plmk.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  plmk.BOOCharcSampleQuantity AS BOOCharcSampleQuantity,
  plmk.InspectionSpecificationText AS InspectionSpecificationText,
  plmk.CreatedByUser AS CreatedByUser,
  plmk.CreationDate AS CreationDate,
  plmk.LastChangedByUser AS LastChangedByUser,
  plmk.LastChangeDate AS LastChangeDate,
  plmk.MatlIsConsideredForDynModif AS MatlIsConsideredForDynModif,
  plmk.SuplrIsConsideredForDynModif AS SuplrIsConsideredForDynModif,
  plmk.MfrIsConsideredForDynModif AS MfrIsConsideredForDynModif,
  plmk.CustIsConsideredForDynModif AS CustIsConsideredForDynModif,
  plmk.InspLotDynamicRule AS InspLotDynamicRule,
  plmk.InspCharcDynModifRef AS InspCharcDynModifRef,
  plmk.QltyCtrlChartAggrgnCriterion AS QltyCtrlChartAggrgnCriterion,
  plmk.InspSpecInputProcedure AS InspSpecInputProcedure,
  plmk.BOOCharcGroup AS BOOCharcGroup,
  plmk.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  plmk.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  plmk.BillOfOperationsVersion AS BillOfOperationsVersion,
  plmk._BillOfOperationsGroup AS _BillOfOperationsGroup,
  plmk._BillOfOperationsType AS _BillOfOperationsType,
  plmk._BOOCharacteristic AS _BOOCharacteristic,
  plmk._BOOOperationInternalID AS _BOOOperationInternalID,
  plmk._InspectionMethod AS _InspectionMethod,
  plmk._InspectionMethodPlant AS _InspectionMethodPlant,
  plmk._InspectionMethodVersion AS _InspectionMethodVersion,
  plmk._InspectionSpecificationPlant AS _InspectionSpecificationPlant,
  plmk._InspectorQualification AS _InspectorQualification,
  plmk._InspSpecificationVersion AS _InspSpecificationVersion,
  plmk._InspSpecImportanceCode AS _InspSpecImportanceCode,
  plmk._SampleUnitOfMeasure AS _SampleUnitOfMeasure,
  plmk._SamplingProcedure AS _SamplingProcedure
FROM I_BOOCharacteristicVersion AS plmk
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS plas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssgmtInspMethInspSpec AS qpmz ON plmk.InspectionMethodPlant = qpmz.InspectionMethodPlant AND plmk.InspectionMethod = qpmz.InspectionMethod AND plmk.InspectionMethodVersion = qpmz.InspectionMethodVersion AND plmk.InspectionSpecificationPlant = qpmz.InspectionSpecificationPlant AND plmk.InspectionSpecification = qpmz.InspectionSpecification AND plmk.InspectionSpecificationVersion = qpmz.InspectionSpecificationVersion AND plmk.BOOCharcHasInspSpecReference = 'X'  -- association [1..1]
;