A_MaintTaskListOpRelshp

DDL: A_MAINTTASKLISTOPRELSHP Type: view_entity CONSUMPTION
22 Fields 1 Data Sources 1 OData Services

Operation Relationships

A_MaintTaskListOpRelshp is a Consumption CDS View that provides data about "Operation Relationships" in SAP S/4HANA. It reads from 1 data source (R_MaintTaskListOpRelshpTP) and exposes 22 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It is exposed through 1 OData service (API_MAINTENANCETASKLIST).

Data Sources (1)

SourceAliasJoin Type
R_MaintTaskListOpRelshpTP R_MaintTaskListOpRelshpTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Operation Relationships view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
API_MAINTENANCETASKLIST API_MAINTENANCETASKLIST V4 C2 C1

Fields (22)

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
KEY TaskListOpBOMItmIntVersCounter TaskListOpBOMItmIntVersCounter
SuccssrBOOGroup SuccssrBOOGroup
SuccssrBOOOpInternalID SuccssrBOOOpInternalID
MaintenanceTaskListOperation MaintenanceTaskListOperation
SuperiorOperation SuperiorOperation
OperationText OperationText Description
MasterRecipeRelationshipType MasterRecipeRelationshipType
OperationIsSuccessor OperationIsSuccessor
FactoryCalendar FactoryCalendar Factory Calendar
WorkCenter WorkCenter Work Center
Plant Plant Valuation Area
MaxTimeIntvlIsUsedForSchedg MaxTimeIntvlIsUsedForSchedg
BOORelationshipType BOORelationshipType
TimeIntvlBtwnRelshp TimeIntvlBtwnRelshp
TimeIntvlBtwnRelshpUnit TimeIntvlBtwnRelshpUnit
WorkCenterInternalID WorkCenterInternalID Work Center
_HeaderredirectedtoA_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 A_MaintTaskListOpRelshp.
-- 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 A_MaintTaskListOpRelshp AS
SELECT
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListSequence,
  TaskListOperationInternalId,
  TaskListOpBOMItmIntVersCounter,
  SuccssrBOOGroup,
  SuccssrBOOOpInternalID,
  MaintenanceTaskListOperation,
  SuperiorOperation,
  OperationText,
  MasterRecipeRelationshipType,
  OperationIsSuccessor,
  FactoryCalendar,
  WorkCenter,
  Plant,
  MaxTimeIntvlIsUsedForSchedg,
  BOORelationshipType,
  TimeIntvlBtwnRelshp,
  TimeIntvlBtwnRelshpUnit,
  WorkCenterInternalID
FROM R_MaintTaskListOpRelshpTP
;

Learn More