I_RetsMgmtInspExec

DDL: I_RETSMGMTINSPEXEC Type: view_entity COMPOSITE
10 Fields 1 Data Sources 1 Associations

Returns Inspection Executed

I_RetsMgmtInspExec is a Composite CDS View that provides data about "Returns Inspection Executed" in SAP S/4HANA. It reads from 1 data source (I_AdvncdRetsMgmtProcExecuted) and exposes 10 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem, RetsMgmtProcItmQtySplit, ReturnsDocumentType, RetsMgmtProcessStep. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_AdvncdRetsMgmtProcExecuted AdvncdRetsMgmtProcExecuted from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ReturnsInspectionItem _ReturnsInspectionItem $projection.RetsMgmtProcess = _ReturnsInspectionItem.RetsMgmtProcess and $projection.ReturnsDocument = _ReturnsInspectionItem.ReturnsInspection

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Returns Inspection Executed view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess RetsMgmtProcess Process ID No.
KEY RetsMgmtProcessItem RetsMgmtProcessItem Task ID
KEY RetsMgmtProcItmQtySplit RetsMgmtProcItmQtySplit WM Split Number
KEY ReturnsDocumentType ReturnsDocumentType VAT Document Type
KEY RetsMgmtProcessStep RetsMgmtProcessStep Step ID
ReturnsDocument ReturnsDocument Document Number
TargetPlant TargetPlant Target Plant
TargetStorageLocation TargetStorageLocation Location
TargetStockType TargetStockType Stock Type
_ReturnsInspectionItem _ReturnsInspectionItem

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_RetsMgmtInspExec.
-- 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.

CREATE VIEW I_RetsMgmtInspExec AS
SELECT
  RetsMgmtProcess,
  RetsMgmtProcessItem,
  RetsMgmtProcItmQtySplit,
  ReturnsDocumentType,
  RetsMgmtProcessStep,
  ReturnsDocument,
  TargetPlant,
  TargetStorageLocation,
  TargetStockType
FROM I_AdvncdRetsMgmtProcExecuted AS AdvncdRetsMgmtProcExecuted
LEFT OUTER JOIN I_ReturnsInspectionItem AS _ReturnsInspectionItem ON RetsMgmtProcess = _ReturnsInspectionItem.RetsMgmtProcess AND ReturnsDocument = _ReturnsInspectionItem.ReturnsInspection  -- association [1..*]
;

Learn More