R_MatlValnEndgInvtryByKeyDate

DDL: R_MATLVALNENDGINVTRYBYKEYDATE Type: view_entity COMPOSITE Package: FINS_ML_VDM
16 Fields 2 Data Sources

Ending Invtry Qty and Amount by Date

R_MatlValnEndgInvtryByKeyDate is a Composite CDS View that provides data about "Ending Invtry Qty and Amount by Date" in SAP S/4HANA. It reads from 2 data sources (R_MatlLdgrCrcyTypeMappg, I_GLAccountLineItemRawData) and exposes 16 fields with key fields CompanyCode, CostEstimate, Ledger, CurrencyRole. Part of development package FINS_ML_VDM.

Data Sources (2)

SourceAliasJoin Type
R_MatlLdgrCrcyTypeMappg c inner
I_GLAccountLineItemRawData m from

Parameters (1)

NameTypeDefault
P_ValidOnDate fml_date_valid_on

Annotations (8)

NameValueLevelField
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Ending Invtry Qty and Amount by Date view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY CostEstimate I_GLAccountLineItemRawData CostEstimate Cost EstimateNo
KEY Ledger I_GLAccountLineItemRawData SourceLedger Source Ledger
KEY CurrencyRole R_MatlLdgrCrcyTypeMappg CurrencyRole Curr./Val. Type
Material I_GLAccountLineItemRawData Product Product Sold
ValuationType I_GLAccountLineItemRawData InventoryValuationType Valuation Type
ValuationArea I_GLAccountLineItemRawData ValuationArea Valuation Area
SalesOrder I_GLAccountLineItemRawData InventorySpclStkSalesDocument
SalesOrderItem I_GLAccountLineItemRawData InventorySpclStkSalesDocItm
Supplier I_GLAccountLineItemRawData InventorySpecialStockSupplier Vendor of Inv.
InvtryValnSpecialStockType I_GLAccountLineItemRawData InventorySpecialStockType Special Stock Type
Currency R_MatlLdgrCrcyTypeMappg Currency Valuation Crcy
ValidOnDate
WBSElementInternalID I_GLAccountLineItemRawData InvtrySpclStockWBSElmntIntID
ValuationQuantity
UnitOfMeasure I_GLAccountLineItemRawData CostSourceUnit Valuation UoM

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 R_MatlValnEndgInvtryByKeyDate.
-- 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.
-- Parameters: P_ValidOnDate : fml_date_valid_on

CREATE VIEW R_MatlValnEndgInvtryByKeyDate AS
SELECT
  m.CompanyCode AS CompanyCode,
  m.CostEstimate AS CostEstimate,
  m.SourceLedger AS Ledger,
  c.CurrencyRole AS CurrencyRole,
  m.Product AS Material,
  m.InventoryValuationType AS ValuationType,
  m.ValuationArea AS ValuationArea,
  m.InventorySpclStkSalesDocument AS SalesOrder,
  m.InventorySpclStkSalesDocItm AS SalesOrderItem,
  m.InventorySpecialStockSupplier AS Supplier,
  m.InventorySpecialStockType AS InvtryValnSpecialStockType,
  c.Currency AS Currency,
  $parameters.P_ValidOnDate AS ValidOnDate,
  m.InvtrySpclStockWBSElmntIntID AS WBSElementInternalID,
  sum(m.ValuationQuantity) AS ValuationQuantity,
  m.CostSourceUnit AS UnitOfMeasure
FROM I_GLAccountLineItemRawData AS m
INNER JOIN R_MatlLdgrCrcyTypeMappg AS c ON /* join condition not captured in parsed metadata */
;

Learn More