P_Inspcharresultdet_With_Smpl

DDL: P_INSPCHARRESULTDET_WITH_SMPL SQL: PRSLTDETWITHSMPL Type: view COMPOSITE
31 Fields 7 Data Sources

P_Inspcharresultdet_With_Smpl is a Composite CDS View in SAP S/4HANA. It reads from 7 data sources and exposes 31 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID, InspResultItemInternalID.

Data Sources (7)

SourceAliasJoin Type
I_QltyMgmtPlantLvlConfign _Configuration left_outer
I_InspectionCharacteristic _Inspcharspecification inner
I_InspectionResultValue _InspResultValue left_outer
I_InspSubsetCharacteristic _InspSubsetChar inner
I_InspSubsetResult _InspSubsetResult inner
I_InspectionLot I_InspectionLot from
I_InspectionOperation I_InspectionOperation inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRSLTDETWITHSMPL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID _Insplotoperations InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic Characteristic
KEY InspectionSubsetInternalID I_InspSubsetResult InspectionSubsetInternalID Sample Number
KEY InspResultItemInternalID I_InspectionResultValue InspResultItemInternalID Insp. Unit No.
Plant I_InspectionLot Plant Valuation Area
InspectionSpecification I_InspectionCharacteristic InspectionSpecification Master IC
InspectionOperation _Insplotoperations InspectionOperation Operation
InspCharacteristicSampleUnit I_InspectionCharacteristic InspCharacteristicSampleUnit Sample Unit
InspectionMethod I_InspectionCharacteristic InspectionMethod Insp. Method
InspSpecLowerLimit I_InspectionCharacteristic InspSpecLowerLimit Lower Limit
InspSpecUpperLimit I_InspectionCharacteristic InspSpecUpperLimit Upper Limit
InspSpecTargetValue I_InspectionCharacteristic InspSpecTargetValue Target Value
InspSpecDecimalPlaces I_InspectionCharacteristic InspSpecDecimalPlaces Decimal Places
InspectionMethodVersion I_InspectionCharacteristic InspectionMethodVersion Version
InspectionSpecificationUnit I_InspectionCharacteristic InspectionSpecificationUnit Unit of Meas.
InspCharacteristicSampleSize I_InspectionCharacteristic InspCharacteristicSampleSize Inspect
InspSpecControlIndicators I_InspectionCharacteristic InspSpecControlIndicators CharCntrl ind.
Inspector I_InspSubsetResult Inspector Inspector
InspectionResultMeanValue I_InspSubsetResult InspectionResultMeanValue Mean Value
InspResultValidValuesNumber I_InspSubsetResult InspResultValidValuesNumber Inspected
InspResultValueInternalID I_InspectionResultValue InspResultValueInternalID Indiv. result
InspectionResultOriginalValue I_InspectionResultValue InspectionResultOriginalValue Original Value
InspectionResultMeasuredValue I_InspectionResultValue InspectionResultMeasuredValue Measured Value
InspectionResultItem I_InspectionResultValue InspectionResultItem Serial Number
LastChangedByUser _InspectionResult LastChangedByUser User Name
CreatedByUser _InspectionResult CreatedByUser User Name
InspSpecAddlDecimalPlaces I_QltyMgmtPlantLvlConfign InspSpecAddlDecimalPlaces AddlDecPlaces
InspSpecSummarizedDcmlPlaces
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.

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_Inspcharresultdet_With_Smpl.
-- 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: PRSLTDETWITHSMPL

CREATE VIEW P_Inspcharresultdet_With_Smpl AS
SELECT
  I_InspectionLot.InspectionLot AS InspectionLot,
  _Insplotoperations.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _Inspcharspecification.InspectionCharacteristic AS InspectionCharacteristic,
  _InspSubsetResult.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspResultValue.InspResultItemInternalID AS InspResultItemInternalID,
  I_InspectionLot.Plant AS Plant,
  _Inspcharspecification.InspectionSpecification AS InspectionSpecification,
  _Insplotoperations.InspectionOperation AS InspectionOperation,
  _Inspcharspecification.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _Inspcharspecification.InspectionMethod AS InspectionMethod,
  _Inspcharspecification.InspSpecLowerLimit AS InspSpecLowerLimit,
  _Inspcharspecification.InspSpecUpperLimit AS InspSpecUpperLimit,
  _Inspcharspecification.InspSpecTargetValue AS InspSpecTargetValue,
  _Inspcharspecification.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _Inspcharspecification.InspectionMethodVersion AS InspectionMethodVersion,
  _Inspcharspecification.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _Inspcharspecification.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _Inspcharspecification.InspSpecControlIndicators AS InspSpecControlIndicators,
  _InspSubsetResult.Inspector AS Inspector,
  _InspSubsetResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  _InspSubsetResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _InspResultValue.InspResultValueInternalID AS InspResultValueInternalID,
  _InspResultValue.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  _InspResultValue.InspectionResultMeasuredValue AS InspectionResultMeasuredValue,
  _InspResultValue.InspectionResultItem AS InspectionResultItem,
  _InspectionResult.LastChangedByUser AS LastChangedByUser,
  _InspectionResult.CreatedByUser AS CreatedByUser,
  _Configuration.InspSpecAddlDecimalPlaces AS InspSpecAddlDecimalPlaces,
  cast(_Configuration.InspSpecAddlDecimalPlaces+ _Inspcharspecification.InspSpecDecimalPlaces as qnkstellof) AS InspSpecSummarizedDcmlPlaces,
  I_InspectionLot.InspectionLotType AS InspectionLotType,
  I_InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspectionLot
INNER JOIN I_InspectionOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionCharacteristic AS _Inspcharspecification ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspSubsetCharacteristic AS _InspSubsetChar ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspSubsetResult AS _InspSubsetResult ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionResultValue AS _InspResultValue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_QltyMgmtPlantLvlConfign AS _Configuration ON /* join condition not captured in parsed metadata */
;

Learn More