I_LstMiProcessMaintenance

DDL: I_LSTMIPROCESSMAINTENANCE SQL: ILSTMIPFRWPRCMNT Type: view_entity BASIC

Process Framework Process Maintenance

I_LstMiProcessMaintenance is a Basic CDS View that provides data about "Process Framework Process Maintenance" in SAP S/4HANA. It reads from 1 data source (lmd_prcs_prcmnt) and exposes 14 fields with key field LstMiProcessUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
lmd_prcs_prcmnt ProcessMaintenance from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LstMiProcessStatus _ProcessStatus $projection.LstMiProcessStatusValue = _ProcessStatus.LstMiProcessStatusValue
[0..1] I_LstMiRecoveryPoint _RecoveryPoint

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process Framework Process Maintenance view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY LstMiProcessUUID process_key Process Key
LstMiProcess process Trans.
LstMiParentProcessUUID parent_process_key Process Key
LstMiProcessObjectType object_type Type
LstMiProcessObjectUUID object_key UUID
LstMiProcessOriginObjectUUID origin_object_key Object Key
LstMiProcessStep process_step Process Step
LstMiProcessStatusValue process_status User Status Code
LstMiProcessResmblValue resumable Process Resumable
LstMiProcessRetryValue retry_count Retry Count
LstMiProcessNextRetryValue next_retry Next Retry
LstMiProcessLastChangedDteTime changed_at Timestamp
_ProcessStatus _ProcessStatus
_RecoveryPoint _RecoveryPoint

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_LstMiProcessMaintenance.
-- 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: ILSTMIPFRWPRCMNT

CREATE VIEW I_LstMiProcessMaintenance AS
SELECT
  process_key AS LstMiProcessUUID,
  process AS LstMiProcess,
  parent_process_key AS LstMiParentProcessUUID,
  object_type AS LstMiProcessObjectType,
  object_key AS LstMiProcessObjectUUID,
  origin_object_key AS LstMiProcessOriginObjectUUID,
  process_step AS LstMiProcessStep,
  process_status AS LstMiProcessStatusValue,
  resumable AS LstMiProcessResmblValue,
  retry_count AS LstMiProcessRetryValue,
  next_retry AS LstMiProcessNextRetryValue,
  changed_at AS LstMiProcessLastChangedDteTime
FROM lmd_prcs_prcmnt AS ProcessMaintenance
LEFT OUTER JOIN I_LstMiProcessStatus AS _ProcessStatus ON LstMiProcessStatusValue = _ProcessStatus.LstMiProcessStatusValue  -- association [0..1]
LEFT OUTER JOIN I_LstMiRecoveryPoint AS _RecoveryPoint ON /* condition not available in parsed metadata */  -- association [0..1]
;