P_RETSMGMTPROCESSITEMEXEC1

CDS View

Returns Mgmt Process Item Execution 1

P_RETSMGMTPROCESSITEMEXEC1 is a CDS View in S/4HANA. Returns Mgmt Process Item Execution 1. 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
}

Learn More