P_CN_CADECustomer

DDL: P_CN_CADECUSTOMER SQL: PCNCADECUSTOMER Type: view CONSUMPTION Package: GLO_FIN_CADE_CN

CADE Customer

P_CN_CADECustomer is a Consumption CDS View that provides data about "CADE Customer" in SAP S/4HANA. It reads from 3 data sources (I_Customer, I_Customer_to_BusinessPartner, I_CustomerCompany) and exposes 7 fields with key fields CompanyCode, Customer. Part of development package GLO_FIN_CADE_CN.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_Customer Customer inner
I_Customer_to_BusinessPartner Customer_to_BusinessPartner inner
I_CustomerCompany CustomerCompany from

Annotations (7)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CustomerCompany CompanyCode
KEY Customer
BusinessPartner
PersonNumber
AuthorizationGroup I_Customer AuthorizationGroup
CustomerFullName
CustomerName 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PCNCADECUSTOMER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_CN_CADECustomer
  as select from I_CustomerCompany             as CustomerCompany

    inner join   I_Customer                    as Customer                    on CustomerCompany.Customer = Customer.Customer
    inner join   I_Customer_to_BusinessPartner as Customer_to_BusinessPartner on CustomerCompany.Customer = Customer_to_BusinessPartner.Customer


{
  key CustomerCompany.CompanyCode                                                               as CompanyCode,
  key ltrim(CustomerCompany.Customer,'0')                                                       as Customer,
      Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner                      as BusinessPartner,
      Customer._CustomerToBusinessPartner._BusinessPartner.PersonNumber                         as PersonNumber,
      Customer.AuthorizationGroup                                                               as AuthorizationGroup,
      concat(rtrim(Customer.BusinessPartnerName1,' '),ltrim(Customer.BusinessPartnerName2,' '))
                                                                                                as CustomerFullName,
      Customer._CustomerToBusinessPartner._BusinessPartner.SearchTerm1
                                                                                                as CustomerName


}
//where

//  (

//       CustomerCompany.IsBusinessPurposeCompleted is null

//    or CustomerCompany.IsBusinessPurposeCompleted = ''

//  )

//  or(

//       Customer.IsBusinessPurposeCompleted        is null

//    or Customer.IsBusinessPurposeCompleted        = ''

//  )

Learn More