I_RO_SAFTProductValuation

DDL: I_RO_SAFTPRODUCTVALUATION SQL: IROSAFTPRDVAL Type: view BASIC Package: GLO_LOG_SAFT_RO
9 Fields 1 Data Sources 1 Associations

RO SAFT Product Valuation

I_RO_SAFTProductValuation is a Basic CDS View that provides data about "RO SAFT Product Valuation" in SAP S/4HANA. It reads from 1 data source (v_mbew_md) and exposes 9 fields with key fields Product, ValuationArea, ValuationType. It has 1 association to related views. Part of development package GLO_LOG_SAFT_RO.

Data Sources (1)

SourceAliasJoin Type
v_mbew_md Valuation from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTPRDVAL 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 #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
EndUserText.label RO SAFT Product Valuation view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY ValuationArea v_mbew_md bwkey Valuation Area
KEY ValuationType v_mbew_md bwtar Valuation Type
IsMarkedForDeletion v_mbew_md lvorm Stock del. flag
InventoryValuationProcedure
IsLIFOAndFIFORelevant
LIFOValuationPoolNumber v_mbew_md mypol LIFO Pool
ValuationClass v_mbew_md bklas Valuation Class
_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 I_RO_SAFTProductValuation.
-- 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.
-- SQL view name: IROSAFTPRDVAL

CREATE VIEW I_RO_SAFTProductValuation 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,
  cast (Valuation.xlifo as boole_d preserving type) AS IsLIFOAndFIFORelevant,
  Valuation.mypol AS LIFOValuationPoolNumber,
  Valuation.bklas AS ValuationClass
FROM v_mbew_md AS Valuation
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
;

Learn More