C_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 C_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 C_SFIOpActyInspCharcsAggrg AS
SELECT
  SFIOpActyInspCharcsAggrg.ShopFloorItem AS ShopFloorItem,
  SFIOpActyInspCharcsAggrg.OrderOperationInternalID AS OrderOperationInternalID,
  SFIOpActyInspCharcsAggrg.InspectionCharacteristic AS InspectionCharacteristic,
  SFIOpActyInspCharcsAggrg.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  SFIOpActyInspCharcsAggrg.SerialNumber AS SerialNumber,
  SFIOpActyInspCharcsAggrg.InspectionSpecificationText AS InspectionSpecificationText,
  SFIOpActyInspCharcsAggrg.InspectionLot AS InspectionLot,
  SFIOpActyInspCharcsAggrg.ManufacturingOrder AS ManufacturingOrder,
  SFIOpActyInspCharcsAggrg.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  SFIOpActyInspCharcsAggrg.MfgOrderOperationText AS MfgOrderOperationText,
  SFIOpActyInspCharcsAggrg.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  SFIOpActyInspCharcsAggrg.OperationActivityName AS OperationActivityName,
  SFIOpActyInspCharcsAggrg.InspCharcGrpDesc AS InspCharcGrpDesc,
  SFIOpActyInspCharcsAggrg.InspCharcGrpDivnDesc AS InspCharcGrpDivnDesc,
  SFIOpActyInspCharcsAggrg.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  SFIOpActyInspCharcsAggrg.BillOfOperationsType AS BillOfOperationsType,
  SFIOpActyInspCharcsAggrg.BillOfOperationsGroup AS BillOfOperationsGroup,
  SFIOpActyInspCharcsAggrg.BillOfOperationsVariant AS BillOfOperationsVariant,
  SFIOpActyInspCharcsAggrg.BillOfOperationsVersion AS BillOfOperationsVersion,
  SFIOpActyInspCharcsAggrg.BillOfMaterial AS BillOfMaterial,
  SFIOpActyInspCharcsAggrg.BillOfMaterialCategory AS BillOfMaterialCategory,
  SFIOpActyInspCharcsAggrg.BillOfMaterialVariant AS BillOfMaterialVariant,
  SFIOpActyInspCharcsAggrg.BillOfMaterialVersion AS BillOfMaterialVersion,
  SFIOpActyInspCharcsAggrg.InheritedNodeNumberForBOMItem AS OriglBOMItemInheritedNodeNmbr,
  cast( '' as stvkn ) AS InheritedNodeNumberForBOMItem,
  SFIOpActyInspCharcsAggrg.OriglDgtlMockUpCharcsUUID AS OriglOriglDgtlMockUpCharcsUUID,
  cast( hextobin('00000000000000000000000000000000') as cim_dmu_guid16 preserving type ) AS OriglDgtlMockUpCharcsUUID,
  SFIOpActyInspCharcsAggrg.RefDgtlMockUpCharcsUUID AS RefDgtlMockUpCharcsUUID,
  cast( '' as stlan ) AS BillOfMaterialVariantUsage,
  cast( '' as werks_d ) AS BOMOrBOMAltvCrtedInPlnt,
  cast( hextobin('00000000000000000000000000000000') as mpe_mrs_leaf_assignment_uuid preserving type ) AS MfgRefStrucBOMLeafAssgmtUUID,
  cast( '' as vmp_ref_des) AS ReferenceDesignatorName,
  cast( hextobin('00000000000000000000000000000000') as mpe_mrs_item_detail_uuid preserving type ) AS MfgRefStructureItemDetailUUID,
  cast( '' as mpe_mrs_item_det_is_contextual preserving type ) AS MfgRefStrucItmDetIsContextual,
  SFIOpActyInspCharcsAggrg.InspectionResultMeanValue AS InspectionResultMeanValue,
  cast('' as qmittelwrt_f) AS InspResultFrmtdMeanValue,
  SFIOpActyInspCharcsAggrg.InspectionResultMaximumValue AS InspectionResultMaximumValue,
  cast('' as qmaxwert_f) AS InspResultFrmtdMaximumValue,
  SFIOpActyInspCharcsAggrg.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  cast('' as qminwert_f) AS InspResultFrmtdMinimumValue,
  SFIOpActyInspCharcsAggrg.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  SFIOpActyInspCharcsAggrg.InspSpecRecordingType AS InspSpecRecordingType,
  UnitOfMeasureText.UnitOfMeasureTechnicalName AS InspSpecificationUnitTechName,
  SFIOpActyInspCharcsAggrg.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  SFIOpActyInspCharcsAggrg.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  SFIOpActyInspCharcsAggrg.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  CharcAttCodeText.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  SFIOpActyInspCharcsAggrg.InspectionSpecification AS InspectionSpecification,
  SFIOpActyInspCharcsAggrg.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  SFIOpActyInspCharcsAggrg.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  SFIOpActyInspCharcsAggrg.InspCharcInspSpecRefType AS InspCharcInspSpecRefType,
  SFIOpActyInspCharcsAggrg.InspCharcLongTextLanguage AS InspCharcLongTextLanguage,
  SFIOpActyInspCharcsAggrg.SelectedCodeSetText AS SelectedCodeSetText,
  lineItem: [{position: 10,criticality: 'InspValnResultCriticality',criticalityRepresentation: #WITHOUT_ICON AS InspectionValuationResultText,
  SFIOpActyInspCharcsAggrg.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  SFIOpActyInspCharcsAggrg.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  SFIOpActyInspCharcsAggrg.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  SFIOpActyInspCharcsAggrg.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  SFIOpActyInspCharcsAggrg.InspSubsetResultLongText AS InspSubsetResultLongText,
  SFIOpActyInspCharcsAggrg.InspectionResultText AS InspectionResultText,
  cast('' as char1 preserving type ) AS InspectionResultLongText,
  SFIOpActyInspCharcsAggrg.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  SFIOpActyInspCharcsAggrg.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIOpActyInspCharcsAggrg.OpActyNtwkElement AS OpActyNtwkElement,
  SFIOpActyInspCharcsAggrg.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  SFIOpActyInspCharcsAggrg.ManufacturingOrderType AS ManufacturingOrderType,
  SFIOpActyInspCharcsAggrg.ProductionPlant AS ProductionPlant,
  SFIOpActyInspCharcsAggrg.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  SFIOpActyInspCharcsAggrg.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  SFIOpActyInspCharcsAggrg.InspSpecSummarizedDcmlPlaces AS InspSpecSummarizedDcmlPlaces,
  SFIOpActyInspCharcsAggrg.InspResultNrOfAddlDcmlsPlaces AS InspResultNrOfAddlDcmlsPlaces,
  SFIOpActyInspCharcsAggrg.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  SFIOpActyInspCharcsAggrg.InspSpecLowerLimit AS InspSpecLowerLimit,
  cast('' as qtolun_f) AS InspSpecFrmtdLowerLimit,
  SFIOpActyInspCharcsAggrg.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  SFIOpActyInspCharcsAggrg.InspSpecUpperLimit AS InspSpecUpperLimit,
  cast('' as qtolob_f) AS InspSpecFrmtdUpperLimit,
  SFIOpActyInspCharcsAggrg.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  SFIOpActyInspCharcsAggrg.InspSpecTargetValue AS InspSpecTargetValue,
  cast('' as qsollwerte_f) AS InspSpecFrmtdTargetValue,
  SFIOpActyInspCharcsAggrg.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  cast( ' ' as qplausiobc ) AS InspSpecFrmtdUprPlsbltyLmt,
  SFIOpActyInspCharcsAggrg.InspSpecHasLowrPlausibilityLmt AS InspSpecHasLowrPlausibilityLmt,
  SFIOpActyInspCharcsAggrg.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  cast( ' ' as qplausiunc ) AS InspSpecFrmtdLowerPlsbltyLmt,
  SFIOpActyInspCharcsAggrg.InspSpecHasControlChart AS InspSpecHasControlChart,
  SFIOpActyInspCharcsAggrg.QualityControlChart AS QualityControlChart,
  SFIOpActyInspCharcsAggrg.QltyCtrlChartAggrgnCriterion AS QltyCtrlChartAggrgnCriterion,
  SFIOpActyInspCharcsAggrg.OpActyCharacteristicItem AS OpActyCharacteristicItem,
  SFIOpActyInspCharcsAggrg.OpActyCharcDivnSqnc AS OpActyCharcDivnSqnc,
  SFIOpActyInspCharcsAggrg.OpActyCharcGrpSqnc AS OpActyCharcGrpSqnc,
  InspectionMethodVersionText.InspectionMethodText AS InspectionMethodText,
  SFIOpActyInspCharcsAggrg.InspectionMethodPlant AS InspectionMethodPlant,
  SFIOpActyInspCharcsAggrg.InspectionMethodVersion AS InspectionMethodVersion,
  cast( '' as idnrk) AS Material,
  cast( '' as maktx) AS MaterialName,
  InspectionRelevanceText.BOOCharcInspRelevanceText AS BOOCharcInspRelevanceText,
  SFIOpActyInspCharcsAggrg.InspSpecInformationField2 AS InspSpecInformationField2,
  SFIOpActyInspCharcsAggrg.InspSpecInformationField3 AS InspSpecInformationField3,
  SFIOpActyInspCharcsAggrg.BOOCharcVersionLongText AS InspSpecificationLongText,
  SFIOpActyInspCharcsAggrg.BOOCharcVersionLongText AS BOOCharcVersionLongText,
  SFIOpActyInspCharcsAggrg.InspSpecVersionLongText AS InspSpecVersionLongText,
  OperationActyPRTAssignment.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  OperationActyPRTAssignment.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  OperationActyPRTAssignment.DocumentType AS DocumentType,
  OperationActyPRTAssignment.DocumentInfoRecord AS DocumentInfoRecord,
  OperationActyPRTAssignment.DocumentVersion AS DocumentVersion,
  OperationActyPRTAssignment.DocumentPart AS DocumentPart
FROM I_SFIOpActyInspCharcsAggrg AS SFIOpActyInspCharcsAggrg
LEFT OUTER JOIN C_SFIPlanInspCharResultRec AS _InspCharResultDetails ON _InspCharResultDetails.InspectionLot = InspectionLot AND _InspCharResultDetails.InspPlanOperationInternalID = OrderOperationInternalID AND _InspCharResultDetails.InspectionSubsetInternalID = InspectionSubsetInternalID AND _InspCharResultDetails.InspectionCharacteristic = InspectionCharacteristic  -- association [0..*]
;