C_SFIPlanInspCharInfo

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_SFIPlanInspCharInfo.
-- 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: CSFIPICINFO

CREATE VIEW C_SFIPlanInspCharInfo AS
SELECT
  Charinfo.InspectionLot AS InspectionLot,
  Charinfo.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  Charinfo.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  Charinfo.InspectionCharacteristic AS InspectionCharacteristic,
  Charinfo.ShopFloorItem AS ShopFloorItem,
  OpActyNtwkElement.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyNtwkInstance.OpActyNtwkInstance AS OpActyNtwkInstance,
  ShopFloorItemStatus.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  Charinfo.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  Charinfo.Plant AS Plant,
  Charinfo.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  Charinfo.SelectedCodeSet AS SelectedCodeSet,
  Charinfo._CharAttribSelectedCodeSetText.SelectedCodeSetText AS SelectedCodeSetText,
  Charinfo.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  Charinfo.InspCharacteristicSampleSize AS OriglNrOfInspCharcSamples,
  Charinfo.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  Charinfo.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  Charinfo.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  Charinfo.InspectionNonconformingRatio AS InspectionNonconformingRatio,
  Charinfo.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  Charinfo.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  Charinfo.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  Charinfo.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  Charinfo.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  Charinfo.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  Charinfo.InspSampleValuationRule AS InspSampleValuationRule,
  Charinfo.InspSpecAddlDecimalPlaces AS InspSpecAddlDecimalPlaces,
  Charinfo.InspSpecCharcCategory AS InspSpecCharcCategory,
  Charinfo.InspSpecControlIndicators AS InspSpecControlIndicators,
  Charinfo.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  cast(Charinfo.InspSpecHasLowerLimit as boolean) AS InspSpecHasLowerLimit,
  Charinfo.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  cast(Charinfo.InspSpecHasUpperLimit as boolean) AS InspSpecHasUpperLimit,
  Charinfo.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  Charinfo.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  Charinfo.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  Charinfo.InspSpecLowerLimit AS InspSpecLowerLimit,
  Charinfo.InspSpecRecordingType AS InspSpecRecordingType,
  Charinfo.InspSpecResultCalculation AS InspSpecResultCalculation,
  Charinfo.InspSpecSummarizedDcmlPlaces AS InspSpecSummarizedDcmlPlaces,
  Charinfo.InspSpecTargetValue AS InspSpecTargetValue,
  Charinfo.InspSpecUpperLimit AS InspSpecUpperLimit,
  Charinfo.InspSpecHasUprPlausibilityLmt AS InspSpecHasUprPlausibilityLmt,
  Charinfo.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  Charinfo.InspSpecHasLowrPlausibilityLmt AS InspSpecHasLowrPlausibilityLmt,
  InspSubsetResultLongText.InspSubsetResultLongText AS InspSpecificationLongText,
  Charinfo.InspectionLotStartTime AS InspectionLotStartTime,
  Charinfo.InspectionLotType AS InspectionLotType,
  InspectionMethodVersionText.InspectionMethodText AS InspectionMethodText,
  Charinfo.InspectionMethodPlant AS InspectionMethodPlant,
  Charinfo.InspectionMethodVersion AS InspectionMethodVersion,
  Charinfo.InspectionOperation AS InspectionOperation,
  Charinfo.InspectionResultAttribute AS InspectionResultAttribute,
  Charinfo.InspectionResultHasLongText AS InspectionResultHasLongText,
  Charinfo.InspectionResultMeanValue AS InspectionResultMeanValue,
  Charinfo.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  Charinfo.InspResultNrOfAddlDcmlsPlaces AS InspResultNrOfAddlDcmlsPlaces,
  Charinfo._InspectionResultStatusText.InspectionResultStatusText AS InspectionResultStatusText,
  Charinfo.InspectionResultText AS InspectionResultText,
  InspSubsetResultLongText.InspSubsetResultLongText AS InspectionResultLongText,
  Charinfo.InspectionResultStatus AS InspectionResultStatus,
  Charinfo.InspectionSampleSize AS InspectionSampleSize,
  Charinfo.InspectionSampleSize AS OriglNrOfInspSbstCharcSamples,
  Charinfo.InspectionSpecification AS InspectionSpecification,
  Charinfo.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  Charinfo.InspCharcInspSpecRefType AS InspCharcInspSpecRefType,
  Charinfo.InspCharcLongTextLanguage AS InspCharcLongTextLanguage,
  Charinfo.InspectionSpecificationText AS InspectionSpecificationText,
  Charinfo.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  Charinfo.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  Charinfo.InspectionValuationResult AS InspectionValuationResult,
  Charinfo.InspectionValuationResultText AS InspectionValuationResultText,
  Charinfo.LastChangedByUser AS LastChangedByUser,
  Charinfo.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  Charinfo.QuantityUnit AS QuantityUnit,
  Charinfo._InspectionSpecUnitText.UnitOfMeasureTechnicalName AS UnitOfMeasureTechnicalName,
  Charinfo.WorkCenter AS WorkCenter,
  Charinfo.InspSpecHasSamplingProcedure AS InspSpecHasSamplingProcedure,
  OpActyNtwkInstance.OrderInternalID AS OrderInternalID,
  Charinfo.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  Charinfo.InspSpecInspectedIsEnabled AS InspSpecInspectedIsEnabled,
  Charinfo.InspSpecNonConformingIsEnabled AS InspSpecNonConformingIsEnabled,
  Charinfo.NrOfRsltsAboveIsVisible AS NrOfRsltsAboveIsVisible,
  Charinfo.NrOfRsltsBelowIsVisible AS NrOfRsltsBelowIsVisible,
  Charinfo.InspRsltRecgViewTemplate AS InspRsltRecgViewTemplate,
  Charinfo.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  Charinfo.BOOCharacteristicInspRelevance AS BOOCharacteristicInspRelevance,
  Charinfo.InspSpecInformationField2 AS InspSpecInformationField2,
  Charinfo.InspSpecInformationField3 AS InspSpecInformationField3,
  Charinfo.InspSpecFormula2 AS InspSpecFormula2,
  OperationActivityInstance.BillOfOperationsType AS BillOfOperationsType,
  OperationActivityInstance.BillOfOperationsGroup AS BillOfOperationsGroup,
  OperationActivityInstance.BillOfOperationsVariant AS BillOfOperationsVariant,
  OperationActivityInstance.BillOfOperationsVersion AS BillOfOperationsVersion,
  cast( OpActyBOOCharcAssgmt.BillOfMaterial as abap.char( 8 ) ) AS BillOfMaterial,
  OpActyBOOCharcAssgmt.BillOfMaterialCategory AS BillOfMaterialCategory,
  OpActyBOOCharcAssgmt.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyBOOCharcAssgmt.InheritedNodeNumberForBOMItem AS OriglBOMItemInheritedNodeNmbr,
  cast( '' as stvkn ) AS InheritedNodeNumberForBOMItem,
  OpActyBOOCharcAssgmt.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyBOOCharcAssgmt.OriglDgtlMockUpCharcsUUID AS OriglOriglDgtlMockUpCharcsUUID,
  cast( hextobin('00000000000000000000000000000000') as cim_dmu_guid16 preserving type ) AS OriglDgtlMockUpCharcsUUID,
  OpActyBOOCharcAssgmt.DgtlMockUpCharcsUUID AS RefDgtlMockUpCharcsUUID,
  cast( hextobin('00000000000000000000000000000000') as cim_dmu_guid16 preserving type ) AS DgtlMockUpCharcsUUID,
  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,
  cast( '' as meta_value ) AS ReferenceDesignatorValue,
  Charinfo.BOOCharcGroup AS BOOCharcGroup,
  Charinfo.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  Charinfo.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  Charinfo._InspCharcGrp._InspCharcGrpDesc.InspCharcGrpDesc AS InspCharcGrpDesc,
  Charinfo._InspCharcGrp.InspCharcGrpDivnCnt AS InspCharcGrpDivnCnt,
  _InspCharcGrpDivnDesc.InspCharcGrpDivnDesc AS InspCharcGrpDivnDesc,
  OpActyBOOCharcAssgmt.OpActyCharcGrpSqnc AS OpActyCharcGrpSqnc,
  OpActyBOOCharcAssgmt.OpActyCharacteristicItem AS OpActyCharacteristicItem,
  QltyCtrlCht.QltyCtrlChartAggrgnCriterion AS QltyCtrlChartAggrgnCriterion,
  Charinfo.QualityControlChart AS QualityControlChart,
  cast( '' as idnrk) AS Material,
  cast( '' as maktx) AS MaterialName,
  OperationActyPRTAssignment.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  ProdnRsceToolCategoryText.ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  OperationActyPRTAssignment.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  OperationActyPRTAssignment.DocumentType AS DocumentType,
  OperationActyPRTAssignment.DocumentInfoRecord AS DocumentInfoRecord,
  OperationActyPRTAssignment.DocumentVersion AS DocumentVersion,
  OperationActyPRTAssignment.DocumentPart AS DocumentPart,
  Charinfo.InspectionLotQuantity AS InspectionLotQuantity,
  Charinfo.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  OrderOperationDatesQty.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  OrderOperationDatesQty.OperationUnit AS OperationUnit
FROM I_SFIPlanInspCharInfo AS Charinfo
INNER JOIN I_OpActyNtwkInstanceBasic AS OpActyNtwkInstance 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_OperationActivityInstance AS OperationActivityInstance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_SFIPlanInspCharResultRec AS _SFIResultDetails ON InspectionLot = _SFIResultDetails.InspectionLot AND InspPlanOperationInternalID = _SFIResultDetails.InspPlanOperationInternalID AND InspectionSubsetInternalID = _SFIResultDetails.InspectionSubsetInternalID AND InspectionCharacteristic = _SFIResultDetails.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN I_MfgInspCharcGrpDivnDesc AS _InspCharcGrpDivnDesc ON BOOCharcGroup = _InspCharcGrpDivnDesc.InspCharcGrp AND BOOCharcGroupDivision = _InspCharcGrpDivnDesc.InspCharcGrpDivn AND _InspCharcGrpDivnDesc.Language = $session.system_language  -- association [0..1]
;