UPOV_GLG_WC

CDS View

Unique GLG WC

UPOV_GLG_WC is a CDS View in S/4HANA. Unique GLG WC. It contains 2 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 2 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
UPOV_GLG_WC_VOLUMES view from Injected & Produced Volumes at WC
UPOV_SUMMARY_AT_WC_VT16 view from Allocation Results Summary - VT16
UPOV_SUMMARY_AT_WC_VT17 view from Allocation Results Summary - VT17
UPOV_SUMMARY_AT_WC_VT17_60 view from Allocation Results Summary - VT17,60
UPOV_SUMMARY_AT_WC_VT17_60 view union Allocation Results Summary - VT17,60
UPOV_SUMMARY_AT_WC_VT60 view from Allocation Results Summary - VT60

Fields (2)

KeyField CDS FieldsUsed in Views
RunID alloc_run_id,RunID 5
WellCompletion dest_node_id,WellCompletion 5 
@AbapCatalog.sqlViewName: 'UPOS_GLG_WC'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Unique GLG WC'
define view UPOV_GLG_WC
  as select distinct from gho_allocres_h   as header_res
    inner join            gho_allocres_i   as wcReceived on  wcReceived.alloc_run_id = header_res.alloc_run_id
                                                         and wcReceived.theo_act_ind = 'A'
    inner join            upoc_udm_vtqt_mp as vtqtr      on vtqtr.quant_type = wcReceived.qty_type
                                                         and(
                                                           vtqtr.vol_type    = '53'
                                                           or vtqtr.vol_type = '55'
                                                         )
{
  wcReceived.alloc_run_id as RunID,
  wcReceived.dest_node_id as WellCompletion
}
where
      header_res.frequency    = 'M'
  and header_res.alloc_status = '01'
  and header_res.final_ind    = 'X'

Learn More