I_RU_FinStmntAccountingDoc

DDL: I_RU_FINSTMNTACCOUNTINGDOC SQL: IRUFSTMACCDOC Type: view BASIC Package: GLO_FIN_IS_RU_FIN_STMNT
14 Fields 1 Data Sources

Log Table for Accounting Documents

I_RU_FinStmntAccountingDoc is a Basic CDS View that provides data about "Log Table for Accounting Documents" in SAP S/4HANA. It reads from 1 data source (firud_fstm_s_fi) and exposes 14 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. Part of development package GLO_FIN_IS_RU_FIN_STMNT.

Data Sources (1)

SourceAliasJoin Type
firud_fstm_s_fi firud_fstm_s_fi from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUFSTMACCDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Log Table for Accounting Documents view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity firud_fstm_s_fi statryrptgentity Reporting Entity
KEY StatryRptCategory firud_fstm_s_fi statryrptcategory Report ID
KEY StatryRptRunID firud_fstm_s_fi statryrptrunid Report Run ID
KEY CompanyCode firud_fstm_s_fi companycode Receiver Company Code
KEY AccountingDocument firud_fstm_s_fi accountingdocument Journal Entry
KEY FiscalYear firud_fstm_s_fi fiscalyear G/L Fiscal Year
KEY AccountingDocumentItem firud_fstm_s_fi accountingdocumentitem Posting View Item
Material firud_fstm_s_fi material Vehicle Model
ValuationArea firud_fstm_s_fi valuationarea Valuation Area
InventoryValuationType firud_fstm_s_fi inventoryvaluationtype Valuation Type
Plant firud_fstm_s_fi plant Valuation Area
TotalAmountInLocalCurrency firud_fstm_s_fi totalamountinlocalcurrency RNPT Item Amount
Currency firud_fstm_s_fi currency Valuation Crcy
PostingDate firud_fstm_s_fi postingdate Posting Date for GR

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_FinStmntAccountingDoc.
-- 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: IRUFSTMACCDOC

CREATE VIEW I_RU_FinStmntAccountingDoc AS
SELECT
  firud_fstm_s_fi.statryrptgentity AS StatryRptgEntity,
  firud_fstm_s_fi.statryrptcategory AS StatryRptCategory,
  firud_fstm_s_fi.statryrptrunid AS StatryRptRunID,
  firud_fstm_s_fi.companycode AS CompanyCode,
  firud_fstm_s_fi.accountingdocument AS AccountingDocument,
  firud_fstm_s_fi.fiscalyear AS FiscalYear,
  firud_fstm_s_fi.accountingdocumentitem AS AccountingDocumentItem,
  firud_fstm_s_fi.material AS Material,
  firud_fstm_s_fi.valuationarea AS ValuationArea,
  firud_fstm_s_fi.inventoryvaluationtype AS InventoryValuationType,
  firud_fstm_s_fi.plant AS Plant,
  firud_fstm_s_fi.totalamountinlocalcurrency AS TotalAmountInLocalCurrency,
  firud_fstm_s_fi.currency AS Currency,
  firud_fstm_s_fi.postingdate AS PostingDate
FROM firud_fstm_s_fi
;

Learn More