C_PRATstCombinedHdrCompareUI

DDL: C_PRATSTCOMBINEDHDRCOMPAREUI SQL: CPRATVCOMHDC Type: view CONSUMPTION Package: OIU_TV
51 Fields 1 Data Sources

TV - Combine Run Header - Consp Compare UI

C_PRATstCombinedHdrCompareUI is a Consumption CDS View that provides data about "TV - Combine Run Header - Consp Compare UI" in SAP S/4HANA. It reads from 1 data source (I_PRATstCombinedHdrCompareUI) and exposes 51 fields with key fields CurrentValnDocument, CurrentValnDocumentYear, DeliveryNetwork, SalesDate, Well. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstCombinedHdrCompareUI I_PRATstCombinedHdrCompareUI from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPRATVCOMHDC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label TV - Combine Run Header - Consp Compare UI view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName Combined Run Header view
UI.headerInfo.typeNamePlural Combined Run Headers view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY CurrentValnDocument CurrentValnDocument DocNr
KEY CurrentValnDocumentYear CurrentValnDocumentYear Document year
KEY DeliveryNetwork DeliveryNetwork Delivery network ID
KEY SalesDate SalesDate Sales Date
KEY Well Well Well
KEY WellCompletion WellCompletion Well Completion
KEY OriginatingMeasurementPt OriginatingMeasurementPt
KEY PRAJointVenture PRAJointVenture Ext vent name
KEY DivisionOfInterest DivisionOfInterest Venture/DOI
KEY PRAProduct PRAProduct Full Product
KEY PRAContract PRAContract Contract
KEY Material Material Vehicle Model
KEY VolumeType VolumeType Volume Type
KEY BookingReversalType BookingReversalType CR HEADER TYPE CODE
KEY CombinedHdrSqncNumber CombinedHdrSqncNumber
VolumeUnit VolumeUnit Volume Unit
EnergyUnit EnergyUnit
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ActualGrossVolumeStsCritlty ActualGrossVolumeStsCritlty
ActualGrossVolume ActualGrossVolume
BaselineActualGrossVolume BaselineActualGrossVolume
ActualGrossValueStsCritlty ActualGrossValueStsCritlty
ActualGrossValue ActualGrossValue
BaselineActualGrossValue BaselineActualGrossValue
EntldGrossVolumeStsCritlty EntldGrossVolumeStsCritlty
EntldGrossVolume EntldGrossVolume
BaselineEntldGrossVolume BaselineEntldGrossVolume
EntldGrossValueStsCritlty EntldGrossValueStsCritlty
EntldGrossValue EntldGrossValue
BaselineEntldGrossValue BaselineEntldGrossValue
ActualVolReducnStsCritlty ActualVolReducnStsCritlty
ActualVolReducn ActualVolReducn
BaselineActualVolReducn BaselineActualVolReducn
EntitledVolReducnStsCritlty EntitledVolReducnStsCritlty
EntitledVolReducn EntitledVolReducn
BaselineEntitledVolReducn BaselineEntitledVolReducn
ActualEnergyStsCritlty ActualEnergyStsCritlty
ActualEnergy ActualEnergy
BaselineActualEnergy BaselineActualEnergy
ActualPriceStsCritlty ActualPriceStsCritlty
SalesPriceAmount SalesPriceAmount
BaselineSalesPriceAmount BaselineSalesPriceAmount
EntitledEnergyStsCritlty EntitledEnergyStsCritlty
EntitledEnergy EntitledEnergy
BaselineEntitledEnergy BaselineEntitledEnergy
ActualEngyReducnStsCritlty ActualEngyReducnStsCritlty
ActualEnergyReducn ActualEnergyReducn
BaselineActualEngyReducn BaselineActualEngyReducn
EntldEngyReducnStsCritlty EntldEngyReducnStsCritlty
EntitledEngyReducn EntitledEngyReducn
BaselineEntldEngyReducn BaselineEntldEngyReducn

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_PRATstCombinedHdrCompareUI.
-- 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: CPRATVCOMHDC

CREATE VIEW C_PRATstCombinedHdrCompareUI AS
SELECT
  CurrentValnDocument,
  CurrentValnDocumentYear,
  DeliveryNetwork,
  SalesDate,
  Well,
  WellCompletion,
  OriginatingMeasurementPt,
  PRAJointVenture,
  DivisionOfInterest,
  PRAProduct,
  PRAContract,
  Material,
  VolumeType,
  BookingReversalType,
  CombinedHdrSqncNumber,
  VolumeUnit,
  EnergyUnit,
  CompanyCodeCurrency,
  ActualGrossVolumeStsCritlty,
  ActualGrossVolume,
  BaselineActualGrossVolume,
  ActualGrossValueStsCritlty,
  ActualGrossValue,
  BaselineActualGrossValue,
  EntldGrossVolumeStsCritlty,
  EntldGrossVolume,
  BaselineEntldGrossVolume,
  EntldGrossValueStsCritlty,
  EntldGrossValue,
  BaselineEntldGrossValue,
  ActualVolReducnStsCritlty,
  ActualVolReducn,
  BaselineActualVolReducn,
  EntitledVolReducnStsCritlty,
  EntitledVolReducn,
  BaselineEntitledVolReducn,
  ActualEnergyStsCritlty,
  ActualEnergy,
  BaselineActualEnergy,
  ActualPriceStsCritlty,
  SalesPriceAmount,
  BaselineSalesPriceAmount,
  EntitledEnergyStsCritlty,
  EntitledEnergy,
  BaselineEntitledEnergy,
  ActualEngyReducnStsCritlty,
  ActualEnergyReducn,
  BaselineActualEngyReducn,
  EntldEngyReducnStsCritlty,
  EntitledEngyReducn,
  BaselineEntldEngyReducn
FROM I_PRATstCombinedHdrCompareUI
;

Learn More