I_PRAValnDocTransRunTicket

DDL: I_PRAVALNDOCTRANSRUNTICKET Type: view_entity BASIC
21 Fields 1 Data Sources 1 Associations

Valuation Transaction Run Ticket

I_PRAValnDocTransRunTicket (Basic)

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

PRAValnDocTransacRunTicket · Cross Applications

I_PRAValnDocTransRunTicket is a Basic CDS View that provides data about "Valuation Transaction Run Ticket" in SAP S/4HANA. It reads from 1 data source (oiurv_doc_runtkt) and exposes 21 fields with key fields ValuationDocumentNumber, ValuationDocumentYear, ValuationDocumentLineNumber, PRAPositionNumber, PRARunTicketNumber. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Production and Revenue Accounting (PRA)
Purpose
This CDS view stores Oil Run ticket volumes (Sales volumes) at Well Completion or Measurement Point level.

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-O3UVL_RTI (Mapping role for I_PRAValnDocTransRunTicket)

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment PRARunTicketNumber OIU_RUN_TKT_NO CHAR 45 ValuationDocumentLineNumber OIU_DOC_LINENR NUMC 5 ValuationDocumentYear OIU_DOC_YEAR NUMC 4 PRAPositionNumber OIU_DOC_POS_NO NUMC 10 ValuationDocumentNumber OIURV_DOCNR CHAR 20 PRATransferEffectiveFromDate OIU_EFF_FROM_DT DATS 8

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 stores Oil Run ticket volumes (Sales volumes) at Well Completion or Measurement Point level.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
oiurv_doc_runtkt oiurv_doc_runtkt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PRADensityTypeVH _PRADensityTypeVH _PRADensityTypeVH.PRADensityType = $projection.PRADensityType

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Valuation Transaction Run Ticket view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name PRAValnDocTransacRunTicket view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ValuationDocumentNumber doc_no Val. document number
KEY ValuationDocumentYear doc_year Mat. Doc. Year
KEY ValuationDocumentLineNumber line_no Document Line Number
KEY PRAPositionNumber pos_no Tax doc. item number
KEY PRARunTicketNumber run_tkt_no Run Ticket Number
KEY PRATransferEffectiveFromDate eff_from_dt Effective From Date
PRATransferEffectiveToDate eff_to_dt Effective To Date
PRAStandardVolume std_vol Standard volume
EntldGrossVolume entl_gr_vl Entitled Gross Volume Amount
StandardVolUnit std_vol_u Standard volume unit
PRAStandardDensity base_density Standard Density
PRAStandardDensityUnit base_density_u Standard Density UoM
PRATransporterUnitPrice price_per_unit Transporter unit value
Currency price_punit_curr Currency Key
ActualGrossValue actl_gr_val_am Actual Gross Value Amount
PRAEntitledGrossValueAmount entl_gr_val_am Entitled Gross Value Amount
PRAGrossValueCurrency actl_gr_val_curr Currency Key
PRADensityType dntyp Density Type
Transporter trnsp_no Transporter number
TransporterReference trnsp_ref_no Transporter Reference Number
_PRADensityTypeVH _PRADensityTypeVH

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_PRAValnDocTransRunTicket.
-- 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_PRAValnDocTransRunTicket AS
SELECT
  doc_no AS ValuationDocumentNumber,
  doc_year AS ValuationDocumentYear,
  line_no AS ValuationDocumentLineNumber,
  pos_no AS PRAPositionNumber,
  run_tkt_no AS PRARunTicketNumber,
  eff_from_dt AS PRATransferEffectiveFromDate,
  eff_to_dt AS PRATransferEffectiveToDate,
  std_vol AS PRAStandardVolume,
  entl_gr_vl AS EntldGrossVolume,
  std_vol_u AS StandardVolUnit,
  base_density AS PRAStandardDensity,
  base_density_u AS PRAStandardDensityUnit,
  price_per_unit AS PRATransporterUnitPrice,
  price_punit_curr AS Currency,
  actl_gr_val_am AS ActualGrossValue,
  entl_gr_val_am AS PRAEntitledGrossValueAmount,
  actl_gr_val_curr AS PRAGrossValueCurrency,
  dntyp AS PRADensityType,
  trnsp_no AS Transporter,
  trnsp_ref_no AS TransporterReference
FROM oiurv_doc_runtkt
LEFT OUTER JOIN I_PRADensityTypeVH AS _PRADensityTypeVH ON _PRADensityTypeVH.PRADensityType = PRADensityType  -- association [0..1]
;

Learn More