I_RU_FinStmntRptgItems

DDL: I_RU_FINSTMNTRPTGITEMS SQL: IRUFSTMRPTGITEMS Type: view BASIC
18 Fields 1 Data Sources

Storage for Financial Statement (ACR)

I_RU_FinStmntRptgItems is a Basic CDS View that provides data about "Storage for Financial Statement (ACR)" in SAP S/4HANA. It reads from 1 data source (firud_fstm_rpitm) and exposes 18 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, FinancialStatementFormType, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
firud_fstm_rpitm firud_fstm_rpitm from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IRUFSTMRPTGITEMS view
VDM.viewType #BASIC view
EndUserText.label Storage for Financial Statement (ACR) view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity firud_fstm_rpitm statryrptgentity Reporting Entity
KEY StatryRptCategory firud_fstm_rpitm statryrptcategory Report ID
KEY StatryRptRunID firud_fstm_rpitm statryrptrunid Report Run ID
KEY FinancialStatementFormType firud_fstm_rpitm formcode FS Version
KEY CompanyCode firud_fstm_rpitm companycode Receiver Company Code
KEY AccountingDocument firud_fstm_rpitm accountingdocument Journal Entry
KEY FiscalYear firud_fstm_rpitm fiscalyear G/L Fiscal Year
KEY FinancialStatementLeafItem firud_fstm_rpitm financialstatementleafitem Node
KEY LedgerGLLineItem firud_fstm_rpitm ledgergllineitem Journal Entry Item
KEY InvoiceNumber firud_fstm_rpitm invoicenumber Invoice Number
KEY InvoiceYear firud_fstm_rpitm invoiceyear Orig.Inv.Year
PeriodBalAmtInDspCrcy firud_fstm_rpitm periodbalamt PerBalAmt
YearlyBalAmtInDspCrcy firud_fstm_rpitm yearopeningbalamt PerBalAmt
StartingBalAmtInDspCrcy firud_fstm_rpitm openingperiodbalamt PerBalAmt
EndingBalAmtInDspCrcy firud_fstm_rpitm endingperiodbalamt PerBalAmt
CreditAmountInDisplayCrcy firud_fstm_rpitm creditperiodbalamt PerBalAmt
DebitAmountInDisplayCrcy firud_fstm_rpitm debitperiodbalamt PerBalAmt
Currency firud_fstm_rpitm currency Valuation Crcy

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_FinStmntRptgItems.
-- 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: IRUFSTMRPTGITEMS

CREATE VIEW I_RU_FinStmntRptgItems AS
SELECT
  firud_fstm_rpitm.statryrptgentity AS StatryRptgEntity,
  firud_fstm_rpitm.statryrptcategory AS StatryRptCategory,
  firud_fstm_rpitm.statryrptrunid AS StatryRptRunID,
  firud_fstm_rpitm.formcode AS FinancialStatementFormType,
  firud_fstm_rpitm.companycode AS CompanyCode,
  firud_fstm_rpitm.accountingdocument AS AccountingDocument,
  firud_fstm_rpitm.fiscalyear AS FiscalYear,
  firud_fstm_rpitm.financialstatementleafitem AS FinancialStatementLeafItem,
  firud_fstm_rpitm.ledgergllineitem AS LedgerGLLineItem,
  firud_fstm_rpitm.invoicenumber AS InvoiceNumber,
  firud_fstm_rpitm.invoiceyear AS InvoiceYear,
  firud_fstm_rpitm.periodbalamt AS PeriodBalAmtInDspCrcy,
  firud_fstm_rpitm.yearopeningbalamt AS YearlyBalAmtInDspCrcy,
  firud_fstm_rpitm.openingperiodbalamt AS StartingBalAmtInDspCrcy,
  firud_fstm_rpitm.endingperiodbalamt AS EndingBalAmtInDspCrcy,
  firud_fstm_rpitm.creditperiodbalamt AS CreditAmountInDisplayCrcy,
  firud_fstm_rpitm.debitperiodbalamt AS DebitAmountInDisplayCrcy,
  firud_fstm_rpitm.currency AS Currency
FROM firud_fstm_rpitm
;

Learn More