UPOT_INT_V_GET_ORG_LEVEL_DATA

CDS View

Get org level data

UPOT_INT_V_GET_ORG_LEVEL_DATA is a CDS View in S/4HANA. Get org level data. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
UPOV_PR_WC_UOM view inner UOM: Well Completion

Fields (4)

KeyField CDS FieldsUsed in Views
or1_or_lvl_1_no OR1_OR_LVL_1_NO 1
or2_or_lvl_2_no OR2_OR_LVL_2_NO 1
or3_or_lvl_3_no OR3_OR_LVL_3_NO 1
or4_or_lvl_4_no OR4_OR_LVL_4_NO 1 
@AbapCatalog.sqlViewName: 'UPOS_ORG_DATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm:#SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Get org level data'
define view upot_int_v_get_org_level_data
  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 func_wc       on func_wc.gho_wc_ref_id = WL_Label.tplnr
    inner join            gho_iflot_ext      as functionalloc on functionalloc.tplnr = func_wc.tplnr
{
  WL_Label.tplnr,
  max(functionalloc.tplnr)           as wc_no,
  max(functionalloc.or1_or_lvl_1_no) as or1_or_lvl_1_no,
  max(functionalloc.or2_or_lvl_2_no) as or2_or_lvl_2_no,
  max(functionalloc.or3_or_lvl_3_no) as or3_or_lvl_3_no,
  max(functionalloc.or4_or_lvl_4_no) as or4_or_lvl_4_no
}
where
  WL_Label.gho_netobj_type = 'GHO_WELL'
group by
  WL_Label.tplnr
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UPOV_COMMINGLED_WC",
"GHO_IFLOT_EXT",
"UPOT_INT_NOBJ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More