P_ProductValuationBasic

DDL: P_PRODUCTVALUATIONBASIC Type: view BASIC
82 Fields 1 Data Sources 1 Associations

P_ProductValuationBasic is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mbew) and exposes 82 fields with key fields Product, ValuationArea, ValuationType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mbew Valuation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRDVALUATION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY ValuationArea mbew bwkey Valuation Area
KEY ValuationType mbew bwtar Valuation Type
IsMarkedForDeletion mbew lvorm Stock del. flag
InventoryValuationProcedure
MovingAveragePrice mbew verpr Moving price
StandardPrice mbew stprs Standard price
PriceUnitQty mbew peinh Unit of measure
ValuationClass mbew bklas Valuation Class
ProdPrcControlInPreviousPeriod mbew vmvpr Price ctrl PP
MvgAvgPriceInPreviousPeriod mbew vmver MovAvgPrice PP
StandardPriceInPreviousPeriod mbew vmstp Std price PP
ProdPrcUntQtyInPreviousPeriod mbew vmpei Price unit PP
ValuationClassPreviousPeriod mbew vmbkl Val. class PP
ProdPriceControlInPreviousYear mbew vjvpr Price ctrl PY
MvgAveragePriceInPreviousYear mbew vjver MovAvgPrice PY
StandardPricePrevYear mbew vjstp Std price PY
ProdPrcUntQtyInPreviousYear mbew vjpei Price unit PY
ValuationClassPreviousYear mbew vjbkl Val. class PY
FiscalYearCurrentPeriod mbew lfgja Year Cur.Period
FiscalMonthCurrentPeriod mbew lfmon Current Period
ValuationCategory mbew bwtty Valuation Cat.
PrevInvtryPriceInCoCodeCrcy mbew stprv Previous Price
PriceLastChangeDate mbew laepr Last Price Chg.
FuturePrice mbew zkprs Future Price
FuturePriceValidityStartDate mbew zkdat Valid from
TaxPricel1InCoCodeCrcy mbew bwprs Tax price 1
CommercialPrice1InCoCodeCrcy mbew bwprh Comm. price 1
TaxPrice3InCoCodeCrcy mbew vjbws Tax price 3
CommercialPrice3InCoCodeCrcy mbew vjbwh Coml price 3
PlannedPrice mbew zplpr Fut. Plnd Price
PlannedPrice1InCoCodeCrcy mbew zplp1 Planned price 1
PlannedPrice2InCoCodeCrcy mbew zplp2 Planned price 2
PlannedPrice3InCoCodeCrcy mbew zplp3 Planned price 3
FuturePlndPrice1ValdtyDate mbew zpld1 Plnd pr. date 1
FuturePlndPrice2ValdtyDate mbew zpld2 Plnd pr. date 2
FuturePlndPrice3ValdtyDate mbew zpld3 Plnd pr. date 3
ProdSpecCompUpperLimitQuantity mbew pperl Current c/e pd
PCEctxPHScaleUprValTxt mbew pperv Prev. c/e per.
OperationIsIncludedInCosting mbew kalkz Fut. cost est.
HasStdCostEstForCurrentPeriod mbew kalkl CurrentCostEst.
HasStdCostEstForPreviousPeriod mbew kalkv PreviousCostEst
IsLIFOAndFIFORelevant
LIFOValuationPoolNumber mbew mypol LIFO Pool
CommercialPrice2InCoCodeCrcy mbew bwph1 Commercial pr.2
TaxPrice2InCoCodeCrcy mbew bwps1 Tax price 2
DevaluationYearCount mbew abwkz Devaluation Ind
MaintenanceStatus mbew pstat Processing Status
ProdCostEstNumber mbew kaln1 ProdCostEst.No.
CostEstimateNumberOfOutput mbew kalnr ProdCostEst.No.
FutrCostEstValuationVariant mbew bwva1 Valuation Var.
CurCostEstValuationVariant mbew bwva2 Valuatn Variant
PrevCostEstValuationVariant mbew bwva3 Valuation Var.
FutureCostEstCostingVersion mbew vers1 Late Completion
CurrentCostEstCostingVersion mbew vers2 EarlyCompletion
PreviousCostEstCostingVersion mbew vers3 Costing Version
CostOriginGroup mbew hrkft Origin group order
CostingOverheadGroup mbew kosgr Overhead Group
FutureCostEstimateFiscalPeriod mbew pprdz Posting Period
CurrentCostEstFiscalPeriod mbew pprdl Current Period
PreviousCostEstFiscalPeriod mbew pprdv Previous Period
FutureCostEstFiscalYear mbew pdatz Fut. FYyear
CurrentCostEstFiscalYear mbew pdatl Curr. Fiscal Yr
PreviousCostEstFiscalYear mbew pdatv Valid From
IsMaterialCostedWithQtyStruc mbew ekalr Cost Est. w/QS
PreviousPlanPriceInCoCodeCrcy mbew vplpr Prev. Plnd Prc.
PriceDeterminationControl mbew mlast Price Determ.
DairyCurrentPlannedPrice mbew lplpr Curr.Plnd Price
IsMaterialRelatedOrigin mbew hkmat Material origin
ValuationMargin mbew bwspa Val. Margin
FxdPortnOfPlanPrcInCoCodeCrcy mbew lplpx Fix. Cur. Plnd Prc.
FxdPortOfPrevPlPrcInCoCodeCrcy mbew vplpx Fixed Prev. PlndPrc.
CurPlanProjSlsOrdValnStrategy mbew lbwst Curr. Valn Strat.
PrevPlanProjSlsOrdValnStrategy mbew vbwst Prev. Valn Strat.
ValuationClassSalesOrderStock mbew eklas VC: Sal.Ord.Stk
ProjectStockValuationClass mbew qklas Project stk VC
ProductUsageType
ProductOriginType
IsProducedInhouse mbew ownpr Prod. in-house
TaxBasedPricesPriceUnitQty mbew bwpei Price Unit
MLIsActiveAtProductLevel mbew mlmaa ML Act.
_Product _Product

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ProductValuationBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_ProductValuationBasic AS
SELECT
  cast ( Valuation.matnr as productnumber preserving type ) AS Product,
  Valuation.bwkey AS ValuationArea,
  Valuation.bwtar AS ValuationType,
  Valuation.lvorm AS IsMarkedForDeletion,
  cast (Valuation.vprsv as inventoryvaluationprocedure preserving type ) AS InventoryValuationProcedure,
  Valuation.verpr AS MovingAveragePrice,
  Valuation.stprs AS StandardPrice,
  Valuation.peinh AS PriceUnitQty,
  Valuation.bklas AS ValuationClass,
  Valuation.vmvpr AS ProdPrcControlInPreviousPeriod,
  Valuation.vmver AS MvgAvgPriceInPreviousPeriod,
  Valuation.vmstp AS StandardPriceInPreviousPeriod,
  Valuation.vmpei AS ProdPrcUntQtyInPreviousPeriod,
  Valuation.vmbkl AS ValuationClassPreviousPeriod,
  Valuation.vjvpr AS ProdPriceControlInPreviousYear,
  Valuation.vjver AS MvgAveragePriceInPreviousYear,
  Valuation.vjstp AS StandardPricePrevYear,
  Valuation.vjpei AS ProdPrcUntQtyInPreviousYear,
  Valuation.vjbkl AS ValuationClassPreviousYear,
  Valuation.lfgja AS FiscalYearCurrentPeriod,
  Valuation.lfmon AS FiscalMonthCurrentPeriod,
  Valuation.bwtty AS ValuationCategory,
  Valuation.stprv AS PrevInvtryPriceInCoCodeCrcy,
  Valuation.laepr AS PriceLastChangeDate,
  Valuation.zkprs AS FuturePrice,
  Valuation.zkdat AS FuturePriceValidityStartDate,
  Valuation.bwprs AS TaxPricel1InCoCodeCrcy,
  Valuation.bwprh AS CommercialPrice1InCoCodeCrcy,
  Valuation.vjbws AS TaxPrice3InCoCodeCrcy,
  Valuation.vjbwh AS CommercialPrice3InCoCodeCrcy,
  Valuation.zplpr AS PlannedPrice,
  Valuation.zplp1 AS PlannedPrice1InCoCodeCrcy,
  Valuation.zplp2 AS PlannedPrice2InCoCodeCrcy,
  Valuation.zplp3 AS PlannedPrice3InCoCodeCrcy,
  Valuation.zpld1 AS FuturePlndPrice1ValdtyDate,
  Valuation.zpld2 AS FuturePlndPrice2ValdtyDate,
  Valuation.zpld3 AS FuturePlndPrice3ValdtyDate,
  Valuation.pperl AS ProdSpecCompUpperLimitQuantity,
  Valuation.pperv AS PCEctxPHScaleUprValTxt,
  Valuation.kalkz AS OperationIsIncludedInCosting,
  Valuation.kalkl AS HasStdCostEstForCurrentPeriod,
  Valuation.kalkv AS HasStdCostEstForPreviousPeriod,
  cast (Valuation.xlifo as boole_d preserving type) AS IsLIFOAndFIFORelevant,
  Valuation.mypol AS LIFOValuationPoolNumber,
  Valuation.bwph1 AS CommercialPrice2InCoCodeCrcy,
  Valuation.bwps1 AS TaxPrice2InCoCodeCrcy,
  Valuation.abwkz AS DevaluationYearCount,
  Valuation.pstat AS MaintenanceStatus,
  Valuation.kaln1 AS ProdCostEstNumber,
  Valuation.kalnr AS CostEstimateNumberOfOutput,
  Valuation.bwva1 AS FutrCostEstValuationVariant,
  Valuation.bwva2 AS CurCostEstValuationVariant,
  Valuation.bwva3 AS PrevCostEstValuationVariant,
  Valuation.vers1 AS FutureCostEstCostingVersion,
  Valuation.vers2 AS CurrentCostEstCostingVersion,
  Valuation.vers3 AS PreviousCostEstCostingVersion,
  Valuation.hrkft AS CostOriginGroup,
  Valuation.kosgr AS CostingOverheadGroup,
  Valuation.pprdz AS FutureCostEstimateFiscalPeriod,
  Valuation.pprdl AS CurrentCostEstFiscalPeriod,
  Valuation.pprdv AS PreviousCostEstFiscalPeriod,
  Valuation.pdatz AS FutureCostEstFiscalYear,
  Valuation.pdatl AS CurrentCostEstFiscalYear,
  Valuation.pdatv AS PreviousCostEstFiscalYear,
  Valuation.ekalr AS IsMaterialCostedWithQtyStruc,
  Valuation.vplpr AS PreviousPlanPriceInCoCodeCrcy,
  Valuation.mlast AS PriceDeterminationControl,
  Valuation.lplpr AS DairyCurrentPlannedPrice,
  Valuation.hkmat AS IsMaterialRelatedOrigin,
  Valuation.bwspa AS ValuationMargin,
  Valuation.lplpx AS FxdPortnOfPlanPrcInCoCodeCrcy,
  Valuation.vplpx AS FxdPortOfPrevPlPrcInCoCodeCrcy,
  Valuation.lbwst AS CurPlanProjSlsOrdValnStrategy,
  Valuation.vbwst AS PrevPlanProjSlsOrdValnStrategy,
  Valuation.eklas AS ValuationClassSalesOrderStock,
  Valuation.qklas AS ProjectStockValuationClass,
  cast (Valuation.mtuse as productusagetype preserving type ) AS ProductUsageType,
  cast (Valuation.mtorg as productorigintype preserving type ) AS ProductOriginType,
  Valuation.ownpr AS IsProducedInhouse,
  Valuation.bwpei AS TaxBasedPricesPriceUnitQty,
  Valuation.mlmaa AS MLIsActiveAtProductLevel
FROM mbew AS Valuation
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
;

Learn More