P_PaytReceiptCustomerVH

DDL: P_PAYTRECEIPTCUSTOMERVH SQL: PPAYTRECPTCUSTVH Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT

Payment Receipt Customer

P_PaytReceiptCustomerVH is a Composite CDS View that provides data about "Payment Receipt Customer" in SAP S/4HANA. It reads from 2 data sources (I_Customer, I_CustomerCompany) and exposes 7 fields with key fields CompanyCode, Customer. Part of development package GLO_FIN_PAYMENT_RECEIPT.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_Customer Customer inner
I_CustomerCompany CustomerCompany from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPAYTRECPTCUSTVH view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CustomerCompany CompanyCode
KEY Customer I_CustomerCompany Customer
CustomerFullName I_Customer CustomerFullName
CustomerName I_Customer CustomerName
BPCustomerFullName I_Customer BPCustomerFullName
BPCustomerName I_Customer BPCustomerName
CustomerUUID I_CustomerCompany Customer 
@AbapCatalog.sqlViewName: 'PPAYTRECPTCUSTVH'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@VDM.viewType: #COMPOSITE
@Search.searchable: true
define view P_PaytReceiptCustomerVH
  as select from I_CustomerCompany             as CustomerCompany
    inner join   I_Customer                    as Customer                    on CustomerCompany.Customer = Customer.Customer
//    inner join   kna1                          as Customer2                   on CustomerCompany.Customer = Customer2.kunnr

{
      @Search: {
          defaultSearchElement: true,
          ranking: #HIGH,
          fuzzinessThreshold: 0.7
      }
  key CustomerCompany.CompanyCode                                                                   as CompanyCode,
  key CustomerCompany.Customer                                                                      as Customer,
      Customer.CustomerFullName                                                                     as CustomerFullName,
      Customer.CustomerName                                                                         as CustomerName,
      Customer.BPCustomerFullName                                                                   as BPCustomerFullName,
      Customer.BPCustomerName                                                                       as BPCustomerName,
//      Customer2.ph_biz_style                                                                        as PH_BusinessStyleOfBPText,

      CustomerCompany.Customer                                                                      as CustomerUUID
}
where
  (
       CustomerCompany.IsBusinessPurposeCompleted is null
    or CustomerCompany.IsBusinessPurposeCompleted = ''
  )
  or(
       Customer.IsBusinessPurposeCompleted        is null
    or Customer.IsBusinessPurposeCompleted        = ''
  )

Learn More