A_ProductValuation_2

DDL: A_PRODUCTVALUATION_2 Type: view_entity CONSUMPTION Package: VDM_MD_PRODUCT_API_V2
20 Fields 1 Data Sources 2 OData Services

Product Valuation

A_ProductValuation_2 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 20 fields with key fields Product, ValuationArea, ValuationType. It is exposed through 2 OData services (API_PRODUCT, ASQL_F6618). Part of development package VDM_MD_PRODUCT_API_V2.

Data Sources (1)

SourceAliasJoin Type
R_ProductValuationTP R_ProductValuationTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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

OData Services (2)

ServiceBindingVersionContractRelease
API_PRODUCT API_PRODUCT V4 C2 Deprecated
ASQL_F6618 ASQL_F6618 C2 NOT_RELEASED

Fields (20)

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
_ProductredirectedtoparentA_Product_2

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_2.
-- 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_2 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
FROM R_ProductValuationTP
;

Learn More