C_PRATstEntldSecdryCompareUI

DDL: C_PRATSTENTLDSECDRYCOMPAREUI SQL: CPRATSTESCUI Type: view CONSUMPTION
18 Fields 1 Data Sources

Entitled Secondary Compare - Consumption

C_PRATstEntldSecdryCompareUI is a Consumption CDS View that provides data about "Entitled Secondary Compare - Consumption" in SAP S/4HANA. It reads from 1 data source (I_PRATstEntldSecdryCompareUI) and exposes 18 fields with key fields DeliveryNetwork, Well, WellCompletion, Material, SalesDate.

Data Sources (1)

SourceAliasJoin Type
I_PRATstEntldSecdryCompareUI I_PRATstEntldSecdryCompareUI from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPRATSTESCUI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Entitled Secondary Compare - Consumption view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Entitled Residue & NGL Product view
UI.headerInfo.typeNamePlural Entitled Residue & NGL Products view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DeliveryNetwork DeliveryNetwork Delivery network ID
KEY Well Well Well
KEY WellCompletion WellCompletion Well Completion
KEY Material Material Vehicle Model
KEY SalesDate SalesDate Sales Date
KEY VolumeType VolumeType Volume Type
KEY PRAOwner PRAOwner
KEY OwnerInterestType OwnerInterestType
KEY OwnerInterestSequence OwnerInterestSequence
MajorProduct MajorProduct Major Product
EntitledVolumeStsCritlty EntitledVolumeStsCritlty
BaselineEntitledVolume BaselineEntitledVolume
EntitledVolume EntitledVolume
VolumeUnit VolumeUnit Volume Unit
EntitledEnergyStsCritlty EntitledEnergyStsCritlty
BaselineEntitledEnergy BaselineEntitledEnergy
EntitledEnergy EntitledEnergy
EnergyUnit EnergyUnit

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 C_PRATstEntldSecdryCompareUI.
-- 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: CPRATSTESCUI

CREATE VIEW C_PRATstEntldSecdryCompareUI AS
SELECT
  DeliveryNetwork,
  Well,
  WellCompletion,
  Material,
  SalesDate,
  VolumeType,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  MajorProduct,
  EntitledVolumeStsCritlty,
  BaselineEntitledVolume,
  EntitledVolume,
  VolumeUnit,
  EntitledEnergyStsCritlty,
  BaselineEntitledEnergy,
  EntitledEnergy,
  EnergyUnit
FROM I_PRATstEntldSecdryCompareUI
;

Learn More