A_InspectionResultValue

DDL: A_INSPECTIONRESULTVALUE SQL: AINSPRESULTVALUE Type: view COMPOSITE Package: ODATA_QM_INSPECTION_API
52 Fields 1 Data Sources 3 Associations

Single Inspection Results

A_InspectionResultValue is a Composite CDS View that provides data about "Single Inspection Results" in SAP S/4HANA. It reads from 1 data source (I_InspectionResultValueTP) and exposes 52 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspResultValueInternalID. It has 3 associations to related views. Part of development package ODATA_QM_INSPECTION_API.

Data Sources (1)

SourceAliasJoin Type
I_InspectionResultValueTP _InspResultValue from

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_InspectionResult _InspResult $projection.InspectionLot = _InspResult.InspectionLot and $projection.InspPlanOperationInternalID = _InspResult.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _InspResult.InspectionCharacteristic
[1..1] A_InspectionCharacteristic _InspCharc $projection.InspectionLot = _InspCharc.InspectionLot and $projection.InspPlanOperationInternalID = _InspCharc.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _InspCharc.InspectionCharacteristic
[1..1] E_InspectionResultValue _Extension $projection.InspectionLot = _Extension.InspectionLot and $projection.InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _Extension.InspectionCharacteristic and $projection.InspResultValueInternalID = _Extension.InspResultValueInternalID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName AINSPRESULTVALUE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Single Inspection Results view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.entityChangeStateId ChangedDateTime view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionResultValueTP InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspectionResultValueTP InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspectionResultValueTP InspectionCharacteristic
KEY InspResultValueInternalID I_InspectionResultValueTP InspResultValueInternalID
InspectionResultAttribute I_InspectionResultValueTP InspectionResultAttribute
InspResultItemInternalID I_InspectionResultValueTP InspResultItemInternalID
InspectionSubsetInternalID I_InspectionResultValueTP InspectionSubsetInternalID
InspectionResultMeasuredValue I_InspectionResultValueTP InspectionResultMeasuredValue
InspResultFrmtdMeasuredValue I_InspectionResultValueTP InspResultFrmtdMeasuredValue
InspResultHasMeasuredValue I_InspectionResultValueTP InspResultHasMeasuredValue
InspectionResultOriginalValue I_InspectionResultValueTP InspectionResultOriginalValue
InspectionNumberOfDefects I_InspectionResultValueTP InspectionNumberOfDefects
DefectClass I_InspectionResultValueTP DefectClass Defect Class
InspectionResultText I_InspectionResultValueTP InspectionResultText
InspLotSingleUnitNumber I_InspectionResultValueTP InspLotSingleUnitNumber
InspectionResultItem I_InspectionResultValueTP InspectionResultItem
InspRsltFreeDefinedTestEquip I_InspectionResultValueTP InspRsltFreeDefinedTestEquip
InspectionValuationResult I_InspectionResultValueTP InspectionValuationResult
CharacteristicAttributeCodeGrp I_InspectionResultValueTP CharacteristicAttributeCodeGrp
InspectionResultCodeGroup2 I_InspectionResultValueTP InspectionResultCodeGroup2
InspectionResultCodeGroup3 I_InspectionResultValueTP InspectionResultCodeGroup3
InspectionResultCodeGroup4 I_InspectionResultValueTP InspectionResultCodeGroup4
InspectionResultCodeGroup5 I_InspectionResultValueTP InspectionResultCodeGroup5
CharacteristicAttributeCode I_InspectionResultValueTP CharacteristicAttributeCode
InspectionResultCode2 I_InspectionResultValueTP InspectionResultCode2
InspectionResultCode3 I_InspectionResultValueTP InspectionResultCode3
InspectionResultCode4 I_InspectionResultValueTP InspectionResultCode4
InspectionResultCode5 I_InspectionResultValueTP InspectionResultCode5
CharacteristicAttributeCatalog I_InspectionResultValueTP CharacteristicAttributeCatalog
InspectionResultCatalog2 I_InspectionResultValueTP InspectionResultCatalog2
InspectionResultCatalog3 I_InspectionResultValueTP InspectionResultCatalog3
InspectionResultCatalog4 I_InspectionResultValueTP InspectionResultCatalog4
InspectionResultCatalog5 I_InspectionResultValueTP InspectionResultCatalog5
Inspector I_InspectionResultValueTP Inspector Inspector
InspectionStartDate I_InspectionResultValueTP InspectionStartDate
InspectionStartTime I_InspectionResultValueTP InspectionStartTime
InspectionEndDate I_InspectionResultValueTP InspectionEndDate
InspectionEndTime I_InspectionResultValueTP InspectionEndTime
CreationDate I_InspectionResultValueTP CreationDate Time Stamp
CreationTime I_InspectionResultValueTP CreationTime Time of Change
CreatedByUser I_InspectionResultValueTP CreatedByUser User Name
LastChangeDate I_InspectionResultValueTP LastChangeDate Time Stamp
ChangedTime I_InspectionResultValueTP ChangedTime Changed at
LastChangedByUser I_InspectionResultValueTP LastChangedByUser User Name
ChangedDateTime I_InspectionResultValueTP ChangedDateTime Time Stamp
Plant I_InspectionResultValueTP Plant Valuation Area
IsBusinessPurposeCompleted I_InspectionResultValueTP IsBusinessPurposeCompleted Purpose Completed
WorkCenter I_InspectionResultValueTP WorkCenter Work Center
InspectionLotType I_InspectionResultValueTP InspectionLotType Inspection Type
MatlQualityAuthorizationGroup I_InspectionResultValueTP MatlQualityAuthorizationGroup QM Matl Auth.
_InspResult _InspResult
_InspCharc _InspCharc

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 A_InspectionResultValue.
-- 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: AINSPRESULTVALUE

CREATE VIEW A_InspectionResultValue AS
SELECT
  _InspResultValue.InspectionLot AS InspectionLot,
  _InspResultValue.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspResultValue.InspectionCharacteristic AS InspectionCharacteristic,
  _InspResultValue.InspResultValueInternalID AS InspResultValueInternalID,
  _InspResultValue.InspectionResultAttribute AS InspectionResultAttribute,
  _InspResultValue.InspResultItemInternalID AS InspResultItemInternalID,
  _InspResultValue.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspResultValue.InspectionResultMeasuredValue AS InspectionResultMeasuredValue,
  _InspResultValue.InspResultFrmtdMeasuredValue AS InspResultFrmtdMeasuredValue,
  _InspResultValue.InspResultHasMeasuredValue AS InspResultHasMeasuredValue,
  _InspResultValue.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  _InspResultValue.InspectionNumberOfDefects AS InspectionNumberOfDefects,
  _InspResultValue.DefectClass AS DefectClass,
  _InspResultValue.InspectionResultText AS InspectionResultText,
  _InspResultValue.InspLotSingleUnitNumber AS InspLotSingleUnitNumber,
  _InspResultValue.InspectionResultItem AS InspectionResultItem,
  _InspResultValue.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  _InspResultValue.InspectionValuationResult AS InspectionValuationResult,
  _InspResultValue.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _InspResultValue.InspectionResultCodeGroup2 AS InspectionResultCodeGroup2,
  _InspResultValue.InspectionResultCodeGroup3 AS InspectionResultCodeGroup3,
  _InspResultValue.InspectionResultCodeGroup4 AS InspectionResultCodeGroup4,
  _InspResultValue.InspectionResultCodeGroup5 AS InspectionResultCodeGroup5,
  _InspResultValue.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _InspResultValue.InspectionResultCode2 AS InspectionResultCode2,
  _InspResultValue.InspectionResultCode3 AS InspectionResultCode3,
  _InspResultValue.InspectionResultCode4 AS InspectionResultCode4,
  _InspResultValue.InspectionResultCode5 AS InspectionResultCode5,
  _InspResultValue.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspResultValue.InspectionResultCatalog2 AS InspectionResultCatalog2,
  _InspResultValue.InspectionResultCatalog3 AS InspectionResultCatalog3,
  _InspResultValue.InspectionResultCatalog4 AS InspectionResultCatalog4,
  _InspResultValue.InspectionResultCatalog5 AS InspectionResultCatalog5,
  _InspResultValue.Inspector AS Inspector,
  _InspResultValue.InspectionStartDate AS InspectionStartDate,
  _InspResultValue.InspectionStartTime AS InspectionStartTime,
  _InspResultValue.InspectionEndDate AS InspectionEndDate,
  _InspResultValue.InspectionEndTime AS InspectionEndTime,
  _InspResultValue.CreationDate AS CreationDate,
  _InspResultValue.CreationTime AS CreationTime,
  _InspResultValue.CreatedByUser AS CreatedByUser,
  _InspResultValue.LastChangeDate AS LastChangeDate,
  _InspResultValue.ChangedTime AS ChangedTime,
  _InspResultValue.LastChangedByUser AS LastChangedByUser,
  _InspResultValue.ChangedDateTime AS ChangedDateTime,
  _InspResultValue.Plant AS Plant,
  _InspResultValue.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspResultValue.WorkCenter AS WorkCenter,
  _InspResultValue.InspectionLotType AS InspectionLotType,
  _InspResultValue.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspectionResultValueTP AS _InspResultValue
LEFT OUTER JOIN A_InspectionResult AS _InspResult ON InspectionLot = _InspResult.InspectionLot AND InspPlanOperationInternalID = _InspResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspResult.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN A_InspectionCharacteristic AS _InspCharc ON InspectionLot = _InspCharc.InspectionLot AND InspPlanOperationInternalID = _InspCharc.InspPlanOperationInternalID AND InspectionCharacteristic = _InspCharc.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN E_InspectionResultValue AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic AND InspResultValueInternalID = _Extension.InspResultValueInternalID  -- association [1..1]
;

Learn More