C_PRATstActlSecdryDets

DDL: C_PRATSTACTLSECDRYDETS SQL: CPRATSTASPD Type: view CONSUMPTION
32 Fields 1 Data Sources 3 Associations

CA - Actual Secdry Product Details tab

C_PRATstActlSecdryDets is a Consumption CDS View that provides data about "CA - Actual Secdry Product Details tab" in SAP S/4HANA. It reads from 1 data source (I_PRATstActlSecdryCompareUI) and exposes 32 fields with key fields DeliveryNetwork, Well, WellCompletion, Material, PRAContract. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRATstActlSecdryCompareUI I_PRATstActlSecdryCompareUI from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PRADeliveryNetworkVH f4_dn $projection.DeliveryNetwork = f4_dn.DeliveryNetwork
[0..1] I_PRAMajorProductCodeVH f4_majpd_cd $projection.MajorProduct = f4_majpd_cd.MajorProduct
[1..1] I_PRATstContrAllocRsltsHdr _hdr $projection.DeliveryNetwork = _hdr.DeliveryNetwork and $projection.SalesDate = _hdr.SalesDate and $projection.MajorProduct = _hdr.MajorProduct

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPRATSTASPD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label CA - Actual Secdry Product Details tab view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY DeliveryNetwork DeliveryNetwork Delivery network ID
KEY Well Well Well
KEY WellCompletion WellCompletion Well Completion
KEY Material Material Vehicle Model
KEY PRAContract PRAContract Contract
KEY SalesDate SalesDate Sales Date
KEY PRAOwner PRAOwner
KEY OwnerInterestType OwnerInterestType
KEY OriginatingMeasurementPt OriginatingMeasurementPt
KEY Transporter Transporter Partner
DeliveryNetworkName _hdr DeliveryNetworkName
MajorProduct MajorProduct Major Product
ActlSecdryStatusCritlty _hdr ActlSecdryStatusCritlty
ActlSecdryStatusText _hdr ActlSecdryStatusText Actual Residue & NGL Status
ActualVolumeStsCritlty ActualVolumeStsCritlty
BaselineActualVolume BaselineActualVolume
ActualVolume ActualVolume
VolumeUnit VolumeUnit Volume Unit
ActualHeatingValueStsCritlty ActualHeatingValueStsCritlty
BaselineActualHeatingValue BaselineActualHeatingValue
ActualHeatingValue ActualHeatingValue
HeatingValUnit HeatingValUnit
ActualEnergyStsCritlty ActualEnergyStsCritlty
BaselineActualEnergy BaselineActualEnergy
ActualEnergy ActualEnergy
EnergyUnit EnergyUnit
EntitledVolumeStsCritlty EntitledVolumeStsCritlty
BaselineEntitledVolume BaselineEntitledVolume
EntitledVolume EntitledVolume
EntitledEnergyStsCritlty EntitledEnergyStsCritlty
BaselineEntitledEnergy BaselineEntitledEnergy
EntitledEnergy EntitledEnergy

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_PRATstActlSecdryDets.
-- 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: CPRATSTASPD

CREATE VIEW C_PRATstActlSecdryDets AS
SELECT
  DeliveryNetwork,
  Well,
  WellCompletion,
  Material,
  PRAContract,
  SalesDate,
  PRAOwner,
  OwnerInterestType,
  OriginatingMeasurementPt,
  Transporter,
  _hdr.DeliveryNetworkName AS DeliveryNetworkName,
  MajorProduct,
  _hdr.ActlSecdryStatusCritlty AS ActlSecdryStatusCritlty,
  _hdr.ActlSecdryStatusText AS ActlSecdryStatusText,
  ActualVolumeStsCritlty,
  BaselineActualVolume,
  ActualVolume,
  VolumeUnit,
  ActualHeatingValueStsCritlty,
  BaselineActualHeatingValue,
  ActualHeatingValue,
  HeatingValUnit,
  ActualEnergyStsCritlty,
  BaselineActualEnergy,
  ActualEnergy,
  EnergyUnit,
  EntitledVolumeStsCritlty,
  BaselineEntitledVolume,
  EntitledVolume,
  EntitledEnergyStsCritlty,
  BaselineEntitledEnergy,
  EntitledEnergy
FROM I_PRATstActlSecdryCompareUI
LEFT OUTER JOIN I_PRADeliveryNetworkVH AS f4_dn ON DeliveryNetwork = f4_dn.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_PRAMajorProductCodeVH AS f4_majpd_cd ON MajorProduct = f4_majpd_cd.MajorProduct  -- association [0..1]
LEFT OUTER JOIN I_PRATstContrAllocRsltsHdr AS _hdr ON DeliveryNetwork = _hdr.DeliveryNetwork AND SalesDate = _hdr.SalesDate AND MajorProduct = _hdr.MajorProduct  -- association [1..1]
;

Learn More