I_ValnPriceCategoryPrice

DDL: I_VALNPRICECATEGORYPRICE Type: view COMPOSITE
27 Fields 1 Data Sources 7 Associations

Prices of Valuation Price Categories

I_ValnPriceCategoryPrice is a Composite CDS View that provides data about "Prices of Valuation Price Categories" in SAP S/4HANA. It reads from 1 data source (P_ValnPriceCategoryPrice) and exposes 27 fields with key fields ValuationPriceCategory, FiscalYear, FiscalPeriod, LedgerValuationCurrencyRole, CostEstimate. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ValnPriceCategoryPrice vpcp from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingArea $projection.controllingarea = _ControllingArea.ControllingArea
[0..*] I_ValuationPriceCategoryText _ValuationPriceCategoryText $projection.ValuationPriceCategory = _ValuationPriceCategoryText.ValuationPriceCategory
[0..1] I_LedgerText _LedgerText _LedgerText.Ledger = vpcp.Ledger and _LedgerText.Language = $session.system_language
[0..1] I_LedgerText _LeadingLedgerText _LeadingLedgerText.Ledger = _LeadingLedger.Ledger and _LeadingLedgerText.Language = $session.system_language
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_Plant _Plant $projection.ValuationArea = _Plant.Plant
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IVALPRCATPR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Prices of Valuation Price Categories view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ValuationPriceCategory ValuationPriceCategory
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY LedgerValuationCurrencyRole P_ValnPriceCategoryPrice LedgerValuationCurrencyRole Valuation Area
KEY CostEstimate P_ValnPriceCategoryPrice CostEstimate Cost EstimateNo
LegalCurrencyRole LegalCurrencyRole
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
CompanyCode CompanyCode Receiver Company Code
ControllingArea _CompanyCode ControllingArea Controlling Area
AccountingValuationView
LedgerendasLedger
LedgerNameendasLedgerName
ValuationPriceCategoryPrice ValuationPriceCategoryPrice RVP f.PricePro.
Currency Currency Valuation Crcy
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
ValuationQuantityUnit ValuationQuantityUnit Valuation Unit
ValuationPriceNumeratorAmount ValuationPriceNumeratorAmount
ValuationPriceDenominatorQty ValuationPriceDenominatorQty
TotalValuatedStockAmount TotalValuatedStockAmount
TotalVltdStockQuantity TotalVltdStockQuantity
_Material _Material
_Plant _Plant
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ValuationPriceCategoryText _ValuationPriceCategoryText

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_ValnPriceCategoryPrice.
-- 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 I_ValnPriceCategoryPrice AS
SELECT
  ValuationPriceCategory,
  FiscalYear,
  FiscalPeriod,
  vpcp.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  vpcp.CostEstimate AS CostEstimate,
  LegalCurrencyRole,
  Material,
  ValuationArea,
  InventoryValuationType,
  CompanyCode,
  _CompanyCode.ControllingArea AS ControllingArea,
  cast('0' as fins_valutyp_wo_cogm) AS AccountingValuationView,
  case vpcp.Ledger when '' then _LeadingLedger.Ledger else vpcp.Ledger end as Ledger AS LedgerendasLedger,
  case vpcp.Ledger when '' then _LeadingLedgerText[1:Language = $session.system_language].LedgerName else _LedgerText[1:Language = $session.system_language].LedgerName end as LedgerName AS LedgerNameendasLedgerName,
  ValuationPriceCategoryPrice,
  Currency,
  MaterialPriceUnitQty,
  ValuationQuantityUnit,
  ValuationPriceNumeratorAmount,
  ValuationPriceDenominatorQty,
  TotalValuatedStockAmount,
  TotalVltdStockQuantity
FROM P_ValnPriceCategoryPrice AS vpcp
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ValuationPriceCategoryText AS _ValuationPriceCategoryText ON ValuationPriceCategory = _ValuationPriceCategoryText.ValuationPriceCategory  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON _LedgerText.Ledger = vpcp.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LeadingLedgerText ON _LeadingLedgerText.Ledger = _LeadingLedger.Ledger AND _LeadingLedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ValuationArea = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More