I_BalanceAuditTrailCustomer

DDL: I_BALANCEAUDITTRAILCUSTOMER SQL: IFINS_BAT_CUSTOM Type: view BASIC
9 Fields 2 Data Sources

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.

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 Stock customer
KEY CompanyCode knb1 bukrs Value
AuthorizationGroup kna1 begru AuthorizGroup
CustomerName kna1 name1 PA text
CustomerSearchText
CityName kna1 ort01 Province
Country kna1 land1 Trip Ctry/Reg
StreetName kna1 stras Street/House
PostalCode kna1 pstlz Postal Code

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BalanceAuditTrailCustomer.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFINS_BAT_CUSTOM

CREATE VIEW I_BalanceAuditTrailCustomer AS
SELECT
  kna1.kunnr AS Customer,
  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
FROM kna1
INNER JOIN knb1 ON /* join condition not captured in parsed metadata */
;

Learn More