A_ProductValuation_3

DDL: A_PRODUCTVALUATION_3 Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Product Valuation

A_ProductValuation_3 is a Consumption CDS View that provides data about "Product Valuation" in SAP S/4HANA. It reads from 1 data source (R_ProductValuationTP) and exposes 21 fields with key fields Product, ValuationArea, ValuationType.

Data Sources (1)

SourceAliasJoin Type
R_ProductValuationTP R_ProductValuationTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Product Valuation view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name ProductValuation_Type view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
KEY ValuationArea ValuationArea Valuation Area
KEY ValuationType ValuationType Valuation Type
ValuationClass ValuationClass Valuation Class
PriceDeterminationControl PriceDeterminationControl Price Determ.
StandardPrice StandardPrice Standard price
ProductPriceUnitQuantity ProductPriceUnitQuantity Price unit
InventoryValuationProcedure InventoryValuationProcedure Price Control
MovingAveragePrice MovingAveragePrice Per. Unit Price
ValuationCategory ValuationCategory Valuation Cat.
ProductUsageType ProductUsageType Product Usage
ProductOriginType ProductOriginType Product Origin
IsProducedInhouse IsProducedInhouse Prod. in-house
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
ValuationClassSalesOrderStock ValuationClassSalesOrderStock VC: Sal.Ord.Stk
ProjectStockValuationClass ProjectStockValuationClass Project stk VC
Currency Currency Valuation Crcy
BaseUnit BaseUnit Unit of Measure
BaseISOUnit
ValuationMarginPercent ValuationMarginPercent Val. margin
_ProductredirectedtoparentA_Product_3

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 A_ProductValuation_3.
-- 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 A_ProductValuation_3 AS
SELECT
  Product,
  ValuationArea,
  ValuationType,
  ValuationClass,
  PriceDeterminationControl,
  StandardPrice,
  ProductPriceUnitQuantity,
  InventoryValuationProcedure,
  MovingAveragePrice,
  ValuationCategory,
  ProductUsageType,
  ProductOriginType,
  IsProducedInhouse,
  IsMarkedForDeletion,
  ValuationClassSalesOrderStock,
  ProjectStockValuationClass,
  Currency,
  BaseUnit,
  cast( _Product._BaseUnitOfMeasure.UnitOfMeasureISOCode as meins_iso preserving type ) AS BaseISOUnit,
  ValuationMarginPercent
FROM R_ProductValuationTP
;

Learn More