UPOV_WELLTEST_MEASUREDVAL

DDL: UPO_INT_V_WELLTEST_MEASUREDVAL SQL: UPOS_PR_WTMEASRD Type: view
4 Fields 4 Data Sources

Sample Readings of a Well / WC Test

UPOV_WELLTEST_MEASUREDVAL is a CDS View that provides data about "Sample Readings of a Well / WC Test" in SAP S/4HANA. It reads from 4 data sources (cabn, qamv, gho_measdt, qasr) and exposes 4 fields with key fields InspectionLot, Characterstic.

Data Sources (4)

SourceAliasJoin Type
cabn CharactName inner
qamv InspChar from
gho_measdt Measurements inner
qasr SampleReading inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_PR_WTMEASRD view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Sample Readings of a Well / WC Test view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot qamv prueflos Inspection Lot
KEY Characterstic cabn atnam Characteristic
RawValue qasr mittelwert Mean Value
MeasuringUnit qamv masseinhsw Unit of Meas.

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 UPOV_WELLTEST_MEASUREDVAL.
-- 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.
-- SQL view name: UPOS_PR_WTMEASRD

CREATE VIEW UPOV_WELLTEST_MEASUREDVAL AS
SELECT
  InspChar.prueflos AS InspectionLot,
  CharactName.atnam AS Characterstic,
  SampleReading.mittelwert AS RawValue,
  InspChar.masseinhsw AS MeasuringUnit
FROM qamv AS InspChar
INNER JOIN qasr AS SampleReading ON /* join condition not captured in parsed metadata */
INNER JOIN cabn AS CharactName ON /* join condition not captured in parsed metadata */
INNER JOIN gho_measdt AS Measurements ON /* join condition not captured in parsed metadata */
;

Learn More