P_SFOInspSubsetCharcInfo

DDL: P_SFOINSPSUBSETCHARCINFO Type: view_entity COMPOSITE
97 Fields 5 Data Sources

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

Data Sources (5)

SourceAliasJoin Type
I_InspectionCharacteristic InspectionCharacteristic inner
I_InspectionLot InspectionLot from
I_InspectionOperation InspectionOperation inner
I_InspectionSubset InspectionSubset inner
I_InspSubsetCharacteristic InspSubsetCharacteristic 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
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID Sample Number
ShopFloorItem I_InspectionSubset ShopFloorItem Serial.Mat. ID
InspLotHasSubsets
InspectionLotStartTime I_InspectionLot InspectionLotStartTime
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.
Plant I_InspectionOperation InspectionOperationPlant Receiving Plant
WorkCenterInternalID I_InspectionOperation WorkCenterInternalID Work Center
SelectedCodeSetPlant
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
BOOCharacteristicVersion I_InspectionCharacteristic BOOCharacteristicVersion Sort pos.
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 I_InspSubsetCharacteristic InspSampleAcceptanceNumber Acceptance no.
InspSampleRejectionNumber I_InspSubsetCharacteristic InspSampleRejectionNumber Rejection no.
InspSampleValuationRule I_InspSubsetCharacteristic InspSampleValuationRule Valuation Rule
InspSpecAddlDecimalPlaces
InspSpecSummarizedDcmlPlaces
InspRsltFreeDefinedTestEquip
EquipmentName EquipmentText EquipmentName Tech. Obj. Desc
InspResultValidValuesNumber InspSampleResult InspResultValidValuesNumber
InspRsltBelowToleranceValsNmbr InspSampleResult InspRsltBelowToleranceValsNmbr
InspRsltAboveToleranceValsNmbr InspSampleResult InspRsltAboveToleranceValsNmbr
InspRsltNonconformingValsNmbr InspSampleResult InspRsltNonconformingValsNmbr
fltpendasInspectionNonconformingRatio
InspectionResultAttribute InspSampleResult InspectionResultAttribute
InspectionResultHasLongText InspSampleResult InspectionResultHasLongText
InspectionResultMeanValue InspSampleResult InspectionResultMeanValue
InspectionResultOriginalValue InspSampleResult InspectionResultOriginalValue
InspResultNrOfAddlDcmlsPlaces InspSampleResult InspResultNrOfAddlDcmlsPlaces
InspectionResultText InspSampleResult InspectionResultText
InspectionResultStatus InspSampleResult InspectionResultStatus
InspectionValuationResult InspSampleResult InspectionValuationResult
InspectionResultHasMeanValue InspSampleResult InspectionResultHasMeanValue
LastChangedByUser InspSampleResult LastChangedByUser User Name
CharacteristicAttributeCode
CharacteristicAttributeCodeGrp InspSampleResult CharacteristicAttributeCodeGrp
QltyCtrlChartAggrgnCriterion
InspSubsetResultLongText
SelectedCodeSetText
_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_SFOInspSubsetCharcInfo.
-- 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_SFOInspSubsetCharcInfo AS
SELECT
  InspectionLot.InspectionLot AS InspectionLot,
  InspectionOperation.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspectionCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  InspSubsetCharacteristic.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspectionSubset.ShopFloorItem AS ShopFloorItem,
  InspectionLot.InspectionLotStartTime AS InspectionLotStartTime,
  InspectionLot.InspectionLotType AS InspectionLotType,
  InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  InspectionOperation.InspectionOperationPlant AS Plant,
  InspectionOperation.WorkCenterInternalID AS WorkCenterInternalID,
  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.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  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,
  InspSampleResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  InspSampleResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  InspSampleResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  InspSampleResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  case when InspSampleResult.InspResultValidValuesNumber = 0 or InspSampleResult.InspectionValuationResult = '' or InspSampleResult.InspectionValuationResult is null then 0 else cast(InspSampleResult.InspRsltNonconformingValsNmbr as abap.fltp) / cast(InspSampleResult.InspResultValidValuesNumber as abap.fltp) end as InspectionNonconformingRatio AS fltpendasInspectionNonconformingRatio,
  InspSampleResult.InspectionResultAttribute AS InspectionResultAttribute,
  InspSampleResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  InspSampleResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  InspSampleResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  InspSampleResult.InspResultNrOfAddlDcmlsPlaces AS InspResultNrOfAddlDcmlsPlaces,
  InspSampleResult.InspectionResultText AS InspectionResultText,
  InspSampleResult.InspectionResultStatus AS InspectionResultStatus,
  InspSampleResult.InspectionValuationResult AS InspectionValuationResult,
  InspSampleResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  InspSampleResult.LastChangedByUser AS LastChangedByUser,
  InspSampleResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp
FROM I_InspectionLot AS InspectionLot
INNER JOIN I_InspectionOperation AS InspectionOperation 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 */
INNER JOIN I_InspectionCharacteristic AS InspectionCharacteristic ON /* join condition not captured in parsed metadata */
;

Learn More