What is C_MaintInspLotCharacteristic in SAP S/4HANA?

C_MaintInspLotCharacteristic is a consumption CDS view in SAP S/4HANA. Characteristics in Manage Inspection It contains 143 fields.

Which tables does C_MaintInspLotCharacteristic read from?

C_MaintInspLotCharacteristic reads data from: R_MaintInspLotCharacteristic.

What VDM layer is C_MaintInspLotCharacteristic?

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

C_MaintInspLotCharacteristic

DDL: C_MAINTINSPLOTCHARACTERISTIC Type: view_entity CONSUMPTION

143 Fields 1 Data Sources

Characteristics in Manage Inspection

C_MaintInspLotCharacteristic is a Consumption CDS View that provides data about "Characteristics in Manage Inspection" in SAP S/4HANA. It reads from 1 data source (R_MaintInspLotCharacteristic) and exposes 143 fields with key fields InspectionLot, MaintenanceOrder, MaintenanceOrderOperation, InspPlanOperationInternalID, InspectionCharacteristic.

Data Sources (1)

Source	Alias	Join Type
R_MaintInspLotCharacteristic	R_MaintInspLotCharacteristic	projection

Annotations (7)

Name	Value	Level
EndUserText.label	Characteristics in Manage Inspection	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (143)

Key	Field	Source Table	Source Field	Description
KEY	InspectionLot		InspectionLot	Inspection Lot
KEY	MaintenanceOrder		MaintenanceOrder	Order
KEY	MaintenanceOrderOperation		MaintenanceOrderOperation	Suboperation
KEY	InspPlanOperationInternalID		InspPlanOperationInternalID
KEY	InspectionCharacteristic		InspectionCharacteristic
	MaintenanceBusinessSubobject		MaintenanceBusinessSubobject
	Plant		Plant	Valuation Area
	MaintOperationalChecklistType		MaintOperationalChecklistType	Checklist Type
	MaintenanceChecklistTypeText	_CheckListType	MaintenanceChecklistTypeText
	InspectionLotText		InspectionLotText
	InspectionSpecificationText		InspectionSpecificationText
	InspectionResultText		InspectionResultText
	InspectionLotType		InspectionLotType	Inspection Type
	InspectionLotTypeText
	MainChecklistIsDeactivated		MainChecklistIsDeactivated
	IsLocked		IsLocked
	TechnicalObject	_OrderTechnicalObject	TechnicalObject	Technical Object
	TechnicalObjectDescription
	TechObjIsEquipOrFuncnlLoc	_OrderTechnicalObject	TechObjIsEquipOrFuncnlLoc	Tech. Obj. Type
	TechnicalObjectLabel
	FunctionalLocationLabelName
	AuthorizationGroup		AuthorizationGroup	AuthorizGroup
	TechObjAuthorizationGroupDesc	_AuthorizationGroup	TechObjAuthorizationGroupDesc
	InspectionLotTechnicalObject		InspectionLotTechnicalObject
	InspLotTechnicalObjectDesc	_InspectionLotTechnicalObject	TechnicalObjectDescription	Tech. Obj. Desc
	OpTechObjEquipOrFuncnlLoc		OpTechObjEquipOrFuncnlLoc
	InspLotTechnicalObjectLabel
	MaintObjectFreeDefinedAttrib
	InspLotUsageDecisionValuation		InspLotUsageDecisionValuation
	InspLotUsgeDcsnValuationText
	InspectionLotUsageDecisionCode		InspectionLotUsageDecisionCode
	UsageDecisionCodeText
	UsageDecisionCodeCriticality		UsageDecisionCodeCriticality
	ScheduledBasicStartDate		ScheduledBasicStartDate	Sched. start
	ScheduledBasicStartTime		ScheduledBasicStartTime
	MaintOrdSchedBscStartDateTime		MaintOrdSchedBscStartDateTime
	ScheduledBasicEndDate		ScheduledBasicEndDate	Sched. finish
	ScheduledBasicEndTime		ScheduledBasicEndTime
	MaintOrdSchedldBscEndDateTime		MaintOrdSchedldBscEndDateTime	Time Stamp
	MaintenanceOrderDesc		MaintenanceOrderDesc	Description
	OperationDescription		OperationDescription	Op. Short Text
	PlantName	_Plant	PlantName	Plant Name
	MaintenancePlanningPlant		MaintenancePlanningPlant	Planning Plant
	MaintenancePlanningPlantName
	MaintenanceOrderType		MaintenanceOrderType	Order Type
	OrderTypeName
	MaintenancePlan		MaintenancePlan	MaintenancePlan
	MaintenancePlanDesc
	MaintenanceItem		MaintenanceItem	MaintItem
	MaintenanceItemDescription
	MaintenanceActivityType		MaintenanceActivityType	MaintActivType
	MaintenanceActivityTypeName
	MaintenancePlannerGroup		MaintenancePlannerGroup	Planner Group
	MaintenancePlannerGroupName
	MainWorkCenter		MainWorkCenter	Work Center
	WorkCenterText
	MainWorkCenterPlant		MainWorkCenterPlant	Plnt WorkCenter
	WorkCenterPlantName
	OperationWorkCenter	_OperationWorkCenter	WorkCenter	Work Center
	OperationWorkCenterText
	OperationWorkCenterPlant	_OperationWorkCenter	Plant	Valuation Area
	OperationWorkCenterPlantName
	OperationControlKey		OperationControlKey	Control Key
	OperationControlProfileName
	OperationStandardTextCode		OperationStandardTextCode	Std Text Key
	OperationStandardTextCodeName
	InspectionLotCreatedOn		InspectionLotCreatedOn
	InspectionLotCreatedOnTime		InspectionLotCreatedOnTime
	InspectionLotCreateDateTime		InspectionLotCreateDateTime
	InspectionLotCreatedBy		InspectionLotCreatedBy
	CreatedByUserName	_CreatedByUser	UserDescription	Full Name
	InspectionLotChangeDate		InspectionLotChangeDate
	InspectionLotChangeTime		InspectionLotChangeTime
	InspectionLotChangeDateTime		InspectionLotChangeDateTime
	InspectionLotChangedBy		InspectionLotChangedBy
	LastChangedByUserName	_LastChangedByUser	UserDescription	Full Name
	InspectionLotPlant		InspectionLotPlant	Valuation Area
	InspectionLotPlantName
	Material		Material	Vehicle Model
	MaterialName
	Supplier		Supplier	Supplier
	SupplierName	_Supplier	SupplierName	Supplier Name
	BillOfOperationsGroup		BillOfOperationsGroup	Group
	BillOfOperationsVariant		BillOfOperationsVariant	Group Counter
	BillOfOperationsType		BillOfOperationsType	Task List Type
	BillOfOperationsUsage		BillOfOperationsUsage
	BillOfOperationsUsageDesc
	BillOfOperationsChangeStateID		BillOfOperationsChangeStateID
	InspectionPlanDescription	_BillOfOperationsChangeState	BillOfOperationsDesc
	InspLotCompltnStatus		InspLotCompltnStatus
	InspLotCompltnStatusText	_InspLotCompltnStatusText	InspLotCompltnStatusText
	InspectionOperation		InspectionOperation
	OperationText	_InspectionOperation	OperationText	Description
	InspSpecIsQuantitative		InspSpecIsQuantitative	Quant.charac.
	InspSpecImportanceCode		InspSpecImportanceCode
	InspSpecImportanceCodeText		InspSpecImportanceCodeText
	InspSpecLowerPlausibilityLimit		InspSpecLowerPlausibilityLimit
	InspSpecUpperPlausibilityLimit		InspSpecUpperPlausibilityLimit
	InspSpecTargetValue		InspSpecTargetValue	Target Value
	InspSpecInformationField1		InspSpecInformationField1
	InspSpecInformationField2		InspSpecInformationField2
	InspSpecInformationField3		InspSpecInformationField3
	InspSpecDecimalPlaces		InspSpecDecimalPlaces
	InspectionSpecificationUnit		InspectionSpecificationUnit	Unit of Meas.
	InspSpecUpperLimit		InspSpecUpperLimit	Upper Limit
	InspSpecLowerLimit		InspSpecLowerLimit	Lower Limit
	SamplingProcedure		SamplingProcedure
	InspectionSpecification		InspectionSpecification	Master IC
	InspectionSpecificationPlant		InspectionSpecificationPlant
	InspectionSpecificationVersion		InspectionSpecificationVersion
	InspectionMethod		InspectionMethod	Insp. Method
	InspectionMethodText		InspectionMethodText
	InspectionMethodVersion		InspectionMethodVersion
	InspectionMethodPlant		InspectionMethodPlant
	MaterialSample		MaterialSample
	MaterialSampleText		MaterialSampleText
	SelectedCodeSet		SelectedCodeSet	CodeGrp/SelSet
	SelectedCodeSetText		SelectedCodeSetText
	InspectionResultMeanValue		InspectionResultMeanValue
	InspectionResultMaximumValue		InspectionResultMaximumValue
	InspectionResultMinimumValue		InspectionResultMinimumValue
	InspRsltFreeDefinedTestEquip		InspRsltFreeDefinedTestEquip
	CharacteristicAttributeCatalog		CharacteristicAttributeCatalog
	CharacteristicAttributeCodeGrp		CharacteristicAttributeCodeGrp
	CharacteristicAttribCodeGrpTxt		CharacteristicAttribCodeGrpTxt
	CharacteristicAttributeCode		CharacteristicAttributeCode
	CharacteristicAttributeCodeTxt		CharacteristicAttributeCodeTxt
	InspectionResultLongText	_InspResultLongText	InspectionResultLongText
	InspectionResultStatus		InspectionResultStatus
	InspectionResultStatusText		InspectionResultStatusText
	Inspector		Inspector	Inspector
	InspectorName	_Inspector	UserDescription	Full Name
	InspectionEndDate		InspectionEndDate
	InspectionEndTime		InspectionEndTime
	InspectionEndDateTime		InspectionEndDateTime
	DefectClass		DefectClass	Defect Class
	DefectClassText
	InspectionValuationResult		InspectionValuationResult
	InspectionValuationResultText		InspectionValuationResultText
	InspectionValuationCriticality		InspectionValuationCriticality
	ProductionResourceTool
	ProductionResourceToolDesc
	InspCharcRecgUITemplateID	_InspectionResultRec	InspCharcRecgUITemplateID

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_MaintInspLotCharacteristic.
-- 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_MaintInspLotCharacteristic AS
SELECT
  InspectionLot,
  MaintenanceOrder,
  MaintenanceOrderOperation,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  MaintenanceBusinessSubobject,
  Plant,
  MaintOperationalChecklistType,
  _CheckListType.MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText,
  InspectionLotText,
  InspectionSpecificationText,
  InspectionResultText,
  InspectionLotType,
  _InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  MainChecklistIsDeactivated,
  IsLocked,
  _OrderTechnicalObject.TechnicalObject AS TechnicalObject,
  _OrderTechnicalObject._TechnicalObject.TechnicalObjectDescription AS TechnicalObjectDescription,
  _OrderTechnicalObject.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  cast (_OrderTechnicalObject._TechnicalObject.TechnicalObjectLabel as eams_tech_obj_alpha_conv preserving type ) AS TechnicalObjectLabel,
  _OrderTechnicalObject._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  AuthorizationGroup,
  _AuthorizationGroup.TechObjAuthorizationGroupDesc AS TechObjAuthorizationGroupDesc,
  InspectionLotTechnicalObject,
  _InspectionLotTechnicalObject.TechnicalObjectDescription AS InspLotTechnicalObjectDesc,
  OpTechObjEquipOrFuncnlLoc,
  cast (_InspectionLotTechnicalObject.TechnicalObjectLabel as eams_tech_obj_alpha_conv preserving type ) AS InspLotTechnicalObjectLabel,
  _InspectionLotTechnicalObject._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  InspLotUsageDecisionValuation,
  _InspLotUsageDecision._UsageDecisionValuation._Text[1:Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText,
  InspectionLotUsageDecisionCode,
  _InspLotUsageDecision._UsageDecisionCode._Text[1:Language=$session.system_language].UsageDecisionCodeText AS UsageDecisionCodeText,
  UsageDecisionCodeCriticality,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  MaintOrdSchedBscStartDateTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  MaintOrdSchedldBscEndDateTime,
  MaintenanceOrderDesc,
  OperationDescription,
  _Plant.PlantName AS PlantName,
  MaintenancePlanningPlant,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  MaintenanceOrderType,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenanceOrderType._Text[1: Language=$session.system_language].OrderTypeName AS OrderTypeName,
  MaintenancePlan,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  MaintenanceItem,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  MaintenanceActivityType,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenanceActivityType._Text[1: Language=$session.system_language].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  MaintenancePlannerGroup,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  MainWorkCenter,
  _MaintenanceOrderOp._MaintenanceOrder._MainWorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  MainWorkCenterPlant,
  _MaintenanceOrderOp._MaintenanceOrder._MainWorkCenter._Plant.PlantName AS WorkCenterPlantName,
  _OperationWorkCenter.WorkCenter AS OperationWorkCenter,
  _OperationWorkCenter._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS OperationWorkCenterText,
  _OperationWorkCenter.Plant AS OperationWorkCenterPlant,
  _OperationWorkCenter._WorkCenter._Plant.PlantName AS OperationWorkCenterPlantName,
  OperationControlKey,
  _MaintenanceOrderOp._OperationControlKey._Text[1:Language=$session.system_language].OperationControlProfileName AS OperationControlProfileName,
  OperationStandardTextCode,
  _OperationStandardText._Text[1:Language = $session.system_language].OperationStandardTextCodeName AS OperationStandardTextCodeName,
  InspectionLotCreatedOn,
  InspectionLotCreatedOnTime,
  InspectionLotCreateDateTime,
  InspectionLotCreatedBy,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  InspectionLotChangeDate,
  InspectionLotChangeTime,
  InspectionLotChangeDateTime,
  InspectionLotChangedBy,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  InspectionLotPlant,
  _InspectionLot._Plant.PlantName AS InspectionLotPlantName,
  Material,
  _InspectionLot._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsType,
  BillOfOperationsUsage,
  _BillOfOperationsUsage._Text[1:Language=$session.system_language].BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
  BillOfOperationsChangeStateID,
  _BillOfOperationsChangeState.BillOfOperationsDesc AS InspectionPlanDescription,
  InspLotCompltnStatus,
  _InspLotCompltnStatusText.InspLotCompltnStatusText AS InspLotCompltnStatusText,
  InspectionOperation,
  _InspectionOperation.OperationText AS OperationText,
  InspSpecIsQuantitative,
  InspSpecImportanceCode,
  InspSpecImportanceCodeText,
  InspSpecLowerPlausibilityLimit,
  InspSpecUpperPlausibilityLimit,
  InspSpecTargetValue,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspSpecDecimalPlaces,
  InspectionSpecificationUnit,
  InspSpecUpperLimit,
  InspSpecLowerLimit,
  SamplingProcedure,
  InspectionSpecification,
  InspectionSpecificationPlant,
  InspectionSpecificationVersion,
  InspectionMethod,
  InspectionMethodText,
  InspectionMethodVersion,
  InspectionMethodPlant,
  MaterialSample,
  MaterialSampleText,
  SelectedCodeSet,
  SelectedCodeSetText,
  InspectionResultMeanValue,
  InspectionResultMaximumValue,
  InspectionResultMinimumValue,
  InspRsltFreeDefinedTestEquip,
  CharacteristicAttributeCatalog,
  CharacteristicAttributeCodeGrp,
  CharacteristicAttribCodeGrpTxt,
  CharacteristicAttributeCode,
  CharacteristicAttributeCodeTxt,
  _InspResultLongText.InspectionResultLongText AS InspectionResultLongText,
  InspectionResultStatus,
  InspectionResultStatusText,
  Inspector,
  _Inspector.UserDescription AS InspectorName,
  InspectionEndDate,
  InspectionEndTime,
  InspectionEndDateTime,
  DefectClass,
  _DefectClass._Text[1:Language=$session.system_language].DefectClassText AS DefectClassText,
  InspectionValuationResult,
  InspectionValuationResultText,
  InspectionValuationCriticality,
  _OrderProdnResourceTool._ProdnRsceToolByInternalKey.ProductionResourceTool AS ProductionResourceTool,
  _OrderProdnResourceTool._ProdnRsceToolByInternalKey._ProdnRsceToolText[1:Language = $session.system_language].ProductionResourceToolDesc AS ProductionResourceToolDesc,
  _InspectionResultRec.InspCharcRecgUITemplateID AS InspCharcRecgUITemplateID
FROM R_MaintInspLotCharacteristic
;

Depth:

C_MaintInspLotCharacteristic view_entity

R_MaintInspLotCharacteristic view_entity