I_RU_FinStmntStockValuation

DDL: I_RU_FINSTMNTSTOCKVALUATION SQL: IRUFSTMMATVAL Type: view BASIC
12 Fields 1 Data Sources

Log Table for Stock Valuation

I_RU_FinStmntStockValuation is a Basic CDS View that provides data about "Log Table for Stock Valuation" in SAP S/4HANA. It reads from 1 data source (firud_fstm_smval) and exposes 12 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, Material, ValuationArea.

Data Sources (1)

SourceAliasJoin Type
firud_fstm_smval firud_fstm_smval from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUFSTMMATVAL 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 Stock Valuation view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity firud_fstm_smval statryrptgentity Reporting Entity
KEY StatryRptCategory firud_fstm_smval statryrptcategory Report ID
KEY StatryRptRunID firud_fstm_smval statryrptrunid Report Run ID
KEY Material firud_fstm_smval material Vehicle Model
KEY ValuationArea firud_fstm_smval valuationarea Valuation Area
KEY InventoryValuationType firud_fstm_smval inventoryvaluationtype Valuation Type
TotalValStockQuantity firud_fstm_smval totalvalstockquantity Total Stock
MaterialBaseUnit firud_fstm_smval materialbaseunit Valuation Unit
StockValueInCCCrcy firud_fstm_smval stockvalueincccrcy Total Value
Currency firud_fstm_smval currency Valuation Crcy
MaterialValuationClass firud_fstm_smval materialvaluationclass Valuation Class
DebitGLAccount firud_fstm_smval debitglaccount G/L Account

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_FinStmntStockValuation.
-- 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: IRUFSTMMATVAL

CREATE VIEW I_RU_FinStmntStockValuation AS
SELECT
  firud_fstm_smval.statryrptgentity AS StatryRptgEntity,
  firud_fstm_smval.statryrptcategory AS StatryRptCategory,
  firud_fstm_smval.statryrptrunid AS StatryRptRunID,
  firud_fstm_smval.material AS Material,
  firud_fstm_smval.valuationarea AS ValuationArea,
  firud_fstm_smval.inventoryvaluationtype AS InventoryValuationType,
  firud_fstm_smval.totalvalstockquantity AS TotalValStockQuantity,
  firud_fstm_smval.materialbaseunit AS MaterialBaseUnit,
  firud_fstm_smval.stockvalueincccrcy AS StockValueInCCCrcy,
  firud_fstm_smval.currency AS Currency,
  firud_fstm_smval.materialvaluationclass AS MaterialValuationClass,
  firud_fstm_smval.debitglaccount AS DebitGLAccount
FROM firud_fstm_smval
;

Learn More