I_InvtryPrcByKeyDateUsdInLogs

DDL: I_INVTRYPRCBYKEYDATEUSDINLOGS Type: view_entity COMPOSITE Package: FINS_ML_VDM
30 Fields 1 Data Sources 2 Associations

Inventory Price By KeyDate For Logistics

I_InvtryPrcByKeyDateUsdInLogs is a Composite CDS View (Cube) that provides data about "Inventory Price By KeyDate For Logistics" in SAP S/4HANA. It reads from 1 data source (R_InventoryPriceByKeyDate) and exposes 30 fields with key field CostEstimate. It has 2 associations to related views. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
R_InventoryPriceByKeyDate R_InventoryPriceByKeyDate from

Parameters (1)

NameTypeDefault
P_CalendarDate calendardate

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CurrencyRole _CurrencyRole $projection.CurrencyRole = _CurrencyRole.CurrencyRole
[0..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Inventory Price By KeyDate For Logistics view
ObjectModel.representativeKey CostEstimate view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.technicalName IINVPRKEYDATELOGISTICS view
Analytics.internalName #LOCAL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
Ledger Ledger Ledger
CurrencyRole CurrencyRole Curr./Val. Type
FiscalPeriod FiscalPeriod Tax period
FiscalYear FiscalYear G/L Fiscal Year
FiscalYearPeriod FiscalYearPeriod Period/Year
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Supplier Supplier Supplier
WBSElementInternalID WBSElementInternalID WBS Internal ID
CompanyCode CompanyCode Receiver Company Code
BaseUnit BaseUnit Unit of Measure
InventorySpecialStockType InventorySpecialStockType Special Stock Type
MaterialPriceControl MaterialPriceControl Price Control
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
Currency Currency Valuation Crcy
InventoryPrice InventoryPrice Price
StandardPrice StandardPrice Standard price
ActualPrice ActualPrice
LedgerName LedgerName Ledger Name
CurrencyRoleName CurrencyRoleName
LegalCurrencyRole LegalCurrencyRole
LegalCurrencyRoleName LegalCurrencyRoleName
AccountingValuationView AccountingValuationView
AcctgValnVwSubviewCombinedName AcctgValnVwSubviewCombinedName
_Ledger _Ledger
_CurrencyRole _CurrencyRole

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_InvtryPrcByKeyDateUsdInLogs.
-- 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_CalendarDate : calendardate

CREATE VIEW I_InvtryPrcByKeyDateUsdInLogs AS
SELECT
  CostEstimate,
  Ledger,
  CurrencyRole,
  FiscalPeriod,
  FiscalYear,
  FiscalYearPeriod,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementInternalID,
  CompanyCode,
  BaseUnit,
  InventorySpecialStockType,
  MaterialPriceControl,
  MaterialPriceUnitQty,
  Currency,
  InventoryPrice,
  StandardPrice,
  ActualPrice,
  LedgerName,
  CurrencyRoleName,
  LegalCurrencyRole,
  LegalCurrencyRoleName,
  AccountingValuationView,
  AcctgValnVwSubviewCombinedName
FROM R_InventoryPriceByKeyDate
LEFT OUTER JOIN I_CurrencyRole AS _CurrencyRole ON CurrencyRole = _CurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;

Learn More