P_CustRetProcFlow04

DDL: P_CUSTRETPROCFLOW04 SQL: PCSTRETPRCF04 Type: view CONSUMPTION Package: ODATA_SD_CRET_PROCESSFLOW

Customer Return Process Flow: Level +0.5 RPO

P_CustRetProcFlow04 is a Consumption CDS View that provides data about "Customer Return Process Flow: Level +0.5 RPO" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 7 fields with key field ReturnsDocument. Part of development package ODATA_SD_CRET_PROCESSFLOW.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic Level0 from

Annotations (7)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ReturnsDocument ARMProcessExcuted ReturnsDocument
ReturnsDocumentType ARMProcessExcuted ReturnsDocumentType
CustRetItmFollowUpActivity ARMProcessChain CustRetItmFollowUpActivity
CustomerReturn I_SalesDocumentBasic SalesDocument
ReturnsDocumentItem
RetsMgmtProcess I_SalesDocumentBasic RetsMgmtProcess
CustomerReturnItem ARMProcessExcuted RetsMgmtProcessItem 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PCSTRETPRCF04'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION

define view P_CustRetProcFlow04
  as select from           I_SalesDocumentBasic         as Level0

    left outer to one join I_AdvncdRetsMgmtProcExecuted as ARMProcessExcuted on Level0.RetsMgmtProcess = ARMProcessExcuted.RetsMgmtProcess

    left outer to one join I_AdvncdReturnsMgmtProcChain as ARMProcessChain   on ARMProcessChain.CustRetItmChainID = ARMProcessExcuted.CustRetItmChainID


{
      //Key

  key ARMProcessExcuted.ReturnsDocument                                    as ReturnsDocument,

      ARMProcessExcuted.ReturnsDocumentType                                as ReturnsDocumentType,

      ARMProcessChain.CustRetItmFollowUpActivity,

      Level0.SalesDocument                                                 as CustomerReturn,
      cast( right(ARMProcessExcuted.ReturnsDocumentItem, 6) as posnr_von ) as ReturnsDocumentItem,

      Level0.RetsMgmtProcess,

      ARMProcessExcuted.RetsMgmtProcessItem                                as CustomerReturnItem
}
where
  (
    Level0.SDDocumentCategory = 'H'
  )
//  and(

//    ARMProcessExcuted.ReturnsDocumentType = '02'

//  )

Learn More