P_CustRetProcFlow05

DDL: P_CUSTRETPROCFLOW05 SQL: PCUSTRETPROCF05 Type: view CONSUMPTION Package: ODATA_SD_CRET_PROCESSFLOW

Customer Return Process Flow: Level +0.5 Inspection

P_CustRetProcFlow05 is a Consumption CDS View that provides data about "Customer Return Process Flow: Level +0.5 Inspection" in SAP S/4HANA. It reads from 3 data sources (I_AdvncdRetsMgmtProcExecuted, P_CustRetProcFlow0, I_AdvncdRetsMgmtMatlInspection) and exposes 14 fields with key field Level1Document. It has 1 association to related views. Part of development package ODATA_SD_CRET_PROCESSFLOW.

3 data source(s) 14 fields

Data Sources (3)

SourceAliasJoin Type
I_AdvncdRetsMgmtProcExecuted ARMProcessExcuted inner
P_CustRetProcFlow0 Level0 from
I_AdvncdRetsMgmtMatlInspection Level1 inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentItemBasic _CustomerReturnItem Level0.CustomerReturn = _CustomerReturnItem.SalesDocument and Level1.ReferenceDocumentItem = _CustomerReturnItem.SalesDocumentItem

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PCUSTRETPROCF05 view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Level1Document I_AdvncdRetsMgmtMatlInspection InspectionDocument
Level1DocumentItem I_AdvncdRetsMgmtMatlInspection ReferenceDocumentItem
Level1DocumentCategory
SDDocumentCategory P_CustRetProcFlow0 SDDocumentCategory
CustomerReturnType P_CustRetProcFlow0 CustomerReturnType
CustomerReturn P_CustRetProcFlow0 CustomerReturn
ProductIsInspectedAtCustSite I_AdvncdRetsMgmtMatlInspection ProductIsInspectedAtCustSite
ReturnsDelivery I_AdvncdRetsMgmtMatlInspection ReturnsDelivery
ReturnsDeliveryItem I_AdvncdRetsMgmtMatlInspection ReturnsDeliveryItem
SalesOrganization P_CustRetProcFlow0 SalesOrganization
DistributionChannel P_CustRetProcFlow0 DistributionChannel
OrganizationDivision P_CustRetProcFlow0 OrganizationDivision
CustRetItmFollowUpActivity I_AdvncdRetsMgmtMatlInspection CustRetItmFollowUpActivity
RetsMgmtProcItmQtySplit I_AdvncdRetsMgmtProcExecuted RetsMgmtProcItmQtySplit 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PCUSTRETPROCF05'


define view P_CustRetProcFlow05

  as select from P_CustRetProcFlow0             as Level0
    inner join   I_AdvncdRetsMgmtMatlInspection as Level1 on Level1.ReferenceDocument = Level0.CustomerReturn
  
    inner join   I_AdvncdRetsMgmtProcExecuted   as ARMProcessExcuted    on  ARMProcessExcuted.RetsMgmtProcess = Level0.RetsMgmtProcess
                                                                        and ARMProcessExcuted.RetsMgmtProcessItem =Level1.ReferenceDocumentItem
                                                                        and ARMProcessExcuted.RetsMgmtProcessStep = '0042'
                                                                        and ARMProcessExcuted.ReturnsDocument =Level1.InspectionDocument
                                                                        and ARMProcessExcuted.ReturnsDocumentType = '05'
  association [1..1] to I_SalesDocumentItemBasic as _CustomerReturnItem on  Level0.CustomerReturn        = _CustomerReturnItem.SalesDocument
                                                                        and Level1.ReferenceDocumentItem = _CustomerReturnItem.SalesDocumentItem

{
      //Key

  key Level1.InspectionDocument    as Level1Document,
      Level1.ReferenceDocumentItem as Level1DocumentItem,
      'INSP'                       as Level1DocumentCategory,

      Level0.SDDocumentCategory,
      Level0.CustomerReturnType,

      //Customer Return

      Level0.CustomerReturn,

      Level1.ProductIsInspectedAtCustSite,
      Level1.ReturnsDelivery,
      Level1.ReturnsDeliveryItem,
      //Organization

      Level0.SalesOrganization,
      Level0.DistributionChannel,
      Level0.OrganizationDivision,

      Level1.CustRetItmFollowUpActivity,
      
      ARMProcessExcuted.RetsMgmtProcItmQtySplit as RetsMgmtProcItmQtySplit

}
where
  (
        _CustomerReturnItem.RetsMgmtProcessingBlock = ''
    and Level1.IsDeleted                            = ''
    and Level1.ReturnsInspectionPublishStatus       = 'P' --- ARM Inspection Published
   
  )

Learn More