UPOV_GET_WC

DDL: UPO_INT_V_GET_WC SQL: UPOS_GET_WC Type: view

Separate WC from STRNO

UPOV_GET_WC is a CDS View that provides data about "Separate WC from STRNO" in SAP S/4HANA. It reads from 6 data sources and exposes 5 fields with key fields wl_tplnr, wc_tplnr.

6 data source(s) 5 fields

Data Sources (6)

SourceAliasJoin Type
upoc_udm_alkey alkeyobj_wc left_outer
upoc_udm_alkey alkeyobj_well left_outer
iflos funcloclabel_wc inner
iflos funcloclabel_well inner
gho_iflot_ext functionalloc from
upoc_udm_wc_sep wc_sep left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_GET_WC 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 Separate WC from STRNO view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY wl_tplnr iflos tplnr
KEY wc_tplnr iflos tplnr
wl_strno
wc_strno
strno iflos strno 
@AbapCatalog.sqlViewName: 'UPOS_GET_WC'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Separate WC from STRNO'
define view UPOV_GET_WC
  as select from    gho_iflot_ext   as functionalloc
    left outer join upoc_udm_alkey  as alkeyobj_wc       on alkeyobj_wc.gho_netobj_type = 'GHO_WC'
    inner join      iflos           as funcloclabel_wc   on  funcloclabel_wc.tplnr = functionalloc.tplnr
                                                         and funcloclabel_wc.alkey = alkeyobj_wc.alkey
    left outer join upoc_udm_alkey  as alkeyobj_well     on alkeyobj_well.gho_netobj_type = 'GHO_WELL'
    inner join      iflos           as funcloclabel_well on  funcloclabel_well.tplnr = functionalloc.gho_wc_ref_id
                                                         and funcloclabel_well.alkey = alkeyobj_well.alkey
    left outer join upoc_udm_wc_sep as wc_sep            on wc_sep.mandt = functionalloc.mandt   
{
  key funcloclabel_well.tplnr                                                                                                                                                                                    as wl_tplnr,
  key funcloclabel_wc.tplnr                                                                                                                                                                                      as wc_tplnr,
      cast(funcloclabel_well.strno as ilom_strno)                                                                                                                                                                 as wl_strno, 
      cast(ltrim(replace(funcloclabel_wc.strno, concat(left(funcloclabel_well.strno,15),wc_sep.w_wc_separator ),''),'')   as ilom_strno)                                                                       as wc_strno,
      funcloclabel_wc.strno
}
where
  functionalloc.gho_netobj_type = 'GHO_WC'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GHO_IFLOT_EXT",
"IFLOS",
"UPOC_UDM_ALKEY",
"UPOC_UDM_WC_SEP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More