I_BalanceAuditTrailCustomer

DDL: I_BALANCEAUDITTRAILCUSTOMER SQL: IFINS_BAT_CUSTOM Type: view BASIC Package: FINS_FIS_AUDIT

Customers for Balance Audit Trail

I_BalanceAuditTrailCustomer is a Basic CDS View that provides data about "Customers for Balance Audit Trail" in SAP S/4HANA. It reads from 2 data sources (kna1, knb1) and exposes 9 fields with key fields Customer, CompanyCode. Part of development package FINS_FIS_AUDIT.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
kna1 kna1 from
knb1 knb1 inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFINS_BAT_CUSTOM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Customers for Balance Audit Trail view
Search.searchable true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Customer kna1 kunnr
KEY CompanyCode knb1 bukrs
AuthorizationGroup kna1 begru
CustomerName kna1 name1
CustomerSearchText
CityName kna1 ort01
Country kna1 land1
StreetName kna1 stras
PostalCode kna1 pstlz 
@AbapCatalog.sqlViewName: 'IFINS_BAT_CUSTOM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Customers for Balance Audit Trail'
@Search.searchable: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_BalanceAuditTrailCustomer as select from kna1 
inner join knb1 on kna1.kunnr = knb1.kunnr {
@Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7}
    key kna1.kunnr as Customer,
    key knb1.bukrs as CompanyCode,
    kna1.begru as AuthorizationGroup,
    kna1.name1 as CustomerName,
    concat_with_space(kna1.mcod1, kna1.mcod3, 1) as CustomerSearchText,
    kna1.ort01 as CityName,
    kna1.land1 as Country,
    kna1.stras as StreetName,
    kna1.pstlz as PostalCode
}

Learn More