P_CURMATLVALNPRICE_PR

DDL: P_CURMATLVALNPRICE_PR SQL: PCURMVPRICEPR Type: view BASIC Package: FINS_ML_PRODUCT_MASTER_API

Material Ledger Prices CKMLCR with Header Information

P_CURMATLVALNPRICE_PR is a Basic CDS View that provides data about "Material Ledger Prices CKMLCR with Header Information" in SAP S/4HANA. It reads from 1 data source (ckmlpr) and exposes 12 fields with key fields CostEstimate, CurrencyRole. Part of development package FINS_ML_PRODUCT_MASTER_API.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
ckmlpr pr from

Annotations (7)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate ckmlpr kalnr
KEY CurrencyRole ckmlpr curtp
Ledger
FuturePrice ckmlpr zkprs
FuturePriceValidityStartDate ckmlpr zprsdat
PlannedPrice
FutrCostEstValuationVariant ckmlpr bwva1
FutureCostEstFiscalYear ckmlpr pdatz
FutureCostEstimateFiscalPeriod ckmlpr pprdz
FutureCostEstCostingVersion ckmlpr vers1
FutrPlanProjSlsOrdValnStrategy ckmlpr zbwst
FixedPortionOfPlannedPrice 
@AbapCatalog.sqlViewName: 'PCURMVPRICEPR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC

// DO NOT DELETE: Dynamically used in mapping service of Unified Product API


define view P_CURMATLVALNPRICE_PR
  as select from ckmlpr as pr
{
  key           pr.kalnr                   as CostEstimate,
  key           pr.curtp                   as CurrencyRole,

                cast(' ' as rldnr)         as Ledger,
                pr.zkprs                   as FuturePrice,
                pr.zprsdat                 as FuturePriceValidityStartDate,
                cast(pr.zplpr as fml_plpr) as PlannedPrice,
                pr.bwva1                   as FutrCostEstValuationVariant,
                pr.pdatz                   as FutureCostEstFiscalYear,
                pr.pprdz                   as FutureCostEstimateFiscalPeriod,
                pr.vers1                   as FutureCostEstCostingVersion,
                pr.zbwst                   as FutrPlanProjSlsOrdValnStrategy,
                cast(pr.fplpx as fml_plpx) as FixedPortionOfPlannedPrice

}

Learn More