P_CN_CADESupplier

DDL: P_CN_CADESUPPLIER SQL: PCNCADESUPPLIER Type: view CONSUMPTION Package: GLO_FIN_CADE_CN

CADE Supplier

P_CN_CADESupplier is a Consumption CDS View that provides data about "CADE Supplier" in SAP S/4HANA. It reads from 2 data sources (I_Supplier, I_SupplierCompany) and exposes 8 fields with key fields CompanyCode, Supplier. Part of development package GLO_FIN_CADE_CN.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_Supplier Supplier inner
I_SupplierCompany SupplierCompany from

Annotations (7)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PCNCADESUPPLIER 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 (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SupplierCompany CompanyCode
KEY Supplier
BusinessPartner
PersonNumber
AuthorizationGroup I_Supplier AuthorizationGroup
AddressID I_Supplier AddressID
SupplierName I_Supplier SortField
SupplierFullName 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PCNCADESUPPLIER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_CN_CADESupplier
  as select from I_SupplierCompany as SupplierCompany
    inner join   I_Supplier        as Supplier on Supplier.Supplier = SupplierCompany.Supplier
{
  key SupplierCompany.CompanyCode                                                             as CompanyCode,
  key ltrim(SupplierCompany.Supplier,'0')                                                     as Supplier,
      Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner                    as BusinessPartner,
      Supplier._SupplierToBusinessPartner._BusinessPartner.PersonNumber                       as PersonNumber,
      Supplier.AuthorizationGroup,
      Supplier.AddressID,
      Supplier.SortField                                                                      as SupplierName,
      concat(rtrim(Supplier.BusinessPartnerName1,' '),ltrim(Supplier.BusinessPartnerName2,' ')) as SupplierFullName

}
//where

//  (

//       SupplierCompany.IsBusinessPurposeCompleted is null

//    or SupplierCompany.IsBusinessPurposeCompleted = ''

//  )

//  or(

//       Supplier.IsBusinessPurposeCompleted        is null

//    or Supplier.IsBusinessPurposeCompleted        = ''

//  )

//

Learn More