What is C_MaintOrderTechObjQuery in SAP S/4HANA?

C_MaintOrderTechObjQuery is a consumption CDS view in SAP S/4HANA. Maint. Order Analysis Query w. Techn.Obj It contains 85 fields.

Which tables does C_MaintOrderTechObjQuery read from?

C_MaintOrderTechObjQuery reads data from: I_MaintOrderTechObjCube.

What VDM layer is C_MaintOrderTechObjQuery?

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

C_MaintOrderTechObjQuery

DDL: C_MAINTORDERTECHOBJQUERY SQL: CMNTORDTOQUERY Type: view CONSUMPTION

85 Fields 1 Data Sources

Maint. Order Analysis Query w. Techn.Obj

C_MaintOrderTechObjQuery is a Consumption CDS View that provides data about "Maint. Order Analysis Query w. Techn.Obj" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderTechObjCube) and exposes 85 fields with key field MaintenanceOrder.

Data Sources (1)

Source	Alias	Join Type
I_MaintOrderTechObjCube	I_MaintOrderTechObjCube	from

Annotations (11)

Name	Value	Level
EndUserText.label	Maint. Order Analysis Query w. Techn.Obj	view
Analytics.query	true	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	CMNTORDTOQUERY	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
Metadata.ignorePropagatedAnnotations	true	view
AbapCatalog.compiler.compareFilter	true	view

Fields (85)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceOrder	I_MaintOrderTechObjCube	MaintenanceOrder	Order
	MaintenanceOrderDesc	I_MaintOrderTechObjCube	MaintenanceOrderDesc	Description
	FunctionalLocation	I_MaintOrderTechObjCube	FunctionalLocation	Object ID
	Equipment	I_MaintOrderTechObjCube	Equipment	Equipment check
	Assembly	I_MaintOrderTechObjCube	Assembly	Pegged Reqmt
	Material	I_MaintOrderTechObjCube	Material	Vehicle Model
	SerialNumber	I_MaintOrderTechObjCube	SerialNumber	Serial Number
	MaintenanceNotification	I_MaintOrderTechObjCube	MaintenanceNotification	Notification
	LeadingOrder	I_MaintOrderTechObjCube	LeadingOrder	Last order
	MaintenancePlannerGroup	I_MaintOrderTechObjCube	MaintenancePlannerGroup	Planner Group
	MaintenancePlanningPlant	I_MaintOrderTechObjCube	MaintenancePlanningPlant	Planning Plant
	MaintOrdPersonResponsible			Person Resp. ID
	MaintenanceRevision	I_MaintOrderTechObjCube	MaintenanceRevision	Revision
	MaintenancePlan	I_MaintOrderTechObjCube	MaintenancePlan	MaintenancePlan
	MaintenanceItem	I_MaintOrderTechObjCube	MaintenanceItem	MaintItem
	BillOfOperationsType
	BillOfOperations
	BillOfOperationsVariant
	MaintenanceOrderPlanningCode	I_MaintOrderTechObjCube	MaintenanceOrderPlanningCode	OrderPlanInd.
	MaintenanceActivityType	I_MaintOrderTechObjCube	MaintenanceActivityType	MaintActivType
	ABCIndicator	I_MaintOrderTechObjCube	ABCIndicator	ABC Indicator
	MaintenancePlant	I_MaintOrderTechObjCube	MaintenancePlant	Plant
	AssetLocation	I_MaintOrderTechObjCube	AssetLocation	Location
	OperationSystemCondition	I_MaintOrderTechObjCube	OperationSystemCondition	SystemCondition
	PlantSection	I_MaintOrderTechObjCube	PlantSection	Plant Section
	MainWorkCenter	I_MaintOrderTechObjCube	MainWorkCenter	Work Center
	MainWorkCenterPlant	I_MaintOrderTechObjCube	MainWorkCenterPlant	Plnt WorkCenter
	WorkCenter	I_MaintOrderTechObjCube	WorkCenter	Work Center
	ReferenceElement	I_MaintOrderTechObjCube	ReferenceElement	Ref. Element PM/PS
	CostCenter	I_MaintOrderTechObjCube	CostCenter	Cost Center
	ControllingArea	I_MaintOrderTechObjCube	ControllingArea	Controlling Area
	WBSElementInternalID	I_MaintOrderTechObjCube	WBSElementInternalID	WBS Internal ID
	MasterFixedAsset	I_MaintOrderTechObjCube	MasterFixedAsset	Fixed Asset
	FixedAsset	I_MaintOrderTechObjCube	FixedAsset	Sub-number
	IsMarkedForDeletion	I_MaintOrderTechObjCube	IsMarkedForDeletion	Purch.org. data
	CreationDate	I_MaintOrderTechObjCube	CreationDate	Time Stamp
	CreationTime	I_MaintOrderTechObjCube	CreationTime	Time of Change
	LastChangeDate	I_MaintOrderTechObjCube	LastChangeDate	Time Stamp
	LastChangeTime	I_MaintOrderTechObjCube	LastChangeTime	Time changed
	PlannedStartDate	I_MaintOrderTechObjCube	PlannedStartDate	Latest Planned Start
	PlannedStartTime	I_MaintOrderTechObjCube	PlannedStartTime
	PlannedEndDate	I_MaintOrderTechObjCube	PlannedEndDate	Ltst Planned Finish
	PlannedEndTime	I_MaintOrderTechObjCube	PlannedEndTime
	ScheduledBasicStartDate	I_MaintOrderTechObjCube	ScheduledBasicStartDate	Sched. start
	ScheduledBasicStartTime	I_MaintOrderTechObjCube	ScheduledBasicStartTime
	ScheduledBasicEndDate	I_MaintOrderTechObjCube	ScheduledBasicEndDate	Sched. finish
	ScheduledBasicEndTime	I_MaintOrderTechObjCube	ScheduledBasicEndTime
	ActualStartDate	I_MaintOrderTechObjCube	ActualStartDate	Actual Start
	ActualStartTime	I_MaintOrderTechObjCube	ActualStartTime
	ConfirmedEndDate	I_MaintOrderTechObjCube	ConfirmedEndDate
	ConfirmedEndTime	I_MaintOrderTechObjCube	ConfirmedEndTime
	MaintOrderReferenceDate	I_MaintOrderTechObjCube	MaintOrderReferenceDate
	CreationDateTime	I_MaintOrderTechObjCube	CreationDateTime	Timestamp
	ScheduledBasicEndDateTime	I_MaintOrderTechObjCube	ScheduledBasicEndDateTime
	ConfirmedEndDateTime	I_MaintOrderTechObjCube	ConfirmedEndDateTime
	CreatedByUser	I_MaintOrderTechObjCube	CreatedByUser	User Name
	LastChangedByUser	I_MaintOrderTechObjCube	LastChangedByUser	User Name
	TechnicalObject	I_MaintOrderTechObjCube	TechnicalObject	Technical Object
	TechnicalObjectType	I_MaintOrderTechObjCube	TechnicalObjectType	Text object
	TechObjIsEquipOrFuncnlLoc	I_MaintOrderTechObjCube	TechObjIsEquipOrFuncnlLoc	Tech. Obj. Type
	AssetRoom	I_MaintOrderTechObjCube	AssetRoom	Room
	BusinessArea	I_MaintOrderTechObjCube	BusinessArea	Business Area
	CompanyCode	I_MaintOrderTechObjCube	CompanyCode	Receiver Company Code
	MaintenanceOrderIsHistorical	I_MaintOrderTechObjCube	MaintenanceOrderIsHistorical
	MaintenanceOrderType	I_MaintOrderTechObjCube	MaintenanceOrderType	Order Type
	MaintOrdPersonResponsible	I_MaintOrderTechObjCube	MaintOrdPersonResponsible	Person Resp. ID
	OrderDurationUnit	I_MaintOrderTechObjCube	OrderDurationUnit
	SettlementOrder	I_MaintOrderTechObjCube	SettlementOrder	SettlementOrder
	SuperiorProjectNetwork	I_MaintOrderTechObjCube	SuperiorProjectNetwork	Subnetwork of
	TaskListGroup	I_MaintOrderTechObjCube	TaskListGroup	Group
	TaskListGroupCounter	I_MaintOrderTechObjCube	TaskListGroupCounter	Group Counter
	TaskListType	I_MaintOrderTechObjCube	TaskListType	Task List Type
	WorkCenterPlant	I_MaintOrderTechObjCube	WorkCenterPlant	Plant
	OrderLeadTimeDuration	I_MaintOrderTechObjCube	OrderLeadTimeDuration
	OrderRuntimeDuration	I_MaintOrderTechObjCube	OrderRuntimeDuration
	NumberOfCreatedMaintOrders	I_MaintOrderTechObjCube	NumberOfCreatedMaintOrders
	NumberOfOrders	I_MaintOrderTechObjCube	NumberOfOrders	Open Notifications
	NumberOfCompletedMaintOrders	I_MaintOrderTechObjCube	NumberOfCompletedMaintOrders
	NumberOfPlannedMaintOrders	I_MaintOrderTechObjCube	NumberOfPlannedMaintOrders
	NumberOfUnplannedMaintOrders	I_MaintOrderTechObjCube	NumberOfUnplannedMaintOrders
	NumberOfImmediateMaintOrders	I_MaintOrderTechObjCube	NumberOfImmediateMaintOrders
	NmbrOfMaintOrdsNotToBeExecuted	I_MaintOrderTechObjCube	NmbrOfMaintOrdsNotToBeExecuted
	NmbrOfOutstandingMaintOrders	I_MaintOrderTechObjCube	NmbrOfOutstandingMaintOrders
	NmbrOfMaintOrdsCompletedOnTime	I_MaintOrderTechObjCube	NmbrOfMaintOrdsCompletedOnTime
	NmbrOfHistoricalOrders	I_MaintOrderTechObjCube	NmbrOfHistoricalOrders

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_MaintOrderTechObjQuery.
-- 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: CMNTORDTOQUERY

CREATE VIEW C_MaintOrderTechObjQuery AS
SELECT
  I_MaintOrderTechObjCube.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderTechObjCube.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  I_MaintOrderTechObjCube.FunctionalLocation AS FunctionalLocation,
  I_MaintOrderTechObjCube.Equipment AS Equipment,
  I_MaintOrderTechObjCube.Assembly AS Assembly,
  I_MaintOrderTechObjCube.Material AS Material,
  I_MaintOrderTechObjCube.SerialNumber AS SerialNumber,
  I_MaintOrderTechObjCube.MaintenanceNotification AS MaintenanceNotification,
  I_MaintOrderTechObjCube.LeadingOrder AS LeadingOrder,
  I_MaintOrderTechObjCube.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_MaintOrderTechObjCube.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintOrderTechObjCube.MaintenanceRevision AS MaintenanceRevision,
  I_MaintOrderTechObjCube.MaintenancePlan AS MaintenancePlan,
  I_MaintOrderTechObjCube.MaintenanceItem AS MaintenanceItem,
  I_MaintOrderTechObjCube.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  I_MaintOrderTechObjCube.MaintenanceActivityType AS MaintenanceActivityType,
  I_MaintOrderTechObjCube.ABCIndicator AS ABCIndicator,
  I_MaintOrderTechObjCube.MaintenancePlant AS MaintenancePlant,
  I_MaintOrderTechObjCube.AssetLocation AS AssetLocation,
  I_MaintOrderTechObjCube.OperationSystemCondition AS OperationSystemCondition,
  I_MaintOrderTechObjCube.PlantSection AS PlantSection,
  I_MaintOrderTechObjCube.MainWorkCenter AS MainWorkCenter,
  I_MaintOrderTechObjCube.MainWorkCenterPlant AS MainWorkCenterPlant,
  I_MaintOrderTechObjCube.WorkCenter AS WorkCenter,
  I_MaintOrderTechObjCube.ReferenceElement AS ReferenceElement,
  I_MaintOrderTechObjCube.CostCenter AS CostCenter,
  I_MaintOrderTechObjCube.ControllingArea AS ControllingArea,
  I_MaintOrderTechObjCube.WBSElementInternalID AS WBSElementInternalID,
  I_MaintOrderTechObjCube.MasterFixedAsset AS MasterFixedAsset,
  I_MaintOrderTechObjCube.FixedAsset AS FixedAsset,
  I_MaintOrderTechObjCube.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_MaintOrderTechObjCube.CreationDate AS CreationDate,
  I_MaintOrderTechObjCube.CreationTime AS CreationTime,
  I_MaintOrderTechObjCube.LastChangeDate AS LastChangeDate,
  I_MaintOrderTechObjCube.LastChangeTime AS LastChangeTime,
  I_MaintOrderTechObjCube.PlannedStartDate AS PlannedStartDate,
  I_MaintOrderTechObjCube.PlannedStartTime AS PlannedStartTime,
  I_MaintOrderTechObjCube.PlannedEndDate AS PlannedEndDate,
  I_MaintOrderTechObjCube.PlannedEndTime AS PlannedEndTime,
  I_MaintOrderTechObjCube.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  I_MaintOrderTechObjCube.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  I_MaintOrderTechObjCube.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  I_MaintOrderTechObjCube.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  I_MaintOrderTechObjCube.ActualStartDate AS ActualStartDate,
  I_MaintOrderTechObjCube.ActualStartTime AS ActualStartTime,
  I_MaintOrderTechObjCube.ConfirmedEndDate AS ConfirmedEndDate,
  I_MaintOrderTechObjCube.ConfirmedEndTime AS ConfirmedEndTime,
  I_MaintOrderTechObjCube.MaintOrderReferenceDate AS MaintOrderReferenceDate,
  I_MaintOrderTechObjCube.CreationDateTime AS CreationDateTime,
  I_MaintOrderTechObjCube.ScheduledBasicEndDateTime AS ScheduledBasicEndDateTime,
  I_MaintOrderTechObjCube.ConfirmedEndDateTime AS ConfirmedEndDateTime,
  I_MaintOrderTechObjCube.CreatedByUser AS CreatedByUser,
  I_MaintOrderTechObjCube.LastChangedByUser AS LastChangedByUser,
  I_MaintOrderTechObjCube.TechnicalObject AS TechnicalObject,
  I_MaintOrderTechObjCube.TechnicalObjectType AS TechnicalObjectType,
  I_MaintOrderTechObjCube.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_MaintOrderTechObjCube.AssetRoom AS AssetRoom,
  I_MaintOrderTechObjCube.BusinessArea AS BusinessArea,
  I_MaintOrderTechObjCube.CompanyCode AS CompanyCode,
  I_MaintOrderTechObjCube.MaintenanceOrderIsHistorical AS MaintenanceOrderIsHistorical,
  I_MaintOrderTechObjCube.MaintenanceOrderType AS MaintenanceOrderType,
  I_MaintOrderTechObjCube.MaintOrdPersonResponsible AS MaintOrdPersonResponsible,
  I_MaintOrderTechObjCube.OrderDurationUnit AS OrderDurationUnit,
  I_MaintOrderTechObjCube.SettlementOrder AS SettlementOrder,
  I_MaintOrderTechObjCube.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  I_MaintOrderTechObjCube.TaskListGroup AS TaskListGroup,
  I_MaintOrderTechObjCube.TaskListGroupCounter AS TaskListGroupCounter,
  I_MaintOrderTechObjCube.TaskListType AS TaskListType,
  I_MaintOrderTechObjCube.WorkCenterPlant AS WorkCenterPlant,
  I_MaintOrderTechObjCube.OrderLeadTimeDuration AS OrderLeadTimeDuration,
  I_MaintOrderTechObjCube.OrderRuntimeDuration AS OrderRuntimeDuration,
  I_MaintOrderTechObjCube.NumberOfCreatedMaintOrders AS NumberOfCreatedMaintOrders,
  I_MaintOrderTechObjCube.NumberOfOrders AS NumberOfOrders,
  I_MaintOrderTechObjCube.NumberOfCompletedMaintOrders AS NumberOfCompletedMaintOrders,
  I_MaintOrderTechObjCube.NumberOfPlannedMaintOrders AS NumberOfPlannedMaintOrders,
  I_MaintOrderTechObjCube.NumberOfUnplannedMaintOrders AS NumberOfUnplannedMaintOrders,
  I_MaintOrderTechObjCube.NumberOfImmediateMaintOrders AS NumberOfImmediateMaintOrders,
  I_MaintOrderTechObjCube.NmbrOfMaintOrdsNotToBeExecuted AS NmbrOfMaintOrdsNotToBeExecuted,
  I_MaintOrderTechObjCube.NmbrOfOutstandingMaintOrders AS NmbrOfOutstandingMaintOrders,
  I_MaintOrderTechObjCube.NmbrOfMaintOrdsCompletedOnTime AS NmbrOfMaintOrdsCompletedOnTime,
  I_MaintOrderTechObjCube.NmbrOfHistoricalOrders AS NmbrOfHistoricalOrders
FROM I_MaintOrderTechObjCube
;

Depth:

C_MaintOrderTechObjQuery view

I_MaintOrderTechObjCube view