P_EBPCC_MaxKeyStatus

DDL: P_EBPCC_MAXKEYSTATUS Type: view_entity COMPOSITE

Event-Based PCC Max Key Status

P_EBPCC_MaxKeyStatus is a Composite CDS View that provides data about "Event-Based PCC Max Key Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 2 fields with key field ControllingObject.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Event-Based PCC Max Key Status view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject StatusObject
StatusCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Event-Based PCC Max Key Status'
@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #COMPOSITE
@VDM.private: true

define view entity P_EBPCC_MaxKeyStatus
  as select from I_StatusObjectStatusBasic
{
  key StatusObject    as ControllingObject,

      max(StatusCode) as StatusCode
}
where
  (
       StatusCode       = 'I0002' // Released

    or StatusCode       = 'I0009' // Confirmed

    or StatusCode       = 'I0045' // Technicaly Completed

    or StatusCode       = 'I0076' // Deletion Flag

  )
  and  StatusIsInactive = ''
group by
  StatusObject
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSOBJECTSTATUSBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More