C_PRATstProdnRsltsDet

DDL: C_PRATSTPRODNRSLTSDET SQL: CPRATPRD Type: view CONSUMPTION Package: OIU_TV
34 Fields 1 Data Sources

TV - Production Detail View

C_PRATstProdnRsltsDet is a Consumption CDS View that provides data about "TV - Production Detail View" in SAP S/4HANA. It reads from 1 data source (I_PRATstProdnCompareUI) and exposes 34 fields with key fields PRATstAllocVersion, WellCompltnVolDoc, WellCompltnVolDocYr. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstProdnCompareUI ui from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPRATPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label TV - Production Detail View view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY PRATstAllocVersion I_PRATstProdnCompareUI PRATstAllocVersion
KEY WellCompltnVolDoc I_PRATstProdnCompareUI WellCompltnVolDoc
KEY WellCompltnVolDocYr I_PRATstProdnCompareUI WellCompltnVolDocYr
DeliveryNetwork I_PRATstProdnCompareUI DeliveryNetwork Delivery network ID
ProductionDate I_PRATstProdnCompareUI ProductionDate Production Date
MajorProduct I_PRATstProdnCompareUI MajorProduct Major Product
Material I_PRATstProdnCompareUI Material Vehicle Model
Well I_PRATstProdnCompareUI Well Well
WellCompletion I_PRATstProdnCompareUI WellCompletion Well Completion
VolumeType I_PRATstProdnCompareUI VolumeType Volume Type
TicketNumber I_PRATstProdnCompareUI TicketNumber
Transporter I_PRATstProdnCompareUI Transporter Partner
EffectiveValidityStartDate I_PRATstProdnCompareUI EffectiveValidityStartDate
InventoryDate I_PRATstProdnCompareUI InventoryDate
OriginatingMeasurementPt I_PRATstProdnCompareUI OriginatingMeasurementPt
ActualVolumeStsCritlty ActualVolumeStsCritlty
BaselineStandardVolume I_PRATstProdnCompareUI BaselineStandardVolume
StandardVolume I_PRATstProdnCompareUI StandardVolume
StandardVolUnit I_PRATstProdnCompareUI StandardVolUnit
ActualEnergyStsCritlty ActualEnergyStsCritlty
BaselineEnergy I_PRATstProdnCompareUI BaselineEnergy
Energy I_PRATstProdnCompareUI Energy Energy Qty.
EnergyUnit I_PRATstProdnCompareUI EnergyUnit
ActualHeatingValueStsCritlty ActualHeatingValueStsCritlty
BaselineHeatingValue I_PRATstProdnCompareUI BaselineHeatingValue
HeatingValue I_PRATstProdnCompareUI HeatingValue
HeatingValUnit I_PRATstProdnCompareUI HeatingValUnit
BslnNmbrOfDaysProduced I_PRATstProdnCompareUI BslnNmbrOfDaysProduced
NmbrOfDaysProduced I_PRATstProdnCompareUI NmbrOfDaysProduced
BaselineMaterial I_PRATstProdnCompareUI BaselineMaterial
StdDensStsCritlty StdDensStsCritlty
BaselineStandardDensity I_PRATstProdnCompareUI BaselineStandardDensity
StandardDensity I_PRATstProdnCompareUI StandardDensity
StandardDensityUnit I_PRATstProdnCompareUI StandardDensityUnit Standard Density 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_PRATstProdnRsltsDet.
-- 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: CPRATPRD

CREATE VIEW C_PRATstProdnRsltsDet AS
SELECT
  ui.PRATstAllocVersion AS PRATstAllocVersion,
  ui.WellCompltnVolDoc AS WellCompltnVolDoc,
  ui.WellCompltnVolDocYr AS WellCompltnVolDocYr,
  ui.DeliveryNetwork AS DeliveryNetwork,
  ui.ProductionDate AS ProductionDate,
  ui.MajorProduct AS MajorProduct,
  ui.Material AS Material,
  ui.Well AS Well,
  ui.WellCompletion AS WellCompletion,
  ui.VolumeType AS VolumeType,
  ui.TicketNumber AS TicketNumber,
  ui.Transporter AS Transporter,
  ui.EffectiveValidityStartDate AS EffectiveValidityStartDate,
  ui.InventoryDate AS InventoryDate,
  ui.OriginatingMeasurementPt AS OriginatingMeasurementPt,
  ActualVolumeStsCritlty,
  ui.BaselineStandardVolume AS BaselineStandardVolume,
  ui.StandardVolume AS StandardVolume,
  ui.StandardVolUnit AS StandardVolUnit,
  ActualEnergyStsCritlty,
  ui.BaselineEnergy AS BaselineEnergy,
  ui.Energy AS Energy,
  ui.EnergyUnit AS EnergyUnit,
  ActualHeatingValueStsCritlty,
  ui.BaselineHeatingValue AS BaselineHeatingValue,
  ui.HeatingValue AS HeatingValue,
  ui.HeatingValUnit AS HeatingValUnit,
  ui.BslnNmbrOfDaysProduced AS BslnNmbrOfDaysProduced,
  ui.NmbrOfDaysProduced AS NmbrOfDaysProduced,
  ui.BaselineMaterial AS BaselineMaterial,
  StdDensStsCritlty,
  ui.BaselineStandardDensity AS BaselineStandardDensity,
  ui.StandardDensity AS StandardDensity,
  ui.StandardDensityUnit AS StandardDensityUnit
FROM I_PRATstProdnCompareUI AS ui
;

Learn More