I_INTERNALORDERSYSTEMSTATUS

CDS View

Internal Order System Status

I_INTERNALORDERSYSTEMSTATUS is a CDS View in S/4HANA. Internal Order System Status. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_InternalOrderSystemStatus view_entity cross COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
StatusIsInactive StatusIsInactive 1 
@EndUserText.label: 'Internal Order System Status'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@Analytics.internalName:#LOCAL
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFIINDORDSYSSTS'
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true 
@AccessControl.authorizationCheck: #CHECK //Inserted by VDM CDS Suite Plugin

@ObjectModel.representativeKey: 'ControllingObjectStatus'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.allowExtensions:true

define view I_InternalOrderSystemStatus
  as select from(
           jest
      join aufk on jest.objnr = aufk.objnr
  )
  association [0..*] to I_InternalOrderSystemStatusT as _Text              on $projection.ControllingObjectStatus = _Text.SystemStatus
  association [0..1] to I_ControllingObject          as _ControllingObject on $projection.ControllingObject = _ControllingObject.ControllingObject
{
      @ObjectModel.foreignKey.association: '_ControllingObject'
  key jest.objnr as ControllingObject,
      @ObjectModel.text.association: '_Text'
  key jest.stat  as ControllingObjectStatus,
      jest.inact as StatusIsInactive,
      jest.chgnr as StatusObjectStatusChangeNumber,
      aufk.kokrs as ControllingArea,
      
      _Text,
      _ControllingObject
}
where
  (
       jest.stat  = 'I0001' //Status: Created

    or jest.stat  = 'I0002' //Status: Released

    or jest.stat  = 'I0045' //Status: Technically completed

    or jest.stat  = 'I0046'
  ) //Status: Closed

  //   or jest.stat = 'I0076' )     //Status: Deletion Flag

  and  jest.inact = ' '
  and  ( aufk.autyp = '01' or aufk.autyp = '02' ) 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFK",
"JEST"
],
"ASSOCIATED":
[
"I_CONTROLLINGOBJECT",
"I_INTERNALORDERSYSTEMSTATUST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More