I_BalanceAuditTrail

DDL: I_BALANCEAUDITTRAIL SQL: IFINS_BAT_ITEMS Type: view COMPOSITE Package: FINS_FIS_AUDIT
32 Fields 5 Data Sources

Line Items for Balance Audit Trail

I_BalanceAuditTrail is a Composite CDS View that provides data about "Line Items for Balance Audit Trail" in SAP S/4HANA. It reads from 5 data sources (I_CompanyCode, I_Customer, I_FiscalCalendarDate, I_OperationalAcctgDocItem, I_Supplier) and exposes 32 fields with key fields CompanyCode, AccountingDocument, FiscalYear, LedgerGLLineItem. Part of development package FINS_FIS_AUDIT.

Data Sources (5)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_Customer I_Customer left_outer
I_FiscalCalendarDate I_FiscalCalendarDate left_outer
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from
I_Supplier I_Supplier left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFINS_BAT_ITEMS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Line Items for Balance Audit Trail view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
FiscalPeriod I_OperationalAcctgDocItem FiscalPeriod Tax period
AccountingDocumentCategory
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
_Currency _Currency
Customer I_Customer Customer Sold-to Party
Supplier I_Supplier Supplier Supplier
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
ProfitCenter I_OperationalAcctgDocItem ProfitCenter Profit Center
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
ClearingCreationDate I_OperationalAcctgDocItem ClearingCreationDate Clrg Creation Date
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
TaxCode I_OperationalAcctgDocItem TaxCode Tax Code
AssignmentReference I_OperationalAcctgDocItem AssignmentReference Assignment Reference
DocumentItemText I_OperationalAcctgDocItem DocumentItemText Text
ClearingFiscalPeriod
ClearingFiscalYear
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
CustomerName
SupplierName
ChartOfAccounts I_CompanyCode ChartOfAccounts Node Class
IsOpenItemManaged I_OperationalAcctgDocItem IsOpenItemManaged Open Item Management
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
BaseUnit I_OperationalAcctgDocItem BaseUnit Unit of Measure
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type

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_BalanceAuditTrail.
-- 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_ITEMS

CREATE VIEW I_BalanceAuditTrail AS
SELECT
  I_CompanyCode.CompanyCode AS CompanyCode,
  I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  cast(I_OperationalAcctgDocItem.AccountingDocumentItem as fins_bat_posting_row preserving type) AS LedgerGLLineItem,
  I_OperationalAcctgDocItem.ClearingDate AS ClearingDate,
  I_OperationalAcctgDocItem.ClearingJournalEntry AS ClearingAccountingDocument,
  I_OperationalAcctgDocItem.FiscalPeriod AS FiscalPeriod,
  cast(I_OperationalAcctgDocItem.AccountingDocumentCategory as fins_bat_document_category preserving type) AS AccountingDocumentCategory,
  I_OperationalAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_Customer.Customer AS Customer,
  I_Supplier.Supplier AS Supplier,
  I_OperationalAcctgDocItem.GLAccount AS GLAccount,
  I_OperationalAcctgDocItem.DebitCreditCode AS DebitCreditCode,
  I_OperationalAcctgDocItem.ProfitCenter AS ProfitCenter,
  I_OperationalAcctgDocItem.PostingDate AS PostingDate,
  I_OperationalAcctgDocItem.ClearingCreationDate AS ClearingCreationDate,
  I_OperationalAcctgDocItem.FinancialAccountType AS FinancialAccountType,
  I_OperationalAcctgDocItem.TaxCode AS TaxCode,
  I_OperationalAcctgDocItem.AssignmentReference AS AssignmentReference,
  I_OperationalAcctgDocItem.DocumentItemText AS DocumentItemText,
  cast(I_FiscalCalendarDate.FiscalPeriod as fins_bat_clearing_period) AS ClearingFiscalPeriod,
  cast(I_FiscalCalendarDate.FiscalYear as fins_bat_clearing_fiscal_year) AS ClearingFiscalYear,
  I_CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(I_Customer.CustomerName as fins_bat_customer_name) AS CustomerName,
  cast(I_Supplier.SupplierName as fins_bat_supplier_name) AS SupplierName,
  I_CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  I_OperationalAcctgDocItem.IsOpenItemManaged AS IsOpenItemManaged,
  I_OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  I_OperationalAcctgDocItem.BaseUnit AS BaseUnit,
  I_OperationalAcctgDocItem.AccountingDocumentType AS AccountingDocumentType
FROM I_OperationalAcctgDocItem
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalCalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
;

Learn More