UPOV_PR_DNVD_UOM

@AbapCatalog.sqlViewName: 'UPOS_PR_DNVD_UOM'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Delivery Network Variable Data_UOM'
define view UPOV_PR_DNVD_UOM
  as select from    upot_udm_no_vd         as upo_novd
    inner join      upot_int_nobj          as dn_id         on dn_id.tplnr = upo_novd.tplnr
    left outer join upot_int_uomdnvd       as cavl          on  cavl.dn_no       = dn_id.converted_label
                                                            and cavl.eff_from_dt = tstmp_to_dats(
      upo_novd.effective_from, 'UTC', $session.client, 'NULL'
    )
                                                            and cavl.eff_to_dt   = tstmp_to_dats(
      upo_novd.effective_to, 'UTC', $session.client, 'NULL'
    )
    inner join      iflot                  as funcloc       on funcloc.tplnr = dn_id.tplnr
    left outer join UPOV_ALC_BASIS_FOR_PRA as alc_basis     on  alc_basis.tplnr          = upo_novd.tplnr
                                                            and alc_basis.effective_from = upo_novd.effective_from
                                                            and alc_basis.effective_to   = upo_novd.effective_to
    inner join      gho_iflot_ext          as functionalloc on  functionalloc.tplnr           = upo_novd.tplnr
                                                            and functionalloc.gho_netobj_type = upo_novd.gho_netobj_type

{
  key cast(dn_id.converted_label as oiu_dn_no)                                                        as   DN_NO, // Network id

  key tstmp_to_dats(upo_novd.effective_from,
                    'UTC',
                    $session.client,'NULL')                                                           as   EFF_FROM_DT, //Effective from date

      tstmp_to_dats(upo_novd.effective_to,
                    'UTC',
                    $session.client,'NULL')                                                           as   EFF_TO_DT,   //Effective To Date


      cast(alc_basis.al_basis_cd as oiu_al_basis_cd)                                                  as   AL_BASIS_CD, //Allocation Basis Code

      functionalloc.gho_pn_nw_alloc                                                                   as   AL_FL, //Allocation indicator

      cavl.theo_basis_cd                                                                              as   THEO_BASIS_CD, //Saturated/Dry Code

      cavl.theo_infl_am                                                                               as   THEO_INFL_AM, //Theoretical inflation factor

      cavl.cha_compat_cd                                                                              as   CHA_COMPAT_CD, //Chemical analysis compatibility code.

      cavl.pi_meth_cd                                                                                 as   PI_METH_CD, //Plant inlet calculation method code

      cavl.inactive_fl                                                                                as   INACTIVE_FL, //Inactive indicator

      cavl.chem_meas_grp_id                                                                           as   CHEM_MEAS_GRP_ID, //Chemical Measurement Group

      upo_novd.pn_meas_grp                                                                            as   MEAS_GRP_ID, //Measurement Group ID

      cavl.ca_prcs_freq_cd                                                                            as   CA_PRCS_FREQ_CD, //Processing Frequency Code

      cavl.ca_auto_sel_fl                                                                             as   CA_AUTO_SEL_FL, //Contractual Allocation Auto Select indicator

      cavl.ca_alloc_meth_cd                                                                           as   CA_ALLOC_METH_CD, //Allocation Method Code

      cavl.ca_alloc_tol_pc                                                                            as   CA_ALLOC_TOL_PC, //CA Allocation Tolerance Percentage

      cavl.ca_alloc_bas_cd                                                                            as   CA_ALLOC_BAS_CD, //Gas Allocation Basis Code

      cavl.ca_assume_mkr_fl                                                                           as   CA_ASSUME_MKR_FL, //Assume Market Groups

      cavl.ca_assume_acr_fl                                                                           as   CA_ASSUME_ACR_FL, //Assume ACRs

      cavl.ca_assume_doi_fl                                                                           as   CA_ASSUME_DOI_FL, //Assume DOIs in Simple Plants

      cavl.ca_spf_sbe_fl                                                                              as   CA_SPF_SBE_FL, //SPF Sales-Based Entitlements indicator

      cavl.ca_spf_cpnt_fl                                                                             as   CA_SPF_CPNT_FL, //Component Level

      cavl.ca_fpf_wgb_cd                                                                              as   CA_FPF_WGB_CD, //FPF Wet Gas Balancing Code

      cavl.ca_fpf_sp_rlf_fl                                                                           as   CA_FPF_SP_RLF_FL, //FPF Special Return Lease Fuel Processing Flag

      cavl.vl_prcs_freq_cd                                                                            as   VL_PRCS_FREQ_CD, //Run Valuation

      cavl.vl_auto_sel_fl                                                                             as   VL_AUTO_SEL_FL, //Valuation Auto Select Flag

      cavl.vl_val_on_val_fl                                                                           as   VL_VAL_ON_VAL_FL, //Value on Value indicator

      case
      when cavl.oiu_cruser is not null then cavl.oiu_cruser
      else
      funcloc.ernam
      end
                                                                                                      as   OIU_CRUSER,       //Name of Person Who Created Object

      case
      when cavl.oiu_timestamp is not null then cavl.oiu_timestamp
      else
       dats_tims_to_tstmp(funcloc.erdat,
                       cast('000000' as abap.tims),
                       'UTC',
                       $session.client,
                       'NULL')
      end                                                                                             as   OIU_TIMESTAMP, //UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

      cavl.ca_static_takes                                                                            as   CA_STATIC_TAKES, //CA Static Takes network

      cavl.ca_alloc_bas_cd                                                                            as   CA_SPF_AL_BASIS, //Gas Allocation Basis Code

      cavl.no_wg                                                                                      as   NO_WG // CA NO Wet gas flag for manual method


}
where
     upo_novd.gho_netobj_type = 'GHO_PN'
  or upo_novd.gho_netobj_type = 'GHO_FS'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UPOV_ALC_BASIS_FOR_PRA",
"GHO_IFLOT_EXT",
"IFLOT",
"UPOT_INT_NOBJ",
"UPOT_INT_UOMDNVD",
"UPOT_UDM_NO_VD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/