I_PRASimplePlantVolumeDetKey

DDL: I_PRASIMPLEPLANTVOLUMEDETKEY Type: view_entity COMPOSITE
29 Fields 2 Data Sources 8 Associations

PRA Simple Plant Volume Detail Key

I_PRASimplePlantVolumeDetKey is a Composite CDS View that provides data about "PRA Simple Plant Volume Detail Key" in SAP S/4HANA. It reads from 2 data sources (I_PRASimplePlantVolumeDetail, I_PRASimplePlantVolumeHeader) and exposes 29 fields with key fields DeliveryNetwork, MeasurementPoint, PRASalesDate, PRAContract, PRAMaterial. It has 8 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_PRASimplePlantVolumeDetail PRASimplePlantVolumeDetail from
I_PRASimplePlantVolumeHeader PRASimplePlantVolumeHeader inner

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_PRAContract _PRAContract _PRAContract.PRAContract = $projection.PRAContract
[0..1] I_PRAMatlMjrProdMappg _PRAMatlMjrProdMappg _PRAMatlMjrProdMappg.Material = $projection.PRAMaterial
[0..1] I_UnitOfMeasure _PRAObsvdPrssrBsdVolumeUnit _PRAObsvdPrssrBsdVolumeUnit.UnitOfMeasure = $projection.PRAObsvdPrssrBsdVolumeUnit
[0..1] I_UnitOfMeasure _PRAStandardHeatingValueUnit _PRAStandardHeatingValueUnit.UnitOfMeasure = $projection.PRAStandardHeatingValueUnit
[0..1] I_UnitOfMeasure _PRAObservedHeatingValueUnit _PRAObservedHeatingValueUnit.UnitOfMeasure = $projection.PRAObservedHeatingValueUnit
[0..1] I_UnitOfMeasure _PRAVolumeUnitOfMeasure _PRAVolumeUnitOfMeasure.UnitOfMeasure = $projection.PRAVolumeUnitOfMeasure
[0..1] I_UnitOfMeasure _PRAStandardVolumeUnit _PRAStandardVolumeUnit.UnitOfMeasure = $projection.PRAStandardVolumeUnit
[0..1] I_UnitOfMeasure _PRATemperatureUnit _PRATemperatureUnit.UnitOfMeasure = $projection.PRATemperatureUnit

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PRA Simple Plant Volume Detail Key view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
ObjectModel.sapObjectNodeType.name PRASimplePlantVolumeDetail view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY DeliveryNetwork I_PRASimplePlantVolumeHeader DeliveryNetwork Delivery network ID
KEY MeasurementPoint I_PRASimplePlantVolumeHeader MeasurementPoint Measurement Pt
KEY PRASalesDate I_PRASimplePlantVolumeHeader PRASalesDate Sales Date
KEY PRAContract I_PRASimplePlantVolumeDetail PRAContract Contract
KEY PRAMaterial I_PRASimplePlantVolumeDetail PRAMaterial Vehicle Model
PRASimplePlantVolumeNumber I_PRASimplePlantVolumeDetail PRASimplePlantVolumeNumber OORC no
PRAObsvdPrssrBsdVolumeUnit I_PRASimplePlantVolumeDetail PRAObsvdPrssrBsdVolumeUnit Obs. PB unit
PRAObsvdPrssrBsdVolume I_PRASimplePlantVolumeDetail PRAObsvdPrssrBsdVolume Obs. Pressure
PRAStandardHeatingValueUnit I_PRASimplePlantVolumeDetail PRAStandardHeatingValueUnit Std HV unit
PRAStandardHeatingValueQty I_PRASimplePlantVolumeDetail PRAStandardHeatingValueQty Standardized HV
PRAObservedHeatingValueUnit I_PRASimplePlantVolumeDetail PRAObservedHeatingValueUnit Ob. HV unit
PRAObservedHeatingValueQty I_PRASimplePlantVolumeDetail PRAObservedHeatingValueQty Observed HV
PRACalorificValueClass I_PRASimplePlantVolumeDetail PRACalorificValueClass HV class
PRAVolumeUnitOfMeasure I_PRASimplePlantVolumeDetail PRAVolumeUnitOfMeasure Unit
PRASalesVolume I_PRASimplePlantVolumeDetail PRASalesVolume Sales Volume
PRAStandardVolumeUnit I_PRASimplePlantVolumeDetail PRAStandardVolumeUnit Unit
PRAStandardVolume I_PRASimplePlantVolumeDetail PRAStandardVolume Volume
PRATemperatureUnit I_PRASimplePlantVolumeDetail PRATemperatureUnit Temp. unit
PRAObservedTemperature I_PRASimplePlantVolumeDetail PRAObservedTemperature Temperature
CreatedByUser I_PRASimplePlantVolumeDetail CreatedByUser User Name
CreationDateTime I_PRASimplePlantVolumeDetail CreationDateTime Timestamp
_PRAContract _PRAContract
_PRAMatlMjrProdMappg _PRAMatlMjrProdMappg
_PRAObsvdPrssrBsdVolumeUnit _PRAObsvdPrssrBsdVolumeUnit
_PRAStandardHeatingValueUnit _PRAStandardHeatingValueUnit
_PRAObservedHeatingValueUnit _PRAObservedHeatingValueUnit
_PRAVolumeUnitOfMeasure _PRAVolumeUnitOfMeasure
_PRAStandardVolumeUnit _PRAStandardVolumeUnit
_PRATemperatureUnit _PRATemperatureUnit

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 I_PRASimplePlantVolumeDetKey.
-- 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 I_PRASimplePlantVolumeDetKey AS
SELECT
  PRASimplePlantVolumeHeader.DeliveryNetwork AS DeliveryNetwork,
  PRASimplePlantVolumeHeader.MeasurementPoint AS MeasurementPoint,
  PRASimplePlantVolumeHeader.PRASalesDate AS PRASalesDate,
  PRASimplePlantVolumeDetail.PRAContract AS PRAContract,
  PRASimplePlantVolumeDetail.PRAMaterial AS PRAMaterial,
  PRASimplePlantVolumeDetail.PRASimplePlantVolumeNumber AS PRASimplePlantVolumeNumber,
  PRASimplePlantVolumeDetail.PRAObsvdPrssrBsdVolumeUnit AS PRAObsvdPrssrBsdVolumeUnit,
  PRASimplePlantVolumeDetail.PRAObsvdPrssrBsdVolume AS PRAObsvdPrssrBsdVolume,
  PRASimplePlantVolumeDetail.PRAStandardHeatingValueUnit AS PRAStandardHeatingValueUnit,
  PRASimplePlantVolumeDetail.PRAStandardHeatingValueQty AS PRAStandardHeatingValueQty,
  PRASimplePlantVolumeDetail.PRAObservedHeatingValueUnit AS PRAObservedHeatingValueUnit,
  PRASimplePlantVolumeDetail.PRAObservedHeatingValueQty AS PRAObservedHeatingValueQty,
  PRASimplePlantVolumeDetail.PRACalorificValueClass AS PRACalorificValueClass,
  PRASimplePlantVolumeDetail.PRAVolumeUnitOfMeasure AS PRAVolumeUnitOfMeasure,
  PRASimplePlantVolumeDetail.PRASalesVolume AS PRASalesVolume,
  PRASimplePlantVolumeDetail.PRAStandardVolumeUnit AS PRAStandardVolumeUnit,
  PRASimplePlantVolumeDetail.PRAStandardVolume AS PRAStandardVolume,
  PRASimplePlantVolumeDetail.PRATemperatureUnit AS PRATemperatureUnit,
  PRASimplePlantVolumeDetail.PRAObservedTemperature AS PRAObservedTemperature,
  PRASimplePlantVolumeDetail.CreatedByUser AS CreatedByUser,
  PRASimplePlantVolumeDetail.CreationDateTime AS CreationDateTime
FROM I_PRASimplePlantVolumeDetail AS PRASimplePlantVolumeDetail
INNER JOIN I_PRASimplePlantVolumeHeader AS PRASimplePlantVolumeHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON _PRAContract.PRAContract = PRAContract  -- association [0..1]
LEFT OUTER JOIN I_PRAMatlMjrProdMappg AS _PRAMatlMjrProdMappg ON _PRAMatlMjrProdMappg.Material = PRAMaterial  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAObsvdPrssrBsdVolumeUnit ON _PRAObsvdPrssrBsdVolumeUnit.UnitOfMeasure = PRAObsvdPrssrBsdVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAStandardHeatingValueUnit ON _PRAStandardHeatingValueUnit.UnitOfMeasure = PRAStandardHeatingValueUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAObservedHeatingValueUnit ON _PRAObservedHeatingValueUnit.UnitOfMeasure = PRAObservedHeatingValueUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAVolumeUnitOfMeasure ON _PRAVolumeUnitOfMeasure.UnitOfMeasure = PRAVolumeUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRAStandardVolumeUnit ON _PRAStandardVolumeUnit.UnitOfMeasure = PRAStandardVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PRATemperatureUnit ON _PRATemperatureUnit.UnitOfMeasure = PRATemperatureUnit  -- association [0..1]
;

Learn More