I_PRAMeasurementDocument

DDL: I_PRAMEASUREMENTDOCUMENT Type: view BASIC
19 Fields 1 Data Sources 1 Associations

PRA Measurement Document

I_PRAMeasurementDocument is a Basic CDS View (Cube) that provides data about "PRA Measurement Document" in SAP S/4HANA. It reads from 1 data source (oiu_me_medoc) and exposes 19 fields with key fields PRAMeasurementDocumentNumber, MeasurementDocYear. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
oiu_me_medoc oiu_me_medoc from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_PRAMeasurementDocumentItem _PRAMeasurementDocumentItem

Annotations (16)

NameValueLevelField
EndUserText.label PRA Measurement Document view
AbapCatalog.sqlViewName IPRAMEASDOCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
Analytics.dataExtraction.enabled true view
Analytics.dataCategory #CUBE view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PRAMeasurementDocumentNumber docnr Well doc.no.
KEY MeasurementDocYear docyr Year
PRAMeasurementClass mecls Meas.Class
PRAMeasurementType metyp UoM Load Cat.
PRAMeasurementObjectNumber objnr Val. Obj. No.
PRAMeasurementSource mesrc Meas. Source
PRAMeasurementSourceKey srcky Source Key
PRASourceDocumentNumber src_docnr Source Doc.
PRASourceDocumentYear src_docyr Source Year
PRAUnitOfMeasureGroup uomgr UoM Group
ConversionGroup umrsl Conv. Group
PRAMeasurementYear meayr Year
PRAMeasurementPeriod meapd Msmt.Period
PRAMeasurementTimeStamp meats Timestamp
DocumentIsChangedFlag xchng Changed
DocumentIsDeletedFlag xdelt Deletion Ind.
CreatedByUser oiu_cruser Created By
PRACreationDateTime oiu_timestamp Timestamp
_PRAMeasurementDocumentItem _PRAMeasurementDocumentItem

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_PRAMeasurementDocument.
-- 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_PRAMeasurementDocument AS
SELECT
  docnr AS PRAMeasurementDocumentNumber,
  docyr AS MeasurementDocYear,
  mecls AS PRAMeasurementClass,
  metyp AS PRAMeasurementType,
  objnr AS PRAMeasurementObjectNumber,
  mesrc AS PRAMeasurementSource,
  srcky AS PRAMeasurementSourceKey,
  src_docnr AS PRASourceDocumentNumber,
  src_docyr AS PRASourceDocumentYear,
  uomgr AS PRAUnitOfMeasureGroup,
  umrsl AS ConversionGroup,
  meayr AS PRAMeasurementYear,
  meapd AS PRAMeasurementPeriod,
  meats AS PRAMeasurementTimeStamp,
  xchng AS DocumentIsChangedFlag,
  xdelt AS DocumentIsDeletedFlag,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS PRACreationDateTime
FROM oiu_me_medoc
LEFT OUTER JOIN I_PRAMeasurementDocumentItem AS _PRAMeasurementDocumentItem ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More