I_InvtryPrcBasicByKeyDate

DDL: I_INVTRYPRCBASICBYKEYDATE SQL: IINVENPRCBYDATE Type: view COMPOSITE
5 Fields 1 Data Sources

Basic view to display inventory Price at a specific date.

I_InvtryPrcBasicByKeyDate is a Composite CDS View that provides data about "Basic view to display inventory Price at a specific date." in SAP S/4HANA. It reads from 1 data source (P_InvPricesMaxFis) and exposes 5 fields with key field CostEstimate.

Data Sources (1)

SourceAliasJoin Type
P_InvPricesMaxFis P_InvPricesMaxFis from

Parameters (1)

NameTypeDefault
P_CalendarDate calendardate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINVENPRCBYDATE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Basic view to display inventory Price at a specific date. view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
ValuationArea ValuationArea Valuation Area
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
Currency Currency Valuation Crcy
InventoryPrice InventoryPrice Price

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_InvtryPrcBasicByKeyDate.
-- 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: IINVENPRCBYDATE
-- Parameters: P_CalendarDate : calendardate

CREATE VIEW I_InvtryPrcBasicByKeyDate AS
SELECT
  CostEstimate,
  ValuationArea,
  MaterialPriceUnitQty,
  Currency,
  InventoryPrice
FROM P_InvPricesMaxFis
;

Learn More