R_ProductValuationTP

DDL: R_PRODUCTVALUATIONTP Type: view_entity TRANSACTIONAL

Product Valuation - TP

R_ProductValuationTP is a Transactional CDS View that provides data about "Product Valuation - TP" in SAP S/4HANA. It reads from 1 data source (I_ProductValuationBasic) and exposes 32 fields with key fields Product, ValuationArea, ValuationType. It has 5 associations to related views.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductValuationBasic I_ProductValuationBasic from

Associations (5)

CardinalityTargetAliasCondition
[1] E_Productvaluation _ActiveExtension $projection.Product = _ActiveExtension.Product and $projection.ValuationArea = _ActiveExtension.ValuationArea and $projection.ValuationType = _ActiveExtension.ValuationType
[0..1] R_ProductValuationAccountingTP _ProductValuationAccounting
[0..*] R_ProdValuationLedgerAccountTP _ProductValuationLedgerAccount
[0..*] R_ProdValuationLedgerPricesTP _ProductValuationLedgerPrices
[0..1] R_ProductValuationCostingTP _ProductValuationCosting

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

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Product Product
KEY ValuationArea ValuationArea
KEY ValuationType ValuationType
ValuationClass ValuationClass
PriceDeterminationControl PriceDeterminationControl
StandardPrice StandardPrice
ProductPriceUnitQuantity PriceUnitQty
InventoryValuationProcedure InventoryValuationProcedure
MovingAveragePrice MovingAveragePrice
ValuationCategory ValuationCategory
ProductUsageType ProductUsageType
ProductOriginType ProductOriginType
IsProducedInhouse IsProducedInhouse
IsMarkedForDeletion IsMarkedForDeletion
ValuationClassSalesOrderStock ValuationClassSalesOrderStock
ProjectStockValuationClass ProjectStockValuationClass
Currency Currency
BaseUnit BaseUnit
_BaseUnitOfMeasure _BaseUnitOfMeasure
_BR_MaterialOrigin _BR_MaterialOrigin
_BR_MaterialUsage _BR_MaterialUsage
_InventoryValnProcedure _InventoryValnProcedure
_InventoryValuationType _InventoryValuationType
_PriceDeterminationControl _PriceDeterminationControl
_Product _Product
_ValnClassProjectStock _ValnClassProjectStock
_ValnClassSalesOrderStock _ValnClassSalesOrderStock
_ValuationClass _ValuationClass
_ProductValuationAccounting _ProductValuationAccounting
_ProductValuationLedgerAccount _ProductValuationLedgerAccount
_ProductValuationLedgerPrices _ProductValuationLedgerPrices
_ProductValuationCosting _ProductValuationCosting 
@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 - TP'
@ObjectModel.semanticKey: [ 'Product','ValuationArea','ValuationType' ]

define view entity R_ProductValuationTP
  as select from I_ProductValuationBasic
  composition [0..1] of R_ProductValuationAccountingTP as _ProductValuationAccounting
  composition [0..*] of R_ProdValuationLedgerAccountTP as _ProductValuationLedgerAccount
  composition [0..*] of R_ProdValuationLedgerPricesTP  as _ProductValuationLedgerPrices
  composition [0..1] of R_ProductValuationCostingTP    as _ProductValuationCosting
  association     to parent 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 Product,
  key ValuationArea,
  key ValuationType,
      ValuationClass,
      PriceDeterminationControl,
      StandardPrice,
      PriceUnitQty as ProductPriceUnitQuantity,
      InventoryValuationProcedure,
      //PrevInvtryPriceInCoCodeCrcy, //read-only field

      MovingAveragePrice,
      ValuationCategory,
      ProductUsageType,
      ProductOriginType,
      IsProducedInhouse,
      //ProdCostEstNumber, //Internal technical field

      IsMarkedForDeletion,
      ValuationClassSalesOrderStock,
      ProjectStockValuationClass,
      //PriceLastChangeDate, //read-only field

      Currency,
      BaseUnit,
      /* Associations */
      _BaseUnitOfMeasure,
      _BR_MaterialOrigin,
      _BR_MaterialUsage,
      _InventoryValnProcedure,
      _InventoryValuationType,
      _PriceDeterminationControl,
      _Product,
      _ValnClassProjectStock,
      _ValnClassSalesOrderStock,
      _ValuationClass,
      _ProductValuationAccounting,
      _ProductValuationLedgerAccount,
      _ProductValuationLedgerPrices,
      _ProductValuationCosting
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTVALUATIONBASIC"
],
"ASSOCIATED":
[
"I_BR_MATERIALORIGIN",
"I_BR_MATERIALUSAGE",
"I_INVENTORYVALUATIONTYPE",
"I_PRICEDETERMINATIONCONTROL",
"I_PRODVALNPRICECONTROL",
"I_PRODVALUATIONCLASS",
"I_UNITOFMEASURE",
"R_PRODUCTTP",
"R_PRODUCTVALUATIONACCOUNTINGTP",
"R_PRODUCTVALUATIONCOSTINGTP",
"R_PRODVALUATIONLEDGERACCOUNTTP",
"R_PRODVALUATIONLEDGERPRICESTP"
],
"BASE":
[
"I_PRODUCTVALUATIONBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More