I_PRAWellMsmtDocumentItem

DDL: I_PRAWELLMSMTDOCUMENTITEM Type: view_entity BASIC
17 Fields 2 Data Sources

PRA Well Measurement Document Item

I_PRAWellMsmtDocumentItem is a Basic CDS View that provides data about "PRA Well Measurement Document Item" in SAP S/4HANA. It reads from 2 data sources (oiu_me_medoc, oiu_me_medoc_it) and exposes 17 fields with key fields Well, PRAMeasurementDocumentNumber, MeasurementDocYear, MeasurementReadingIdentifier.

Data Sources (2)

SourceAliasJoin Type
oiu_me_medoc oiu_me_medoc inner
oiu_me_medoc_it oiu_me_medoc_it from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label PRA Well Measurement Document Item view
ObjectModel.sapObjectNodeType.name PRAMeasurementDocumentItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Well _Well Well Well
KEY PRAMeasurementDocumentNumber oiu_me_medoc_it docnr Well doc.no.
KEY MeasurementDocYear oiu_me_medoc_it docyr Year
KEY MeasurementReadingIdentifier oiu_me_medoc_it rdgid Meas.Reading ID
PRAReadingType oiu_me_medoc_it retyp Read.Type
PRAReadingTypeFormat oiu_me_medoc_it refmt Fmt
PRAMeasurementReadingTxt oiu_me_medoc_it merdg Reading
MeasurementReadingUnit oiu_me_medoc_it runit Unit/Area
PRAIsObservedValueFlag oiu_me_medoc_it xvobs Obs
PRANullValueFlag oiu_me_medoc_it xnval N.Val
PRAMeasurementRdngIsHidnFlag oiu_me_medoc_it xhide Hide
PRAReadingDisplayFormat oiu_me_medoc_it rdfmt Format
PRAReadingDisplayLengthTxt
PRAReadingDisplayDecimals oiu_me_medoc_it rddec Dec
PRASourceDocumentNumber oiu_me_medoc src_docnr Source Doc.
PRASourceDocumentYear oiu_me_medoc src_docyr Source Year
_Well _Well

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_PRAWellMsmtDocumentItem.
-- 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_PRAWellMsmtDocumentItem AS
SELECT
  _Well.Well AS Well,
  oiu_me_medoc_it.docnr AS PRAMeasurementDocumentNumber,
  oiu_me_medoc_it.docyr AS MeasurementDocYear,
  oiu_me_medoc_it.rdgid AS MeasurementReadingIdentifier,
  oiu_me_medoc_it.retyp AS PRAReadingType,
  oiu_me_medoc_it.refmt AS PRAReadingTypeFormat,
  oiu_me_medoc_it.merdg AS PRAMeasurementReadingTxt,
  oiu_me_medoc_it.runit AS MeasurementReadingUnit,
  oiu_me_medoc_it.xvobs AS PRAIsObservedValueFlag,
  oiu_me_medoc_it.xnval AS PRANullValueFlag,
  oiu_me_medoc_it.xhide AS PRAMeasurementRdngIsHidnFlag,
  oiu_me_medoc_it.rdfmt AS PRAReadingDisplayFormat,
  cast( oiu_me_medoc_it.rdlen as char3 ) AS PRAReadingDisplayLengthTxt,
  oiu_me_medoc_it.rddec AS PRAReadingDisplayDecimals,
  oiu_me_medoc.src_docnr AS PRASourceDocumentNumber,
  oiu_me_medoc.src_docyr AS PRASourceDocumentYear
FROM oiu_me_medoc_it
INNER JOIN oiu_me_medoc ON /* join condition not captured in parsed metadata */
;

Learn More