I_ProcessOrderUserStatus

DDL: I_PROCESSORDERUSERSTATUS Type: view_entity COMPOSITE

Process Orders User Status

I_ProcessOrderUserStatus is a Composite CDS View that provides data about "Process Orders User Status" in SAP S/4HANA. It reads from 3 data sources (P_ProcOrdAORListDistinct, I_ProcessOrderStatus, I_ProcessOrderStatusInfo) and exposes 9 fields with key fields OrderID, StatusObject, StatusCode, StatusProfile. It has 3 associations to related views.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
P_ProcOrdAORListDistinct AORList inner
I_ProcessOrderStatus jest from
I_ProcessOrderStatusInfo jsto inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UserStatus _UserStatus _UserStatus.UserStatus = jest.StatusCode and _UserStatus.StatusProfile = jsto.StatusProfile
[0..1] I_StatusProfile _StatusProfile _StatusProfile.StatusProfile = jsto.StatusProfile --FOR DCL
[1..1] I_LogisticsOrder _Order _Order.OrderID = $projection.OrderID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Process Orders User Status view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_ProcOrdAORListDistinct OrderID
KEY StatusObject I_ProcessOrderStatusInfo StatusObject
KEY StatusCode I_ProcessOrderStatus StatusCode
KEY StatusProfile I_ProcessOrderStatusInfo StatusProfile
UserStatusName
UserStatusShortName
_UserStatus _UserStatus
_StatusProfile _StatusProfile
forDCL_Order 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Process Orders User Status'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE

define view entity I_ProcessOrderUserStatus
  as select from I_ProcessOrderStatus     as jest
    inner join   I_ProcessOrderStatusInfo as jsto    on jest.StatusObject = jsto.StatusObject
    inner join   P_ProcOrdAORListDistinct as AORList on jest.StatusObject = AORList.ProcessOrderObjectNumber
  association [0..1] to I_UserStatus     as _UserStatus    on  _UserStatus.UserStatus    = jest.StatusCode
                                                           and _UserStatus.StatusProfile = jsto.StatusProfile
  association [0..1] to I_StatusProfile  as _StatusProfile on  _StatusProfile.StatusProfile = jsto.StatusProfile

  --FOR DCL
  association [1..1] to I_LogisticsOrder as _Order         on  _Order.OrderID = $projection.OrderID
{
  key AORList.OrderID                                                                          as OrderID,
      //    key '000001127297' as OrderID,

  key jsto.StatusObject                                                                        as StatusObject,
  key jest.StatusCode                                                                          as StatusCode,
  key jsto.StatusProfile                                                                       as StatusProfile,

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

      _UserStatus,
      _StatusProfile,
      --for DCL
      _Order
}
where
  jest.StatusCode like 'E%'

Learn More