I_InspSubsetResultValueTP

DDL: I_INSPSUBSETRESULTVALUETP SQL: IINSUBRESVALTP Type: view TRANSACTIONAL
44 Fields 1 Data Sources 2 Associations

Single Value of an Inspection Charc Rslt

I_InspSubsetResultValueTP is a Transactional CDS View that provides data about "Single Value of an Inspection Charc Rslt" in SAP S/4HANA. It reads from 1 data source (I_InspectionResultValue) and exposes 44 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID, InspectionCharacteristic, InspResultValueInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspectionResultValue I_InspectionResultValue from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InspectionSubsetTP _InspectionSubset $projection.InspectionLot = _InspectionSubset.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionSubset.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _InspectionSubset.InspectionSubsetInternalID
[1..1] I_InspSubsetCharcResultTP _InspSubsetCharacteristic $projection.InspectionLot = _InspSubsetCharacteristic.InspectionLot and $projection.InspPlanOperationInternalID = _InspSubsetCharacteristic.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _InspSubsetCharacteristic.InspectionSubsetInternalID and $projection.InspectionCharacteristic = _InspSubsetCharacteristic.InspectionCharacteristic

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IINSUBRESVALTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Single Value of an Inspection Charc Rslt view
VDM.viewType #TRANSACTIONAL view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence QINSPRSLTVAL_D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
KEY InspectionSubsetInternalID InspectionSubsetInternalID Sample Number
KEY InspectionCharacteristic InspectionCharacteristic Characteristic
KEY InspResultValueInternalID InspResultValueInternalID Indiv. result
InspectionResultAttribute InspectionResultAttribute Name of attribute
CreationDate CreationDate Time Stamp
InspResultItemInternalID InspResultItemInternalID Insp. Unit No.
InspectionResultMeasuredValue InspectionResultMeasuredValue Measured Value
InspResultHasMeasuredValue InspResultHasMeasuredValue
InspectionResultOriginalValue InspectionResultOriginalValue Original Value
InspectionResultText InspectionResultText
InspLotSingleUnitNumber InspLotSingleUnitNumber Single Unit
InspectionResultItem InspectionResultItem Serial Number
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip Information
InspectionValuationResult InspectionValuationResult Valuation
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp Code Group
InspectionResultCodeGroup2 InspectionResultCodeGroup2 Code Group
InspectionResultCodeGroup3 InspectionResultCodeGroup3 Code Group
InspectionResultCodeGroup4 InspectionResultCodeGroup4 Code Group
InspectionResultCodeGroup5 InspectionResultCodeGroup5 Code Group
CharacteristicAttributeCode CharacteristicAttributeCode Code
InspectionResultCode2 InspectionResultCode2 Code
InspectionResultCode3 InspectionResultCode3 Code
InspectionResultCode4 InspectionResultCode4 Code
InspectionResultCode5 InspectionResultCode5 Code
CharacteristicAttributeCatalog CharacteristicAttributeCatalog Catalog Type
InspectionResultCatalog2 InspectionResultCatalog2 Catalog Type
InspectionResultCatalog3 InspectionResultCatalog3 Catalog Type
InspectionResultCatalog4 InspectionResultCatalog4 Catalog Type
InspectionResultCatalog5 InspectionResultCatalog5 Catalog Type
InspectionStartDate InspectionStartDate Insp.Start Date
InspectionStartTime InspectionStartTime Insp.Start Time
InspectionEndDate InspectionEndDate Insp. End Date
InspectionEndTime InspectionEndTime Insp. End Time
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_InspectionCharacteristic _InspectionCharacteristic
_CharcAttributeCodeGrp _CharcAttributeCodeGrp
_CharcAttributeCode _CharcAttributeCode
_InspectionResultAttribute _InspectionResultAttribute
_InspectionValuationResult _InspectionValuationResult
_InspectionSubset _InspectionSubset
_InspSubsetCharacteristic _InspSubsetCharacteristic

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 I_InspSubsetResultValueTP.
-- 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: IINSUBRESVALTP

CREATE VIEW I_InspSubsetResultValueTP AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionSubsetInternalID,
  InspectionCharacteristic,
  InspResultValueInternalID,
  InspectionResultAttribute,
  CreationDate,
  InspResultItemInternalID,
  InspectionResultMeasuredValue,
  InspResultHasMeasuredValue,
  InspectionResultOriginalValue,
  InspectionResultText,
  InspLotSingleUnitNumber,
  InspectionResultItem,
  InspRsltFreeDefinedTestEquip,
  InspectionValuationResult,
  CharacteristicAttributeCodeGrp,
  InspectionResultCodeGroup2,
  InspectionResultCodeGroup3,
  InspectionResultCodeGroup4,
  InspectionResultCodeGroup5,
  CharacteristicAttributeCode,
  InspectionResultCode2,
  InspectionResultCode3,
  InspectionResultCode4,
  InspectionResultCode5,
  CharacteristicAttributeCatalog,
  InspectionResultCatalog2,
  InspectionResultCatalog3,
  InspectionResultCatalog4,
  InspectionResultCatalog5,
  InspectionStartDate,
  InspectionStartTime,
  InspectionEndDate,
  InspectionEndTime
FROM I_InspectionResultValue
LEFT OUTER JOIN I_InspectionSubsetTP AS _InspectionSubset ON InspectionLot = _InspectionSubset.InspectionLot AND InspPlanOperationInternalID = _InspectionSubset.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspectionSubset.InspectionSubsetInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetCharcResultTP AS _InspSubsetCharacteristic ON InspectionLot = _InspSubsetCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspSubsetCharacteristic.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspSubsetCharacteristic.InspectionSubsetInternalID AND InspectionCharacteristic = _InspSubsetCharacteristic.InspectionCharacteristic  -- association [1..1]
;

Learn More