UPOV_WCDPS_MEATYPE_FLD

DDL: UPO_INT_V_WCDPS_MEAS_TYPE_FLD SQL: UPOS_WCDPMEAFLD Type: view
6 Fields 2 Data Sources

WCDPS Measurement field

UPOV_WCDPS_MEATYPE_FLD is a CDS View that provides data about "WCDPS Measurement field" in SAP S/4HANA. It reads from 2 data sources (upoc_int_mrid, oiu_me_mtype_ft) and exposes 6 fields.

Data Sources (2)

SourceAliasJoin Type
upoc_int_mrid MeasId inner
oiu_me_mtype_ft MeasType from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_WCDPMEAFLD view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label WCDPS Measurement field view

Fields (6)

KeyFieldSource TableSource FieldDescription
mecls oiu_me_mtype_ft mecls Meas.Class
metyp oiu_me_mtype_ft metyp UoM Load Cat.
rdgid oiu_me_mtype_ft rdgid Meas.Reading ID
measmnt upoc_int_mrid measmnt Measurement
fldnm_r oiu_me_mtype_ft fldnm_r Rdg field
fldnm_u oiu_me_mtype_ft fldnm_u Unit field

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_WCDPS_MEATYPE_FLD.
-- 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_WCDPMEAFLD

CREATE VIEW UPOV_WCDPS_MEATYPE_FLD AS
SELECT
  MeasType.mecls AS mecls,
  MeasType.metyp AS metyp,
  MeasType.rdgid AS rdgid,
  MeasId.measmnt AS measmnt,
  MeasType.fldnm_r AS fldnm_r,
  MeasType.fldnm_u AS fldnm_u
FROM oiu_me_mtype_ft AS MeasType
INNER JOIN upoc_int_mrid AS MeasId ON /* join condition not captured in parsed metadata */
;

Learn More