I_RetsMgmtProcItmInspExec

DDL: I_RETSMGMTPROCITMINSPEXEC SQL: IRMRTSITMINSPEXE Type: view BASIC

Returns Mgmt Process Item Inspection Execution

I_RetsMgmtProcItmInspExec is a Basic CDS View that provides data about "Returns Mgmt Process Item Inspection Execution" in SAP S/4HANA. It reads from 1 data source (msr_d_executed) and exposes 5 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem, RetsMgmtProcItmQtySplit.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
msr_d_executed msr_d_executed from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Returns Mgmt Process Item Inspection Execution view
Analytics.dataExtraction.enabled false view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IRMRTSITMINSPEXE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess msr_id
KEY RetsMgmtProcessItem item
KEY RetsMgmtProcItmQtySplit split_id
RetMatlInspResultCode inspection_code
_RetMatlInspResultCode _RetMatlInspResultCode 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:  #C 
@ObjectModel.usageType.sizeCategory: #L 

@EndUserText.label: 'Returns Mgmt Process Item Inspection Execution' 
@Analytics.dataExtraction.enabled: false  
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IRMRTSITMINSPEXE'

define view I_RetsMgmtProcItmInspExec 
as select from msr_d_executed

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

{
    //Key

    key msr_id   as RetsMgmtProcess,
    key item     as RetsMgmtProcessItem,
    key split_id as RetsMgmtProcItmQtySplit, 
    
    //Inspection

    inspection_code as RetMatlInspResultCode,
    
    //Associations

    _RetMatlInspResultCode
    
}
where executed_step_id = '0041'  -- Inspection
        and   doc_type = '05'
        and doc_status = ' '     -- active 
        and  split_id  = '000'   -- only for items without split an inspection result will be shown           
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"MSR_D_EXECUTED"
],
"ASSOCIATED":
[
"I_RETMATLINSPRESULTCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More