P_RU_CustomerData1

DDL: P_RU_CUSTOMERDATA1 SQL: PRUCUSTOMERDATA1 Type: view COMPOSITE

P_RU_CustomerData1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 11 fields with key field Customer.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer Customer from

Annotations (7)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer
CustomerName I_Customer CustomerName
BusinessPartner
BusinessPartnerCategory
PersonNumber
IsNaturalPerson
AddressID I_Customer AddressID
Country I_Customer Country
IsOneTimeAccount I_Customer IsOneTimeAccount
AuthorizationGroup I_Customer AuthorizationGroup
_CustomerCompany I_Customer _CustomerCompany 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PRUCUSTOMERDATA1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_CustomerData1
  as select from I_Customer as Customer

{
  key Customer.Customer,
      Customer.CustomerName,
      Customer._CustomerToBusinessPartner[inner]._BusinessPartner[inner].BusinessPartner,
      Customer._CustomerToBusinessPartner[inner]._BusinessPartner[inner].BusinessPartnerCategory,
      Customer._CustomerToBusinessPartner[inner]._BusinessPartner[inner].PersonNumber,
      Customer._CustomerToBusinessPartner[inner]._BusinessPartner[inner].IsNaturalPerson,

      Customer.AddressID,
      Customer.Country,
      Customer.IsOneTimeAccount,
      Customer.AuthorizationGroup,
      Customer._CustomerCompany
}

Learn More