UPO_INT_V_WCVD_PRD

@AbapCatalog.sqlViewName: 'UPOS_WCVD_PRD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'List of WC which are marked as Producing and Operating'
define view UPO_INT_V_WCVD_PRD
  as select distinct from UPOV_COMMINGLED_WC as commingled
    inner join            upot_int_nobj      as WL_Label    on WL_Label.converted_label = commingled.wl_no
    inner join            gho_iflot_ext      as wellID      on wellID.gho_wc_ref_id = WL_Label.tplnr
    left outer join       upot_udm_no_vd     as udm_no_vd   on  udm_no_vd.tplnr = wellID.tplnr
    left outer join       upoc_int_sts_cde   as status_code on  status_code.netobj_type      = udm_no_vd.gho_netobj_type
                                                            and status_code.netobj_stat_code = udm_no_vd.netobj_status
  association [0..1] to oiu_pr_npsts as non_prd_stat on non_prd_stat.status_cd = status_code.status_cd_pra
{
  key udm_no_vd.gho_netobj_type,
  key udm_no_vd.tplnr,
  key udm_no_vd.effective_from,
      udm_no_vd.effective_to,
      cast(commingled.wl_no as oiu_wl_no) as WL_NO, // Well id

      cast(commingled.wc_no as oiu_wc_no) as WC_NO, // Well completion

      udm_no_vd.op_fl
}
where
      non_prd_stat.mandt is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UPOV_COMMINGLED_WC",
"GHO_IFLOT_EXT",
"OIU_PR_NPSTS",
"UPOC_INT_STS_CDE",
"UPOT_INT_NOBJ",
"UPOT_UDM_NO_VD"
],
"ASSOCIATED":
[
"OIU_PR_NPSTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/