I_MaintOrderOperObjectListLink

DDL: I_MAINTORDEROPEROBJECTLISTLINK SQL: IMTORDOPOBJLST Type: view BASIC
10 Fields 1 Data Sources 4 Associations

Link Order Operation to Object List

I_MaintOrderOperObjectListLink is a Basic CDS View that provides data about "Link Order Operation to Object List" in SAP S/4HANA. It reads from 1 data source (oprol) and exposes 10 fields with key fields MaintOrderRoutingNumber, MaintOrderOperationCounter. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
oprol oprol from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceItemObject _MaintenanceItemObject _MaintenanceItemObject.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList and _MaintenanceItemObject.MaintenanceItemObject = $projection.MaintenanceItemObject
[0..1] I_MaintenanceObjectListItem _MaintenanceObjectListItem _MaintenanceObjectListItem.MaintenanceObjectList = $projection.MaintenanceItemObjectList and _MaintenanceObjectListItem.MaintenanceObjectListItem = $projection.MaintenanceItemObject
[0..1] I_MaintenanceOrderOperation _MaintenanceOrderOperation _MaintenanceOrderOperation.MaintOrderRoutingNumber = $projection.MaintOrderRoutingNumber and _MaintenanceOrderOperation.MaintOrderOperationCounter = $projection.MaintOrderOperationCounter
[0..1] I_MaintOrderOperAndSubOper _MaintOrderOpAndSubOperation _MaintOrderOpAndSubOperation.MaintOrderRoutingNumber = $projection.MaintOrderRoutingNumber and _MaintOrderOpAndSubOperation.MaintOrderOperationCounter = $projection.MaintOrderOperationCounter

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMTORDOPOBJLST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Link Order Operation to Object List view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderRoutingNumber oprol aufpl TaskList No.Ops
KEY MaintOrderOperationCounter oprol aplzl Plan No.f.Oper.
MaintenanceItemObjectList oprol obknr Object list
MaintenanceItemObject oprol obzae Object counters
MaintenanceObjectList oprol obknr Object list
MaintenanceObjectListItem oprol obzae Object counters
_MaintenanceItemObject _MaintenanceItemObject
_MaintenanceObjectListItem _MaintenanceObjectListItem
_MaintenanceOrderOperation _MaintenanceOrderOperation
_MaintOrderOpAndSubOperation _MaintOrderOpAndSubOperation

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_MaintOrderOperObjectListLink.
-- 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: IMTORDOPOBJLST

CREATE VIEW I_MaintOrderOperObjectListLink AS
SELECT
  oprol.aufpl AS MaintOrderRoutingNumber,
  oprol.aplzl AS MaintOrderOperationCounter,
  oprol.obknr AS MaintenanceItemObjectList,
  oprol.obzae AS MaintenanceItemObject,
  oprol.obknr AS MaintenanceObjectList,
  oprol.obzae AS MaintenanceObjectListItem
FROM oprol
LEFT OUTER JOIN I_MaintenanceItemObject AS _MaintenanceItemObject ON _MaintenanceItemObject.MaintenanceItemObjectList = MaintenanceItemObjectList AND _MaintenanceItemObject.MaintenanceItemObject = MaintenanceItemObject  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceObjectListItem AS _MaintenanceObjectListItem ON _MaintenanceObjectListItem.MaintenanceObjectList = MaintenanceItemObjectList AND _MaintenanceObjectListItem.MaintenanceObjectListItem = MaintenanceItemObject  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _MaintenanceOrderOperation.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderOperAndSubOper AS _MaintOrderOpAndSubOperation ON _MaintOrderOpAndSubOperation.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _MaintOrderOpAndSubOperation.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
;

Learn More