A_PRAWellCompletionVolHdr

DDL: A_PRAWELLCOMPLETIONVOLHDR Type: view_entity CONSUMPTION

Consumption : PRA WC Volume Hdr Record

A_PRAWellCompletionVolHdr is a Consumption CDS View that provides data about "Consumption : PRA WC Volume Hdr Record" in SAP S/4HANA. It reads from 1 data source (R_PRAWellCompletionVolHdrTP) and exposes 42 fields with key fields WellCompltnVolDoc, WellCompltnVolDocYr.

Data Sources (1)

SourceAliasJoin Type
R_PRAWellCompletionVolHdrTP R_PRAWellCompletionVolHdrTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consumption : PRA WC Volume Hdr Record view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name PRAWellCompletionVolumes_Type view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY WellCompltnVolDoc WellCompltnVolDoc
KEY WellCompltnVolDocYr WellCompltnVolDocYr
Well Well Well
WellCompletion WellCompletion Well Completion
DeliveryNetwork DeliveryNetwork Delivery network ID
EffectiveValidityStartDate EffectiveValidityStartDate
EffectiveValidityEndDate EffectiveValidityEndDate
ProductionDate ProductionDate Production Date
ReclassifiedMaterial ReclassifiedMaterial
Material Material Vehicle Model
AllocationFrequency AllocationFrequency
TankBatteryMeasurementPt TankBatteryMeasurementPt
VolumeType VolumeType Volume Type
VolumeClass VolumeClass
VolumeSource VolumeSource
Transporter Transporter Partner
TransporterReference TransporterReference
TicketNumber TicketNumber
TicketDateTime TicketDateTime
OriginatingMeasurementPt OriginatingMeasurementPt
ConversionGroup ConversionGroup Conv. Group
DensityType DensityType Dens. Type
InventoryDate InventoryDate
CrossRefWell CrossRefWell
CrossRefWellCompletion CrossRefWellCompletion
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
OriginTransaction OriginTransaction
StandardVolUnit StandardVolUnit
EnergyUnit EnergyUnit
ThrtclVolUnit ThrtclVolUnit
HeatingValUnit HeatingValUnit
StandardDensityUnit StandardDensityUnit
HeatingValue HeatingValue
StandardDensity StandardDensity
NmbrOfDaysProduced NmbrOfDaysProduced
NmbrOfHoursProduced NmbrOfHoursProduced
NumberOfItems NumberOfItems
TheoreticalVolume TheoreticalVolume
StandardVolume StandardVolume
Energy Energy Energy Qty.
GasMolarVolume GasMolarVolume

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 A_PRAWellCompletionVolHdr.
-- 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 A_PRAWellCompletionVolHdr AS
SELECT
  WellCompltnVolDoc,
  WellCompltnVolDocYr,
  Well,
  WellCompletion,
  DeliveryNetwork,
  EffectiveValidityStartDate,
  EffectiveValidityEndDate,
  ProductionDate,
  ReclassifiedMaterial,
  Material,
  AllocationFrequency,
  TankBatteryMeasurementPt,
  VolumeType,
  VolumeClass,
  VolumeSource,
  Transporter,
  TransporterReference,
  TicketNumber,
  TicketDateTime,
  OriginatingMeasurementPt,
  ConversionGroup,
  DensityType,
  InventoryDate,
  CrossRefWell,
  CrossRefWellCompletion,
  CreatedByUser,
  CreationDateTime,
  OriginTransaction,
  StandardVolUnit,
  EnergyUnit,
  ThrtclVolUnit,
  HeatingValUnit,
  StandardDensityUnit,
  HeatingValue,
  StandardDensity,
  NmbrOfDaysProduced,
  NmbrOfHoursProduced,
  NumberOfItems,
  TheoreticalVolume,
  StandardVolume,
  Energy,
  GasMolarVolume
FROM R_PRAWellCompletionVolHdrTP
;