UPOV_PR_FLD_UOM

DDL: UPO_INT_V_FIELD_UOM SQL: UPOS_PR_FLD_UOM Type: view
9 Fields 2 Data Sources

Field UOM Data

UPOV_PR_FLD_UOM is a CDS View that provides data about "Field UOM Data" in SAP S/4HANA. It reads from 2 data sources (upot_int_entity, gho_prdenty_type) and exposes 9 fields with key field FIELD.

Data Sources (2)

SourceAliasJoin Type
upot_int_entity field_id left_outer
gho_prdenty_type prodenttype from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_PR_FLD_UOM 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 Field UOM Data view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FIELD
NAME
SHTXT
MAJPD_CD gho_prdenty_type major_product_cd Major Product
WATER_DEPTH gho_prdenty_type water_depth Water depth
WATER_DEPTH_U gho_prdenty_type water_dpth_unit Water Depth Unit
FL_GRP
OIU_CRUSER gho_prdenty_type ernam User Name
clientNULLasOIU_TIMESTAMP

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_PR_FLD_UOM.
-- 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_FLD_UOM

CREATE VIEW UPOV_PR_FLD_UOM AS
SELECT
  cast(field_id.converted_label as oiu_fieldid) AS FIELD,
  cast (prodenttype.descr as oiu_fl_nm) AS NAME,
  cast (UPPER(prodenttype.descr) as oiu_shtxt) AS SHTXT,
  prodenttype.major_product_cd AS MAJPD_CD,
  prodenttype.water_depth AS WATER_DEPTH,
  prodenttype.water_dpth_unit AS WATER_DEPTH_U,
  cast('' as oiu_fl_grp) AS FL_GRP,
  prodenttype.ernam AS OIU_CRUSER,
  dats_tims_to_tstmp(prodenttype.erdat, cast('000000' as abap.tims), 'UTC', $session.client, 'NULL') as OIU_TIMESTAMP AS clientNULLasOIU_TIMESTAMP
FROM gho_prdenty_type AS prodenttype
LEFT OUTER JOIN upot_int_entity AS field_id ON /* join condition not captured in parsed metadata */
;

Learn More