A_PRAMsmtDocWellCompltn

DDL: A_PRAMSMTDOCWELLCOMPLTN Type: view_entity CONSUMPTION Package: OIU_ODATA_PRD_VOL
18 Fields 1 Data Sources

PRA Measurement Document-WellCompletion

A_PRAMsmtDocWellCompltn is a Consumption CDS View that provides data about "PRA Measurement Document-WellCompletion" in SAP S/4HANA. It reads from 1 data source (R_PRAMsmtDocWellCompltnTP) and exposes 18 fields with key fields PRAMeasurementDocumentNumber, MeasurementDocYear. Part of development package OIU_ODATA_PRD_VOL.

Data Sources (1)

SourceAliasJoin Type
R_PRAMsmtDocWellCompltnTP R_PRAMsmtDocWellCompltnTP from

Annotations (9)

NameValueLevelField
EndUserText.label PRA Measurement Document-WellCompletion view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name PRAMeasurementDocument_Type view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PRAMeasurementDocumentNumber PRAMeasurementDocumentNumber
KEY MeasurementDocYear MeasurementDocYear
PRAMeasurementClass PRAMeasurementClass
PRAMeasurementType PRAMeasurementType
PRAMeasurementObjectNumber PRAMeasurementObjectNumber
PRAMeasurementSource PRAMeasurementSource
PRAMeasurementSourceKey PRAMeasurementSourceKey
PRASourceDocumentNumber PRASourceDocumentNumber
PRASourceDocumentYear PRASourceDocumentYear
PRAUnitOfMeasureGroup PRAUnitOfMeasureGroup
ConversionGroup ConversionGroup Conv. Group
PRAMeasurementYear PRAMeasurementYear
PRAMeasurementPeriod PRAMeasurementPeriod
PRAMeasurementTimeStamp PRAMeasurementTimeStamp
DocumentIsChangedFlag DocumentIsChangedFlag
DocumentIsDeletedFlag DocumentIsDeletedFlag
CreatedByUser CreatedByUser User Name
PRACreationDateTime PRACreationDateTime Time Stamp

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 A_PRAMsmtDocWellCompltn.
-- 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 A_PRAMsmtDocWellCompltn AS
SELECT
  PRAMeasurementDocumentNumber,
  MeasurementDocYear,
  PRAMeasurementClass,
  PRAMeasurementType,
  PRAMeasurementObjectNumber,
  PRAMeasurementSource,
  PRAMeasurementSourceKey,
  PRASourceDocumentNumber,
  PRASourceDocumentYear,
  PRAUnitOfMeasureGroup,
  ConversionGroup,
  PRAMeasurementYear,
  PRAMeasurementPeriod,
  PRAMeasurementTimeStamp,
  DocumentIsChangedFlag,
  DocumentIsDeletedFlag,
  CreatedByUser,
  PRACreationDateTime
FROM R_PRAMsmtDocWellCompltnTP
;

Learn More