I_AdvncdRetsMgmtProcNextPlants

DDL: I_ADVNCDRETSMGMTPROCNEXTPLANTS SQL: IARMPNXTPLNTS Type: view BASIC
10 Fields 1 Data Sources

Advanced Returns Mgmt Proc Next Plants

I_AdvncdRetsMgmtProcNextPlants is a Basic CDS View that provides data about "Advanced Returns Mgmt Proc Next Plants" in SAP S/4HANA. It reads from 1 data source (msr_d_nextplants) and exposes 10 fields with key fields RetsMgmtProcess, RetsMgmtProcessItem, RetsMgmtProcItmQtySplit, RetsMgmtProcessStep, ReturnsReferenceDocumentType.

Data Sources (1)

SourceAliasJoin Type
msr_d_nextplants _NextPlants from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Advanced Returns Mgmt Proc Next Plants view
Analytics.dataExtraction.enabled false view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IARMPNXTPLNTS view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RetsMgmtProcess msr_id Process ID No.
KEY RetsMgmtProcessItem item Task ID
KEY RetsMgmtProcItmQtySplit split_id WM Split Number
KEY RetsMgmtProcessStep executed_step_id Step ID
KEY ReturnsReferenceDocumentType doc_type VAT Document Type
KEY ReturnsReferenceDocument doc_nr Document Number
KEY ReturnsReferenceDocumentItem doc_item Item Number
KEY NumberOfNextPlants nxt_plnt_counter Counter
NextPlantForFollowUpActivity next_plant Plant
ReturnsTransshipmentPlant transshipment Transship 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 I_AdvncdRetsMgmtProcNextPlants.
-- 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: IARMPNXTPLNTS

CREATE VIEW I_AdvncdRetsMgmtProcNextPlants AS
SELECT
  msr_id AS RetsMgmtProcess,
  item AS RetsMgmtProcessItem,
  split_id AS RetsMgmtProcItmQtySplit,
  executed_step_id AS RetsMgmtProcessStep,
  doc_type AS ReturnsReferenceDocumentType,
  doc_nr AS ReturnsReferenceDocument,
  doc_item AS ReturnsReferenceDocumentItem,
  nxt_plnt_counter AS NumberOfNextPlants,
  next_plant AS NextPlantForFollowUpActivity,
  transshipment AS ReturnsTransshipmentPlant
FROM msr_d_nextplants AS _NextPlants
;

Learn More