I_BR_Customer

DDL: I_BR_CUSTOMER SQL: IBRCUSTOMER Type: view BASIC

Brazil Customer Data

I_BR_Customer is a Basic CDS View that provides data about "Brazil Customer Data" in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 17 fields with key field Customer.

Data Sources (1)

SourceAliasJoin Type
kna1 Customer from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBRCUSTOMER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Brazil Customer Data view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Customer kna1 kunnr
Country kna1 land1
Name kna1 name1
BR_NFPartnerName2 kna1 name2
BR_NFPartnerName3 kna1 name3
BR_NFPartnerName4 kna1 name4
DataControllerSet kna1 xdcset
DataController1 kna1 data_ctrlr1
DataController2 kna1 data_ctrlr2
DataController3 kna1 data_ctrlr3
DataController4 kna1 data_ctrlr4
DataController5 kna1 data_ctrlr5
DataController6 kna1 data_ctrlr6
DataController7 kna1 data_ctrlr7
DataController8 kna1 data_ctrlr8
DataController9 kna1 data_ctrlr9
DataController10 kna1 data_ctrlr10
@AbapCatalog.sqlViewName: 'IBRCUSTOMER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Brazil Customer Data'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_BR_Customer 
  as select from kna1 as Customer {
    
  key Customer.kunnr as Customer,
  Customer.land1 as Country,
  Customer.name1 as Name,
  Customer.name2 as BR_NFPartnerName2,
  Customer.name3 as BR_NFPartnerName3,
  Customer.name4 as BR_NFPartnerName4,
  
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.xdcset as DataControllerSet,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr1 as DataController1,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr2 as DataController2,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr3 as DataController3,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr4 as DataController4,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr5 as DataController5,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr6 as DataController6,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr7 as DataController7,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr8 as DataController8,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr9 as DataController9,
  @UI.hidden: true
  @Consumption.hidden: true
  Customer.data_ctrlr10 as DataController10 
  
}