UPOV_UOM_STD_UNIT

DDL: UPO_INT_V_UOM_STD_UNIT SQL: UPOS_UOM_STD_UT Type: view

Standardized Measurement Units

UPOV_UOM_STD_UNIT is a CDS View that provides data about "Standardized Measurement Units" in SAP S/4HANA. It reads from 7 data sources and exposes 5 fields with key fields BusinessKey, Dimension.

7 data source(s) 5 fields

Data Sources (7)

SourceAliasJoin Type
t006 dimension inner
gho_imptt_ext impt inner
gho_imrg_ext imrge inner
gho_imrg_std_h Measurement_hdr from
gho_imrg_std_i Measurement_item inner
gho_uom_rule_h RuleUoMHdr inner
gho_uom_rule_i RuleUoMItem inner

Parameters (1)

NameTypeDefault
p_bus_key gho_meas_guid

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_UOM_STD_UT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Standardized Measurement Units view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BusinessKey gho_imrg_std_h bus_key
KEY Dimension t006 dimid
std_uomendasUnit
ConversionGroup gho_uom_rule_h conv_grp
StdVolume 
@AbapCatalog.sqlViewName: 'UPOS_UOM_STD_UT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#MIXED
@EndUserText.label: 'Standardized Measurement Units'
define view UPOV_UOM_STD_UNIT
  with parameters
    p_bus_key : gho_meas_guid
  as select from gho_imrg_std_h as Measurement_hdr
    inner join   gho_imrg_std_i as Measurement_item on Measurement_hdr.bus_key = Measurement_item.bus_key
    inner join   t006           as dimension        on Measurement_item.std_uom = dimension.msehi
    inner join   gho_imrg_ext   as imrge            on imrge.mdocm = Measurement_hdr.mdocm
    inner join   gho_imptt_ext  as impt             on impt.measmnt_point = imrge.measmnt_point
    inner join   gho_uom_rule_h as RuleUoMHdr       on  RuleUoMHdr.net_id     =  Measurement_hdr.netid
                                                    and RuleUoMHdr.medium     =  impt.mediu
                                                    and RuleUoMHdr.valid_from <= Measurement_hdr.prod_timestamp
                                                    and RuleUoMHdr.valid_to   >= Measurement_hdr.prod_timestamp
    inner join   gho_uom_rule_i as RuleUoMItem      on  RuleUoMItem.uom_rule_id = RuleUoMHdr.uom_rule_id
                                                    and RuleUoMItem.uom         = Measurement_item.std_uom
{
  key Measurement_hdr.bus_key                                as BusinessKey,
  key dimension.dimid                                        as Dimension,
      case
      when RuleUoMItem.dimension = dimension.dimid then RuleUoMItem.uom
      else Measurement_item.std_uom
      end                                                    as Unit,
      RuleUoMHdr.conv_grp                                    as ConversionGroup,
      cast(Measurement_item.std_val  as  abap.quan( 13, 3 )) as StdVolume
}
where
  Measurement_hdr.bus_key = :p_bus_key

Learn More