UPOV_GLG_WC_VOLUMES

DDL: UPO_INT_V_GLG_WC_VOLUMES SQL: UPOS_GLG_WC_VOL Type: view

Injected & Produced Volumes at WC

UPOV_GLG_WC_VOLUMES is a CDS View that provides data about "Injected & Produced Volumes at WC" in SAP S/4HANA. It reads from 6 data sources and exposes 8 fields.

6 data source(s) 8 fields

Data Sources (6)

SourceAliasJoin Type
gho_allocres_i ReceiptMeter left_outer
gho_allocres_i ReceivedWC inner
t006 unit_dimension inner
upoc_udm_vtqt_mp vtqt_received inner
UPOV_GLG_WC WC from
gho_allocres_i wcProduced left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_GLG_WC_VOL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Injected & Produced Volumes at WC view

Fields (8)

KeyFieldSource TableSource FieldDescription
RunID UPOV_GLG_WC RunID
WellCompletion UPOV_GLG_WC WellCompletion
dimension t006 dimid
unit gho_allocres_i unit
Injected_Volume gho_allocres_i volume
Produced_volume gho_allocres_i volume
material gho_allocres_i material
matnr gho_allocres_i matnr 
@AbapCatalog.sqlViewName: 'UPOS_GLG_WC_VOL'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Injected & Produced Volumes at WC'
define view UPOV_GLG_WC_VOLUMES
  as select from    UPOV_GLG_WC      as WC

  // Received volumes will be receipt meter volume with C indicator

    inner join      gho_allocres_i   as ReceivedWC     on  ReceivedWC.alloc_run_id = WC.RunID
                                                       and ReceivedWC.dest_node_id = WC.WellCompletion
                                                       and ReceivedWC.theo_act_ind = 'A'
    inner join      upoc_udm_vtqt_mp as vtqt_received  on vtqt_received.quant_type = ReceivedWC.qty_type
                                                       and(
                                                         vtqt_received.vol_type    = '53'
                                                         or vtqt_received.vol_type = '55'
                                                       )

    inner join      t006             as unit_dimension on unit_dimension.msehi = ReceivedWC.unit
    left outer join gho_allocres_i   as ReceiptMeter   on  ReceiptMeter.alloc_run_id   = ReceivedWC.alloc_run_id
                                                       and ReceiptMeter.origin_node_id = ReceivedWC.origin_node_id
                                                       and ReceiptMeter.theo_act_ind   = 'C'

  // Produced volumes will be volumes recorded at WC, WC volume with C indicator

    left outer join gho_allocres_i   as wcProduced     on  wcProduced.alloc_run_id   = WC.RunID
                                                       and wcProduced.origin_node_id = WC.WellCompletion
                                                       and wcProduced.theo_act_ind   = 'C'

{
  WC.RunID,
  WC.WellCompletion,
  unit_dimension.dimid as dimension,
  ReceivedWC.unit,
  ReceiptMeter.volume  as Injected_Volume,
  wcProduced.volume    as Produced_volume,
  ReceivedWC.material,
  ReceivedWC.matnr
}
group by
  WC.RunID,
  WC.WellCompletion,
  unit_dimension.dimid,
  ReceivedWC.unit,
  ReceiptMeter.volume,
  wcProduced.volume,
  ReceivedWC.material,
  ReceivedWC.matnr

Learn More