DHCDC_RT_PORTIONINFORMATION

CDS View

Portion Information

DHCDC_RT_PORTIONINFORMATION is a CDS View in S/4HANA. Portion Information. 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
DHCDC_RT_AccessPlanDetailBase view_entity left_outer Access Plan Details

Fields (4)

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 
@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 DHCDC_RT_PortionInformation 
  as select from    DHCDC_RT_ObjStoragePointer    as t1
    left outer join DHCDC_RT_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( 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
}

group by
  t1.acp_id,
  t1.subscriber_id,
  t1.objname,
  t1.objtype

Learn More