P_CustRetProcFlow32

DDL: P_CUSTRETPROCFLOW32 SQL: PCUSTRETPROCF32 Type: view CONSUMPTION

P_CustRetProcFlow32 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_CustRetProcFlow05) and exposes 14 fields with key fields Level0Document, Level0DocumentItem.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
P_CustRetProcFlow05 Level0 from

Annotations (7)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Level0Document P_CustRetProcFlow05 Level1Document
KEY Level0DocumentItem P_CustRetProcFlow05 Level1DocumentItem
Level0DocumentCategory P_CustRetProcFlow05 Level1DocumentCategory
RetsMgmtProcItmQtySplit Level1 RetsMgmtProcItmQtySplit
Level1Document Level1 Level1Document
Level1DocumentItem Level1 Level1DocumentItem
Level1DocumentCategory Level1 Level1DocumentCategory
CustomerReturn P_CustRetProcFlow05 CustomerReturn
CustomerReturnType P_CustRetProcFlow05 CustomerReturnType
CustomerReturnItem Level1 CustomerReturnItem
SalesOrganization P_CustRetProcFlow05 SalesOrganization
DistributionChannel P_CustRetProcFlow05 DistributionChannel
OrganizationDivision P_CustRetProcFlow05 OrganizationDivision
CustRetItmFollowUpActivity P_CustRetProcFlow05 CustRetItmFollowUpActivity 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PCUSTRETPROCF32'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION

define view P_CustRetProcFlow32
  as select from            P_CustRetProcFlow05 as Level0
    left outer to many join P_CustRetProcFlow06 as Level1 on  Level0.CustomerReturn     = Level1.CustomerReturn
                                                          and Level0.Level1DocumentItem = Level1.CustomerReturnItem
                                                          and Level0.RetsMgmtProcItmQtySplit = Level1.RetsMgmtProcItmQtySplit

{
  key Level0.Level1Document         as Level0Document,
  key Level0.Level1DocumentItem     as Level0DocumentItem,
      Level0.Level1DocumentCategory as Level0DocumentCategory,
      
      Level1.RetsMgmtProcItmQtySplit,

      Level1.Level1Document,
      Level1.Level1DocumentItem,
      Level1.Level1DocumentCategory,

      Level0.CustomerReturn,
      Level0.CustomerReturnType,
      Level1.CustomerReturnItem,
      
      //Organization

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

      Level0.CustRetItmFollowUpActivity
}

Learn More