I_InventoryPriceByKeyDate

DDL: I_INVENTORYPRICEBYKEYDATE SQL: IINVPRKEYDATE Type: view COMPOSITE

Inventory Price By KeyDate

I_InventoryPriceByKeyDate is a Composite CDS View (Cube) that provides data about "Inventory Price By KeyDate" in SAP S/4HANA. It reads from 1 data source (P_InventoryPriceByKeydate) and exposes 30 fields with key fields CostEstimate, CurrencyRole. It has 2 associations to related views.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
P_InventoryPriceByKeydate P_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
AbapCatalog.sqlViewName IINVPRKEYDATE view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inventory Price By KeyDate view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CostEstimate view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate
KEY CurrencyRole CurrencyRole
Ledger Ledger
FiscalPeriod FiscalPeriod
FiscalYear FiscalYear
Material Material
ValuationArea ValuationArea
InventoryValuationType InventoryValuationType
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
Supplier Supplier
WBSElementInternalID WBSElementInternalID
CompanyCode CompanyCode
BaseUnit BaseUnit
InventorySpecialStockType InventorySpecialStockType
MaterialPriceControl MaterialPriceControl
MaterialPriceUnitQty MaterialPriceUnitQty
Currency Currency
InventoryPrice InventoryPrice
StandardPrice StandardPrice
ActualPrice ActualPrice
LedgerName LedgerName
CurrencyRoleName CurrencyRoleName
LegalCurrencyRole LegalCurrencyRole
LegalCurrencyRoleName LegalCurrencyRoleName
AccountingValuationView AccountingValuationView
AcctgValnVwSubviewCombinedName AcctgValnVwSubviewCombinedName
LedgerValnCrcyRoleIsUsedInLogs LedgerValnCrcyRoleIsUsedInLogs
_Ledger _Ledger
_CurrencyRole _CurrencyRole 
@AbapCatalog.sqlViewName: 'IINVPRKEYDATE'
@VDM.viewType: #COMPOSITE
@Analytics: { dataCategory: #CUBE }
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inventory Price By KeyDate'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel: { modelingPattern: #ANALYTICAL_CUBE,
                supportedCapabilities: [#ANALYTICAL_PROVIDER,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE ] }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.representativeKey: 'CostEstimate'

define view I_InventoryPriceByKeyDate
  with parameters
    P_CalendarDate : calendardate



  as select from P_InventoryPriceByKeydate(P_CalendarDate : $parameters.P_CalendarDate) as it
  association [0..1] to I_CurrencyRole as _CurrencyRole on $projection.CurrencyRole = _CurrencyRole.CurrencyRole
  association [0..1] to I_Ledger       as _Ledger       on $projection.Ledger = _Ledger.Ledger

{

  key   CostEstimate,
        @Analytics.internalName: #LOCAL
        @ObjectModel.foreignKey.association: '_CurrencyRole'
  key   CurrencyRole,
        @ObjectModel.foreignKey.association: '_Ledger'
        Ledger,
        FiscalPeriod,
        FiscalYear,
        Material,
        ValuationArea,
        InventoryValuationType,
        SalesOrder,
        SalesOrderItem,
        Supplier,
        WBSElementInternalID,
        CompanyCode,
        BaseUnit,
        InventorySpecialStockType,
        MaterialPriceControl,
        @Semantics.quantity.unitOfMeasure: 'BaseUnit'
        MaterialPriceUnitQty,
        Currency,
        @Semantics.amount.currencyCode:'Currency'
        InventoryPrice,
        @Semantics.amount.currencyCode:'Currency'
        StandardPrice,
        @Semantics.amount.currencyCode:'Currency'
        ActualPrice,        
        LedgerName,
        CurrencyRoleName,
        LegalCurrencyRole,
        LegalCurrencyRoleName,
        AccountingValuationView,
        AcctgValnVwSubviewCombinedName,
        @Semantics.booleanIndicator: true
        LedgerValnCrcyRoleIsUsedInLogs,

        @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
        _Ledger,
        _CurrencyRole
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_INVENTORYPRICEBYKEYDATE"
],
"ASSOCIATED":
[
"I_CURRENCYROLE",
"I_LEDGER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More