DHCDC_RT_PortionInformation

DDL: DHCDC_RT_PORTIONINFORMATION Type: view_entity

Portion Information

DHCDC_RT_PortionInformation is a CDS View that provides data about "Portion Information" in SAP S/4HANA. It reads from 2 data sources (DHCDC_RT_ObjStoragePointer, DHCDC_RT_ObjStorageStatistics) and exposes 3 fields with key field acp_id.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
DHCDC_RT_ObjStoragePointer t1 from
DHCDC_RT_ObjStorageStatistics t2 left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Portion Information view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY acp_id DHCDC_RT_ObjStoragePointer acp_id
objname DHCDC_RT_ObjStoragePointer objname
objtype DHCDC_RT_ObjStoragePointer objtype 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DHCDC_RT_OBJSTORAGEPOINTER",
"DHCDC_RT_OBJSTORAGESTATISTICS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More