R_ProdValuationLedgerPricesTP

DDL: R_PRODVALUATIONLEDGERPRICESTP Type: view_entity TRANSACTIONAL Package: VDM_MD_PRODUCT_BO

Product Valuation Ledger Prices

R_ProdValuationLedgerPricesTP is a Transactional CDS View that provides data about "Product Valuation Ledger Prices" in SAP S/4HANA. It reads from 1 data source (I_Productvaluationprices_Union) and exposes 15 fields with key fields Product, ValuationArea, ValuationType, CurrencyRole, Ledger. It has 2 associations to related views. Part of development package VDM_MD_PRODUCT_BO.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_Productvaluationprices_Union I_Productvaluationprices_Union from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ProductTP _Product $projection.Product = _Product.Product
[1] E_Productvaluation _ActiveExtension $projection.Product = _ActiveExtension.Product and $projection.ValuationArea = _ActiveExtension.ValuationArea and $projection.ValuationType = _ActiveExtension.ValuationType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Product Valuation Ledger Prices view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY ValuationArea
KEY ValuationType ValuationType
KEY CurrencyRole CurrencyRole
KEY Ledger Ledger
ProductPriceUnitQuantity PriceUnitQty
Currency Currency
FuturePrice FuturePrice
FuturePriceValidityStartDate FuturePriceValidityStartDate
CompanyCode CompanyCode
BaseUnit _Product BaseUnit
_Product _Product
_ProductValuation _ProductValuation
_BaseUnitOfMeasure _Product _BaseUnitOfMeasure
_CurrencyText _CurrencyText 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Product Valuation Ledger Prices'
@ObjectModel.semanticKey: [ 'Product','ValuationArea','ValuationType','CurrencyRole','Ledger' ]

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity R_ProdValuationLedgerPricesTP
  as select from I_Productvaluationprices_Union
  association        to parent R_ProductValuationTP as _ProductValuation on  $projection.Product       = _ProductValuation.Product
                                                                         and $projection.ValuationArea = _ProductValuation.ValuationArea
                                                                         and $projection.ValuationType = _ProductValuation.ValuationType
  association [1..1] to R_ProductTP                 as _Product          on  $projection.Product = _Product.Product
  association [1]    to E_Productvaluation          as _ActiveExtension  on  $projection.Product       = _ActiveExtension.Product
                                                                         and $projection.ValuationArea = _ActiveExtension.ValuationArea
                                                                         and $projection.ValuationType = _ActiveExtension.ValuationType
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key cast (Product as productnumber preserving type ) as Product,
  key cast ( ValuationArea as bwkey preserving type )  as ValuationArea,
  key ValuationType,
      //  key ProdCostEstNumber,

  key CurrencyRole,
  key Ledger,
      PriceUnitQty                                     as ProductPriceUnitQuantity,
      Currency,
      FuturePrice,
      FuturePriceValidityStartDate,
      CompanyCode,
      _Product.BaseUnit,
      /* Associations */
      _Product,
      _ProductValuation,
      _Product._BaseUnitOfMeasure,
      _CurrencyText
}

Learn More