What is I_MaintTaskListOpTechObj in SAP S/4HANA?

I_MaintTaskListOpTechObj is a composite CDS view in SAP S/4HANA. Maint. Task List Operation w/ Tech. Obj. It contains 71 fields.

Which tables does I_MaintTaskListOpTechObj read from?

I_MaintTaskListOpTechObj reads data from: I_MaintTaskListOperation.

What VDM layer is I_MaintTaskListOpTechObj?

I_MaintTaskListOpTechObj is classified as a Composite view that combines data from multiple basic views.

I_MaintTaskListOpTechObj

DDL: I_MAINTTASKLISTOPTECHOBJ SQL: IMAINTTLOPTECOBJ Type: view COMPOSITE

71 Fields 1 Data Sources 4 Associations

Maint. Task List Operation w/ Tech. Obj.

I_MaintTaskListOpTechObj is a Composite CDS View that provides data about "Maint. Task List Operation w/ Tech. Obj." in SAP S/4HANA. It reads from 1 data source (I_MaintTaskListOperation) and exposes 71 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_MaintTaskListOperation	I_MaintTaskListOperation	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_TechnicalObject	_TechnicalObject	`_TechnicalObject.TechnicalObject = $projection.TechnicalObject and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc`
[0..1]	I_TechObjIsEquipOrFuncnlLoc	_TechObjIsEquipOrFuncnlLoc	`_TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc`
[0..1]	I_Currency	_Currency	`_Currency.Currency = $projection.OpExternalProcessingCurrency`
[0..1]	I_PurgInfoRecdOrgPlantData	_PurgInfoRecdOrgPlantData	`_PurgInfoRecdOrgPlantData.PurchasingInfoRecord = $projection.PurchasingInfoRecord and _PurgInfoRecdOrgPlantData.PurchasingOrganization = $projection.PurchasingOrganization and _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory and _PurgInfoRecdOrgPlantData.Plant = $projection.Plant`

Annotations (9)

Name	Value	Level
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	IMAINTTLOPTECOBJ	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Maint. Task List Operation w/ Tech. Obj.	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#COMPOSITE	view

Fields (71)

Key	Field	Source Table	Source Field	Description
KEY	TaskListType	I_MaintTaskListOperation	TaskListType	Task List Type
KEY	TaskListGroup	I_MaintTaskListOperation	TaskListGroup	Group
KEY	TaskListGroupCounter	I_MaintTaskListOperation	TaskListGroupCounter	Group Counter
KEY	TaskListSequence	I_MaintTaskListOperation	TaskListSequence	Sequence
KEY	TaskListOperationInternalId	I_MaintTaskListOperation	TaskListOperationInternalId	Node
	TaskListOpBOMItmIntVersCounter	I_MaintTaskListOperation	TaskListOpBOMItmIntVersCounter	Counter
	MaintenanceTaskListOperation	I_MaintTaskListOperation	MaintenanceTaskListOperation
	MaintTaskListSubOperation	I_MaintTaskListOperation	MaintTaskListSubOperation
	OperationText	I_MaintTaskListOperation	OperationText	Description
	OperationControlProfile	I_MaintTaskListOperation	OperationControlProfile	Control Key
	WorkCenterInternalID	I_MaintTaskListOperation	WorkCenterInternalID	Work Center
	WorkCenterTypeCode	I_MaintTaskListOperation	WorkCenterTypeCode	Object Type
	Plant	I_MaintTaskListOperation	Plant	Valuation Area
	OpPlannedWorkQuantity	I_MaintTaskListOperation	OpPlannedWorkQuantity
	OpWorkQuantityUnit	I_MaintTaskListOperation	OpWorkQuantityUnit
	ChangeNumber	I_MaintTaskListOperation	ChangeNumber	Change Number
	ValidityStartDate	I_MaintTaskListOperation	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_MaintTaskListOperation	ValidityEndDate	ValidTo
	OperationStandardTextCode	I_MaintTaskListOperation	OperationStandardTextCode	Std Text Key
	PurchasingInfoRecdAddlGrpgName	I_MaintTaskListOperation	PurchasingInfoRecdAddlGrpgName	Sort Term
	PurchasingInfoRecord	I_MaintTaskListOperation	PurchasingInfoRecord	Info Record
	PurchasingInfoRecordCategory	I_MaintTaskListOperation	PurchasingInfoRecordCategory	Infotype
	PurchasingOrganization	I_MaintTaskListOperation	PurchasingOrganization	Purchasing Organization
	Supplier	I_MaintTaskListOperation	Supplier	Supplier
	PurchaseContract	I_MaintTaskListOperation	PurchaseContract	Purchasing Doc.
	PurchaseContractItem	I_MaintTaskListOperation	PurchaseContractItem	Item
	OperationStandardDuration	I_MaintTaskListOperation	OperationStandardDuration
	OperationStandardDurationUnit	I_MaintTaskListOperation	OperationStandardDurationUnit
	NumberOfCapacities	I_MaintTaskListOperation	NumberOfCapacities	Number
	OperationSystemCondition	I_MaintTaskListOperation	OperationSystemCondition	SystemCondition
	CostCtrActivityType	I_MaintTaskListOperation	CostCtrActivityType	Activity Type
	OperationCalculationControl	I_MaintTaskListOperation	OperationCalculationControl	Calculation key
	Assembly	I_MaintTaskListOperation	Assembly	Pegged Reqmt
	PurchaseOrderQty	I_MaintTaskListOperation	PurchaseOrderQty	Purchase Order Quantity
	PurchaseOrderQuantityUnit	I_MaintTaskListOperation	PurchaseOrderQuantityUnit	Order Unit
	FunctionalLocation	I_MaintTaskListOperation	FunctionalLocation	Object ID
	Equipment	I_MaintTaskListOperation	Equipment	Equipment check
	IsDeleted	I_MaintTaskListOperation	IsDeleted	TRUE
	IsImplicitlyDeleted	I_MaintTaskListOperation	IsImplicitlyDeleted
	TaskListOperationObjectKey	I_MaintTaskListOperation	TaskListOperationObjectKey
	MaintOperationExecStageCode	I_MaintTaskListOperation	MaintOperationExecStageCode	Execution Stage
	BillOfOperationsGroup	I_MaintTaskListOperation	BillOfOperationsGroup	Group
	BillOfOperationsType	I_MaintTaskListOperation	BillOfOperationsType	Task List Type
	BOOOperationInternalID	I_MaintTaskListOperation	BOOOperationInternalID	Task list node
	MaintOperationalChecklistType	I_MaintTaskListOperation	MaintOperationalChecklistType	Checklist Type
	_Currency		_Currency
	_Assembly	I_MaintTaskListOperation	_Assembly
	_ChangeMaster	I_MaintTaskListOperation	_ChangeMaster
	_Equipment	I_MaintTaskListOperation	_Equipment
	_FunctionalLocation	I_MaintTaskListOperation	_FunctionalLocation
	_MaintenanceTaskList	I_MaintTaskListOperation	_MaintenanceTaskList
	_OperationCalculationControl	I_MaintTaskListOperation	_OperationCalculationControl
	_OperationControlProfile	I_MaintTaskListOperation	_OperationControlProfile
	_OperationStandardText	I_MaintTaskListOperation	_OperationStandardText
	_OperationSystemCondition	I_MaintTaskListOperation	_OperationSystemCondition
	_Plant	I_MaintTaskListOperation	_Plant
	_PurchaseContract	I_MaintTaskListOperation	_PurchaseContract
	_PurchaseContractItem	I_MaintTaskListOperation	_PurchaseContractItem
	_PurchasingInfoRecord	I_MaintTaskListOperation	_PurchasingInfoRecord
	_PurchasingOrganization	I_MaintTaskListOperation	_PurchasingOrganization
	_Supplier	I_MaintTaskListOperation	_Supplier
	_TaskListType	I_MaintTaskListOperation	_TaskListType
	_TaskListGroup	I_MaintTaskListOperation	_TaskListGroup
	_TaskListGroupCounter	I_MaintTaskListOperation	_TaskListGroupCounter
	_TaskListSequence	I_MaintTaskListOperation	_TaskListSequence
	_TaskListOperationInternalId	I_MaintTaskListOperation	_TaskListOperationInternalId
	_WorkCenter	I_MaintTaskListOperation	_WorkCenter
	_WorkCenterType	I_MaintTaskListOperation	_WorkCenterType
	_MaintOperationExecStageCode	I_MaintTaskListOperation	_MaintOperationExecStageCode
	_TechnicalObject		_TechnicalObject
	_TechObjIsEquipOrFuncnlLoc		_TechObjIsEquipOrFuncnlLoc

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 I_MaintTaskListOpTechObj.
-- 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: IMAINTTLOPTECOBJ

CREATE VIEW I_MaintTaskListOpTechObj AS
SELECT
  I_MaintTaskListOperation.TaskListType AS TaskListType,
  I_MaintTaskListOperation.TaskListGroup AS TaskListGroup,
  I_MaintTaskListOperation.TaskListGroupCounter AS TaskListGroupCounter,
  I_MaintTaskListOperation.TaskListSequence AS TaskListSequence,
  I_MaintTaskListOperation.TaskListOperationInternalId AS TaskListOperationInternalId,
  I_MaintTaskListOperation.TaskListOpBOMItmIntVersCounter AS TaskListOpBOMItmIntVersCounter,
  I_MaintTaskListOperation.MaintenanceTaskListOperation AS MaintenanceTaskListOperation,
  I_MaintTaskListOperation.MaintTaskListSubOperation AS MaintTaskListSubOperation,
  I_MaintTaskListOperation.OperationText AS OperationText,
  I_MaintTaskListOperation.OperationControlProfile AS OperationControlProfile,
  I_MaintTaskListOperation.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintTaskListOperation.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintTaskListOperation.Plant AS Plant,
  I_MaintTaskListOperation.OpPlannedWorkQuantity AS OpPlannedWorkQuantity,
  I_MaintTaskListOperation.OpWorkQuantityUnit AS OpWorkQuantityUnit,
  I_MaintTaskListOperation.ChangeNumber AS ChangeNumber,
  I_MaintTaskListOperation.ValidityStartDate AS ValidityStartDate,
  I_MaintTaskListOperation.ValidityEndDate AS ValidityEndDate,
  I_MaintTaskListOperation.OperationStandardTextCode AS OperationStandardTextCode,
  I_MaintTaskListOperation.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  I_MaintTaskListOperation.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_MaintTaskListOperation.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  I_MaintTaskListOperation.PurchasingOrganization AS PurchasingOrganization,
  I_MaintTaskListOperation.Supplier AS Supplier,
  I_MaintTaskListOperation.PurchaseContract AS PurchaseContract,
  I_MaintTaskListOperation.PurchaseContractItem AS PurchaseContractItem,
  I_MaintTaskListOperation.OperationStandardDuration AS OperationStandardDuration,
  I_MaintTaskListOperation.OperationStandardDurationUnit AS OperationStandardDurationUnit,
  I_MaintTaskListOperation.NumberOfCapacities AS NumberOfCapacities,
  I_MaintTaskListOperation.OperationSystemCondition AS OperationSystemCondition,
  I_MaintTaskListOperation.CostCtrActivityType AS CostCtrActivityType,
  I_MaintTaskListOperation.OperationCalculationControl AS OperationCalculationControl,
  I_MaintTaskListOperation.Assembly AS Assembly,
  I_MaintTaskListOperation.PurchaseOrderQty AS PurchaseOrderQty,
  I_MaintTaskListOperation.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_MaintTaskListOperation.FunctionalLocation AS FunctionalLocation,
  I_MaintTaskListOperation.Equipment AS Equipment,
  I_MaintTaskListOperation.IsDeleted AS IsDeleted,
  I_MaintTaskListOperation.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  I_MaintTaskListOperation.TaskListOperationObjectKey AS TaskListOperationObjectKey,
  I_MaintTaskListOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  I_MaintTaskListOperation.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_MaintTaskListOperation.BillOfOperationsType AS BillOfOperationsType,
  I_MaintTaskListOperation.BOOOperationInternalID AS BOOOperationInternalID,
  I_MaintTaskListOperation.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  I_MaintTaskListOperation._Assembly AS _Assembly,
  I_MaintTaskListOperation._ChangeMaster AS _ChangeMaster,
  I_MaintTaskListOperation._Equipment AS _Equipment,
  I_MaintTaskListOperation._FunctionalLocation AS _FunctionalLocation,
  I_MaintTaskListOperation._MaintenanceTaskList AS _MaintenanceTaskList,
  I_MaintTaskListOperation._OperationCalculationControl AS _OperationCalculationControl,
  I_MaintTaskListOperation._OperationControlProfile AS _OperationControlProfile,
  I_MaintTaskListOperation._OperationStandardText AS _OperationStandardText,
  I_MaintTaskListOperation._OperationSystemCondition AS _OperationSystemCondition,
  I_MaintTaskListOperation._Plant AS _Plant,
  I_MaintTaskListOperation._PurchaseContract AS _PurchaseContract,
  I_MaintTaskListOperation._PurchaseContractItem AS _PurchaseContractItem,
  I_MaintTaskListOperation._PurchasingInfoRecord AS _PurchasingInfoRecord,
  I_MaintTaskListOperation._PurchasingOrganization AS _PurchasingOrganization,
  I_MaintTaskListOperation._Supplier AS _Supplier,
  I_MaintTaskListOperation._TaskListType AS _TaskListType,
  I_MaintTaskListOperation._TaskListGroup AS _TaskListGroup,
  I_MaintTaskListOperation._TaskListGroupCounter AS _TaskListGroupCounter,
  I_MaintTaskListOperation._TaskListSequence AS _TaskListSequence,
  I_MaintTaskListOperation._TaskListOperationInternalId AS _TaskListOperationInternalId,
  I_MaintTaskListOperation._WorkCenter AS _WorkCenter,
  I_MaintTaskListOperation._WorkCenterType AS _WorkCenterType,
  I_MaintTaskListOperation._MaintOperationExecStageCode AS _MaintOperationExecStageCode
FROM I_MaintTaskListOperation
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = OpExternalProcessingCurrency  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS _PurgInfoRecdOrgPlantData ON _PurgInfoRecdOrgPlantData.PurchasingInfoRecord = PurchasingInfoRecord AND _PurgInfoRecdOrgPlantData.PurchasingOrganization = PurchasingOrganization AND _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory AND _PurgInfoRecdOrgPlantData.Plant = Plant  -- association [0..1]
;

Depth:

I_MaintTaskListOpTechObj view

I_MaintTaskListOperation view

I_MaintTaskListOperationTP view_entity