C_IntOrderOverallUserStatus

DDL: C_INTORDEROVERALLUSERSTATUS Type: view_entity CONSUMPTION

Internal order overall user status

C_IntOrderOverallUserStatus is a Consumption CDS View that provides data about "Internal order overall user status" in SAP S/4HANA. It reads from 5 data sources (I_InternalOrder, I_InternalOrderType, I_UserStatus, I_UserStatusText, I_StatusObjectStatusBasic) and exposes 7 fields with key fields StatusObject, StatusProfile, UserStatus. It is exposed through 1 OData service (UI_INTERNALORDER_MANAGE). It is used in 1 Fiori application: Manage Internal Orders (Version 2).

5 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 7 fields

Data Sources (5)

SourceAliasJoin Type
I_InternalOrder _InternalOrder inner
I_InternalOrderType _InternalOrderType inner
I_UserStatus _UserStatus inner
I_UserStatusText _UserStatusText inner
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Internal order overall user status view

OData Services (1)

ServiceBindingVersionContractRelease
UI_INTERNALORDER_MANAGE UI_INTERNALORDER_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F1604A Manage Internal Orders (Version 2) Transactional With this app, you can display internal orders master data. This app enables you to: - Display internal orders. - Navigate to other apps for internal orders.

Manage Internal Orders (Version 2)

Business Role: Cost Accountant - Overhead

With this SAP Fiori app, you can create, view, and edit master data of internal orders. You can also navigate to other apps for managing internal orders.

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObjectStatusBasic StatusObject
KEY StatusProfile I_UserStatusText StatusProfile
KEY UserStatus I_UserStatusText UserStatus
StatusIsInactive I_StatusObjectStatusBasic StatusIsInactive
IntOrderStatusSequenceNumber
UserStatusShortName I_UserStatusText UserStatusShortName
UserStatusName I_UserStatusText UserStatusName 
@VDM: {
  viewType: #CONSUMPTION
}

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

@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #NOT_REQUIRED
}

@UI.presentationVariant: [{ sortOrder: [{ by: 'IntOrderStatusSequenceNumber', direction: #DESC },
                                        { by: 'UserStatusShortName', direction: #ASC } ] }]

@EndUserText.label: 'Internal order overall user status'
define view entity C_IntOrderOverallUserStatus
  as select from I_StatusObjectStatusBasic
    inner join   I_InternalOrder     as _InternalOrder     on _InternalOrder.ControllingObject = I_StatusObjectStatusBasic.StatusObject
    inner join   I_InternalOrderType as _InternalOrderType on _InternalOrderType.OrderType = _InternalOrder.OrderType
    inner join   I_UserStatus        as _UserStatus        on  _UserStatus.StatusProfile = _InternalOrderType.StatusProfile
                                                           and _UserStatus.UserStatus    = I_StatusObjectStatusBasic.StatusCode
    inner join   I_UserStatusText    as _UserStatusText    on  _UserStatusText.StatusProfile = _InternalOrderType.StatusProfile
                                                           and _UserStatusText.UserStatus    = I_StatusObjectStatusBasic.StatusCode
                                                           and _UserStatusText.Language      = $session.system_language
{
      @UI.hidden: true
  key I_StatusObjectStatusBasic.StatusObject,
      @UI.hidden: true
  key _UserStatusText.StatusProfile,
      @UI.hidden: true
  key _UserStatusText.UserStatus,
      @UI.hidden: true
      I_StatusObjectStatusBasic.StatusIsInactive,

      cast(_UserStatus.StatusSequenceNumber as fco_io_j_stonr) as IntOrderStatusSequenceNumber,

      _UserStatusText.UserStatusShortName,

      _UserStatusText.UserStatusName

}

Learn More