I_AdvncdReturnsMgmtProcessItem

DDL: I_ADVNCDRETURNSMGMTPROCESSITEM SQL: IARMPROCESSITM Type: view COMPOSITE
24 Fields 1 Data Sources 2 Associations

Advanced Returns Management Process Item

I_AdvncdReturnsMgmtProcessItem is a Composite CDS View that provides data about "Advanced Returns Management Process Item" in SAP S/4HANA. It reads from 1 data source (I_AdvncdRetsMgmtProcItemBasic) and exposes 24 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AdvncdRetsMgmtProcItemBasic Item from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AdvncdReturnsMgmtProcess _AdvncdRetsMgmtProcess $projection.RetsMgmtProcess = _AdvncdRetsMgmtProcess.RetsMgmtProcess
[0..*] I_AdvncdReturnsMgmtProcessStep _AdvncdRetsMgmtProcStep $projection.RetsMgmtProcess = _AdvncdRetsMgmtProcStep.RetsMgmtProcess and $projection.RetsMgmtProcessItem = _AdvncdRetsMgmtProcStep.RetsMgmtProcessItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IARMPROCESSITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataExtraction.enabled false view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Advanced Returns Management Process Item view
ObjectModel.representativeKey RetsMgmtProcessItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess I_AdvncdRetsMgmtProcItemBasic RetsMgmtProcess Process ID No.
KEY RetsMgmtProcessItem I_AdvncdRetsMgmtProcItemBasic RetsMgmtProcessItem Task ID
ReturnsRefundRjcnReason ReturnsRefundRjcnReason CMR Rej. Reason
CustRetMatlAuthzn CustRetMatlAuthzn Customer RMA
CustomerRetMatlInspResultCode CustomerRetMatlInspResultCode Cust. Insp.Code
NextFllwUpActivityForMatlInsp NextFllwUpActivityForMatlInsp Next Follow-Up
RetsProdValnIsSuspended I_AdvncdRetsMgmtProcItemBasic RetsProdValnIsSuspended Suspend Valuation
ProductionVersion I_AdvncdRetsMgmtProcItemBasic ProductionVersion Version ID
RetsMgmtItmLogProcgStatus RetsMgmtItmLogProcgStatus
RetsMgmtItmLogProcgStatusDesc
RetsMgmtItmCompnProcgStatus RetsMgmtItmCompnProcgStatus
RetsMgmtCompnProcgStatusDesc
RetsMgmtItmProcgStatus RetsMgmtItmProcgStatus
RetsMgmtProcessingStatusDesc
CRMLogicalSystem CRMLogicalSystem CRM Logical System
CRMObjectUUID CRMObjectUUID CRM Object GUID
CRMObjectID CRMObjectID CRM Object ID
CRMObjectType CRMObjectType CRM Object Type
_AdvncdRetsMgmtProcess _AdvncdRetsMgmtProcess
_AdvncdRetsMgmtProcStep _AdvncdRetsMgmtProcStep
_ReturnsRefundRjcnReason _ReturnsRefundRjcnReason
_RetsMgmtItmLogProcgStatus _RetsMgmtItmLogProcgStatus
_RetsMgmtItmCompnProcgStatus _RetsMgmtItmCompnProcgStatus
_RetsMgmtItmProcgStatus _RetsMgmtItmProcgStatus

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_AdvncdReturnsMgmtProcessItem.
-- 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: IARMPROCESSITM

CREATE VIEW I_AdvncdReturnsMgmtProcessItem AS
SELECT
  Item.RetsMgmtProcess AS RetsMgmtProcess,
  Item.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  ReturnsRefundRjcnReason,
  CustRetMatlAuthzn,
  CustomerRetMatlInspResultCode,
  NextFllwUpActivityForMatlInsp,
  Item.RetsProdValnIsSuspended AS RetsProdValnIsSuspended,
  Item.ProductionVersion AS ProductionVersion,
  RetsMgmtItmLogProcgStatus,
  ItemProcessingStatus._RetsMgmtItmLogProcgStatus._Text[1: Language=$session.system_language].RetsMgmtProcessingStatusDesc AS RetsMgmtItmLogProcgStatusDesc,
  RetsMgmtItmCompnProcgStatus,
  ItemProcessingStatus._RetsMgmtItmCompnProcgStatus._Text[1: Language=$session.system_language].RetsMgmtCompnProcgStatusDesc AS RetsMgmtCompnProcgStatusDesc,
  RetsMgmtItmProcgStatus,
  ItemProcessingStatus._RetsMgmtItmProcgStatus._Text[1: Language=$session.system_language].RetsMgmtProcessingStatusDesc AS RetsMgmtProcessingStatusDesc,
  CRMLogicalSystem,
  CRMObjectUUID,
  CRMObjectID,
  CRMObjectType
FROM I_AdvncdRetsMgmtProcItemBasic AS Item
LEFT OUTER JOIN I_AdvncdReturnsMgmtProcess AS _AdvncdRetsMgmtProcess ON RetsMgmtProcess = _AdvncdRetsMgmtProcess.RetsMgmtProcess  -- association [1..1]
LEFT OUTER JOIN I_AdvncdReturnsMgmtProcessStep AS _AdvncdRetsMgmtProcStep ON RetsMgmtProcess = _AdvncdRetsMgmtProcStep.RetsMgmtProcess AND RetsMgmtProcessItem = _AdvncdRetsMgmtProcStep.RetsMgmtProcessItem  -- association [0..*]
;

Learn More