P_WhereUsdPrftCtrUsrStatBasic

DDL: P_WHEREUSDPRFTCTRUSRSTATBASIC SQL: PWUPCUSB Type: view CONSUMPTION Package: ODATA_WHERE_USED_PROFIT_CENTER

Object User Status WUL Profit Centers

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

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UserStatus _UserStatus $projection.StatusCode = _UserStatus.UserStatus and $projection.StatusProfile = _UserStatus.StatusProfile
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWUPCUSB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObjectStatusBasic StatusObject
KEY StatusCode I_StatusObjectStatusBasic StatusCode
KEY StatusProfile jsto StatusProfile
StatusIsInactive StatusIsInactive
MasterLanguage _StatusProfile MasterLanguage
UserStatusNameSessionLang
UserStatusShortNameSessionLang
_StatusObject _StatusObject
_UserStatus _UserStatus
_StatusProfile _StatusProfile 
@AbapCatalog.sqlViewName: 'PWUPCUSB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view P_WhereUsdPrftCtrUsrStatBasic as select from I_StatusObjectStatusBasic

  left outer to one join I_StatusObject as jsto on I_StatusObjectStatusBasic.StatusObject = jsto.StatusObject

  association [0..1] to I_UserStatus as _UserStatus on $projection.StatusCode = _UserStatus.UserStatus
    and $projection.StatusProfile = _UserStatus.StatusProfile

  association [0..1] to I_StatusProfile as _StatusProfile on  $projection.StatusProfile = _StatusProfile.StatusProfile

{

  key I_StatusObjectStatusBasic.StatusObject,
  key I_StatusObjectStatusBasic.StatusCode,
  key jsto.StatusProfile,

  StatusIsInactive,

  _StatusProfile.MasterLanguage,

  _UserStatus._UserStatusText[ 1: Language = $session.system_language ].UserStatusName as UserStatusNameSessionLang,
  _UserStatus._UserStatusText[ 1: Language = $session.system_language ].UserStatusShortName as UserStatusShortNameSessionLang,

  _StatusObject,
  _UserStatus,
  _StatusProfile

} where StatusIsInactive = '' and StatusCode like 'E%'

Learn More