I_MaterialInventoryValuation

DDL: I_MATERIALINVENTORYVALUATION SQL: IMATLINVTRYVAL Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Material Inventory for Valuation

I_MaterialInventoryValuation is a Basic CDS View that provides data about "Material Inventory for Valuation" in SAP S/4HANA. It reads from 1 data source (umip_xls_data) and exposes 8 fields with key fields CreatedByUser, BatchUUID, CostEstimate, LedgerValuationCurrencyRole, InventoryValuationType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
umip_xls_data umip_xls_data from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CurrentMaterialValuations _CurrentMaterialValuations _CurrentMaterialValuations.CostEstimate = $projection.CostEstimate and _CurrentMaterialValuations.LedgerValuationCurrencyRole = $projection.LedgerValuationCurrencyRole

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMATLINVTRYVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
EndUserText.label Material Inventory for Valuation view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CreatedByUser created_by Version Created By
KEY BatchUUID batch_id UUID
KEY CostEstimate kalnr ProdCostEst.No.
KEY LedgerValuationCurrencyRole curtp Valuation Area
KEY InventoryValuationType inventoryvaluationtype Valuation Type
NewInventoryPrice newinvprice New Price
NewMaterialPriceUnitQty newpeinh New Price Unit
_CurrentMaterialValuations _CurrentMaterialValuations

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_MaterialInventoryValuation.
-- 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: IMATLINVTRYVAL

CREATE VIEW I_MaterialInventoryValuation AS
SELECT
  created_by AS CreatedByUser,
  batch_id AS BatchUUID,
  kalnr AS CostEstimate,
  curtp AS LedgerValuationCurrencyRole,
  InventoryValuationType,
  newinvprice AS NewInventoryPrice,
  newpeinh AS NewMaterialPriceUnitQty
FROM umip_xls_data
LEFT OUTER JOIN I_CurrentMaterialValuations AS _CurrentMaterialValuations ON _CurrentMaterialValuations.CostEstimate = CostEstimate AND _CurrentMaterialValuations.LedgerValuationCurrencyRole = LedgerValuationCurrencyRole  -- association [1..1]
;

Learn More