I_MaintTaskListOperationTP

DDL: I_MAINTTASKLISTOPERATIONTP SQL: IMAINTTLOPTP Type: view_entity TRANSACTIONAL
78 Fields 1 Data Sources 1 Associations

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)

SourceAliasJoin Type
I_MaintTaskListOpTechObj _MaintTaskListOperation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintenanceTaskListTP _MaintenanceTaskListTP _MaintenanceTaskListTP.TaskListType = $projection.TaskListType and _MaintenanceTaskListTP.TaskListGroup = $projection.TaskListGroup and _MaintenanceTaskListTP.TaskListGroupCounter = $projection.TaskListGroupCounter

Annotations (6)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY TaskListType I_MaintTaskListOpTechObj TaskListType Task List Type
KEY TaskListGroup I_MaintTaskListOpTechObj TaskListGroup Group
KEY TaskListGroupCounter I_MaintTaskListOpTechObj TaskListGroupCounter Group Counter
KEY TaskListSequence I_MaintTaskListOpTechObj TaskListSequence Sequence
KEY TaskListOperationInternalId I_MaintTaskListOpTechObj TaskListOperationInternalId Node
KEY TaskListOpBOMItmIntVersCounter I_MaintTaskListOpTechObj TaskListOpBOMItmIntVersCounter
MaintenanceTaskListOperation I_MaintTaskListOpTechObj MaintenanceTaskListOperation
MaintTaskListSubOperation I_MaintTaskListOpTechObj MaintTaskListSubOperation
OperationText I_MaintTaskListOpTechObj OperationText Description
TechnicalObject I_MaintTaskListOpTechObj TechnicalObject Technical Object
TechObjIsEquipOrFuncnlLoc I_MaintTaskListOpTechObj TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
OperationControlProfile I_MaintTaskListOpTechObj OperationControlProfile Control Key
WorkCenterInternalID I_MaintTaskListOpTechObj WorkCenterInternalID Work Center
WorkCenterTypeCode I_MaintTaskListOpTechObj WorkCenterTypeCode Object Type
Plant I_MaintTaskListOpTechObj Plant Valuation Area
OpPlannedWorkQuantity I_MaintTaskListOpTechObj OpPlannedWorkQuantity
OpWorkQuantityUnit I_MaintTaskListOpTechObj OpWorkQuantityUnit
ChangeNumber I_MaintTaskListOpTechObj ChangeNumber Change Number
ValidityStartDate I_MaintTaskListOpTechObj ValidityStartDate Validity Start Date
ValidityEndDate I_MaintTaskListOpTechObj ValidityEndDate ValidTo
OperationStandardTextCode I_MaintTaskListOpTechObj OperationStandardTextCode Std Text Key
PurchasingInfoRecdAddlGrpgName I_MaintTaskListOpTechObj PurchasingInfoRecdAddlGrpgName Sort Term
OpExternalProcessingPrice I_MaintTaskListOpTechObj OpExternalProcessingPrice Price
OpExternalProcessingCurrency I_MaintTaskListOpTechObj OpExternalProcessingCurrency Currency
NumberOfOperationPriceUnits I_MaintTaskListOpTechObj NumberOfOperationPriceUnits Price Unit
PurchasingInfoRecord I_MaintTaskListOpTechObj PurchasingInfoRecord Info Record
PurchasingInfoRecordCategory I_MaintTaskListOpTechObj PurchasingInfoRecordCategory Infotype
PurchasingOrganization I_MaintTaskListOpTechObj PurchasingOrganization Purchasing Organization
Supplier I_MaintTaskListOpTechObj Supplier Supplier
PurchaseContract I_MaintTaskListOpTechObj PurchaseContract Purchasing Doc.
PurchaseContractItem I_MaintTaskListOpTechObj PurchaseContractItem Item
OperationStandardDuration I_MaintTaskListOpTechObj OperationStandardDuration
OperationStandardDurationUnit I_MaintTaskListOpTechObj OperationStandardDurationUnit
NumberOfCapacities I_MaintTaskListOpTechObj NumberOfCapacities Number
OperationSystemCondition I_MaintTaskListOpTechObj OperationSystemCondition SystemCondition
CostCtrActivityType I_MaintTaskListOpTechObj CostCtrActivityType Activity Type
OperationCalculationControl I_MaintTaskListOpTechObj OperationCalculationControl Calculation key
Assembly I_MaintTaskListOpTechObj Assembly Pegged Reqmt
PurchaseOrderQty I_MaintTaskListOpTechObj PurchaseOrderQty Purchase Order Quantity
PurchaseOrderQuantityUnit I_MaintTaskListOpTechObj PurchaseOrderQuantityUnit Order Unit
FunctionalLocation I_MaintTaskListOpTechObj FunctionalLocation Object ID
Equipment I_MaintTaskListOpTechObj Equipment Equipment check
IsDeleted I_MaintTaskListOpTechObj IsDeleted TRUE
IsImplicitlyDeleted I_MaintTaskListOpTechObj IsImplicitlyDeleted
TaskListOperationObjectKey I_MaintTaskListOpTechObj TaskListOperationObjectKey
MaintOperationExecStageCode I_MaintTaskListOpTechObj MaintOperationExecStageCode Execution Stage
MaintOperationalChecklistType I_MaintTaskListOpTechObj MaintOperationalChecklistType Checklist Type
CreatedByUser _MaintenanceTaskListTP CreatedByUser User Name
LastChangedByUser _MaintenanceTaskListTP LastChangedByUser User Name
_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 Group
BillOfOperationsType I_MaintTaskListOpTechObj BillOfOperationsType Task List Type
_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

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_MaintTaskListOperationTP.
-- 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: IMAINTTLOPTP

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

Learn More