C_MfgOrdPlanInspCharInfo

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_MfgOrdPlanInspCharInfo.
-- 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: CORDPIC

CREATE VIEW C_MfgOrdPlanInspCharInfo AS
SELECT
  Charinfo.InspectionLot AS InspectionLot,
  Charinfo.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  Charinfo.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  Charinfo.InspectionCharacteristic AS InspectionCharacteristic,
  OpActyNtwkInstance.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyNtwkInstance.OrderInternalID AS OrderInternalID,
  Charinfo.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  Charinfo._CharcAttribSeldSetCodeSetTxt.SelectedCodeSetText AS SelectedCodeSetText,
  Charinfo.SelectedCodeSet AS SelectedCodeSet,
  Charinfo.InspCharacteristicSampleSize AS OriglNrOfInspCharcSamples,
  Charinfo.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  Charinfo.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  Charinfo.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  Charinfo.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  Charinfo.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  Charinfo.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  Charinfo.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  Charinfo.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  Charinfo.InspSampleValuationRule AS InspSampleValuationRule,
  Charinfo.InspSpecControlIndicators AS InspSpecControlIndicators,
  Charinfo.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  Charinfo.InspSpecCharcCategory AS InspSpecCharcCategory,
  cast(Charinfo.InspSpecHasLowerLimit as boolean) AS InspSpecHasLowerLimit,
  Charinfo.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  cast(Charinfo.InspSpecHasUpperLimit as boolean) AS InspSpecHasUpperLimit,
  Charinfo.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  Charinfo.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  Charinfo.InspSpecLowerLimit AS InspSpecLowerLimit,
  Charinfo.InspSpecRecordingType AS InspSpecRecordingType,
  Charinfo.InspSpecSummarizedDcmlPlaces AS InspSpecSummarizedDcmlPlaces,
  Charinfo.InspSpecTargetValue AS InspSpecTargetValue,
  Charinfo.InspSpecUpperLimit AS InspSpecUpperLimit,
  Charinfo.InspectionNonconformingRatio AS InspectionNonconformingRatio,
  Charinfo.InspectionOperation AS InspectionOperation,
  Charinfo.InspectionResultAttribute AS InspectionResultAttribute,
  Charinfo.InspectionResultHasLongText AS InspectionResultHasLongText,
  InspResultLongText.InspectionResultLongText AS InspSpecificationLongText,
  InspectionMethodVersionText.InspectionMethodText AS InspectionMethodText,
  Charinfo.InspectionMethodPlant AS InspectionMethodPlant,
  Charinfo.InspectionMethodVersion AS InspectionMethodVersion,
  Charinfo.InspectionResultMeanValue AS InspectionResultMeanValue,
  Charinfo.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  Charinfo.InspResultNrOfAddlDcmlsPlaces AS InspResultNrOfAddlDcmlsPlaces,
  Charinfo.InspectionResultStatus AS InspectionResultStatus,
  _InspectionResultStatusText.InspectionResultStatusText AS InspectionResultStatusText,
  Charinfo.InspectionResultText AS InspectionResultText,
  InspResultLongText.InspectionResultLongText AS InspectionResultLongText,
  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.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  Charinfo.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  Charinfo.Plant AS Plant,
  Charinfo.QuantityUnit AS QuantityUnit,
  Charinfo._UnitOfMeasureText.UnitOfMeasureTechnicalName AS UnitOfMeasureTechnicalName,
  Charinfo.WorkCenter AS WorkCenter,
  Charinfo.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  Charinfo.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  Charinfo.InspSpecInspectedIsEnabled AS InspSpecInspectedIsEnabled,
  Charinfo.InspSpecNonConformingIsEnabled AS InspSpecNonConformingIsEnabled,
  Charinfo.NrOfRsltsAboveIsVisible AS NrOfRsltsAboveIsVisible,
  Charinfo.NrOfRsltsBelowIsVisible AS NrOfRsltsBelowIsVisible,
  Charinfo.InspRsltRecgViewTemplate AS InspRsltRecgViewTemplate,
  Charinfo.InspectionLotType AS InspectionLotType,
  Charinfo.BOOCharacteristicInspRelevance AS BOOCharacteristicInspRelevance,
  Charinfo.InspSpecInformationField2 AS InspSpecInformationField2,
  Charinfo.InspSpecInformationField3 AS InspSpecInformationField3,
  Charinfo.InspSpecFormula2 AS InspSpecFormula2,
  Charinfo.InspSpecResultCalculation AS InspSpecResultCalculation,
  Charinfo.InspSpecHasUprPlausibilityLmt AS InspSpecHasUprPlausibilityLmt,
  Charinfo.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  Charinfo.InspSpecHasLowrPlausibilityLmt AS InspSpecHasLowrPlausibilityLmt,
  OperationActivityInstance.BillOfOperationsType AS BillOfOperationsType,
  OperationActivityInstance.BillOfOperationsGroup AS BillOfOperationsGroup,
  OperationActivityInstance.BillOfOperationsVariant AS BillOfOperationsVariant,
  OperationActivityInstance.BillOfOperationsVersion AS BillOfOperationsVersion,
  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.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  Charinfo.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  Charinfo._InspCharcGrp._InspCharcGrpDesc.InspCharcGrpDesc AS InspCharcGrpDesc,
  Charinfo._InspCharcGrp.InspCharcGrpDivnCnt AS InspCharcGrpDivnCnt,
  _InspCharcGrpDivnDesc.InspCharcGrpDivnDesc AS InspCharcGrpDivnDesc,
  OpActyBOOCharcAssgmt.OpActyCharcGrpSqnc AS OpActyCharcGrpSqnc,
  OpActyCharacteristicItem,
  Charinfo.QualityControlChart AS QualityControlChart,
  Charinfo.InspSpecHasControlChart AS InspSpecHasControlChart,
  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,
  Charinfo._InspCharcGrp AS _InspCharcGrp,
  Charinfo._InspCharcGrpDivn AS _InspCharcGrpDivn,
  Charinfo._InspectionSpecificationUnit AS _InspectionSpecificationUnit
FROM I_OpActyPlanInspCharInfo 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_MfgOrdInspCharResultRec AS _SFOResultDetails ON InspectionLot = _SFOResultDetails.InspectionLot AND InspPlanOperationInternalID = _SFOResultDetails.InspPlanOperationInternalID AND InspectionSubsetInternalID = _SFOResultDetails.InspectionSubsetInternalID AND InspectionCharacteristic = _SFOResultDetails.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]
;