I_MaintOrdObjectListItemDraft

DDL: I_MAINTORDOBJECTLISTITEMDRAFT Type: view_entity BASIC

Maint Order Object List Item Temp data

I_MaintOrdObjectListItemDraft is a Basic CDS View that provides data about "Maint Order Object List Item Temp data" in SAP S/4HANA. It reads from 1 data source (maintordobjl_d) and exposes 18 fields with key fields MaintenanceOrder, MaintOrdObjListItemDraftUUID, MaintenanceOrderObjectList, MaintenanceObjectListItem.

Data Sources (1)

SourceAliasJoin Type
maintordobjl_d maintordobjl_d from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Maint Order Object List Item Temp data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder maintenanceorder Order
KEY MaintOrdObjListItemDraftUUID draftuuid UUID
KEY MaintenanceOrderObjectList maintenanceorderobjectlist Object list
KEY MaintenanceObjectListItem maintenanceobjectlistitem Object counters
ParentDraftUUID parentdraftuuid NodeID
Equipment equipment Equipment check
FunctionalLocation functionallocation Object ID
MaintenanceNotification maintenancenotification Notification
NotificationText _MaintenanceNotification NotificationText Description
Assembly assembly Pegged Reqmt
SerialNumber serialnumber Serial Number
Material material Vehicle Model
MaintObjectListItemSequence maintobjectlistitemsequence Sort field
_MaintenanceNotification _MaintenanceNotification
_Assembly _Assembly
_Product _Product
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation

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_MaintOrdObjectListItemDraft.
-- 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 I_MaintOrdObjectListItemDraft AS
SELECT
  MaintenanceOrder,
  draftuuid AS MaintOrdObjListItemDraftUUID,
  MaintenanceOrderObjectList,
  MaintenanceObjectListItem,
  ParentDraftUUID,
  Equipment,
  FunctionalLocation,
  MaintenanceNotification,
  _MaintenanceNotification.NotificationText AS NotificationText,
  Assembly,
  SerialNumber,
  Material,
  MaintObjectListItemSequence
FROM maintordobjl_d
;