R_MatlValnEndgInvtryByFsclPerd

DDL: R_MATLVALNENDGINVTRYBYFSCLPERD Type: view_entity COMPOSITE Package: FINS_ML_VDM
19 Fields 1 Data Sources

Ending Invtry Qty and Amount by Perd

R_MatlValnEndgInvtryByFsclPerd is a Composite CDS View that provides data about "Ending Invtry Qty and Amount by Perd" in SAP S/4HANA. It reads from 1 data source (R_MatlValnInvtryPerFsclPerd) and exposes 19 fields with key fields Ledger, CompanyCode, CostEstimate. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
R_MatlValnInvtryPerFsclPerd m from

Parameters (2)

NameTypeDefault
P_FiscalPeriod poper
P_FiscalYear gjahr

Annotations (8)

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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Ledger R_MatlValnInvtryPerFsclPerd Ledger Ledger
KEY CompanyCode R_MatlValnInvtryPerFsclPerd CompanyCode Receiver Company Code
KEY CostEstimate R_MatlValnInvtryPerFsclPerd CostEstimate Cost EstimateNo
Material R_MatlValnInvtryPerFsclPerd Material Vehicle Model
ValuationType R_MatlValnInvtryPerFsclPerd InventoryValuationType Valuation Type
ValuationArea R_MatlValnInvtryPerFsclPerd ValuationArea Valuation Area
InvtryValnSpecialStockType R_MatlValnInvtryPerFsclPerd InvtryValnSpecialStockType
SalesOrder R_MatlValnInvtryPerFsclPerd SalesOrder SD Document
SalesOrderItem R_MatlValnInvtryPerFsclPerd SalesOrderItem Sales Order Item
Supplier R_MatlValnInvtryPerFsclPerd Supplier Supplier
WBSElementInternalID R_MatlValnInvtryPerFsclPerd WBSElementInternalID WBS Internal ID
ValuationQuantity
UnitOfMeasure R_MatlValnInvtryPerFsclPerd UnitOfMeasure Unit Protected Qty
CompanyCodeCurrency R_MatlValnInvtryPerFsclPerd CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency
GlobalCurrency R_MatlValnInvtryPerFsclPerd GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency
FreeDefinedCurrency1 R_MatlValnInvtryPerFsclPerd FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1

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_MatlValnEndgInvtryByFsclPerd.
-- 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_FiscalPeriod : poper, P_FiscalYear : gjahr

CREATE VIEW R_MatlValnEndgInvtryByFsclPerd AS
SELECT
  m.Ledger AS Ledger,
  m.CompanyCode AS CompanyCode,
  m.CostEstimate AS CostEstimate,
  m.Material AS Material,
  m.InventoryValuationType AS ValuationType,
  m.ValuationArea AS ValuationArea,
  m.InvtryValnSpecialStockType AS InvtryValnSpecialStockType,
  m.SalesOrder AS SalesOrder,
  m.SalesOrderItem AS SalesOrderItem,
  m.Supplier AS Supplier,
  m.WBSElementInternalID AS WBSElementInternalID,
  cast(sum(m.ValuationQuantity) as fis_vquan1_12) AS ValuationQuantity,
  m.UnitOfMeasure AS UnitOfMeasure,
  m.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(sum( m.AmountInCompanyCodeCurrency ) as fis_hsl) AS AmountInCompanyCodeCurrency,
  m.GlobalCurrency AS GlobalCurrency,
  cast(sum( m.AmountInGlobalCurrency ) as fis_ksl) AS AmountInGlobalCurrency,
  m.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  cast(sum( m.AmountInFreeDefinedCurrency1 ) as fis_osl) AS AmountInFreeDefinedCurrency1
FROM R_MatlValnInvtryPerFsclPerd AS m
;

Learn More