P_INVPRICESMAXFIS

CDS View

select the unique costestimate

P_INVPRICESMAXFIS is a CDS View in S/4HANA. select the unique costestimate. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InvtryPrcBasicByKeyDate view from COMPOSITE Basic view to display inventory Price at a specific date. 
@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