I_CustRetItemProcessStep

DDL: I_CUSTRETITEMPROCESSSTEP Type: view_entity COMPOSITE
35 Fields 4 Data Sources 1 Associations

Item Process Steps

I_CustRetItemProcessStep is a Composite CDS View that provides data about "Item Process Steps" in SAP S/4HANA. It reads from 4 data sources (I_SalesDocumentBasic, I_SalesDocumentBasic, I_AdvRetsMgmtItmExectdProcStp, I_AdvncdRetsMgmtItmPlndProcStp) and exposes 35 fields with key fields CustomerReturn, CustomerReturnItem, RetsMgmtProcItmQtySplit, RetsMgmtProcessStep, ReturnsDocumentType. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
I_SalesDocumentBasic CustomerReturn inner
I_SalesDocumentBasic CustomerReturn inner
I_AdvRetsMgmtItmExectdProcStp ExecutedProcessStep from
I_AdvncdRetsMgmtItmPlndProcStp PlannedProcessStep union_all

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ReturnsDocumentType _ReturnsDocumentType $projection.ReturnsDocumentType = _ReturnsDocumentType.ReturnsDocumentType

Annotations (9)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Item Process Steps view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn
KEY CustomerReturnItem
KEY RetsMgmtProcItmQtySplit I_AdvRetsMgmtItmExectdProcStp RetsMgmtProcItmQtySplit
KEY RetsMgmtProcessStep I_AdvRetsMgmtItmExectdProcStp RetsMgmtProcessStep
KEY ReturnsDocumentType I_AdvRetsMgmtItmExectdProcStp ReturnsDocumentType
KEY ReturnsDocument I_AdvRetsMgmtItmExectdProcStp ReturnsDocument
KEY ReturnsDocumentItem I_AdvRetsMgmtItmExectdProcStp ReturnsDocumentItem
KEY ReturnsReferenceDocument I_AdvRetsMgmtItmExectdProcStp ReturnsReferenceDocument
KEY ReturnsReferenceDocumentItem I_AdvRetsMgmtItmExectdProcStp ReturnsReferenceDocumentItem
ReturnsReferenceDocumentType I_AdvRetsMgmtItmExectdProcStp ReturnsReferenceDocumentType
RetsMgmtProcess I_AdvRetsMgmtItmExectdProcStp RetsMgmtProcess Process ID No.
RetsMgmtProcessItem I_AdvRetsMgmtItmExectdProcStp RetsMgmtProcessItem
ReturnsDocumentStatus I_AdvRetsMgmtItmExectdProcStp ReturnsDocumentStatus
RetsMgmtProcStepExecStatus I_AdvRetsMgmtItmExectdProcStp RetsMgmtProcStepExecStatus
CustomerReturnType
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
KEY CustomerReturnItem
KEY RetsMgmtProcItmQtySplit I_AdvncdRetsMgmtItmPlndProcStp RetsMgmtProcItmQtySplit
KEY RetsMgmtProcessStep I_AdvncdRetsMgmtItmPlndProcStp RetsMgmtProcessStep
KEY ReturnsDocumentType
KEY ReturnsDocument
KEY ReturnsDocumentItem
KEY ReturnsReferenceDocument I_AdvncdRetsMgmtItmPlndProcStp ReturnsReferenceDocument
KEY ReturnsReferenceDocumentItem I_AdvncdRetsMgmtItmPlndProcStp ReturnsReferenceDocumentItem
ReturnsReferenceDocumentType I_AdvncdRetsMgmtItmPlndProcStp ReturnsReferenceDocumentType
RetsMgmtProcess I_AdvncdRetsMgmtItmPlndProcStp RetsMgmtProcess Process ID No.
RetsMgmtProcessItem I_AdvncdRetsMgmtItmPlndProcStp RetsMgmtProcessItem
ReturnsDocumentStatus
CustomerReturnType
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
_ReturnsDocumentType _ReturnsDocumentType

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_CustRetItemProcessStep.
-- 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_CustRetItemProcessStep AS
SELECT
  cast(CustomerReturn.SalesDocument as vdm_customer_return preserving type) AS CustomerReturn,
  cast(ExecutedProcessStep.RetsMgmtProcessItem as vdm_customer_return_item preserving type) AS CustomerReturnItem,
  ExecutedProcessStep.RetsMgmtProcItmQtySplit AS RetsMgmtProcItmQtySplit,
  ExecutedProcessStep.RetsMgmtProcessStep AS RetsMgmtProcessStep,
  ExecutedProcessStep.ReturnsDocumentType AS ReturnsDocumentType,
  ExecutedProcessStep.ReturnsDocument AS ReturnsDocument,
  ExecutedProcessStep.ReturnsDocumentItem AS ReturnsDocumentItem,
  ExecutedProcessStep.ReturnsReferenceDocument AS ReturnsReferenceDocument,
  ExecutedProcessStep.ReturnsReferenceDocumentItem AS ReturnsReferenceDocumentItem,
  ExecutedProcessStep.ReturnsReferenceDocumentType AS ReturnsReferenceDocumentType,
  ExecutedProcessStep.RetsMgmtProcess AS RetsMgmtProcess,
  ExecutedProcessStep.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  ExecutedProcessStep.ReturnsDocumentStatus AS ReturnsDocumentStatus,
  ExecutedProcessStep.RetsMgmtProcStepExecStatus AS RetsMgmtProcStepExecStatus,
  cast(CustomerReturn.SalesDocumentType as vdm_customer_return_type preserving type) AS CustomerReturnType,
  CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturn.SalesOrganization AS SalesOrganization,
  CustomerReturn.DistributionChannel AS DistributionChannel
FROM I_AdvRetsMgmtItmExectdProcStp AS ExecutedProcessStep
INNER JOIN I_SalesDocumentBasic AS CustomerReturn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReturnsDocumentType AS _ReturnsDocumentType ON ReturnsDocumentType = _ReturnsDocumentType.ReturnsDocumentType  -- association [0..1]
-- UNION ALL with additional select branch(es): I_AdvncdRetsMgmtItmPlndProcStp
;

Learn More