DHADM_MON_PORTIONINFORMATION

CDS View

Portion Information

DHADM_MON_PORTIONINFORMATION is a CDS View in S/4HANA. Portion Information. It contains 8 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 8 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
DHADM_MON_AccessPlanDetailBase view_entity left_outer Access Plans Details Base

Fields (8)

KeyField CDS FieldsUsed in Views
portion_error portion_error 1
portion_finished portion_finished 1
portion_in_process portion_in_process 1
portions_count portions 1
total_bytes total_bytes 1
total_rows total_rows 1
transfer_end transfer_end 1
transfer_start transfer_start 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Portion Information'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity DHADM_MON_PortionInformation
  as select from    DHADM_MON_ObjStoragePointer    as t1
    left outer join DHADM_MON_ObjStorageStatistics as t2 on t1.storage_ptr = t2.storage_ptr
{
  key t1.acp_id,
      t1.subscriber_id,
      t1.objname,
      t1.objtype,
      count( distinct ( t2.storage_id ) )                         as portions_count,
      sum( cast( t2.total_records as abap.int8 ) )                as total_rows,
      sum( cast( t2.total_bytes as abap.int8 ) )                  as total_bytes,
      sum( case when t2.status = abap.char'F' then 1 else 0 end ) as portion_finished,
      sum( case when t2.status = abap.char'I' then 1 else 0 end ) as portion_in_process,
      sum( case when t2.status = abap.char'E' then 1 else 0 end ) as portion_error,
      min(t2.transfer_start)                                      as transfer_start,
      max(t2.transfer_end)                                        as transfer_end
}

group by
  t1.acp_id,
  t1.subscriber_id,
  t1.objname,
  t1.objtype
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DHADM_MON_OBJSTORAGEPOINTER",
"DHADM_MON_OBJSTORAGESTATISTICS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More