What is C_InspSubsetRsltRec in SAP S/4HANA?

C_InspSubsetRsltRec is a consumption CDS view in SAP S/4HANA. Record Rslts for Insp Points: Insp Point It contains 69 fields.

Which tables does C_InspSubsetRsltRec read from?

C_InspSubsetRsltRec reads data from: I_InspectionSubsetTP.

What VDM layer is C_InspSubsetRsltRec?

C_InspSubsetRsltRec is classified as a Consumption view optimized for specific business scenarios and reporting.

C_InspSubsetRsltRec

DDL: C_INSPSUBSETRSLTREC SQL: CINSPSUBRESREC Type: view CONSUMPTION Package: ODATA_QM_INSPSUBSET_RR

69 Fields 1 Data Sources 6 Associations

Record Rslts for Insp Points: Insp Point

C_InspSubsetRsltRec is a Consumption CDS View that provides data about "Record Rslts for Insp Points: Insp Point" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubsetTP) and exposes 69 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID. It has 6 associations to related views. Part of development package ODATA_QM_INSPSUBSET_RR.

Data Sources (1)

Source	Alias	Join Type
I_InspectionSubsetTP	InspSub	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..*]	C_InspSubsetCharcResult	_InspSubsetCharcResult	`$projection.InspectionLot = _InspSubsetCharcResult.InspectionLot and $projection.InspPlanOperationInternalID = _InspSubsetCharcResult.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _InspSubsetCharcResult.InspectionSubsetInternalID`
[0..*]	C_InspSubsetValuation	_InspSubsetValuation	`InspSub.InspectionLot = _InspSubsetValuation.InspectionLot and InspSub.InspPlanOperationInternalID = _InspSubsetValuation.InspPlanOperationInternalID`
[1..1]	C_InspSubsetCharcRsltRec	_InspSubsetCharcRsltRec	`$projection.InspectionLot = _InspSubsetCharcRsltRec.InspectionLot and $projection.InspPlanOperationInternalID = _InspSubsetCharcRsltRec.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _InspSubsetCharcRsltRec.InspectionSubsetInternalID`
[0..*]	C_InspSubsetValnCodesVH	_ValuationCodes	`$projection.SelectedCodeSetPlant = _ValuationCodes.SelectedCodeSetPlant and $projection.SelectedCodeSet = _ValuationCodes.SelectedCodeSet`
[1..1]	I_UserContactCard	_CreatedByUser	`$projection.UserID = _CreatedByUser.ContactCardID`
[1..1]	I_UserContactCard	_LastChangedByUser	`$projection.ContactCardID = _LastChangedByUser.ContactCardID`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CINSPSUBRESREC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Record Rslts for Insp Points: Insp Point	view
ObjectModel.compositionRoot	true	view
ObjectModel.draftEnabled	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view

Fields (69)

Key	Field	Source Table	Source Field	Description
KEY	InspectionLot	I_InspectionSubsetTP	InspectionLot	Inspection Lot
KEY	InspPlanOperationInternalID	I_InspectionSubsetTP	InspPlanOperationInternalID
KEY	InspectionSubsetInternalID	I_InspectionSubsetTP	InspectionSubsetInternalID
	InspectionOperations	I_InspectionSubsetTP	InspectionOperations
	InspectionOperation
	OperationText
	WorkCenter
	Material
	MaterialName
	InspSubsetTimeInterval		InspSubsetTimeInterval
	InspSubsetTimeIntervalUnit		InspSubsetTimeIntervalUnit
	InspectionLotForEdit	I_InspectionSubsetTP	InspectionLotForEdit
	InspectionOperationForEdit	I_InspectionSubsetTP	InspectionOperationForEdit
	InspSubsetStatus	I_InspectionSubsetTP	InspSubsetStatus
	InspectionSubsetSortKey	I_InspectionSubsetTP	InspectionSubsetSortKey
	SelectedCodeSetPlant	I_InspectionSubsetTP	SelectedCodeSetPlant
	SelectedCodeSet	I_InspectionSubsetTP	SelectedCodeSet	CodeGrp/SelSet
	InspSubsetUsageDcsnCodeGroup	I_InspectionSubsetTP	InspSubsetUsageDcsnCodeGroup
	InspSubsetUsageDcsnCode	I_InspectionSubsetTP	InspSubsetUsageDcsnCode
	InspSubsetUsageDcsnValuation	I_InspectionSubsetTP	InspSubsetUsageDcsnValuation
	InspLotUsgeDcsnValuationText
	InspectionSubsetTime	I_InspectionSubsetTP	InspectionSubsetTime
	InspSbstTimeFldProperty	I_InspectionSubsetTP	InspSbstTimeFldProperty
	InspectionSubsetDate	I_InspectionSubsetTP	InspectionSubsetDate
	InspSbstDateFldProperty	I_InspectionSubsetTP	InspSbstDateFldProperty
	InspectionSubsetTimeZone	I_InspectionSubsetTP	InspectionSubsetTimeZone
	InspSubsetLongNumericKey	I_InspectionSubsetTP	InspSubsetLongNumericKey
	InspSbstLongNmbrFldProperty	I_InspectionSubsetTP	InspSbstLongNmbrFldProperty
	InspSubsetShortNumericKey	I_InspectionSubsetTP	InspSubsetShortNumericKey
	InspSbstShrtNmbrFldProperty	I_InspectionSubsetTP	InspSbstShrtNmbrFldProperty
	InspectionSubsetLongCharKey	I_InspectionSubsetTP	InspectionSubsetLongCharKey
	InspSbstLongTxtFldProperty	I_InspectionSubsetTP	InspSbstLongTxtFldProperty
	InspectionSubsetShortCharKey	I_InspectionSubsetTP	InspectionSubsetShortCharKey
	InspSbstShrtTxtFldProperty	I_InspectionSubsetTP	InspSbstShrtTxtFldProperty
	InspSubsetFieldCombination
	InspSubsetTimeFieldName		InspSubsetTimeFieldName
	InspSubsetDateFieldName		InspSubsetDateFieldName
	InspSubsetLongTxtFieldName		InspSubsetLongTxtFieldName
	InspSubsetLongNmbrFieldName		InspSubsetLongNmbrFieldName
	InspSubsetShortTxtFieldName		InspSubsetShortTxtFieldName
	InspSubsetShortNmbrFieldName		InspSubsetShortNmbrFieldName
	InspSubsetAcceptedCount	_InspSubsetCharcRsltRec	InspSubsetAcceptedCount
	InspSubsetRejectedCount	_InspSubsetCharcRsltRec	InspSubsetRejectedCount
	InspSubsetCharcOpenCount	_InspSubsetCharcRsltRec	InspSubsetCharcOpenCount
	InspSubsetCharcAcceptedCount	_InspSubsetCharcRsltRec	InspSubsetCharcAcceptedCount
	InspSubsetCharcRejectedCount	_InspSubsetCharcRsltRec	InspSubsetCharcRejectedCount
	UserID		UserID	User Name
	ContactCardID		ContactCardID	User Name
	Inspector	I_InspectionSubsetTP	Inspector	Inspector
	InspSubsetDateTime	_InspSubsetCharcRsltRec	InspSubsetDateTime
	CreatedByUser		CreatedByUser	Created By
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Change
	LastChangedByUser		LastChangedByUser	Last Changed By
	LastChangeDate		LastChangeDate	Time Stamp
	LastChangeTime		LastChangeTime	Time changed
	InspSbstCompletionConfirmation
	_InspectionLot	I_InspectionSubsetTP	_InspectionLot
	_InspectionOperation	I_InspectionSubsetTP	_InspectionOperation
	_InspectionSubsetInternalID		_InspectionSubsetInternalID
	_InspSubsetUsageDcsnValn		_InspSubsetUsageDcsnValn
	_InspSubsetUsageDcsnValnTxt		_InspSubsetUsageDcsnValnTxt
	_UsageDecisionCode		_UsageDecisionCode
	_UsageDecisionCodeGroup		_UsageDecisionCodeGroup
	_InspSubsetValuation		_InspSubsetValuation
	_ValuationCodes		_ValuationCodes
	_CreatedByUser		_CreatedByUser
	_LastChangedByUser		_LastChangedByUser
	_InspSubsetCharcResult		_InspSubsetCharcResult

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 C_InspSubsetRsltRec.
-- 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: CINSPSUBRESREC

CREATE VIEW C_InspSubsetRsltRec AS
SELECT
  InspSub.InspectionLot AS InspectionLot,
  InspSub.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspSub.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspSub.InspectionOperations AS InspectionOperations,
  InspSub._InspectionOperation.InspectionOperation AS InspectionOperation,
  InspSub._InspectionOperation.OperationText AS OperationText,
  _InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
  InspSub._InspectionLot.Material AS Material,
  _InspectionLot._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  InspSubsetTimeInterval,
  InspSubsetTimeIntervalUnit,
  InspSub.InspectionLotForEdit AS InspectionLotForEdit,
  InspSub.InspectionOperationForEdit AS InspectionOperationForEdit,
  InspSub.InspSubsetStatus AS InspSubsetStatus,
  InspSub.InspectionSubsetSortKey AS InspectionSubsetSortKey,
  InspSub.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  InspSub.SelectedCodeSet AS SelectedCodeSet,
  InspSub.InspSubsetUsageDcsnCodeGroup AS InspSubsetUsageDcsnCodeGroup,
  InspSub.InspSubsetUsageDcsnCode AS InspSubsetUsageDcsnCode,
  InspSub.InspSubsetUsageDcsnValuation AS InspSubsetUsageDcsnValuation,
  _InspSubsetUsageDcsnValn._Text[1:Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText,
  InspSub.InspectionSubsetTime AS InspectionSubsetTime,
  InspSub.InspSbstTimeFldProperty AS InspSbstTimeFldProperty,
  InspSub.InspectionSubsetDate AS InspectionSubsetDate,
  InspSub.InspSbstDateFldProperty AS InspSbstDateFldProperty,
  InspSub.InspectionSubsetTimeZone AS InspectionSubsetTimeZone,
  InspSub.InspSubsetLongNumericKey AS InspSubsetLongNumericKey,
  InspSub.InspSbstLongNmbrFldProperty AS InspSbstLongNmbrFldProperty,
  InspSub.InspSubsetShortNumericKey AS InspSubsetShortNumericKey,
  InspSub.InspSbstShrtNmbrFldProperty AS InspSbstShrtNmbrFldProperty,
  InspSub.InspectionSubsetLongCharKey AS InspectionSubsetLongCharKey,
  InspSub.InspSbstLongTxtFldProperty AS InspSbstLongTxtFldProperty,
  InspSub.InspectionSubsetShortCharKey AS InspectionSubsetShortCharKey,
  InspSub.InspSbstShrtTxtFldProperty AS InspSbstShrtTxtFldProperty,
  InspSub._InspectionLot.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  InspSubsetTimeFieldName,
  InspSubsetDateFieldName,
  InspSubsetLongTxtFieldName,
  InspSubsetLongNmbrFieldName,
  InspSubsetShortTxtFieldName,
  InspSubsetShortNmbrFieldName,
  _InspSubsetCharcRsltRec.InspSubsetAcceptedCount AS InspSubsetAcceptedCount,
  _InspSubsetCharcRsltRec.InspSubsetRejectedCount AS InspSubsetRejectedCount,
  _InspSubsetCharcRsltRec.InspSubsetCharcOpenCount AS InspSubsetCharcOpenCount,
  _InspSubsetCharcRsltRec.InspSubsetCharcAcceptedCount AS InspSubsetCharcAcceptedCount,
  _InspSubsetCharcRsltRec.InspSubsetCharcRejectedCount AS InspSubsetCharcRejectedCount,
  UserID,
  ContactCardID,
  InspSub.Inspector AS Inspector,
  _InspSubsetCharcRsltRec.InspSubsetDateTime AS InspSubsetDateTime,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  InspSub._InspectionOperation.InspSbstCompletionConfirmation AS InspSbstCompletionConfirmation,
  InspSub._InspectionLot AS _InspectionLot,
  InspSub._InspectionOperation AS _InspectionOperation
FROM I_InspectionSubsetTP AS InspSub
LEFT OUTER JOIN C_InspSubsetCharcResult AS _InspSubsetCharcResult ON InspectionLot = _InspSubsetCharcResult.InspectionLot AND InspPlanOperationInternalID = _InspSubsetCharcResult.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspSubsetCharcResult.InspectionSubsetInternalID  -- association [0..*]
LEFT OUTER JOIN C_InspSubsetValuation AS _InspSubsetValuation ON InspSub.InspectionLot = _InspSubsetValuation.InspectionLot AND InspSub.InspPlanOperationInternalID = _InspSubsetValuation.InspPlanOperationInternalID  -- association [0..*]
LEFT OUTER JOIN C_InspSubsetCharcRsltRec AS _InspSubsetCharcRsltRec ON InspectionLot = _InspSubsetCharcRsltRec.InspectionLot AND InspPlanOperationInternalID = _InspSubsetCharcRsltRec.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspSubsetCharcRsltRec.InspectionSubsetInternalID  -- association [1..1]
LEFT OUTER JOIN C_InspSubsetValnCodesVH AS _ValuationCodes ON SelectedCodeSetPlant = _ValuationCodes.SelectedCodeSetPlant AND SelectedCodeSet = _ValuationCodes.SelectedCodeSet  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON UserID = _CreatedByUser.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON ContactCardID = _LastChangedByUser.ContactCardID  -- association [1..1]
;

Depth:

C_InspSubsetRsltRec view

I_InspectionSubsetTP view_entity