I_PRAValuationFormulaID

DDL: I_PRAVALUATIONFORMULAID Type: view_entity BASIC
18 Fields 1 Data Sources 4 Associations

Valuation Formula Id

I_PRAValuationFormulaID (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

PRAValuationFormulaID · Cross Applications

I_PRAValuationFormulaID is a Basic CDS View that provides data about "Valuation Formula Id" in SAP S/4HANA. It reads from 1 data source (oiu_rv_frml) and exposes 18 fields with key field PRAFormulaNumber. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Production and Revenue Accounting (PRA)
Purpose
This CDS view serves as a unique identifier for a valuation formula. Valuation formulas are integral to the valuation process. They are the only means by which a calculated value can be attributed to the volume of oil, gas, or natural gas liquid sold. Moreover, these formulas are solely responsible for applying the costs or reimbursements associated with the expenses of marketing a product to a calculated value. To calculate these values, the formulas utilize data related to volume, ownership, and rates, in addition to formula master data. .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: O_OIU_TXN:ACTVT-03,O_OIU_TXN:OIU_TCODE-O3U_VLFR3 (Mapping role for I_PRAValuationFormulaID)

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source in SQL Select
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view serves as a unique identifier for a valuation formula. Valuation formulas are integral to the valuation process. They are the only means by which a calculated value can be attributed to the volume of oil, gas, or natural gas liquid sold. Moreover, these formulas are solely responsible for applying the costs or reimbursements associated with the expenses of marketing a product to a calculated value. To calculate these values, the formulas utilize data related to volume, ownership, and rates, in addition to formula master data.&nbsp;.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
oiu_rv_frml oiu_rv_frml from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_PRAMatlMjrProdMappg _PRAMatlMjrProdMappg _PRAMatlMjrProdMappg.Material = $projection.PRAMaterial
[0..1] I_VolumeType _VolumeType _VolumeType.VolumeType = $projection.VolumeType
[0..1] I_MajorProduct _MajorProduct _MajorProduct.MajorProduct = $projection.MajorProduct
[0..1] I_VolumeClass _VolumeClass _VolumeClass.VolumeClass = $projection.PRAVolumeClass

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Valuation Formula Id view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey PRAFormulaNumber view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name PRAValuationFormulaID view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PRAFormulaNumber frml_no Formula Number
PRAFormulaDescription frml_desc Formula Description
PRAShortText shtxt Description
VolumeType vl_type_cd Volume type code
PRAVolumeClass vl_cls_cd Volume Class Code
PRALastProductionProcessDate lprd_prcs_dt Last Production Process Date
PRAEnqueueIsSelected enq_sel_flag Enq Selection Flag
PRAIsActual actl_fl Actual indicator
PRAIsEntitled entl_fl Entitled Flag
PRAIsSettlement sett_fl Settlement Flag
MajorProduct majpd_cd Major product code
PRAMaterial matnr Material Number
CreatedByUser oiu_cruser Name of Person Responsible for Creating the Object
CreationDateTime oiu_timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_VolumeClass _VolumeClass
_MajorProduct _MajorProduct
_VolumeType _VolumeType
_PRAMatlMjrProdMappg _PRAMatlMjrProdMappg

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_PRAValuationFormulaID.
-- 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_PRAValuationFormulaID AS
SELECT
  frml_no AS PRAFormulaNumber,
  frml_desc AS PRAFormulaDescription,
  shtxt AS PRAShortText,
  vl_type_cd AS VolumeType,
  vl_cls_cd AS PRAVolumeClass,
  lprd_prcs_dt AS PRALastProductionProcessDate,
  enq_sel_flag AS PRAEnqueueIsSelected,
  actl_fl AS PRAIsActual,
  entl_fl AS PRAIsEntitled,
  sett_fl AS PRAIsSettlement,
  majpd_cd AS MajorProduct,
  matnr AS PRAMaterial,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_rv_frml
LEFT OUTER JOIN I_PRAMatlMjrProdMappg AS _PRAMatlMjrProdMappg ON _PRAMatlMjrProdMappg.Material = PRAMaterial  -- association [0..1]
LEFT OUTER JOIN I_VolumeType AS _VolumeType ON _VolumeType.VolumeType = VolumeType  -- association [0..1]
LEFT OUTER JOIN I_MajorProduct AS _MajorProduct ON _MajorProduct.MajorProduct = MajorProduct  -- association [0..1]
LEFT OUTER JOIN I_VolumeClass AS _VolumeClass ON _VolumeClass.VolumeClass = PRAVolumeClass  -- association [0..1]
;

Learn More