C_PRATstEntldSecdryDets

DDL: C_PRATSTENTLDSECDRYDETS SQL: CPRATSTESD Type: view CONSUMPTION Package: OIU_TV
21 Fields 1 Data Sources 3 Associations

CA - Entld Secdry Product Details tab

C_PRATstEntldSecdryDets is a Consumption CDS View that provides data about "CA - Entld Secdry Product Details tab" in SAP S/4HANA. It reads from 1 data source (I_PRATstEntldSecdryCompareUI) and exposes 21 fields with key fields DeliveryNetwork, Well, WellCompletion, Material, SalesDate. It has 3 associations to related views. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstEntldSecdryCompareUI I_PRATstEntldSecdryCompareUI 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 CPRATSTESD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label CA - Entld 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 (21)

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 Owner Interest Sequence
DeliveryNetworkName _hdr DeliveryNetworkName
MajorProduct MajorProduct Major Product
EntldSecdryStatusCritlty _hdr EntldSecdryStatusCritlty
EntldSecdryStatusText _hdr EntldSecdryStatusText Entitled Residue & NGL Status
EntitledVolumeStsCritlty EntitledVolumeStsCritlty
BaselineEntitledVolume BaselineEntitledVolume Entitled Volume(Baseline)
EntitledVolume EntitledVolume Entitled Volume
VolumeUnit VolumeUnit Volume Unit
EntitledEnergyStsCritlty EntitledEnergyStsCritlty
BaselineEntitledEnergy BaselineEntitledEnergy Entitled Energy(Baseline)
EntitledEnergy EntitledEnergy Entitled Energy
EnergyUnit EnergyUnit Energy Unit

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_PRATstEntldSecdryDets.
-- 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: CPRATSTESD

CREATE VIEW C_PRATstEntldSecdryDets AS
SELECT
  DeliveryNetwork,
  Well,
  WellCompletion,
  Material,
  SalesDate,
  VolumeType,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  _hdr.DeliveryNetworkName AS DeliveryNetworkName,
  MajorProduct,
  _hdr.EntldSecdryStatusCritlty AS EntldSecdryStatusCritlty,
  _hdr.EntldSecdryStatusText AS EntldSecdryStatusText,
  EntitledVolumeStsCritlty,
  BaselineEntitledVolume,
  EntitledVolume,
  VolumeUnit,
  EntitledEnergyStsCritlty,
  BaselineEntitledEnergy,
  EntitledEnergy,
  EnergyUnit
FROM I_PRATstEntldSecdryCompareUI
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