I_AdvncdRetsMgmtProcExecStatus

DDL: I_ADVNCDRETSMGMTPROCEXECSTATUS SQL: IARMPROCEXECSTS Type: view COMPOSITE

ARM Process Execution Status

I_AdvncdRetsMgmtProcExecStatus is a Composite CDS View that provides data about "ARM Process Execution Status" in SAP S/4HANA. It reads from 2 data sources (I_AdvncdRetsMgmtProcExecuted, I_AdvncdRetsMgmtCmpltProcSts) and exposes 9 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem, RetsMgmtProcItmQtySplit, RetsMgmtProcessStep, ReturnsReferenceDocumentType.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_AdvncdRetsMgmtProcExecuted Executed left_outer
I_AdvncdRetsMgmtCmpltProcSts ProcgSts from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IARMPROCEXECSTS view
EndUserText.label ARM Process Execution Status view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess I_AdvncdRetsMgmtCmpltProcSts RetsMgmtProcess
KEY RetsMgmtProcessItem I_AdvncdRetsMgmtCmpltProcSts RetsMgmtProcessItem
KEY RetsMgmtProcItmQtySplit I_AdvncdRetsMgmtCmpltProcSts RetsMgmtProcItmQtySplit
KEY RetsMgmtProcessStep I_AdvncdRetsMgmtCmpltProcSts RetsMgmtProcessStep
KEY ReturnsReferenceDocumentType I_AdvncdRetsMgmtProcExecuted ReturnsReferenceDocumentType
KEY ReturnsReferenceDocument I_AdvncdRetsMgmtProcExecuted ReturnsReferenceDocument
KEY ReturnsReferenceDocumentItem I_AdvncdRetsMgmtProcExecuted ReturnsReferenceDocumentItem
RetsMgmtProcStepExecStatus RetsMgmtProcStepExecStatus
char1asRetsMgmtProcStepIsExecuted 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:  #C 
@ObjectModel.usageType.sizeCategory: #L 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IARMPROCEXECSTS'
@EndUserText.label: 'ARM Process Execution Status'

define view I_AdvncdRetsMgmtProcExecStatus 
  as select from I_AdvncdRetsMgmtCmpltProcSts as ProcgSts
  
  left outer join I_AdvncdRetsMgmtProcExecuted as Executed
    on  ProcgSts.RetsMgmtProcess                 = Executed.RetsMgmtProcess
    and ProcgSts.RetsMgmtProcessItem             = Executed.RetsMgmtProcessItem
    and ProcgSts.RetsMgmtProcItmQtySplit         = Executed.RetsMgmtProcItmQtySplit
    and ProcgSts.RetsMgmtProcessStep             = Executed.RetsMgmtProcessStep
    and (( ProcgSts.ReturnsReferenceDocument     = Executed.ReturnsDocument 
       and ProcgSts.ReturnsReferenceDocumentItem = Executed.ReturnsDocumentItem ) 
        or ProcgSts.ReturnsReferenceDocument     = '' )    
  
{
      //Key

  key ProcgSts.RetsMgmtProcess,
  key ProcgSts.RetsMgmtProcessItem,
  key ProcgSts.RetsMgmtProcItmQtySplit,  
  key ProcgSts.RetsMgmtProcessStep,       
           
      //Reference Document

  key Executed.ReturnsReferenceDocumentType,
  key Executed.ReturnsReferenceDocument,
  key Executed.ReturnsReferenceDocumentItem,  
  
      RetsMgmtProcStepExecStatus,

      cast ( case when ProcgSts.RetsMgmtProcessStep = Executed.RetsMgmtProcessStep
       then 'X' -- ->'Execution of this step has already been started -> step contained in msr_d_executed'
       else '' -- ->'This step has not yet been executed  -> still has to be created'
      end as abap.char(1)) as RetsMgmtProcStepIsExecuted
      
}
where (Executed.ReturnsDocumentStatus = '')


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADVNCDRETSMGMTCMPLTPROCSTS",
"I_ADVNCDRETSMGMTPROCEXECUTED"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More