I_BalanceAuditTrailSupplier

DDL: I_BALANCEAUDITTRAILSUPPLIER SQL: IFINS_BAT_SUPL Type: view BASIC
9 Fields 2 Data Sources

Suppliers for Balance Audit Trail

I_BalanceAuditTrailSupplier is a Basic CDS View that provides data about "Suppliers for Balance Audit Trail" in SAP S/4HANA. It reads from 2 data sources (lfa1, lfb1) and exposes 9 fields with key fields Supplier, CompanyCode.

Data Sources (2)

SourceAliasJoin Type
lfa1 lfa1 from
lfb1 lfb1 inner

Annotations (11)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Supplier lfa1 lifnr Vendor no.
KEY CompanyCode lfb1 bukrs Value
AuthorizationGroup lfa1 begru AuthorizGroup
SupplierName lfa1 name1 PA text
SupplierSearchText
CityName lfa1 ort01 Province
Country lfa1 land1 Trip Ctry/Reg
StreetName lfa1 stras Street/House
PostalCode lfa1 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_BalanceAuditTrailSupplier.
-- 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_SUPL

CREATE VIEW I_BalanceAuditTrailSupplier AS
SELECT
  lfa1.lifnr AS Supplier,
  lfb1.bukrs AS CompanyCode,
  lfa1.begru AS AuthorizationGroup,
  lfa1.name1 AS SupplierName,
  concat_with_space(lfa1.mcod1, lfa1.mcod3, 1) AS SupplierSearchText,
  lfa1.ort01 AS CityName,
  lfa1.land1 AS Country,
  lfa1.stras AS StreetName,
  lfa1.pstlz AS PostalCode
FROM lfa1
INNER JOIN lfb1 ON /* join condition not captured in parsed metadata */
;

Learn More