P_WhereUsdPrftCtrSystemStatus

DDL: P_WHEREUSDPRFTCTRSYSTEMSTATUS SQL: PWUPCSS Type: view CONSUMPTION Package: ODATA_WHERE_USED_PROFIT_CENTER

Object System Status WUL Profit Centers

P_WhereUsdPrftCtrSystemStatus is a Consumption CDS View that provides data about "Object System Status WUL Profit Centers" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 7 fields with key fields StatusObject, StatusCode. It has 1 association to related views. Part of development package ODATA_WHERE_USED_PROFIT_CENTER.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SystemStatus _SystemStatus $projection.StatusCode = _SystemStatus.SystemStatus

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUPCSS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Object System Status WUL Profit Centers view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode StatusCode
StatusIsInactive StatusIsInactive
StatusIsHidden _SystemStatus StatusIsHidden
SystemStatusName
SystemStatusShortName
_SystemStatus _SystemStatus 
@AbapCatalog.sqlViewName: 'PWUPCSS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory : #L,
  dataClass: #TRANSACTIONAL
}

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

@EndUserText.label: 'Object System Status WUL Profit Centers'
define view P_WhereUsdPrftCtrSystemStatus as select from I_StatusObjectStatusBasic

  association [1..1] to I_SystemStatus as _SystemStatus on $projection.StatusCode = _SystemStatus.SystemStatus

{

  key StatusObject,
  key StatusCode,

  StatusIsInactive,

  _SystemStatus.StatusIsHidden as StatusIsHidden,
  _SystemStatus._SystemStatusText[ 1: Language = $session.system_language ].SystemStatusName,
  _SystemStatus._SystemStatusText[ 1: Language = $session.system_language ].SystemStatusShortName,

  _SystemStatus

} where StatusIsInactive = '' and StatusCode like 'I%' and _SystemStatus.StatusIsHidden = ''

Learn More