C_MaintTaskListOpAssgdStrategy

DDL: C_MAINTTASKLISTOPASSGDSTRATEGY Type: view_entity CONSUMPTION Package: VDM_EAM_TASKLIST
16 Fields 1 Data Sources 1 Associations 2 OData Services 2 Fiori Apps

Task List Operations with Strategy

C_MaintTaskListOpAssgdStrategy is a Consumption CDS View that provides data about "Task List Operations with Strategy" in SAP S/4HANA. It reads from 1 data source (I_MaintTaskListOperation) and exposes 16 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 1 association to related views. It is exposed through 2 OData services (UI_MAINTENANCE_PLAN, UI_MAINTENANCEITEM). It is used in 2 Fiori applications: Manage Maintenance Plans, Manage Maintenance Items. Part of development package VDM_EAM_TASKLIST.

Data Sources (1)

SourceAliasJoin Type
I_MaintTaskListOperation I_MaintTaskListOperation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_MaintPckgTaskListOpAlloc _Allocation $projection.TaskListType = _Allocation.TaskListType and $projection.TaskListGroup = _Allocation.TaskListGroup and $projection.TaskListGroupCounter = _Allocation.TaskListGroupCounter and $projection.TaskListSequence = _Allocation.TaskListSequence and $projection.TaskListOperationInternalId = _Allocation.TaskListOperationInternalId

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Task List Operations with Strategy view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
UI_MAINTENANCE_PLAN UI_MAINTENANCE_PLAN V2 C1 NOT_RELEASED
UI_MAINTENANCEITEM UI_MAINTENANCEITEM V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5325 Manage Maintenance Plans Transactional An application to Manage Maintenance Plans, provides and comprehensive maintenance plan view including general data, scheduling information, assigned Maintenance Items, as well as review Maintenance calls, create new maintenance plan, edit existing maintenance plan.
F5356 Manage Maintenance Items Transactional An application to Manage Maintenance Items, provides and comprehensive Maintenance Item view, create new Maintenance Item, edit existing Maintenance Item.

Manage Maintenance Plans

Business Role: Maintenance Planner

With the Manage Maintenance Plans app, you as a maintenance planner can view, create, change, schedule, activate, and delete maintenance plans.

Manage Maintenance Items

Business Role: Maintenance Planner

With the Manage Maintenance Items app, you as a maintenance planner can manage maintenance items. You can create maintenance items, decide how to evaluate final due date for a maintenance item, assign maintenance item to a maintenance plan, view details of a maintenance item, view status of an equipment or a functional location within a maintenance item, and so on.

Fields (16)

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
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
OperationText OperationText Description
Supplier Supplier Supplier
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsSequence _BillOfOperationsSequence
_BOOOperationInternalID _BOOOperationInternalID
_MaintenanceTaskList _MaintenanceTaskList
_Supplier _Supplier
_Allocation _Allocation

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_MaintTaskListOpAssgdStrategy.
-- 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.

CREATE VIEW C_MaintTaskListOpAssgdStrategy AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListSequence,
  TaskListOperationInternalId,
  BillOfOperationsType,
  BillOfOperationsGroup,
  OperationText,
  Supplier
FROM I_MaintTaskListOperation
LEFT OUTER JOIN C_MaintPckgTaskListOpAlloc AS _Allocation ON TaskListType = _Allocation.TaskListType AND TaskListGroup = _Allocation.TaskListGroup AND TaskListGroupCounter = _Allocation.TaskListGroupCounter AND TaskListSequence = _Allocation.TaskListSequence AND TaskListOperationInternalId = _Allocation.TaskListOperationInternalId  -- association [0..*]
;

Learn More