UPOV_MEASDOC_DTL

@AbapCatalog.sqlViewName: 'UPOS_MEASDOC_DTL'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Measurement document Details'
define view UPOV_MEASDOC_DTL
  as select distinct from gho_allocres_h   as header_res
    inner join            gho_imrg_std_h   as std_h    on std_h.netid = header_res.netid
    inner join            gho_iflot_ext    as iflot    on iflot.tplnr = std_h.netid
    inner join            gho_imrg_ext     as imrg_ext on imrg_ext.mdocm = std_h.mdocm
  //and imrg_ext.measmnt_qty_type = '01'

    inner join            gho_imptt_ext    as imptt    on  imptt.measmnt_point    = imrg_ext.measmnt_point
                                                       and imptt.measmnt_freq     = 'M'
                                                       and imptt.measmnt_qty_type = std_h.quantity_type
    inner join            upot_int_mpvnqci as mpvl     on mpvl.bus_key = std_h.bus_key

{
  std_h.netid                                                                                                                                                                                                                                                      as netid,
  std_h.netobj                                                                                                                                                                                                                                                     as netobj,
  std_h.alloc_material                                                                                                                                                                                                                                             as alloc_material,
  std_h.quantity_type                                                                                                                                                                                                                                              as quantity_type,
  std_h.prod_timestamp                                                                                                                                                                                                                                             as prod_timestamp,
  std_h.frequency                                                                                                                                                                                                                                                  as frequency,

  imrg_ext.mdocm                                                                                                                                                                                                                                                   as mdocm,
  imrg_ext.measmnt_point                                                                                                                                                                                                                                           as measmnt_point,
  imptt.measmnt_grp                                                                                                                                                                                                                                                as measmnt_grp,
  imptt.mediu                                                                                                                                                                                                                                                      as mediu,
  mpvl.mpvl_no                                                                                                                                                                                                                                                     as mpvl_no,
  mpvl.mpvl_year                                                                                                                                                                                                                                                   as mpvl_year,
  cast(substring(tstmp_to_dats(std_h.prod_timestamp,iflot.gho_pn_tz,$session.client,'NULL'),1,6) as abap.char(6))                                                                                                                                                  as yr_mnth

}
where
      header_res.final_ind = 'X'
  and std_h.alloc_type     = '03'
  and std_h.frequency      = 'M'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GHO_ALLOCRES_H",
"GHO_IFLOT_EXT",
"GHO_IMPTT_EXT",
"GHO_IMRG_EXT",
"GHO_IMRG_STD_H",
"UPOT_INT_MPVNQCI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/