I_RU_FinStmntBalShtValnDoc

DDL: I_RU_FINSTMNTBALSHTVALNDOC SQL: IRUFSTMBSVDOC Type: view BASIC Package: GLO_FIN_IS_RU_FIN_STMNT
14 Fields 1 Data Sources

Log Table for Balance Sheet Valuation Documents

I_RU_FinStmntBalShtValnDoc is a Basic CDS View that provides data about "Log Table for Balance Sheet Valuation Documents" in SAP S/4HANA. It reads from 1 data source (firud_fstm_s_bsv) 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_bsv firud_fstm_s_bsv from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUFSTMBSVDOC 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 Balance Sheet Valuation Documents view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity firud_fstm_s_bsv statryrptgentity Reporting Entity
KEY StatryRptCategory firud_fstm_s_bsv statryrptcategory Report ID
KEY StatryRptRunID firud_fstm_s_bsv statryrptrunid Report Run ID
KEY CompanyCode firud_fstm_s_bsv companycode Receiver Company Code
KEY AccountingDocument firud_fstm_s_bsv accountingdocument Journal Entry
KEY FiscalYear firud_fstm_s_bsv fiscalyear G/L Fiscal Year
KEY AccountingDocumentItem firud_fstm_s_bsv accountingdocumentitem Posting View Item
Material firud_fstm_s_bsv material Vehicle Model
ValuationArea firud_fstm_s_bsv valuationarea Valuation Area
InventoryValuationType firud_fstm_s_bsv inventoryvaluationtype Valuation Type
Plant firud_fstm_s_bsv plant Valuation Area
TotalAmountInLocalCurrency firud_fstm_s_bsv totalamountinlocalcurrency RNPT Item Amount
Currency firud_fstm_s_bsv currency Valuation Crcy
PostingDate firud_fstm_s_bsv 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_FinStmntBalShtValnDoc.
-- 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: IRUFSTMBSVDOC

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

Learn More