P_RETSMGMTPROCESSITEMEXEC1

CDS View

P_RETSMGMTPROCESSITEMEXEC1 is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RetsMgmtProcessItemExec view from BASIC Returns Mgmt Process Item Execution 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:  #C 
@ObjectModel.usageType.sizeCategory: #L 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PRMRTSITMEXEC1'

define view P_RetsMgmtProcessItemExec1
as select from P_RetsMgmtProcessItemExec2
as ItemExec

left outer to one join msr_d_executed
as InspRslt

on ItemExec.RetsMgmtProcess = InspRslt.msr_id
and ItemExec.RetsMgmtProcessItem = InspRslt.item
and InspRslt.executed_step_id = '0041'  --Inspection
and InspRslt.doc_type = '05'
and InspRslt.doc_status = ' '   --active
and InspRslt.split_id  = '000'  -- for items with split no inspection result will be shown

association[0..1] to I_RetMatlInspResultCode
as _RetMatlInspResultCode
on $projection.RetMatlInspResultCode = _RetMatlInspResultCode.RetMatlInspResultCode

{
    //Key

    key ItemExec.RetsMgmtProcess,
    key ItemExec.RetsMgmtProcessItem,
    
    //Compensation Control

    ItemExec.split_id,
    ItemExec.ReturnsRefundType,
    ItemExec.ReturnsRefundProcgMode,
    ItemExec.ReturnsRefundExtent,
    
    ItemExec.CuRtStep,
    ItemExec.CuRtDocType,
    
    //Replacement Material

    ItemExec.ReplacementMaterial,
    ItemExec.ReplacementMaterialQuantity,
    ItemExec.ReplacementMaterialQtyUnit,
    
    //Inspection Result

    InspRslt.split_id as InspSplit,
    InspRslt.inspection_code as RetMatlInspResultCode,
    
    InspRslt.executed_step_id as InspStep,
    InspRslt.doc_type as InspDocType,
    
    //Associations

    _ReturnsRefundType,
    _ReturnsRefundProcgMode,
    _ReturnsRefundExtent,
    _RetMatlInspResultCode,
    _ReplacementMaterialQtyUnit
}
                 
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_RETSMGMTPROCESSITEMEXEC2",
"MSR_D_EXECUTED"
],
"ASSOCIATED":
[
"I_RETMATLINSPRESULTCODE",
"I_RETURNSREFUNDEXTENT",
"I_RETURNSREFUNDPROCGMODEACTIVE",
"I_RETURNSREFUNDTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[
"P_RETSMGMTPROCESSITEMEXEC2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More