I_RU_FinStmntAcctBalanceLog

DDL: I_RU_FINSTMNTACCTBALANCELOG SQL: IRUFSTMACCTBAL Type: view BASIC
20 Fields 1 Data Sources

ACR FinStmnt RU Accounting Balance Log

I_RU_FinStmntAcctBalanceLog is a Basic CDS View that provides data about "ACR FinStmnt RU Accounting Balance Log" in SAP S/4HANA. It reads from 1 data source (firud_fstm_acctb) and exposes 20 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, Ledger, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
firud_fstm_acctb AccountingBalance from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUFSTMACCTBAL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label ACR FinStmnt RU Accounting Balance Log view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity firud_fstm_acctb statryrptgentity Reporting Entity
KEY StatryRptCategory firud_fstm_acctb statryrptcategory Report ID
KEY StatryRptRunID firud_fstm_acctb statryrptrunid Report Run ID
KEY Ledger firud_fstm_acctb ledger Ledger
KEY CompanyCode firud_fstm_acctb companycode Receiver Company Code
KEY AccountingDocument firud_fstm_acctb accountingdocument Journal Entry
KEY LedgerGLLineItem firud_fstm_acctb ledgergllineitem Journal Entry Item
KEY FiscalYear firud_fstm_acctb fiscalyear G/L Fiscal Year
PostingDate firud_fstm_acctb postingdate Posting Date for GR
ChartOfAccounts firud_fstm_acctb chartofaccounts Node Class
TargetGLAccount firud_fstm_acctb targetglaccount G/L Account
GLAccount firud_fstm_acctb glaccount General Ledger
AlternativeGLAccount firud_fstm_acctb alternativeglaccount Group Account
Currency firud_fstm_acctb currency Valuation Crcy
PeriodBalAmtInDspCrcy firud_fstm_acctb periodbalamt PerBalAmt
YearlyBalAmtInDspCrcy firud_fstm_acctb yearopeningbalamt PerBalAmt
StartingBalAmtInDspCrcy firud_fstm_acctb openingperiodbalamt PerBalAmt
EndingBalAmtInDspCrcy firud_fstm_acctb endingperiodbalamt PerBalAmt
CreditAmountInDisplayCrcy firud_fstm_acctb creditperiodbalamt PerBalAmt
DebitAmountInDisplayCrcy firud_fstm_acctb debitperiodbalamt PerBalAmt

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_RU_FinStmntAcctBalanceLog.
-- 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: IRUFSTMACCTBAL

CREATE VIEW I_RU_FinStmntAcctBalanceLog AS
SELECT
  AccountingBalance.statryrptgentity AS StatryRptgEntity,
  AccountingBalance.statryrptcategory AS StatryRptCategory,
  AccountingBalance.statryrptrunid AS StatryRptRunID,
  AccountingBalance.ledger AS Ledger,
  AccountingBalance.companycode AS CompanyCode,
  AccountingBalance.accountingdocument AS AccountingDocument,
  AccountingBalance.ledgergllineitem AS LedgerGLLineItem,
  AccountingBalance.fiscalyear AS FiscalYear,
  AccountingBalance.postingdate AS PostingDate,
  AccountingBalance.chartofaccounts AS ChartOfAccounts,
  AccountingBalance.targetglaccount AS TargetGLAccount,
  AccountingBalance.glaccount AS GLAccount,
  AccountingBalance.alternativeglaccount AS AlternativeGLAccount,
  AccountingBalance.currency AS Currency,
  AccountingBalance.periodbalamt AS PeriodBalAmtInDspCrcy,
  AccountingBalance.yearopeningbalamt AS YearlyBalAmtInDspCrcy,
  AccountingBalance.openingperiodbalamt AS StartingBalAmtInDspCrcy,
  AccountingBalance.endingperiodbalamt AS EndingBalAmtInDspCrcy,
  AccountingBalance.creditperiodbalamt AS CreditAmountInDisplayCrcy,
  AccountingBalance.debitperiodbalamt AS DebitAmountInDisplayCrcy
FROM firud_fstm_acctb AS AccountingBalance
;

Learn More