P_AdvncdReturnsMgmtProcessStep

DDL: P_ADVNCDRETURNSMGMTPROCESSSTEP SQL: PARMPROCSTEP Type: view CONSUMPTION Package: VDM_ARM_BASICS
13 Fields 1 Data Sources

Advanced Returns Management Process Step

P_AdvncdReturnsMgmtProcessStep is a Consumption CDS View that provides data about "Advanced Returns Management Process Step" in SAP S/4HANA. It reads from 1 data source (I_AdvncdRetsMgmtProcExecuted) and exposes 13 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem, RetsMgmtProcItmQtySplit, RetsMgmtProcessStep, ReturnsDocumentType. Part of development package VDM_ARM_BASICS.

Data Sources (1)

SourceAliasJoin Type
I_AdvncdRetsMgmtProcExecuted Executed from

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PARMPROCSTEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess I_AdvncdRetsMgmtProcExecuted RetsMgmtProcess Process ID No.
KEY RetsMgmtProcessItem I_AdvncdRetsMgmtProcExecuted RetsMgmtProcessItem Task ID
KEY RetsMgmtProcItmQtySplit I_AdvncdRetsMgmtProcExecuted RetsMgmtProcItmQtySplit WM Split Number
KEY RetsMgmtProcessStep I_AdvncdRetsMgmtProcExecuted RetsMgmtProcessStep Step ID
KEY ReturnsDocumentType I_AdvncdRetsMgmtProcExecuted ReturnsDocumentType VAT Document Type
KEY ReturnsDocument I_AdvncdRetsMgmtProcExecuted ReturnsDocument Document Number
CustRetItmFollowUpActivity Chain CustRetItmFollowUpActivity Follow-Up Act.
ReturnsRefundType I_AdvncdRetsMgmtProcExecuted ReturnsRefundType Refund Type
ReturnsRefundProcgMode I_AdvncdRetsMgmtProcExecuted ReturnsRefundProcgMode
ReplacementMaterial I_AdvncdRetsMgmtProcExecuted ReplacementMaterial Repl. Material
ReplacementMaterialQuantity I_AdvncdRetsMgmtProcExecuted ReplacementMaterialQuantity Repl. Quantity
ReplacementMaterialQtyUnit I_AdvncdRetsMgmtProcExecuted ReplacementMaterialQtyUnit Repl. Mat. UoM
ReplacementMatlSupplyingPlant I_AdvncdRetsMgmtProcExecuted ReplacementMatlSupplyingPlant Supplying Plant

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 P_AdvncdReturnsMgmtProcessStep.
-- 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: PARMPROCSTEP

CREATE VIEW P_AdvncdReturnsMgmtProcessStep AS
SELECT
  Executed.RetsMgmtProcess AS RetsMgmtProcess,
  Executed.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  Executed.RetsMgmtProcItmQtySplit AS RetsMgmtProcItmQtySplit,
  Executed.RetsMgmtProcessStep AS RetsMgmtProcessStep,
  Executed.ReturnsDocumentType AS ReturnsDocumentType,
  Executed.ReturnsDocument AS ReturnsDocument,
  Chain.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  Executed.ReturnsRefundType AS ReturnsRefundType,
  Executed.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  Executed.ReplacementMaterial AS ReplacementMaterial,
  Executed.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  Executed.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  Executed.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant
FROM I_AdvncdRetsMgmtProcExecuted AS Executed
;

Learn More