I_PRATstEntldPrimProd

DDL: I_PRATSTENTLDPRIMPROD SQL: IPRATSTEPP Type: view BASIC Package: OIU_TV
25 Fields 1 Data Sources

PRA - Entitlement Primary Products Actual Vols

I_PRATstEntldPrimProd is a Basic CDS View that provides data about "PRA - Entitlement Primary Products Actual Vols" in SAP S/4HANA. It reads from 1 data source (oiu_sb_entwc) and exposes 25 fields with key fields DeliveryNetwork, Material, Well, WellCompletion, ProcessingCompanyCode. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
oiu_sb_entwc oiu_sb_entwc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRATSTEPP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PRA - Entitlement Primary Products Actual Vols view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY DeliveryNetwork dn_no Delivery network ID
KEY Material matnr Vehicle Model
KEY Well wl_no Well
KEY WellCompletion wc_no Well Completion
KEY ProcessingCompanyCode bukrs Value
KEY PRAJointVenture vname Volatility Name
KEY DivisionOfInterest doi_no Venture/DOI
KEY SalesDate sa_dt Sales Date
KEY AllocationFrequency freq_cd Frequency
KEY VolumeType vt_cd Volume Type
KEY PRAOwner own_no Owner Number
KEY OwnerInterestType own_int_type_cd Opart int type
KEY OwnerInterestSequence own_isq_no Own. ISQ
MarketingRep mk_rep_no Marketing Rep
MarketingRepIntrstSequNmbr mk_rep_isq_no Mkt. Rep. ISQ
VolumeUnit vol_u Unit
EntitledVolume entl_vol Entl. Vol.
AdjustedEntitledVol adj_entl_vol Adj.Entl.Vol.
EnergyUnit energy_u UoM
EntitledEnergy entl_energy Energy
AdjustedEntitledEngy adj_entl_energy Adj. Entl. En.
GrossRevenueInterestRatio gri_pc GRI
AdjdGrossRevenueInterestRatio adj_gri_pc Adjusted GRI
CreatedByUser oiu_cruser Created By
CreationDateTime oiu_timestamp Timestamp

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_PRATstEntldPrimProd.
-- 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: IPRATSTEPP

CREATE VIEW I_PRATstEntldPrimProd AS
SELECT
  dn_no AS DeliveryNetwork,
  matnr AS Material,
  wl_no AS Well,
  wc_no AS WellCompletion,
  bukrs AS ProcessingCompanyCode,
  vname AS PRAJointVenture,
  doi_no AS DivisionOfInterest,
  sa_dt AS SalesDate,
  freq_cd AS AllocationFrequency,
  vt_cd AS VolumeType,
  own_no AS PRAOwner,
  own_int_type_cd AS OwnerInterestType,
  own_isq_no AS OwnerInterestSequence,
  mk_rep_no AS MarketingRep,
  mk_rep_isq_no AS MarketingRepIntrstSequNmbr,
  vol_u AS VolumeUnit,
  entl_vol AS EntitledVolume,
  adj_entl_vol AS AdjustedEntitledVol,
  energy_u AS EnergyUnit,
  entl_energy AS EntitledEnergy,
  adj_entl_energy AS AdjustedEntitledEngy,
  gri_pc AS GrossRevenueInterestRatio,
  adj_gri_pc AS AdjdGrossRevenueInterestRatio,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_sb_entwc
;

Learn More