R_MatlPriceSpclStockValnStrgy

DDL: R_MATLPRICESPCLSTOCKVALNSTRGY SQL: RMPSSVSTRGY Type: view COMPOSITE Package: FINS_ML_DB
13 Fields 2 Data Sources

Mat Price Spec Stock Valuation Strategy

R_MatlPriceSpclStockValnStrgy is a Composite CDS View that provides data about "Mat Price Spec Stock Valuation Strategy" in SAP S/4HANA. It reads from 2 data sources (I_MaterialLedgerPrice, t001w) and exposes 13 fields with key fields CostEstimate, CurrencyRole, Ledger. Part of development package FINS_ML_DB.

Data Sources (2)

SourceAliasJoin Type
I_MaterialLedgerPrice fmltp from
t001w plant inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName RMPSSVSTRGY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Mat Price Spec Stock Valuation Strategy view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate I_MaterialLedgerPrice CostEstimate Cost EstimateNo
KEY CurrencyRole I_MaterialLedgerPrice CurrencyRole Curr./Val. Type
KEY Ledger I_MaterialLedgerPrice Ledger Ledger
MatlPrcValdtyEndFsclYearPeriod I_MaterialLedgerPrice MatlPrcValdtyEndFsclYearPeriod
Material I_MaterialLedgerPrice Material Vehicle Model
ValuationArea I_MaterialLedgerPrice ValuationArea Valuation Area
ValuationType I_MaterialLedgerPrice InventoryValuationType Valuation Type
Plant t001w werks Receiving Plant
SalesOrder I_MaterialLedgerPrice SalesOrder SD Document
SalesOrderItem I_MaterialLedgerPrice SalesOrderItem Sales Order Item
WBSElementInternalID
MaterialPriceType I_MaterialLedgerPrice MaterialPriceType Price Type
CurPlanProjSlsOrdValnStrategy I_MaterialLedgerPrice CurPlanProjSlsOrdValnStrategy

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_MatlPriceSpclStockValnStrgy.
-- 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: RMPSSVSTRGY

CREATE VIEW R_MatlPriceSpclStockValnStrgy AS
SELECT
  fmltp.CostEstimate AS CostEstimate,
  fmltp.CurrencyRole AS CurrencyRole,
  fmltp.Ledger AS Ledger,
  fmltp.MatlPrcValdtyEndFsclYearPeriod AS MatlPrcValdtyEndFsclYearPeriod,
  fmltp.Material AS Material,
  fmltp.ValuationArea AS ValuationArea,
  fmltp.InventoryValuationType AS ValuationType,
  plant.werks AS Plant,
  fmltp.SalesOrder AS SalesOrder,
  fmltp.SalesOrderItem AS SalesOrderItem,
  cast ( fmltp.WBSElementInternalID as ps_psp_pnr_core ) AS WBSElementInternalID,
  fmltp.MaterialPriceType AS MaterialPriceType,
  fmltp.CurPlanProjSlsOrdValnStrategy AS CurPlanProjSlsOrdValnStrategy
FROM I_MaterialLedgerPrice AS fmltp
INNER JOIN t001w AS plant ON /* join condition not captured in parsed metadata */
;

Learn More