I_RetsMgmtProcItmInspExec

DDL: I_RETSMGMTPROCITMINSPEXEC SQL: IRMRTSITMINSPEXE Type: view BASIC
5 Fields 1 Data Sources

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.

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 Process ID No.
KEY RetsMgmtProcessItem item Task ID
KEY RetsMgmtProcItmQtySplit split_id WM Split Number
RetMatlInspResultCode inspection_code Inspection Code
_RetMatlInspResultCode _RetMatlInspResultCode

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 I_RetsMgmtProcItmInspExec.
-- 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.
-- SQL view name: IRMRTSITMINSPEXE

CREATE VIEW I_RetsMgmtProcItmInspExec AS
SELECT
  msr_id AS RetsMgmtProcess,
  item AS RetsMgmtProcessItem,
  split_id AS RetsMgmtProcItmQtySplit,
  inspection_code AS RetMatlInspResultCode
FROM msr_d_executed
;

Learn More