I_SFIOpActyInspCharcsAggrg

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_SFIOpActyInspCharcsAggrg.
-- 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_SFIOpActyInspCharcsAggrg AS
SELECT
  ShopFloorItem.ShopFloorItem AS ShopFloorItem,
  OrderOperationBasic.OrderOperationInternalID AS OrderOperationInternalID,
  InspCharSpecification.InspectionCharacteristic AS InspectionCharacteristic,
  ShopFloorItem.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  InspectionSubset.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  OrderOperationBasic.OperationText AS MfgOrderOperationText,
  OrderOperationBasic.Plant AS Plant,
  MfgOrder.InspectionLot AS InspectionLot,
  MfgOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrder.ProductionPlant AS ProductionPlant,
  MfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MfgOrder.ProductionUnit AS ProductionUnit,
  MfgOrder.OrderInternalID AS OrderInternalID,
  ShopFloorItem.SerialNumber AS SerialNumber,
  OpActyNtwkElement.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyNtwkInstance.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActivityInstance.OpActyNtwkElement AS OpActyNtwkElement,
  cast(OpActyNtwkElement.OpActyNtwkElementExternalID as mpe_oa_number_ext preserving type) AS OpActyNtwkElementExternalID,
  OpActyNtwkElement._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  InspCharSpecification.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  InspCharSpecification.InspectionSpecification AS InspectionSpecification,
  InspCharSpecification.InspectionSpecificationText AS InspectionSpecificationText,
  InspCharSpecification.InspSpecificationHasLongText AS InspSpecificationHasLongText,
  BOOCharcVersionLongText.BOOCharcVersionLongText AS BOOCharcVersionLongText,
  InspSpecVersionLongText.InspSpecVersionLongText AS InspSpecVersionLongText,
  InspCharSpecification.InspCharcLongTextLanguage AS InspCharcLongTextLanguage,
  InspCharSpecification.InspCharcInspSpecRefType AS InspCharcInspSpecRefType,
  InspCharSpecification.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  InspCharSpecification.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  InspCharSpecification.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  InspCharSpecification.InspectionMethod AS InspectionMethod,
  InspCharSpecification.InspectionMethodPlant AS InspectionMethodPlant,
  InspCharSpecification.InspectionMethodVersion AS InspectionMethodVersion,
  InspCharSpecification.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  InspCharSpecification.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  InspCharSpecification.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  InspCharSpecification.InspSpecLowerLimit AS InspSpecLowerLimit,
  InspCharSpecification.InspSpecUpperLimit AS InspSpecUpperLimit,
  InspCharSpecification.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  InspCharSpecification.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  InspCharSpecification.InspSpecRecordingType AS InspSpecRecordingType,
  InspCharSpecification.InspSpecTargetValue AS InspSpecTargetValue,
  InspCharSpecification.QuantityUnit AS QuantityUnit,
  InspCharSpecification.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  InspCharSpecification.InspSpecInformationField1 AS InspSpecInformationField1,
  InspCharSpecification.InspSpecInformationField2 AS InspSpecInformationField2,
  InspCharSpecification.InspSpecInformationField3 AS InspSpecInformationField3,
  InspCharSpecification.BOOCharacteristicInspRelevance AS BOOCharacteristicInspRelevance,
  InspSubsetCharacteristic.QualityControlChart AS QualityControlChart,
  QltyCtrlCht.QltyCtrlChartAggrgnCriterion AS QltyCtrlChartAggrgnCriterion,
  InspCharSpecification.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  InspCharSpecification.InspSpecHasUprPlausibilityLmt AS InspSpecHasUprPlausibilityLmt,
  InspCharSpecification.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  InspSubsetResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  InspSubsetResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  InspSubsetResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  InspSubsetResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  InspSubsetResult.InspectionValuationResult AS InspectionValuationResult,
  InspSubsetResult.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  InspectionValuationRsltTxt.InspectionValuationResultText AS InspectionValuationResultText,
  InspSubsetResult.InspectionResultText AS InspectionResultText,
  OpActyBOOCharcAssgmt.OpActyCharcDivnSqnc AS OpActyCharcDivnSqnc,
  OpActyBOOCharcAssgmt.OpActyCharcGrpSqnc AS OpActyCharcGrpSqnc,
  InspCharResultAggregate.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  InspCharcGrpDivnDesc.InspCharcGrpDivnDesc AS InspCharcGrpDivnDesc,
  OperationActivityInstance.BillOfOperationsGroup AS BillOfOperationsGroup,
  OperationActivityInstance.BillOfOperationsVariant AS BillOfOperationsVariant,
  OperationActivityInstance.BillOfOperationsVersion AS BillOfOperationsVersion,
  case when OpActyBOOCharcAssgmt.LogicalComponentUUID is not initial then MfgOrderLogicalComponent.BillOfMaterialInternalID else OpActyBOOCharcAssgmt.BillOfMaterial end as BillOfMaterial AS BillOfMaterialendasBillOfMaterial,
  OpActyBOOCharcAssgmt.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  OpActyBOOCharcAssgmt.DgtlMockUpCharcsUUID AS RefDgtlMockUpCharcsUUID,
  cast( '' as meta_value ) AS ReferenceDesignatorValue
FROM I_SFIOfOriginalReplacedSFI AS ShopFloorItem
INNER JOIN I_MfgOrderBasic AS MfgOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyNtwkInstanceBasic AS OpActyNtwkInstance ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationActivityInstance AS OperationActivityInstance ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyNtwkElement AS OpActyNtwkElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionCharacteristic AS InspCharSpecification ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionSubset AS InspectionSubset ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspSubsetCharacteristic AS InspSubsetCharacteristic ON /* join condition not captured in parsed metadata */
;