R_LstMiProcessMaintenanceTP

DDL: R_LSTMIPROCESSMAINTENANCETP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 2 Associations

Last Mile Process Maintenance

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

Data Sources (1)

SourceAliasJoin Type
I_LstMiProcessMaintenance I_LstMiProcessMaintenance from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LstMiUIRouteTP _Route $projection.LstMiProcessOriginObjectUUID = _Route.LastMileRouteUUID
[0..1] R_LstMiRecoveryPointTP _RecoveryPoint

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name LastMileRoute view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Last Mile Process Maintenance view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY LstMiProcessUUID LstMiProcessUUID Process Key
LstMiProcess LstMiProcess Trans.
LstMiParentProcessUUID LstMiParentProcessUUID Process Key
LstMiProcessObjectType LstMiProcessObjectType Type
LstMiProcessObjectUUID LstMiProcessObjectUUID UUID
LstMiProcessOriginObjectUUID LstMiProcessOriginObjectUUID Object Key
LstMiProcessStep LstMiProcessStep Process Step
LstMiProcessStatusValue LstMiProcessStatusValue User Status Code
LstMiProcessResmblValue LstMiProcessResmblValue Process Resumable
LstMiProcessRetryValue LstMiProcessRetryValue Retry Count
LstMiProcessNextRetryValue LstMiProcessNextRetryValue Next Retry
LstMiProcessLastChangedDteTime LstMiProcessLastChangedDteTime Timestamp
_ProcessStatus _ProcessStatus
_Route _Route
_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 R_LstMiProcessMaintenanceTP.
-- 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 R_LstMiProcessMaintenanceTP AS
SELECT
  LstMiProcessUUID,
  LstMiProcess,
  LstMiParentProcessUUID,
  LstMiProcessObjectType,
  LstMiProcessObjectUUID,
  LstMiProcessOriginObjectUUID,
  LstMiProcessStep,
  LstMiProcessStatusValue,
  LstMiProcessResmblValue,
  LstMiProcessRetryValue,
  LstMiProcessNextRetryValue,
  LstMiProcessLastChangedDteTime
FROM I_LstMiProcessMaintenance
LEFT OUTER JOIN I_LstMiUIRouteTP AS _Route ON LstMiProcessOriginObjectUUID = _Route.LastMileRouteUUID  -- association [1..1]
LEFT OUTER JOIN R_LstMiRecoveryPointTP AS _RecoveryPoint ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More