I_StatusObjectStatusBasic

DDL: I_STATUSOBJECTSTATUSBASIC SQL: ISTSOBJSTSBASIC Type: view BASIC Package: VDM_FND

Status Object Status Basic

I_StatusObjectStatusBasic is a Basic CDS View that provides data about "Status Object Status Basic" in SAP S/4HANA. It reads from 1 data source (jest) and exposes 4 fields with key fields StatusObject, StatusCode. It has 1 association to related views. It is exposed through 1 OData service (UI_MAINTENANCE_PLAN). It is used in 1 Fiori application: Manage Maintenance Plans. Part of development package VDM_FND.

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

Data Sources (1)

SourceAliasJoin Type
jest jest from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_StatusObject _StatusObject $projection.StatusObject = _StatusObject.StatusObject

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISTSOBJSTSBASIC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Status Object Status Basic view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
ObjectModel.representativeKey StatusCode view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MAINTENANCE_PLAN UI_MAINTENANCE_PLAN V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5325 Manage Maintenance Plans Transactional An application to Manage Maintenance Plans, provides and comprehensive maintenance plan view including general data, scheduling information, assigned Maintenance Items, as well as review Maintenance calls, create new maintenance plan, edit existing maintenance plan.

Manage Maintenance Plans

Business Role: Maintenance Planner

With the Manage Maintenance Plans app, you as a maintenance planner can view, create, change, schedule, activate, and delete maintenance plans.

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY StatusObject jest objnr
KEY StatusCode jest stat
StatusIsInactive jest inact
_StatusObject _StatusObject 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'ISTSOBJSTSBASIC'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey:true


@EndUserText.label: 'Status Object Status Basic'
@Analytics : { dataExtraction.enabled : true}
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@VDM.viewType: #BASIC

@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL

define view I_StatusObjectStatusBasic as select from jest

//left outer join jsto on jest.objnr = jsto.objnr


//  association [0..1] to I_StatusCode    as _StatusCode    on  $projection.StatusCode    = _StatusCode.StatusCode

//                                                          and $projection.StatusProfile = _StatusCode.StatusProfile

                                                          
  association [0..1] to I_StatusObject  as _StatusObject  on  $projection.StatusObject = _StatusObject.StatusObject

//  association [0..1] to I_StatusProfile as _StatusProfile on  $projection.StatusProfile = _StatusProfile.StatusProfile


{
      @ObjectModel.foreignKey.association: '_StatusObject'
  key jest.objnr as StatusObject,
  
//      @ObjectModel.foreignKey.association: '_StatusCode'

  key jest.stat  as StatusCode,
  
//      @ObjectModel.foreignKey.association: '_StatusProfile'

//      //jsto.stsma as StatusProfile,

//      case

//        when jest.stat like 'E%' then jsto.stsma

//        when jest.stat not like 'E%' then ''

//      end        as StatusProfile,

//

//      case

//        when jest.stat like 'E%' then 'X'

//        when jest.stat not like 'E%' then ' '

//      end        as IsUserStatus,


//      case jest.inact

//        when 'X' then ''

//        when ''  then 'X'

//      end        as StatusIsActive,


      jest.inact as StatusIsInactive,
      
      _StatusObject
//      ,

//      _StatusCode,

//      _StatusProfile

}

Learn More