P_ACMStorageStatus

DDL: P_ACMSTORAGESTATUS Type: view_entity BASIC

Storage statuses for ACM

P_ACMStorageStatus is a Basic CDS View that provides data about "Storage statuses for ACM" in SAP S/4HANA. It reads from 2 data sources (I_SystemStatusText, jest) and exposes 4 fields with key fields StorageStatusObject, StatusProfileName.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_SystemStatusText _StatusText inner
jest jest from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Storage statuses for ACM view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY StorageStatusObject jest objnr
KEY StatusProfileName jest stat
ChangeDocumentStatusIsInactive jest inact
SystemStatusName I_SystemStatusText SystemStatusName 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Storage statuses for ACM'
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.private:true
@VDM.viewType: #BASIC
define view entity P_ACMStorageStatus
  as select from jest
    inner join   I_SystemStatusText as _StatusText on  _StatusText.SystemStatus = jest.stat
                                                   and _StatusText.Language     = $session.system_language
{
  key jest.objnr                   as StorageStatusObject,
  key jest.stat                    as StatusProfileName,
      @Semantics.booleanIndicator: true
      jest.inact                   as ChangeDocumentStatusIsInactive,
      _StatusText.SystemStatusName as SystemStatusName
}
where
  (
       jest.stat  = 'I7S11'
    or jest.stat  = 'I7S01'
    or jest.stat  = 'I7S12'
    or jest.stat  = 'I7S13'
    or jest.stat  = 'I7S14'

  )
  and  jest.inact is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SYSTEMSTATUSTEXT",
"JEST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More