Which tables does I_MaintTaskListOperationTP use?

I_MaintTaskListOperationTP reads from 1 data source(s): I_MaintTaskListOpTechObj.

I_MaintTaskListOperationTP

Q: How many fields does I_MaintTaskListOperationTP have?

I_MaintTaskListOperationTP has 78 fields. Key fields: TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId.

DDL: I_MAINTTASKLISTOPERATIONTP SQL: IMAINTTLOPTP Type: view_entity TRANSACTIONAL

Maintenance Task List Operation

I_MaintTaskListOperationTP is a Transactional CDS View that provides data about "Maintenance Task List Operation" in SAP S/4HANA. It reads from 1 data source (I_MaintTaskListOpTechObj) and exposes 78 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_MaintTaskListOpTechObj	_MaintTaskListOperation	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_MaintenanceTaskListTP	_MaintenanceTaskListTP	`_MaintenanceTaskListTP.TaskListType = $projection.TaskListType and _MaintenanceTaskListTP.TaskListGroup = $projection.TaskListGroup and _MaintenanceTaskListTP.TaskListGroupCounter = $projection.TaskListGroupCounter`

Annotations (6)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Maintenance Task List Operation	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#TRANSACTIONAL	view

Fields (78)

Key	Field	Source Table	Source Field
KEY	TaskListType	I_MaintTaskListOpTechObj	TaskListType
KEY	TaskListGroup	I_MaintTaskListOpTechObj	TaskListGroup
KEY	TaskListGroupCounter	I_MaintTaskListOpTechObj	TaskListGroupCounter
KEY	TaskListSequence	I_MaintTaskListOpTechObj	TaskListSequence
KEY	TaskListOperationInternalId	I_MaintTaskListOpTechObj	TaskListOperationInternalId
KEY	TaskListOpBOMItmIntVersCounter	I_MaintTaskListOpTechObj	TaskListOpBOMItmIntVersCounter
	MaintenanceTaskListOperation	I_MaintTaskListOpTechObj	MaintenanceTaskListOperation
	MaintTaskListSubOperation	I_MaintTaskListOpTechObj	MaintTaskListSubOperation
	OperationText	I_MaintTaskListOpTechObj	OperationText
	TechnicalObject	I_MaintTaskListOpTechObj	TechnicalObject
	TechObjIsEquipOrFuncnlLoc	I_MaintTaskListOpTechObj	TechObjIsEquipOrFuncnlLoc
	OperationControlProfile	I_MaintTaskListOpTechObj	OperationControlProfile
	WorkCenterInternalID	I_MaintTaskListOpTechObj	WorkCenterInternalID
	WorkCenterTypeCode	I_MaintTaskListOpTechObj	WorkCenterTypeCode
	Plant	I_MaintTaskListOpTechObj	Plant
	OpPlannedWorkQuantity	I_MaintTaskListOpTechObj	OpPlannedWorkQuantity
	OpWorkQuantityUnit	I_MaintTaskListOpTechObj	OpWorkQuantityUnit
	ChangeNumber	I_MaintTaskListOpTechObj	ChangeNumber
	ValidityStartDate	I_MaintTaskListOpTechObj	ValidityStartDate
	ValidityEndDate	I_MaintTaskListOpTechObj	ValidityEndDate
	OperationStandardTextCode	I_MaintTaskListOpTechObj	OperationStandardTextCode
	PurchasingInfoRecdAddlGrpgName	I_MaintTaskListOpTechObj	PurchasingInfoRecdAddlGrpgName
	OpExternalProcessingPrice	I_MaintTaskListOpTechObj	OpExternalProcessingPrice
	OpExternalProcessingCurrency	I_MaintTaskListOpTechObj	OpExternalProcessingCurrency
	NumberOfOperationPriceUnits	I_MaintTaskListOpTechObj	NumberOfOperationPriceUnits
	PurchasingInfoRecord	I_MaintTaskListOpTechObj	PurchasingInfoRecord
	PurchasingInfoRecordCategory	I_MaintTaskListOpTechObj	PurchasingInfoRecordCategory
	PurchasingOrganization	I_MaintTaskListOpTechObj	PurchasingOrganization
	Supplier	I_MaintTaskListOpTechObj	Supplier
	PurchaseContract	I_MaintTaskListOpTechObj	PurchaseContract
	PurchaseContractItem	I_MaintTaskListOpTechObj	PurchaseContractItem
	OperationStandardDuration	I_MaintTaskListOpTechObj	OperationStandardDuration
	OperationStandardDurationUnit	I_MaintTaskListOpTechObj	OperationStandardDurationUnit
	NumberOfCapacities	I_MaintTaskListOpTechObj	NumberOfCapacities
	OperationSystemCondition	I_MaintTaskListOpTechObj	OperationSystemCondition
	CostCtrActivityType	I_MaintTaskListOpTechObj	CostCtrActivityType
	OperationCalculationControl	I_MaintTaskListOpTechObj	OperationCalculationControl
	Assembly	I_MaintTaskListOpTechObj	Assembly
	PurchaseOrderQty	I_MaintTaskListOpTechObj	PurchaseOrderQty
	PurchaseOrderQuantityUnit	I_MaintTaskListOpTechObj	PurchaseOrderQuantityUnit
	FunctionalLocation	I_MaintTaskListOpTechObj	FunctionalLocation
	Equipment	I_MaintTaskListOpTechObj	Equipment
	IsDeleted	I_MaintTaskListOpTechObj	IsDeleted
	IsImplicitlyDeleted	I_MaintTaskListOpTechObj	IsImplicitlyDeleted
	TaskListOperationObjectKey	I_MaintTaskListOpTechObj	TaskListOperationObjectKey
	MaintOperationExecStageCode	I_MaintTaskListOpTechObj	MaintOperationExecStageCode
	MaintOperationalChecklistType	I_MaintTaskListOpTechObj	MaintOperationalChecklistType
	CreatedByUser	_MaintenanceTaskListTP	CreatedByUser
	LastChangedByUser	_MaintenanceTaskListTP	LastChangedByUser
	_Assembly	I_MaintTaskListOpTechObj	_Assembly
	_ChangeMaster	I_MaintTaskListOpTechObj	_ChangeMaster
	_Currency	I_MaintTaskListOpTechObj	_Currency
	_Equipment	I_MaintTaskListOpTechObj	_Equipment
	_FunctionalLocation	I_MaintTaskListOpTechObj	_FunctionalLocation
	_MaintenanceTaskList	I_MaintTaskListOpTechObj	_MaintenanceTaskList
	_OperationCalculationControl	I_MaintTaskListOpTechObj	_OperationCalculationControl
	_OperationControlProfile	I_MaintTaskListOpTechObj	_OperationControlProfile
	_OperationStandardText	I_MaintTaskListOpTechObj	_OperationStandardText
	_OperationSystemCondition	I_MaintTaskListOpTechObj	_OperationSystemCondition
	_Plant	I_MaintTaskListOpTechObj	_Plant
	_PurchaseContract	I_MaintTaskListOpTechObj	_PurchaseContract
	_PurchaseContractItem	I_MaintTaskListOpTechObj	_PurchaseContractItem
	_PurchasingInfoRecord	I_MaintTaskListOpTechObj	_PurchasingInfoRecord
	_PurchasingOrganization	I_MaintTaskListOpTechObj	_PurchasingOrganization
	_Supplier	I_MaintTaskListOpTechObj	_Supplier
	_TaskListGroup	I_MaintTaskListOpTechObj	_TaskListGroup
	_TaskListGroupCounter	I_MaintTaskListOpTechObj	_TaskListGroupCounter
	BillOfOperationsGroup	I_MaintTaskListOpTechObj	BillOfOperationsGroup
	BillOfOperationsType	I_MaintTaskListOpTechObj	BillOfOperationsType
	_TaskListOperationInternalId	I_MaintTaskListOpTechObj	_TaskListOperationInternalId
	_TaskListSequence	I_MaintTaskListOpTechObj	_TaskListSequence
	_TaskListType	I_MaintTaskListOpTechObj	_TaskListType
	_TechnicalObject	I_MaintTaskListOpTechObj	_TechnicalObject
	_TechObjIsEquipOrFuncnlLoc	I_MaintTaskListOpTechObj	_TechObjIsEquipOrFuncnlLoc
	_WorkCenter	I_MaintTaskListOpTechObj	_WorkCenter
	_WorkCenterType	I_MaintTaskListOpTechObj	_WorkCenterType
	_MaintOperationExecStageCode	I_MaintTaskListOpTechObj	_MaintOperationExecStageCode
	_MaintenanceTaskListTP		_MaintenanceTaskListTP

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

//@AbapCatalog.sqlViewName: 'IMAINTTLOPTP'

@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Maintenance Task List Operation'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
                                                    // Quick Action Enablement without Draft support

@VDM.viewType: #TRANSACTIONAL


define view entity I_MaintTaskListOperationTP
  as select from I_MaintTaskListOpTechObj as _MaintTaskListOperation
  association [1..1] to I_MaintenanceTaskListTP as _MaintenanceTaskListTP on  _MaintenanceTaskListTP.TaskListType         = $projection.TaskListType
                                                                          and _MaintenanceTaskListTP.TaskListGroup        = $projection.TaskListGroup
                                                                          and _MaintenanceTaskListTP.TaskListGroupCounter = $projection.TaskListGroupCounter
{

  key _MaintTaskListOperation.TaskListType,

  key _MaintTaskListOperation.TaskListGroup,

  key _MaintTaskListOperation.TaskListGroupCounter,
  key _MaintTaskListOperation.TaskListSequence,
  key _MaintTaskListOperation.TaskListOperationInternalId,
  key _MaintTaskListOperation.TaskListOpBOMItmIntVersCounter,
      _MaintTaskListOperation.MaintenanceTaskListOperation,
      _MaintTaskListOperation.MaintTaskListSubOperation,
      _MaintTaskListOperation.OperationText,
      _MaintTaskListOperation.TechnicalObject,
      _MaintTaskListOperation.TechObjIsEquipOrFuncnlLoc,
      _MaintTaskListOperation.OperationControlProfile,
      _MaintTaskListOperation.WorkCenterInternalID,
      _MaintTaskListOperation.WorkCenterTypeCode,
      _MaintTaskListOperation.Plant,
      _MaintTaskListOperation.OpPlannedWorkQuantity,
      _MaintTaskListOperation.OpWorkQuantityUnit,
      _MaintTaskListOperation.ChangeNumber,
      _MaintTaskListOperation.ValidityStartDate,
      _MaintTaskListOperation.ValidityEndDate,
      _MaintTaskListOperation.OperationStandardTextCode,
      _MaintTaskListOperation.PurchasingInfoRecdAddlGrpgName,
      _MaintTaskListOperation.OpExternalProcessingPrice,
      _MaintTaskListOperation.OpExternalProcessingCurrency,
      _MaintTaskListOperation.NumberOfOperationPriceUnits,
      _MaintTaskListOperation.PurchasingInfoRecord,
      _MaintTaskListOperation.PurchasingInfoRecordCategory,
      _MaintTaskListOperation.PurchasingOrganization,
      _MaintTaskListOperation.Supplier,
      _MaintTaskListOperation.PurchaseContract,
      _MaintTaskListOperation.PurchaseContractItem,
      _MaintTaskListOperation.OperationStandardDuration,
      _MaintTaskListOperation.OperationStandardDurationUnit,
      _MaintTaskListOperation.NumberOfCapacities,
      _MaintTaskListOperation.OperationSystemCondition,
      _MaintTaskListOperation.CostCtrActivityType,
      _MaintTaskListOperation.OperationCalculationControl,
      _MaintTaskListOperation.Assembly,
      _MaintTaskListOperation.PurchaseOrderQty,
      _MaintTaskListOperation.PurchaseOrderQuantityUnit,
      _MaintTaskListOperation.FunctionalLocation,
      _MaintTaskListOperation.Equipment,
      _MaintTaskListOperation.IsDeleted,
      _MaintTaskListOperation.IsImplicitlyDeleted,
      _MaintTaskListOperation.TaskListOperationObjectKey,
      _MaintTaskListOperation.MaintOperationExecStageCode,
      _MaintTaskListOperation.MaintOperationalChecklistType,
      _MaintenanceTaskListTP.CreatedByUser,
      _MaintenanceTaskListTP.LastChangedByUser,

      _MaintTaskListOperation._Assembly,
      _MaintTaskListOperation._ChangeMaster,
      _MaintTaskListOperation._Currency,
      _MaintTaskListOperation._Equipment,
      _MaintTaskListOperation._FunctionalLocation,
      _MaintTaskListOperation._MaintenanceTaskList,
      _MaintTaskListOperation._OperationCalculationControl,
      _MaintTaskListOperation._OperationControlProfile,
      _MaintTaskListOperation._OperationStandardText,
      _MaintTaskListOperation._OperationSystemCondition,
      _MaintTaskListOperation._Plant,
      _MaintTaskListOperation._PurchaseContract,
      _MaintTaskListOperation._PurchaseContractItem,
      _MaintTaskListOperation._PurchasingInfoRecord,
      _MaintTaskListOperation._PurchasingOrganization,
      _MaintTaskListOperation._Supplier,
      _MaintTaskListOperation._TaskListGroup,
      _MaintTaskListOperation._TaskListGroupCounter,
      //      _MaintTaskListOperation.BillOfOperationsGroup,

      //      _MaintTaskListOperation.BOOOperationInternalID,

      _MaintTaskListOperation.BillOfOperationsGroup,
      _MaintTaskListOperation.BillOfOperationsType,
      _MaintTaskListOperation._TaskListOperationInternalId,
      _MaintTaskListOperation._TaskListSequence,
      _MaintTaskListOperation._TaskListType,
      _MaintTaskListOperation._TechnicalObject,
      _MaintTaskListOperation._TechObjIsEquipOrFuncnlLoc,
      _MaintTaskListOperation._WorkCenter,
      _MaintTaskListOperation._WorkCenterType,
      _MaintTaskListOperation._MaintOperationExecStageCode,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _MaintenanceTaskListTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCETASKLISTTP",
"I_MAINTTASKLISTOPTECHOBJ"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSSEQUENCE",
"I_BOOOPERATIONINTERNALID",
"I_CHANGEMASTER",
"I_CURRENCY",
"I_EQUIPMENT",
"I_FUNCTIONALLOCATION",
"I_MAINTENANCETASKLIST",
"I_MAINTENANCETASKLISTTP",
"I_MAINTENANCETASKLISTTYPE",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MATERIAL",
"I_OPERATIONCALCULATIONCONTROL",
"I_OPERATIONCONTROLPROFILE",
"I_OPERATIONSTANDARDTEXT",
"I_PLANT",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURCHASINGINFORECORDAPI01",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_WORKCENTER",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_MAINTTASKLISTOPTECHOBJ"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_MaintTaskListOperationTP view_entity

I_MaintTaskListOpTechObj view

C_ObjPgMaintTaskListAndOp view
C_ObjPgMaintTaskListOperation view