R_PRAMsmtDocPrssrItmTP

DDL: R_PRAMSMTDOCPRSSRITMTP Type: view_entity TRANSACTIONAL
19 Fields 3 Data Sources

PRA WC Daily Pressure Item - RAP

R_PRAMsmtDocPrssrItmTP is a Transactional CDS View that provides data about "PRA WC Daily Pressure Item - RAP" in SAP S/4HANA. It reads from 3 data sources (R_PRAMeasurementDocumentItmTP, R_PRAMsmtDocPrssrTP, R_PRAWellCompltnPrssrHdrTP) and exposes 19 fields with key fields PRAMeasurementDocumentNumber, MeasurementDocYear, MeasurementReadingIdentifier.

Data Sources (3)

SourceAliasJoin Type
R_PRAMeasurementDocumentItmTP R_PRAMeasurementDocumentItmTP from
R_PRAMsmtDocPrssrTP R_PRAMsmtDocPrssrTP inner
R_PRAWellCompltnPrssrHdrTP R_PRAWellCompltnPrssrHdrTP inner

Annotations (12)

NameValueLevelField
EndUserText.label PRA WC Daily Pressure Item - RAP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name MeasurementDocumentItem_Type view
OData.entitySet.name MeasurementDocumentItem view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name PRAMeasurementDocumentItem view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PRAMeasurementDocumentNumber R_PRAMeasurementDocumentItmTP PRAMeasurementDocumentNumber
KEY MeasurementDocYear R_PRAMeasurementDocumentItmTP MeasurementDocYear
KEY MeasurementReadingIdentifier R_PRAMeasurementDocumentItmTP MeasurementReadingIdentifier
PRAReadingType R_PRAMeasurementDocumentItmTP PRAReadingType
PRAReadingTypeFormat R_PRAMeasurementDocumentItmTP PRAReadingTypeFormat
PRAMeasurementReadingTxt R_PRAMeasurementDocumentItmTP PRAMeasurementReadingTxt
MeasurementReadingUnit R_PRAMeasurementDocumentItmTP MeasurementReadingUnit
PRAIsObservedValueFlag R_PRAMeasurementDocumentItmTP PRAIsObservedValueFlag
PRANullValueFlag R_PRAMeasurementDocumentItmTP PRANullValueFlag
PRAMeasurementRdngIsHidnFlag R_PRAMeasurementDocumentItmTP PRAMeasurementRdngIsHidnFlag
PRAReadingDisplayFormat R_PRAMeasurementDocumentItmTP PRAReadingDisplayFormat
PRAReadingDisplayLengthTxt R_PRAMeasurementDocumentItmTP PRAReadingDisplayLengthTxt
PRAReadingDisplayDecimals R_PRAMeasurementDocumentItmTP PRAReadingDisplayDecimals
PRASourceDocumentNumber R_PRAMsmtDocPrssrTP PRASourceDocumentNumber
PRASourceDocumentYear R_PRAMsmtDocPrssrTP PRASourceDocumentYear
Well R_PRAWellCompltnPrssrHdrTP Well Well
WellCompletion R_PRAWellCompltnPrssrHdrTP WellCompletion Well Completion
PRAEffectiveFromDateTime R_PRAWellCompltnPrssrHdrTP PRAEffectiveFromDateTime
_PRAWellCompltnPrssrHdrTP _PRAWellCompltnPrssrHdrTP

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 R_PRAMsmtDocPrssrItmTP.
-- 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 R_PRAMsmtDocPrssrItmTP AS
SELECT
  R_PRAMeasurementDocumentItmTP.PRAMeasurementDocumentNumber AS PRAMeasurementDocumentNumber,
  R_PRAMeasurementDocumentItmTP.MeasurementDocYear AS MeasurementDocYear,
  R_PRAMeasurementDocumentItmTP.MeasurementReadingIdentifier AS MeasurementReadingIdentifier,
  R_PRAMeasurementDocumentItmTP.PRAReadingType AS PRAReadingType,
  R_PRAMeasurementDocumentItmTP.PRAReadingTypeFormat AS PRAReadingTypeFormat,
  R_PRAMeasurementDocumentItmTP.PRAMeasurementReadingTxt AS PRAMeasurementReadingTxt,
  R_PRAMeasurementDocumentItmTP.MeasurementReadingUnit AS MeasurementReadingUnit,
  R_PRAMeasurementDocumentItmTP.PRAIsObservedValueFlag AS PRAIsObservedValueFlag,
  R_PRAMeasurementDocumentItmTP.PRANullValueFlag AS PRANullValueFlag,
  R_PRAMeasurementDocumentItmTP.PRAMeasurementRdngIsHidnFlag AS PRAMeasurementRdngIsHidnFlag,
  R_PRAMeasurementDocumentItmTP.PRAReadingDisplayFormat AS PRAReadingDisplayFormat,
  R_PRAMeasurementDocumentItmTP.PRAReadingDisplayLengthTxt AS PRAReadingDisplayLengthTxt,
  R_PRAMeasurementDocumentItmTP.PRAReadingDisplayDecimals AS PRAReadingDisplayDecimals,
  R_PRAMsmtDocPrssrTP.PRASourceDocumentNumber AS PRASourceDocumentNumber,
  R_PRAMsmtDocPrssrTP.PRASourceDocumentYear AS PRASourceDocumentYear,
  R_PRAWellCompltnPrssrHdrTP.Well AS Well,
  R_PRAWellCompltnPrssrHdrTP.WellCompletion AS WellCompletion,
  R_PRAWellCompltnPrssrHdrTP.PRAEffectiveFromDateTime AS PRAEffectiveFromDateTime
FROM R_PRAMeasurementDocumentItmTP
INNER JOIN R_PRAMsmtDocPrssrTP ON /* join condition not captured in parsed metadata */
INNER JOIN R_PRAWellCompltnPrssrHdrTP ON /* join condition not captured in parsed metadata */
;

Learn More