R_ProdValuationLedgerAccountTP

DDL: R_PRODVALUATIONLEDGERACCOUNTTP Type: view_entity TRANSACTIONAL

Product Valuation Ledger Account - TP

R_ProdValuationLedgerAccountTP is a Transactional CDS View that provides data about "Product Valuation Ledger Account - TP" 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.

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 Account - TP view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY ValuationArea
KEY ValuationType ValuationType
KEY CurrencyRole CurrencyRole
KEY Ledger Ledger
ProductPriceControl ProductPriceControl
ProductPriceUnitQuantity PriceUnitQty
Currency Currency
MovingAveragePrice MovingAveragePrice
StandardPrice StandardPrice
CompanyCode CompanyCode
BaseUnit _Product BaseUnit
_Product _Product
_ProductValuation _ProductValuation
_BaseUnitOfMeasure _Product _BaseUnitOfMeasure 
@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 Account - TP'
@ObjectModel.semanticKey: [ 'Product','ValuationArea','ValuationType','CurrencyRole','Ledger' ]

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity R_ProdValuationLedgerAccountTP
  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,
      ProductPriceControl,
      PriceUnitQty                                      as ProductPriceUnitQuantity,
      Currency,
      MovingAveragePrice,
      StandardPrice,
      CompanyCode,
      _Product.BaseUnit,
      /* Associations */
      _Product,
      _ProductValuation,
      _Product._BaseUnitOfMeasure
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTVALUATIONPRICES_UNION",
"R_PRODUCTTP"
],
"ASSOCIATED":
[
"I_UNITOFMEASURE",
"R_PRODUCTTP",
"R_PRODUCTVALUATIONTP"
],
"BASE":
[
"R_PRODUCTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More