R_IntOrdUnnumberedUserStatusTP

DDL: R_INTORDUNNUMBEREDUSERSTATUSTP Type: view_entity TRANSACTIONAL

Int. order user status without number

R_IntOrdUnnumberedUserStatusTP is a Transactional CDS View that provides data about "Int. order user status without number" in SAP S/4HANA. It reads from 4 data sources (I_InternalOrder, I_InternalOrderType, I_UserStatus, I_UserStatusText) and exposes 8 fields with key fields InternalOrder, InternalOrderDraftInternalUUID, UserStatus.

4 data source(s) 8 fields

Data Sources (4)

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

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Int. order user status without number view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder I_InternalOrder InternalOrder
KEY InternalOrderDraftInternalUUID
KEY UserStatus I_UserStatusText UserStatus
StatusProfile I_UserStatusText StatusProfile
IntOrderStatusSequenceNumber
UserStatusShortName I_UserStatusText UserStatusShortName
UserStatusName I_UserStatusText UserStatusName
_InternalOrderTP _InternalOrderTP 
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #M,
    dataClass: #MIXED
  }
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Int. order user status without number'
define view entity R_IntOrdUnnumberedUserStatusTP
  as select from           I_UserStatus              as _UserStatus
    inner join             I_InternalOrderType       as _InternalOrderType       on _InternalOrderType.StatusProfile = _UserStatus.StatusProfile
    inner join             I_InternalOrder           as _InternalOrder           on _InternalOrder.OrderType = _InternalOrderType.OrderType
    inner join             I_UserStatusText          as _UserStatusText          on  _UserStatusText.StatusProfile = _UserStatus.StatusProfile
                                                                                 and _UserStatusText.UserStatus    = _UserStatus.UserStatus
                                                                                 and _UserStatusText.Language      = $session.system_language
    left outer to one join I_StatusObjectStatusBasic as _StatusObjectStatusBasic on  _StatusObjectStatusBasic.StatusObject = _InternalOrder.ControllingObject
                                                                                 and _StatusObjectStatusBasic.StatusCode   = _UserStatus.UserStatus

  association to parent R_InternalOrderTP as _InternalOrderTP on  $projection.InternalOrder                  = _InternalOrderTP.InternalOrder
                                                              and $projection.InternalOrderDraftInternalUUID = _InternalOrderTP.InternalOrderDraftInternalUUID

{
  key _InternalOrder.InternalOrder,
  key cast('00000000000000000000000000000000' as sysuuid_c32) as InternalOrderDraftInternalUUID,
      @ObjectModel.text.association:null
  key _UserStatusText.UserStatus,
      _UserStatusText.StatusProfile,
      case _StatusObjectStatusBasic.StatusIsInactive
        when ' '
          then cast( 'X' as fin_io_status_is_active)
          else cast( '' as fin_io_status_is_active)
      end                                                     as IsActive,
      cast(_UserStatus.StatusSequenceNumber as fco_io_j_stonr) as IntOrderStatusSequenceNumber,
      _UserStatusText.UserStatusShortName,
      _UserStatusText.UserStatusName,

      _InternalOrderTP
}
where
  _UserStatus.StatusSequenceNumber = '00'

Learn More