P_InvPricesMaxFis

DDL: P_INVPRICESMAXFIS SQL: PINVPRMAXFIS Type: view COMPOSITE Package: FINS_ML_VDM

select the unique costestimate

P_InvPricesMaxFis is a Composite CDS View that provides data about "select the unique costestimate" in SAP S/4HANA. It reads from 2 data sources (I_MatlLedgerValnCrcyRoleName, I_MaterialLedgerPrice) and exposes 5 fields with key field CostEstimate. Part of development package FINS_ML_VDM.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_MatlLedgerValnCrcyRoleName lcurtp inner
I_MaterialLedgerPrice price from

Parameters (1)

NameTypeDefault
P_CalendarDate calendardate

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PINVPRMAXFIS view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate I_MaterialLedgerPrice CostEstimate
ValuationArea I_MaterialLedgerPrice ValuationArea
InventoryPrice I_MaterialLedgerPrice MaterialPrice
Currency I_MaterialLedgerPrice Currency
MaterialPriceUnitQty I_MaterialLedgerPrice MaterialPriceUnitQty 
@AbapCatalog.sqlViewName: 'PINVPRMAXFIS'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true 
define view P_InvPricesMaxFis

  with parameters
    P_CalendarDate : calendardate

  as select from I_MaterialLedgerPrice        as price
  inner join I_MatlLedgerValnCrcyRoleName     as lcurtp     on lcurtp.CompanyCode  = price.CompanyCode
                                                           and lcurtp.CurrencyRole = price.CurrencyRole
                                                           and lcurtp.Ledger       = price.Ledger
                                                           and lcurtp.LedgerValnCrcyRoleIsUsedInLogs = 'X'
{
  key price.CostEstimate,
      price.ValuationArea,
      price.MaterialPrice as InventoryPrice,
      price.Currency,
      price.MaterialPriceUnitQty
}
where  
       price.MaterialPriceType = 'INVPR'
   and price.MaterialPriceSubtype = ' '
   and price.MaterialPriceValidityStartDate <= :P_CalendarDate
   and price.MaterialPriceValidityEndDate   >= :P_CalendarDate

Learn More