I_STATUSOBJECTACTIVESTATUS

CDS View

Status Object Active Status

I_STATUSOBJECTACTIVESTATUS is a CDS View in S/4HANA. Status Object Active Status. It contains 7 fields. 18 CDS views read from this table.

Used by 18 CDS view(s) 7 fields

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_StsObjActiveStatusCodeText view from CONSUMPTION Status Object Active Status Code Text
I_DFS_MaintEquipmentStatus view from COMPOSITE Interface view of Equipment Status
I_DFS_StatusObjectUserStatus view from COMPOSITE Status Object Single Active Status
I_InspectionLotCancelledStatus view from COMPOSITE Canceled Inspection Lot Status
I_InspectionLotStatus view from COMPOSITE Inspection Lot Status
I_InspectionLotStatus1 view from COMPOSITE Inspection Lot Status
I_MfgControllingObjectStatus view from COMPOSITE Manufacturing Controlling Object Status
I_QltyInProcmtUserStatus view from COMPOSITE Quality Info Record Status
I_QltyNotificationStatus view from COMPOSITE Quality Notification Status
I_QualityInProcurementStatus view from COMPOSITE Qlty Information Record Status
I_Recontractstatll view from COMPOSITE Contract with active status logon language
I_StsObjActiveStsInLogonLang view from COMPOSITE Status Object Active Status for logon language
P_EquipMatlSerialNumberStatus view inner COMPOSITE
P_EquipmentStatus view inner COMPOSITE
P_FunctionalLocationStatus view inner COMPOSITE
P_MfgOrderStatus view_entity inner COMPOSITE
P_OrderStatusClosed view_entity from COMPOSITE Order Status Closed
P_SalesDocumentByObjectStatus view inner CONSUMPTION Sales Documents and Items by Object Status

Fields (7)

KeyField CDS FieldsUsed in Views
KEY StatusCode DfsMaintEquipOperationalStatus,StatusCode 7
KEY StatusObject DfsMaintEquipOplObjNmbr,StatusObject 7
KEY StatusProfile DfsMaintEquipOplStatusProfile,StatusProfile 5
_StatusCode _StatusCode 2
_StatusObject _StatusObject 5
_StatusProfile _StatusProfile 3
IsUserStatus IsUserStatus 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'ISTATOBJSTATACT'
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Status Object Active Status'
@Analytics : {dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #COMPOSITE

define view I_StatusObjectActiveStatus as select from I_StatusObjectStatus
//association to I_StatusObject as _StatusObject on

//    $projection.StatusObject = _StatusObject.StatusObject

//

//association [0..1] to I_StatusCode as _StatusCode on

//    $projection.StatusCode = _StatusCode.StatusCode and

//    $projection.StatusProfile = _StatusCode.StatusProfile

//association [0..1] to I_StatusProfile as _StatusProfile on

//    $projection.StatusProfile = _StatusProfile.StatusProfile

{
  @ObjectModel.foreignKey.association: '_StatusObject'
  key StatusObject,
  @ObjectModel.foreignKey.association: '_StatusCode'
  key StatusCode,
  @ObjectModel.foreignKey.association: '_StatusProfile'
  StatusProfile,
  IsUserStatus,
  StatusIsActive,
//  _StatusCode.StatusIsHidden,

//  _StatusCode.StatusSequenceNumber,

//  _StatusCode.StatusDisplayPosition,

//  _StatusCode.StatusDisplayPriority,

    
  _StatusObject,
  _StatusProfile ,
  _StatusCode
} where StatusIsInactive = ''

Learn More