P_RetsMgmtProcessItemExec1

DDL: P_RETSMGMTPROCESSITEMEXEC1 SQL: PRMRTSITMEXEC1 Type: view BASIC Package: VDM_ARM_BASICS
20 Fields 1 Data Sources

Returns Mgmt Process Item Execution 1

P_RetsMgmtProcessItemExec1 is a Basic CDS View that provides data about "Returns Mgmt Process Item Execution 1" in SAP S/4HANA. It reads from 1 data source (P_RetsMgmtProcessItemExec2) and exposes 20 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem. Part of development package VDM_ARM_BASICS.

Data Sources (1)

SourceAliasJoin Type
P_RetsMgmtProcessItemExec2 ItemExec from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PRMRTSITMEXEC1 view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess P_RetsMgmtProcessItemExec2 RetsMgmtProcess Process ID No.
KEY RetsMgmtProcessItem P_RetsMgmtProcessItemExec2 RetsMgmtProcessItem Task ID
split_id P_RetsMgmtProcessItemExec2 split_id WM Split Number
ReturnsRefundType P_RetsMgmtProcessItemExec2 ReturnsRefundType Refund Type
ReturnsRefundProcgMode P_RetsMgmtProcessItemExec2 ReturnsRefundProcgMode
ReturnsRefundExtent P_RetsMgmtProcessItemExec2 ReturnsRefundExtent
CuRtStep P_RetsMgmtProcessItemExec2 CuRtStep Step ID
CuRtDocType P_RetsMgmtProcessItemExec2 CuRtDocType VAT Document Type
ReplacementMaterial P_RetsMgmtProcessItemExec2 ReplacementMaterial Repl. Material
ReplacementMaterialQuantity P_RetsMgmtProcessItemExec2 ReplacementMaterialQuantity Repl. Quantity
ReplacementMaterialQtyUnit P_RetsMgmtProcessItemExec2 ReplacementMaterialQtyUnit Repl. Mat. UoM
InspSplit InspRslt split_id WM Split Number
RetMatlInspResultCode InspRslt inspection_code Inspection Code
InspStep InspRslt executed_step_id Step ID
InspDocType InspRslt doc_type VAT Document Type
_ReturnsRefundType _ReturnsRefundType
_ReturnsRefundProcgMode _ReturnsRefundProcgMode
_ReturnsRefundExtent _ReturnsRefundExtent
_RetMatlInspResultCode _RetMatlInspResultCode
_ReplacementMaterialQtyUnit _ReplacementMaterialQtyUnit

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_RetsMgmtProcessItemExec1.
-- 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: PRMRTSITMEXEC1

CREATE VIEW P_RetsMgmtProcessItemExec1 AS
SELECT
  ItemExec.RetsMgmtProcess AS RetsMgmtProcess,
  ItemExec.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  ItemExec.split_id AS split_id,
  ItemExec.ReturnsRefundType AS ReturnsRefundType,
  ItemExec.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  ItemExec.ReturnsRefundExtent AS ReturnsRefundExtent,
  ItemExec.CuRtStep AS CuRtStep,
  ItemExec.CuRtDocType AS CuRtDocType,
  ItemExec.ReplacementMaterial AS ReplacementMaterial,
  ItemExec.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  ItemExec.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  InspRslt.split_id AS InspSplit,
  InspRslt.inspection_code AS RetMatlInspResultCode,
  InspRslt.executed_step_id AS InspStep,
  InspRslt.doc_type AS InspDocType
FROM P_RetsMgmtProcessItemExec2 AS ItemExec
;

Learn More