R_PRAMsmtDocMsmtPtItmTP

DDL: R_PRAMSMTDOCMSMTPTITMTP Type: view_entity TRANSACTIONAL
16 Fields 2 Data Sources

PRA Measurement Doc Item-MPVolume

R_PRAMsmtDocMsmtPtItmTP is a Transactional CDS View that provides data about "PRA Measurement Doc Item-MPVolume" in SAP S/4HANA. It reads from 2 data sources (R_PRAMeasurementDocMsmtPtTP, R_PRAMeasurementDocumentItmTP) and exposes 16 fields with key fields PRAMeasurementDocumentNumber, MeasurementDocYear, MeasurementReadingIdentifier.

Data Sources (2)

SourceAliasJoin Type
R_PRAMeasurementDocMsmtPtTP R_PRAMeasurementDocMsmtPtTP inner
R_PRAMeasurementDocumentItmTP R_PRAMeasurementDocumentItmTP from

Annotations (12)

NameValueLevelField
EndUserText.label PRA Measurement Doc Item-MPVolume 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 (16)

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_PRAMeasurementDocMsmtPtTP PRASourceDocumentNumber
PRASourceDocumentYear R_PRAMeasurementDocMsmtPtTP PRASourceDocumentYear
_PRAMeasurementPointVolHdrTP _PRAMeasurementPointVolHdrTP

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_PRAMsmtDocMsmtPtItmTP.
-- 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_PRAMsmtDocMsmtPtItmTP 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_PRAMeasurementDocMsmtPtTP.PRASourceDocumentNumber AS PRASourceDocumentNumber,
  R_PRAMeasurementDocMsmtPtTP.PRASourceDocumentYear AS PRASourceDocumentYear
FROM R_PRAMeasurementDocumentItmTP
INNER JOIN R_PRAMeasurementDocMsmtPtTP ON /* join condition not captured in parsed metadata */
;

Learn More