R_InternalOrderSystemStatusTP

DDL: R_INTERNALORDERSYSTEMSTATUSTP Type: view_entity TRANSACTIONAL

Internal order system status

R_InternalOrderSystemStatusTP is a Transactional CDS View that provides data about "Internal order system status" in SAP S/4HANA. It reads from 1 data source (P_InternalOrderSystemStatus) and exposes 13 fields with key fields InternalOrder, InternalOrderDraftInternalUUID, SystemStatus.

Data Sources (1)

SourceAliasJoin Type
P_InternalOrderSystemStatus P_InternalOrderSystemStatus from

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Internal order system status view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder InternalOrder
KEY InternalOrderDraftInternalUUID
KEY SystemStatus SystemStatus
SystemStatusShortName SystemStatusShortName
SystemStatusName SystemStatusName
InternalOrderStatusPlannedDate InternalOrderStatusPlannedDate
InternalOrderStatusReachedDate InternalOrderStatusReachedDate
ControllingObject ControllingObject
LastChangedByUser LastChangedByUser
IsActive
IntOrdSystemStatusCriticality IntOrdSystemStatusCriticality
_InternalOrderTP _InternalOrderTP
_LastChangedByUser _LastChangedByUser
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #MIXED
  }
}

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

@AccessControl: {
  authorizationCheck: #CHECK,
  privilegedAssociations: ['_LastChangedByUser']
}
@EndUserText.label: 'Internal order system status'
define view entity R_InternalOrderSystemStatusTP
  as select from P_InternalOrderSystemStatus

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

{
  key InternalOrder,
  key cast('00000000000000000000000000000000' as sysuuid_c32) as InternalOrderDraftInternalUUID,
      @ObjectModel.text.association:null
  key SystemStatus,
      SystemStatusShortName,
      SystemStatusName,
      InternalOrderStatusPlannedDate,
      InternalOrderStatusReachedDate,
      ControllingObject,
      LastChangedByUser,
      cast ('' as fin_io_status_is_active)                    as IsActive,
      IntOrdSystemStatusCriticality,
      //      cast( '0' as fin_io_status_criticality preserving type ) as IntOrdSystemStatusCriticality,


      _InternalOrderTP,
      _LastChangedByUser
}