I_MaintTaskListOpData

DDL: I_MAINTTASKLISTOPDATA SQL: IPMTSKLISTOPDATA Type: view COMPOSITE
78 Fields 1 Data Sources

Maintenance Task List Operation Data

I_MaintTaskListOpData is a Composite CDS View (Fact) that provides data about "Maintenance Task List Operation Data" in SAP S/4HANA. It reads from 1 data source (I_MaintTaskListOperation) and exposes 78 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryFact
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the type of the maintenance task list? What are the group details of the maintenance task list? What is the sequence of the related operations? What are the validity details of the maintenance task list? Is the maintenance task list marked for deletion? What is the creation date of the maintenance task list? When was the last time the maintenance task list changed? What are the activities, operations, and suboperations related to the maintenance task list? What is the control key of the operation? What is the plant assigned to the operation? What is the work center assigned to the operation? What is the short text of the operation? What is the unit of measurement of the operation or the related activity? What are the purchasing and delivery details of the operation? What is the material group of the operation? What are the duration details of the related activity? What are the capacity details of the operation? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We recommend that you only use it for this purpose.

Prerequisites
You have authorizations to display maintenance task lists in transactions IA03 , IA07 , IA09 and IA13 . This check is based on the following fields: Task Lists ( I_ROUT1 ) Cost Centers ( I_KOSTL ) Maintenance Planner Group ( I_INGRP ) Maintenance Planning Plant ( I_IWERK ) Maintenance Plant ( I_SWERK ) Authorization Group ( I_BEGRP ) Transaction Code ( I_TCODE ) Business Partner: Purpose Completed ( B_BUP_PCPT ) Vendor: Central Data ( F_LFA1_GEN ) Vendor: Account Group Authorization ( F_FLA1_GRP ) Vendor: Account Authorization ( F_LFA1_BEK )

Structure
Business Objects This view is built on the following business objects: Maintenance task list Maintenance task list operation Main CDS parameters and filters This CDS view does not have any input parameters. Measures and attributes Some important measures and attributes are: Maintenance task list type Group data Operation sequence Validity Deletion flag Creation date Change date Activities, operations, suboperations Control key Plant Work center Operation short text Operation or activity unit of measurement Purchasing and delivery data, for example Purchasing Organization and Price Unit Material group Duration data, for example Normal Duration of the Activity and Minimum activity duration Capacity data, for example Number of capacities required and Work percentage

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_MaintTaskListOperation I_MaintTaskListOperation from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPMTSKLISTOPDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Task List Operation Data view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TaskListOperationInternalId view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view
ObjectModel.sapObjectNodeType.name MaintenanceTaskListOperation view

Fields (78)

KeyFieldSource TableSource FieldDescription
KEY TaskListType TaskListType Task List Type
KEY TaskListGroup TaskListGroup Group
KEY TaskListGroupCounter TaskListGroupCounter Group Counter
KEY TaskListSequence TaskListSequence Sequence
KEY TaskListOperationInternalId TaskListOperationInternalId Node
TaskListOpBOMItmIntVersCounter TaskListOpBOMItmIntVersCounter Counter
ValidityStartDate ValidityStartDate Validity Start Date
ChangeNumber ChangeNumber Change Number
IsDeleted IsDeleted TRUE
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
ValidityEndDate ValidityEndDate ValidTo
MaintTaskListSubOperation MaintTaskListSubOperation
MaintenanceTaskListOperation MaintenanceTaskListOperation
OperationControlProfile OperationControlProfile Control Key
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
Plant Plant Valuation Area
OperationStandardTextCode OperationStandardTextCode Std Text Key
OperationText OperationText Description
OperationUnit OperationUnit Act/op UoM
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
OperationReferenceQuantity OperationReferenceQuantity Base Quantity
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName Sort Term
Supplier Supplier Supplier
PlannedDeliveryDuration PlannedDeliveryDuration Pl. Deliv. Time
OpExternalProcessingPrice OpExternalProcessingPrice Price
NumberOfOperationPriceUnits NumberOfOperationPriceUnits Price Unit
CostElement CostElement G/L Account
OpExternalProcessingCurrency OpExternalProcessingCurrency Currency
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingInfoRecordCategory PurchasingInfoRecordCategory Infotype
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
MaterialGroup MaterialGroup Product Group
OperationStandardDuration OperationStandardDuration
OperationStandardDurationUnit OperationStandardDurationUnit
MinimumDuration MinimumDuration
MinimumDurationUnit MinimumDurationUnit
OpPlannedWorkQuantity OpPlannedWorkQuantity
OpWorkQuantityUnit OpWorkQuantityUnit
NumberOfCapacities NumberOfCapacities Number
OperationWorkPercent OperationWorkPercent Percent
CapRqmtsDistributionFunction CapRqmtsDistributionFunction
CompanyCode CompanyCode Receiver Company Code
OperationSystemCondition OperationSystemCondition SystemCondition
FactoryCalendar FactoryCalendar Factory Calendar
CapacityRequirementDistrKey CapacityRequirementDistrKey
OperationCostingRelevancyType OperationCostingRelevancyType Operation Costing Relevancy Type
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
PurchaseOrderQty PurchaseOrderQty Purchase Order Quantity
BOOOperationInternalID BOOOperationInternalID Task list node
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsType BillOfOperationsType Task List Type
_TaskListType _TaskListType
_TaskListGroup _TaskListGroup
_TaskListGroupCounter _TaskListGroupCounter
_TaskListSequence _TaskListSequence
_TaskListOperationInternalId _TaskListOperationInternalId
_OperationControlProfile _OperationControlProfile
_WorkCenter _WorkCenter
_Plant _Plant
_OperationStandardText _OperationStandardText
_Supplier _Supplier
_OpExternalProcessingCurrency _OpExternalProcessingCurrency
_PurchasingInfoRecord _PurchasingInfoRecord
_OperationSystemCondition _OperationSystemCondition
_WorkCenterType _WorkCenterType
_ChangeMaster _ChangeMaster
_OperationUnit _OperationUnit
_PurchasingGroup _PurchasingGroup
_MaterialGroup _MaterialGroup
_MinimumDurationUnit _MinimumDurationUnit
_CompanyCode _CompanyCode
_FactoryCalendar _FactoryCalendar
_PurchaseOrderQtyUnit _PurchaseOrderQtyUnit
_MaintenanceTaskList _MaintenanceTaskList

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_MaintTaskListOpData.
-- 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: IPMTSKLISTOPDATA

CREATE VIEW I_MaintTaskListOpData AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListSequence,
  TaskListOperationInternalId,
  TaskListOpBOMItmIntVersCounter,
  ValidityStartDate,
  ChangeNumber,
  IsDeleted,
  CreationDate,
  LastChangeDate,
  ValidityEndDate,
  MaintTaskListSubOperation,
  MaintenanceTaskListOperation,
  OperationControlProfile,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  Plant,
  OperationStandardTextCode,
  OperationText,
  OperationUnit,
  OpQtyToBaseQtyDnmntr,
  OpQtyToBaseQtyNmrtr,
  OperationReferenceQuantity,
  PurchasingInfoRecdAddlGrpgName,
  Supplier,
  PlannedDeliveryDuration,
  OpExternalProcessingPrice,
  NumberOfOperationPriceUnits,
  CostElement,
  OpExternalProcessingCurrency,
  PurchasingInfoRecord,
  PurchasingInfoRecordCategory,
  PurchasingOrganization,
  PurchasingGroup,
  MaterialGroup,
  OperationStandardDuration,
  OperationStandardDurationUnit,
  MinimumDuration,
  MinimumDurationUnit,
  OpPlannedWorkQuantity,
  OpWorkQuantityUnit,
  NumberOfCapacities,
  OperationWorkPercent,
  CapRqmtsDistributionFunction,
  CompanyCode,
  OperationSystemCondition,
  FactoryCalendar,
  CapacityRequirementDistrKey,
  OperationCostingRelevancyType,
  PurchaseOrderQuantityUnit,
  PurchaseOrderQty,
  BOOOperationInternalID,
  BillOfOperationsGroup,
  BillOfOperationsType
FROM I_MaintTaskListOperation
;

Learn More