What is C_InspLotMatlSmplRsltRecg in SAP S/4HANA?

C_InspLotMatlSmplRsltRecg is a consumption CDS view in SAP S/4HANA. Material Sample It contains 50 fields.

Which tables does C_InspLotMatlSmplRsltRecg read from?

C_InspLotMatlSmplRsltRecg reads data from: I_InspectionLot, I_InspMaterialSampleAggregate, I_MaterialSample.

What VDM layer is C_InspLotMatlSmplRsltRecg?

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

C_InspLotMatlSmplRsltRecg

DDL: C_INSPLOTMATLSMPLRSLTRECG Type: view_entity CONSUMPTION Package: ODATA_QM_RSLT_RECG

50 Fields 3 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Material Sample

C_InspLotMatlSmplRsltRecg is a Consumption CDS View that provides data about "Material Sample" in SAP S/4HANA. It reads from 3 data sources (I_InspectionLot, I_InspMaterialSampleAggregate, I_MaterialSample) and exposes 50 fields with key fields InspectionLot, MaterialSample. It has 1 association to related views. It is exposed through 1 OData service (UI_INSPLOT_RSLTRECG). It is used in 1 Fiori application: Record Inspection Results (Version 2). Part of development package ODATA_QM_RSLT_RECG.

Data Sources (3)

Source	Alias	Join Type
I_InspectionLot	_InspLot	from
I_InspMaterialSampleAggregate	_InspMaterialSampleAggregate	inner
I_MaterialSample	_MaterialSample	inner

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	C_InspLotOpCharcRsltRecg	_Characteristic	`$projection.InspectionLot = _Characteristic.InspectionLot and $projection.MaterialSample = _Characteristic.MaterialSample`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Material Sample	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#D	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view
UI.headerInfo.title.type	#STANDARD	view
UI.headerInfo.title.value	Title	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_INSPLOT_RSLTRECG	UI_INSPLOT_RSLTRECG	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F1685A	Record Inspection Results (Version 2)	Transactional	An application to record results for inspection characteristics.

Record Inspection Results (Version 2)

Business Role: Quality Technician

With the new Record Inspection Results app, you can record and process results for characteristics for one or more inspection lots effectively. You can also use this app to create defects manually for different categories, such as inspection lots, inspection operations, and characteristics.

Fields (50)

Key	Field	Source Table	Source Field	Description
KEY	InspectionLot	I_InspectionLot	InspectionLot	Inspection Lot
KEY	MaterialSample	I_InspMaterialSampleAggregate	MaterialSample	Sample
	InspOperationCount			Number of Operations
	Material	I_InspectionLot	Material	Vehicle Model
	Batch	I_InspectionLot	Batch	Lot No.
	InspectionLotEndDate	I_InspectionLot	InspectionLotEndDate	End Date
	AccountingDocumentType	I_InspectionLot	AccountingDocumentType	Journal Entry Type
	BatchStorageLocation	I_InspectionLot	BatchStorageLocation
	Customer	I_InspectionLot	Customer	Sold-to Party
	DeliveryDocument	I_InspectionLot	DeliveryDocument	Outbound Delivery
	DeliveryDocumentItem	I_InspectionLot	DeliveryDocumentItem	Outb. Delivery Item
	InspCharacteristicCount			Number of Characteristics
	InspCharAcceptedCount	I_InspMaterialSampleAggregate	InspCharAcceptedCount	Number of Accepted Characteristics
	InspCharOpenCount	I_InspMaterialSampleAggregate	InspCharOpenCount	Number of Open Characteristics
	InspCharRejectedCount	I_InspMaterialSampleAggregate	InspCharRejectedCount	Number of Rejected Characteristics
	NumberOfSkipInspCharcs	I_InspMaterialSampleAggregate	NumberOfSkipInspCharcs	Number of Skipped Characteristics
	InspLotCreatedOnLocalDate	I_InspectionLot	InspLotCreatedOnLocalDate	Lot Created
	InspLotCreatedOnLocalTime	I_InspectionLot	InspLotCreatedOnLocalTime
	InspectionLotChangeDate	I_InspectionLot	InspectionLotChangeDate	Changed On
	InspectionLotChangeTime	I_InspectionLot	InspectionLotChangeTime
	InspectionLotChangedBy	I_InspectionLot	InspectionLotChangedBy	Changed By
	InspectionLotCreatedBy	I_InspectionLot	InspectionLotCreatedBy	Created By
	InspectionLotCreatedOn	I_InspectionLot	InspectionLotCreatedOn	Created On
	InspectionLotCreatedOnTime	I_InspectionLot	InspectionLotCreatedOnTime
	InspectionLotHasPartialLots	I_InspectionLot	InspectionLotHasPartialLots	Partial Lots
	InspectionLotObjectText	I_InspectionLot	InspectionLotObjectText	Obj short text
	InspectionLotOrigin	I_InspectionLot	InspectionLotOrigin
	InspectionLotOriginText
	InspectionLotPlant	I_InspectionLot	InspectionLotPlant
	InspectionLotQuantity	I_InspectionLot	InspectionLotQuantity
	InspectionLotQuantityUnit	I_InspectionLot	InspectionLotQuantityUnit	Sample UOM
	InspectionLotStartDate	I_InspectionLot	InspectionLotStartDate	Start Date
	InspectionLotText	I_InspectionLot	InspectionLotText
	InspectionLotType	I_InspectionLot	InspectionLotType	Inspection Type
	InspectionLotTypeText
	Manufacturer	I_InspectionLot	Manufacturer	Manufacturer
	ManufacturingOrder	I_InspectionLot	ManufacturingOrder	Order
	ProductionVersion	I_InspectionLot	ProductionVersion	Version ID
	PurchasingDocument	I_InspectionLot	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	I_InspectionLot	PurchasingDocumentItem	Purchasing Doc. Item
	SalesOrder	I_InspectionLot	SalesOrder	SD Document
	SalesOrderItem	I_InspectionLot	SalesOrderItem	Sales Order Item
	ScheduleLine	I_InspectionLot	ScheduleLine	Schedule Line
	Supplier	I_InspectionLot	Supplier	Supplier
	MatlQualityAuthorizationGroup	I_InspectionLot	MatlQualityAuthorizationGroup	QM Matl Auth.
	IsBusinessPurposeCompleted	I_InspectionLot	IsBusinessPurposeCompleted	Purpose Completed
	Plant	I_InspectionLot	Plant	Valuation Area
	NumberOfDaysLeftForRsltRecg			Inspection Lot End Date
	_InspectionLot		_InspectionLot
	_Characteristic		_Characteristic

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_InspLotMatlSmplRsltRecg.
-- 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 C_InspLotMatlSmplRsltRecg AS
SELECT
  _InspLot.InspectionLot AS InspectionLot,
  _InspMaterialSampleAggregate.MaterialSample AS MaterialSample,
  cast(_InspMaterialSampleAggregate.InspOperationCount as abap.int4 ) AS InspOperationCount,
  _InspLot.Material AS Material,
  _InspLot.Batch AS Batch,
  _InspLot.InspectionLotEndDate AS InspectionLotEndDate,
  _InspLot.AccountingDocumentType AS AccountingDocumentType,
  _InspLot.BatchStorageLocation AS BatchStorageLocation,
  _InspLot.Customer AS Customer,
  _InspLot.DeliveryDocument AS DeliveryDocument,
  _InspLot.DeliveryDocumentItem AS DeliveryDocumentItem,
  cast( _InspMaterialSampleAggregate.InspCharAcceptedCount + _InspMaterialSampleAggregate.InspCharOpenCount + _InspMaterialSampleAggregate.InspCharRejectedCount as abap.int4) AS InspCharacteristicCount,
  _InspMaterialSampleAggregate.InspCharAcceptedCount AS InspCharAcceptedCount,
  _InspMaterialSampleAggregate.InspCharOpenCount AS InspCharOpenCount,
  _InspMaterialSampleAggregate.InspCharRejectedCount AS InspCharRejectedCount,
  _InspMaterialSampleAggregate.NumberOfSkipInspCharcs AS NumberOfSkipInspCharcs,
  _InspLot.InspLotCreatedOnLocalDate AS InspLotCreatedOnLocalDate,
  _InspLot.InspLotCreatedOnLocalTime AS InspLotCreatedOnLocalTime,
  _InspLot.InspectionLotChangeDate AS InspectionLotChangeDate,
  _InspLot.InspectionLotChangeTime AS InspectionLotChangeTime,
  _InspLot.InspectionLotChangedBy AS InspectionLotChangedBy,
  _InspLot.InspectionLotCreatedBy AS InspectionLotCreatedBy,
  _InspLot.InspectionLotCreatedOn AS InspectionLotCreatedOn,
  _InspLot.InspectionLotCreatedOnTime AS InspectionLotCreatedOnTime,
  _InspLot.InspectionLotHasPartialLots AS InspectionLotHasPartialLots,
  _InspLot.InspectionLotObjectText AS InspectionLotObjectText,
  _InspLot.InspectionLotOrigin AS InspectionLotOrigin,
  _InspLot._InspectionLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText AS InspectionLotOriginText,
  _InspLot.InspectionLotPlant AS InspectionLotPlant,
  _InspLot.InspectionLotQuantity AS InspectionLotQuantity,
  _InspLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _InspLot.InspectionLotStartDate AS InspectionLotStartDate,
  _InspLot.InspectionLotText AS InspectionLotText,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLot._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _InspLot.Manufacturer AS Manufacturer,
  _InspLot.ManufacturingOrder AS ManufacturingOrder,
  _InspLot.ProductionVersion AS ProductionVersion,
  _InspLot.PurchasingDocument AS PurchasingDocument,
  _InspLot.PurchasingDocumentItem AS PurchasingDocumentItem,
  _InspLot.SalesOrder AS SalesOrder,
  _InspLot.SalesOrderItem AS SalesOrderItem,
  _InspLot.ScheduleLine AS ScheduleLine,
  _InspLot.Supplier AS Supplier,
  _InspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspLot.Plant AS Plant,
  dats_days_between(cast($session.system_date as abap.dats), _InspectionLot.InspectionLotEndDate) AS NumberOfDaysLeftForRsltRecg
FROM I_InspectionLot AS _InspLot
INNER JOIN I_InspMaterialSampleAggregate AS _InspMaterialSampleAggregate ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialSample AS _MaterialSample ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_InspLotOpCharcRsltRecg AS _Characteristic ON InspectionLot = _Characteristic.InspectionLot AND MaterialSample = _Characteristic.MaterialSample  -- association [0..*]
;

Depth:

C_InspLotMatlSmplRsltRecg view_entity