Which tables does C_InspOriginDefects use?

C_InspOriginDefects reads from 1 data source(s): I_DefectUnion.

How many fields does C_InspOriginDefects have?

C_InspOriginDefects has 42 fields. Key fields: DefectInternalID.

C_InspOriginDefects

DDL: C_INSPORIGINDEFECTS SQL: CINSPORIGNDEFECT Type: view CONSUMPTION Package: ODATA_QM_DEFECT

Defects by Insp Origin

C_InspOriginDefects is a Consumption CDS View that provides data about "Defects by Insp Origin" in SAP S/4HANA. It reads from 1 data source (I_DefectUnion) and exposes 42 fields with key field DefectInternalID. It has 3 associations to related views. Part of development package ODATA_QM_DEFECT.

Data Sources (1)

Source	Alias	Join Type
I_DefectUnion	I_DefectUnion	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_WorkCenterBySemanticKey	_WorkCenter	`$projection.MainWorkCenterInternalID = _WorkCenter.WorkCenterInternalID and $projection.Plant = _WorkCenter.Plant`
[1..1]	I_CalendarDate	_DefectsWeek	`$projection.CreationDate = _DefectsWeek.CalendarDate`
[0..1]	I_Notification	_Notification	`$projection.Notification = _Notification.Notification`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	CINSPORIGNDEFECT	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Defects by Insp Origin	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view

Fields (42)

Key	Field	Source Table	Source Field	Description
KEY	DefectInternalID	I_DefectUnion	DefectInternalID
	Notification	I_DefectUnion	Notification
	NotificationItem	I_DefectUnion	NotificationItem
	Defect	I_DefectUnion	Defect
	InspectionLotOriginText
	InspectionLotOrigin			Inspection Lot Origins
	NumberOfDefects	I_DefectUnion	NumberOfDefects	Defects
	Material	I_DefectUnion	Material
	DefectCode	I_DefectUnion	DefectCode
	DefectCodeGroup	I_DefectUnion	DefectCodeGroup
	Plant	I_DefectUnion	Plant
	CreationDate	I_DefectUnion	CreationDate
	Supplier
	Customer
	DefectCategory	I_DefectUnion	DefectCategory
	DefectClass	I_DefectUnion	DefectClass
	MainWorkCenterInternalID	I_DefectUnion	MainWorkCenterInternalID
	WorkCenter	_WorkCenter	WorkCenter
	InspectionLotType
	Batch
	BatchStorageLocation
	CalendarWeek	_DefectsWeek	CalendarWeek
	CalendarYear	_DefectsWeek	CalendarYear
	Manufacturer
	ManufacturerPartNmbr
	PurchasingOrganization
	PurchasingDocument
	ManufacturingOrder
	SalesOrder
	DeliveryDocument
	SalesOrganization
	MaterialByCustomer
	InspectionLotHasUsageDecision
	InspectionLot		InspectionLot
	IsBusinessPurposeCompleted	_InspectionLot	IsBusinessPurposeCompleted
	WorkCenterTypeCode	I_DefectUnion	WorkCenterTypeCode
	MainWorkCenter	I_DefectUnion	MainWorkCenter
	MainWorkCenterPlant	I_DefectUnion	MainWorkCenterPlant
	_WorkCenter		_WorkCenter
	_DefectsWeek		_DefectsWeek
	_Notification		_Notification
	_InspectionLot		_InspectionLot

@AbapCatalog.sqlViewName: 'CINSPORIGNDEFECT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Defects by Insp Origin'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
}

-- DEPRECATED - This view is deprecated and is no longer used.

define view C_InspOriginDefects
  as select from I_DefectUnion
  association [1..1] to I_WorkCenterBySemanticKey as _WorkCenter  on  $projection.MainWorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                                  and $projection.Plant                    = _WorkCenter.Plant
  //Week & Year format

  association [1..1] to I_CalendarDate            as _DefectsWeek on  $projection.CreationDate = _DefectsWeek.CalendarDate
  
  association [0..1] to I_Notification            as _Notification on $projection.Notification = _Notification.Notification
{

      @DefaultAggregation: #NONE
      @ObjectModel.readOnly: true
  key I_DefectUnion.DefectInternalID,
  
      I_DefectUnion.Notification,
      I_DefectUnion.NotificationItem,

      @DefaultAggregation: #NONE
      @ObjectModel.readOnly: true
      I_DefectUnion.Defect,

      @Semantics.text: true
      I_DefectUnion._InspectionLot._InspectionLotOrigin._Text[1:Language=$session.system_language].InspectionLotOriginText,

      @ObjectModel: { readOnly: true, text.element:  [ 'InspectionLotOriginText' ] }
      @EndUserText.label: 'Inspection Lot Origins'
      I_DefectUnion._InspectionLot.InspectionLotOrigin,


      @DefaultAggregation: #SUM
      @ObjectModel.readOnly: true
      @EndUserText.label: 'Defects'
      I_DefectUnion.NumberOfDefects,

      //Fields for filter

      @UI.hidden: true
      I_DefectUnion.Material,


      @UI.hidden: true
      I_DefectUnion.DefectCode,

      @UI.hidden: true
      I_DefectUnion.DefectCodeGroup,

      @UI.hidden: true
      I_DefectUnion.Plant,


      @UI.hidden: true
      I_DefectUnion.CreationDate,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.Supplier,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.Customer,

      @UI.hidden: true
      I_DefectUnion.DefectCategory,

      @UI.hidden: true
      I_DefectUnion.DefectClass,

      @UI.hidden: true
      I_DefectUnion.MainWorkCenterInternalID,

      @UI.hidden: true
      _WorkCenter.WorkCenter,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.InspectionLotType,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.Batch,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.BatchStorageLocation,

      @UI.hidden: true
      _DefectsWeek.CalendarWeek,

      @UI.hidden: true
      _DefectsWeek.CalendarYear,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.Manufacturer,
      @UI.hidden: true
      I_DefectUnion._InspectionLot.ManufacturerPartNmbr,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.PurchasingOrganization,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.PurchasingDocument,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.ManufacturingOrder,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.SalesOrder,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.DeliveryDocument,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.SalesOrganization,

      @UI.hidden: true
      I_DefectUnion._InspectionLot.MaterialByCustomer,

      @UI.hidden: true
      cast ( I_DefectUnion._InspectionLot.InspectionLotHasUsageDecision as xfeld) as InspectionLotHasUsageDecision,
      
      @Consumption.hidden: true
      InspectionLot,
      
      @Consumption.hidden: true
      _InspectionLot.IsBusinessPurposeCompleted, 

//    Fields related to authorization checks

      @Consumption.hidden: true
      I_DefectUnion.WorkCenterTypeCode,
      @Consumption.hidden: true
      I_DefectUnion.MainWorkCenter,
      @Consumption.hidden: true
      I_DefectUnion.MainWorkCenterPlant,      

      //Associations

      @Consumption.filter.hidden: true
      _WorkCenter,
      @Consumption.filter.hidden: true
      _DefectsWeek,
      @Consumption.filter.hidden: true
      _Notification, //do not publish this association via the OData service, it is just needed for auth. check!

      @Consumption.filter.hidden: true
      @Consumption.hidden: true
      _InspectionLot

} where I_DefectUnion._InspectionLot.InspectionLotOrigin <> '' and I_DefectUnion._InspectionLot.InspectionLotOrigin is not null

Depth:

C_InspOriginDefects view

I_DefectUnion view