P_SFOInspCharcInfo

DDL: P_SFOINSPCHARCINFO Type: view_entity COMPOSITE
97 Fields 3 Data Sources

P_SFOInspCharcInfo is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_InspectionCharacteristic, I_InspectionLot, I_InspectionOperation) and exposes 97 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic.

Data Sources (3)

SourceAliasJoin Type
I_InspectionCharacteristic InspectionCharacteristic inner
I_InspectionLot InspectionLot from
I_InspectionOperation InspectionOperation inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (97)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspectionOperation InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic Characteristic
InspectionSubsetInternalID InspSubsetCharacteristic InspectionSubsetInternalID
InspLotHasSubsets
InspectionLotStartTime I_InspectionLot InspectionLotStartTime
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.
Material I_InspectionLot Material Vehicle Model
Plant I_InspectionOperation InspectionOperationPlant Receiving Plant
WorkCenterInternalID I_InspectionOperation WorkCenterInternalID Work Center
SelectedCodeSetPlant
InspectionCharacteristicStatus I_InspectionCharacteristic InspectionCharacteristicStatus Status
ProductionOrderOperationActy
ProductionOrderOpActyVers I_InspectionCharacteristic ProductionOrderOpActyVers OA Version
SelectedCodeSet
InspSpecIsSelectedSetRequired I_InspectionCharacteristic InspSpecIsSelectedSetRequired
InspCharacteristicSampleUnit I_InspectionCharacteristic InspCharacteristicSampleUnit Sample Unit
InspCharacteristicSampleSize I_InspectionCharacteristic InspCharacteristicSampleSize Inspect
InspResultIsDocumentationRqd
InspSpecCharcCategory I_InspectionCharacteristic InspSpecCharcCategory
InspSpecControlIndicators I_InspectionCharacteristic InspSpecControlIndicators CharCntrl ind.
InspSpecDecimalPlaces I_InspectionCharacteristic InspSpecDecimalPlaces Decimal Places
InspSpecHasLowerLimit I_InspectionCharacteristic InspSpecHasLowerLimit Not Initial
InspSpecHasTargetValue I_InspectionCharacteristic InspSpecHasTargetValue Not Initial
InspSpecHasUpperLimit I_InspectionCharacteristic InspSpecHasUpperLimit Not Initial
InspSpecIsLongTermInspection I_InspectionCharacteristic InspSpecIsLongTermInspection
InspSpecIsMeasuredValueRqd I_InspectionCharacteristic InspSpecIsMeasuredValueRqd
InspSpecIsQuantitative I_InspectionCharacteristic InspSpecIsQuantitative Quant.charac.
InspSpecLowerLimit I_InspectionCharacteristic InspSpecLowerLimit Lower Limit
InspSpecRecordingType I_InspectionCharacteristic InspSpecRecordingType
InspSpecResultCalculation I_InspectionCharacteristic InspSpecResultCalculation
InspSpecSampleQuantityFactor I_InspectionCharacteristic InspSpecSampleQuantityFactor Base smpl. qty
InspSpecTargetValue I_InspectionCharacteristic InspSpecTargetValue Target Value
InspSpecUpperLimit I_InspectionCharacteristic InspSpecUpperLimit Upper Limit
InspSpecUpperPlausibilityLimit
InspSpecHasUprPlausibilityLmt I_InspectionCharacteristic InspSpecHasUprPlausibilityLmt Not Initial
InspSpecLowerPlausibilityLimit I_InspectionCharacteristic InspSpecLowerPlausibilityLimit LoPlaus. Limit
InspSpecHasLowrPlausibilityLmt I_InspectionCharacteristic InspSpecHasLowrPlausibilityLmt Not Initial
InspSpecificationHasLongText
InspectionMethod I_InspectionCharacteristic InspectionMethod Insp. Method
InspectionMethodPlant I_InspectionCharacteristic InspectionMethodPlant
InspectionMethodVersion I_InspectionCharacteristic InspectionMethodVersion Version
InspectionSpecification I_InspectionCharacteristic InspectionSpecification Master IC
InspectionSpecificationPlant I_InspectionCharacteristic InspectionSpecificationPlant
InspCharcInspSpecRefType I_InspectionCharacteristic InspCharcInspSpecRefType Reference type
InspCharcLongTextLanguage I_InspectionCharacteristic InspCharcLongTextLanguage Language
InspectionSpecificationText I_InspectionCharacteristic InspectionSpecificationText
InspectionSpecificationUnit I_InspectionCharacteristic InspectionSpecificationUnit Unit of Meas.
InspectionSpecificationVersion I_InspectionCharacteristic InspectionSpecificationVersion Version
QuantityUnit I_InspectionCharacteristic QuantityUnit Unit of measure
InspSpecHasSamplingProcedure I_InspectionCharacteristic InspSpecHasSamplingProcedure
SamplingProcedure I_InspectionCharacteristic SamplingProcedure Smpl.procedure
InspSpecIsDefectsRecgAutomatic I_InspectionCharacteristic InspSpecIsDefectsRecgAutomatic
BOOCharacteristicInspRelevance I_InspectionCharacteristic BOOCharacteristicInspRelevance Insp. Relevance
InspSpecInformationField1
InspSpecInformationField2 I_InspectionCharacteristic InspSpecInformationField2 Info Field 2
InspSpecInformationField3 I_InspectionCharacteristic InspSpecInformationField3 Info Field 3
InspSpecHasFormula
InspSpecFormula1
InspSpecFormula2 I_InspectionCharacteristic InspSpecFormula2 Formula
BOOCharcGroup
BOOCharcGroupDivision I_InspectionCharacteristic BOOCharcGroupDivision Internal Division ID
BOOCharcSourceCharc I_InspectionCharacteristic BOOCharcSourceCharc Source Charc
InspCharcIsNotPlanned
InspSpecHasControlChart
InspLotTestEquipInternalID
QualityControlChart
InspectionSampleSize
InspSampleAcceptanceNumber InspSubsetCharacteristic InspSampleAcceptanceNumber
InspSampleRejectionNumber InspSubsetCharacteristic InspSampleRejectionNumber
InspSampleValuationRule InspSubsetCharacteristic InspSampleValuationRule Valuation Rule
InspSpecAddlDecimalPlaces
InspSpecSummarizedDcmlPlaces
InspRsltFreeDefinedTestEquip
EquipmentName EquipmentText EquipmentName Tech. Obj. Desc
InspResultValidValuesNumber InspectionResult InspResultValidValuesNumber
InspRsltBelowToleranceValsNmbr InspectionResult InspRsltBelowToleranceValsNmbr
InspRsltAboveToleranceValsNmbr InspectionResult InspRsltAboveToleranceValsNmbr
InspRsltNonconformingValsNmbr InspectionResult InspRsltNonconformingValsNmbr
fltpendasInspectionNonconformingRatio
InspectionResultAttribute InspectionResult InspectionResultAttribute
InspectionResultHasLongText InspectionResult InspectionResultHasLongText
InspectionResultMeanValue InspectionResult InspectionResultMeanValue
InspectionResultOriginalValue InspectionResult InspectionResultOriginalValue
InspResultNrOfAddlDcmlsPlaces InspectionResult InspResultNrOfAddlDcmlsPlaces
InspectionResultText InspectionResult InspectionResultText
InspectionResultStatus InspectionResult InspectionResultStatus
InspectionValuationResult InspectionResult InspectionValuationResult
InspectionResultHasMeanValue InspectionResult InspectionResultHasMeanValue
LastChangedByUser InspectionResult LastChangedByUser User Name
CharacteristicAttributeCode
CharacteristicAttributeCodeGrp InspectionResult CharacteristicAttributeCodeGrp
QltyCtrlChartAggrgnCriterion
InspectionResultLongText InspResultLongText InspectionResultLongText
BOOCharacteristicVersion I_InspectionCharacteristic BOOCharacteristicVersion Sort pos.
_InspectionSpecificationUnit I_InspectionCharacteristic _InspectionSpecificationUnit

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 P_SFOInspCharcInfo.
-- 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 P_SFOInspCharcInfo AS
SELECT
  InspectionLot.InspectionLot AS InspectionLot,
  InspectionOperation.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspectionCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  InspSubsetCharacteristic.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspectionLot.InspectionLotStartTime AS InspectionLotStartTime,
  InspectionLot.InspectionLotType AS InspectionLotType,
  InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  InspectionLot.Material AS Material,
  InspectionOperation.InspectionOperationPlant AS Plant,
  InspectionOperation.WorkCenterInternalID AS WorkCenterInternalID,
  InspectionCharacteristic.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  InspectionCharacteristic.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  InspectionCharacteristic.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  InspectionCharacteristic.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  InspectionCharacteristic.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  InspectionCharacteristic.InspSpecCharcCategory AS InspSpecCharcCategory,
  InspectionCharacteristic.InspSpecControlIndicators AS InspSpecControlIndicators,
  InspectionCharacteristic.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  InspectionCharacteristic.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  InspectionCharacteristic.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  InspectionCharacteristic.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  InspectionCharacteristic.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  InspectionCharacteristic.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  InspectionCharacteristic.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  InspectionCharacteristic.InspSpecLowerLimit AS InspSpecLowerLimit,
  InspectionCharacteristic.InspSpecRecordingType AS InspSpecRecordingType,
  InspectionCharacteristic.InspSpecResultCalculation AS InspSpecResultCalculation,
  InspectionCharacteristic.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  InspectionCharacteristic.InspSpecTargetValue AS InspSpecTargetValue,
  InspectionCharacteristic.InspSpecUpperLimit AS InspSpecUpperLimit,
  InspectionCharacteristic.InspSpecHasUprPlausibilityLmt AS InspSpecHasUprPlausibilityLmt,
  InspectionCharacteristic.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  InspectionCharacteristic.InspSpecHasLowrPlausibilityLmt AS InspSpecHasLowrPlausibilityLmt,
  InspectionCharacteristic.InspectionMethod AS InspectionMethod,
  InspectionCharacteristic.InspectionMethodPlant AS InspectionMethodPlant,
  InspectionCharacteristic.InspectionMethodVersion AS InspectionMethodVersion,
  InspectionCharacteristic.InspectionSpecification AS InspectionSpecification,
  InspectionCharacteristic.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  InspectionCharacteristic.InspCharcInspSpecRefType AS InspCharcInspSpecRefType,
  InspectionCharacteristic.InspCharcLongTextLanguage AS InspCharcLongTextLanguage,
  InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  InspectionCharacteristic.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  InspectionCharacteristic.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  InspectionCharacteristic.QuantityUnit AS QuantityUnit,
  InspectionCharacteristic.InspSpecHasSamplingProcedure AS InspSpecHasSamplingProcedure,
  InspectionCharacteristic.SamplingProcedure AS SamplingProcedure,
  InspectionCharacteristic.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  InspectionCharacteristic.BOOCharacteristicInspRelevance AS BOOCharacteristicInspRelevance,
  InspectionCharacteristic.InspSpecInformationField2 AS InspSpecInformationField2,
  InspectionCharacteristic.InspSpecInformationField3 AS InspSpecInformationField3,
  InspectionCharacteristic.InspSpecFormula2 AS InspSpecFormula2,
  InspectionCharacteristic.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  InspectionCharacteristic.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  InspSubsetCharacteristic.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  InspSubsetCharacteristic.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  InspSubsetCharacteristic.InspSampleValuationRule AS InspSampleValuationRule,
  cast ( Configuration.InspSpecAddlDecimalPlaces + InspectionCharacteristic.InspSpecDecimalPlaces as qstellen ) AS InspSpecSummarizedDcmlPlaces,
  EquipmentText.EquipmentName AS EquipmentName,
  InspectionResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  InspectionResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  InspectionResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  InspectionResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  case when InspectionResult.InspResultValidValuesNumber = 0 or InspectionResult.InspectionValuationResult = '' or InspectionResult.InspectionValuationResult is null then 0 else cast(InspectionResult.InspRsltNonconformingValsNmbr as abap.fltp) / cast(InspectionResult.InspResultValidValuesNumber as abap.fltp) end as InspectionNonconformingRatio AS fltpendasInspectionNonconformingRatio,
  InspectionResult.InspectionResultAttribute AS InspectionResultAttribute,
  InspectionResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  InspectionResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  InspectionResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  InspectionResult.InspResultNrOfAddlDcmlsPlaces AS InspResultNrOfAddlDcmlsPlaces,
  InspectionResult.InspectionResultText AS InspectionResultText,
  InspectionResult.InspectionResultStatus AS InspectionResultStatus,
  InspectionResult.InspectionValuationResult AS InspectionValuationResult,
  InspectionResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  InspectionResult.LastChangedByUser AS LastChangedByUser,
  InspectionResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  InspResultLongText.InspectionResultLongText AS InspectionResultLongText,
  InspectionCharacteristic.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  InspectionCharacteristic._InspectionSpecificationUnit AS _InspectionSpecificationUnit
FROM I_InspectionLot AS InspectionLot
INNER JOIN I_InspectionOperation AS InspectionOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionCharacteristic AS InspectionCharacteristic ON /* join condition not captured in parsed metadata */
;

Learn More