P_CustRetProcFlow22

DDL: P_CUSTRETPROCFLOW22 SQL: PCUSTRETPROCF22 Type: view CONSUMPTION

P_CustRetProcFlow22 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_CustRetProcFlow05, P_CustRetProcFlow10) and exposes 12 fields with key fields Level2Document, Level2DocumentItem, Level1Document, Level1DocumentItem.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
P_CustRetProcFlow05 InspectionDoc inner
P_CustRetProcFlow10 Level1 from

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
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PCUSTRETPROCF22 view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Level2Document
KEY Level2DocumentItem P_CustRetProcFlow05 Level1DocumentItem
KEY Level1Document P_CustRetProcFlow10 Level1Document
KEY Level1DocumentItem P_CustRetProcFlow10 Level1DocumentItem
CustomerReturn P_CustRetProcFlow10 CustomerReturn
CustomerReturnType P_CustRetProcFlow10 CustomerReturnType
Level2DocumentCategory P_CustRetProcFlow05 Level1DocumentCategory
Level1DocumentCategory P_CustRetProcFlow10 Level1DocumentCategory
SalesOrganization P_CustRetProcFlow10 SalesOrganization
DistributionChannel P_CustRetProcFlow10 DistributionChannel
OrganizationDivision P_CustRetProcFlow10 OrganizationDivision
BillingDocumentIsRequired 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

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

define view P_CustRetProcFlow22
  as select from P_CustRetProcFlow10 as Level1
    inner join   P_CustRetProcFlow05 as InspectionDoc on  InspectionDoc.CustomerReturn     = Level1.CustomerReturn
                                                      and InspectionDoc.Level1DocumentItem = Level1.PrecedingDocumentItem

{
      //Key

  key cast(InspectionDoc.Level1Document as preced_doc) as Level2Document,
  key InspectionDoc.Level1DocumentItem                 as Level2DocumentItem,
  key Level1.Level1Document,
  key Level1.Level1DocumentItem,

      //Customer Return

      Level1.CustomerReturn,

      //Category

      Level1.CustomerReturnType,

      InspectionDoc.Level1DocumentCategory             as Level2DocumentCategory,
      Level1.Level1DocumentCategory,

      //Organization

      Level1.SalesOrganization,
      Level1.DistributionChannel,
      Level1.OrganizationDivision,

      //Relevance for planned subsequent processing

      ''                                               as BillingDocumentIsRequired
}
where
  Level1.Level1DocumentCategory = 'T'

Learn More