P_STATUSOBJECTSTATUSWITHGUID

CDS View

P_StatusObjectStatusWithGUID

P_STATUSOBJECTSTATUSWITHGUID is a CDS View in S/4HANA. P_StatusObjectStatusWithGUID. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StatusObjectUUIDStatus view from BASIC I_StatusObjectUUIDStatus 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'PSTATUSOBJSTATUS'
//@EndUserText.label: 'Status Object Status'


//@Analytics : { dataExtraction.enabled : true}

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC

@AbapCatalog.compiler.compareFilter: true
@VDM.private: true

define view P_StatusObjectStatusWithGUID  as select from    crm_jest

  left outer join crm_jsto on crm_jest.objnr = crm_jsto.objnr
  
 // ------------------- OLD Code Start---------------------------------

//-------------------Changes done fo IM:  1980398731/ Abhishek


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

//                                                          and $projection.StatusProfile = _StatusCode.StatusProfile

//                                                          

////  association [0..1] to P_StatusObjectWithGUID  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 crm_jest.objnr as StatusObjectUUID,

//  

//      @ObjectModel.foreignKey.association: '_StatusCode'

//  key crm_jest.stat  as StatusCode,

//  

//      @ObjectModel.foreignKey.association: '_StatusProfile'

//      case

//        when crm_jest.stat like 'E%' then crm_jsto.stsma

//        else ''

//      end        as StatusProfile,

//

//      case

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

//        else   ' '

//      end        as IsUserStatus,

//

//      case crm_jest.inact

//        when 'X' then ''

//        else 'X'

//      end        as StatusIsActive,

//

//      crm_jest.inact as StatusIsInactive,

//      

////      _StatusObject,

//      _StatusCode,

//      _StatusProfile

//} 

  
// ------------------- OLD Code End ---------------------------------

 
{
  key crm_jest.objnr as StatusObjectUUID,
  
  key crm_jest.stat  as StatusCode,
  
      crm_jsto.stsma as StatusProfile,

      cast('X' as vdm_j_isuserstatus ) as IsUserStatus,

       cast('' as vdm_j_statusisactive)  as StatusIsActive,

      crm_jest.inact as StatusIsInactive

}
where crm_jest.stat like 'E%' and crm_jest.inact = 'X'

union all select from crm_jest 
left outer join crm_jsto on crm_jest.objnr = crm_jsto.objnr

{
  key crm_jest.objnr as StatusObjectUUID,
  
  key crm_jest.stat  as StatusCode,
  
      crm_jsto.stsma as StatusProfile,

      cast('X' as vdm_j_isuserstatus ) as IsUserStatus,

      cast('X' as vdm_j_statusisactive ) as StatusIsActive,

      crm_jest.inact as StatusIsInactive

}
where crm_jest.stat like 'E%' and ( crm_jest.inact != 'X' or crm_jest.inact is null )

union all select from crm_jest 

{
  key crm_jest.objnr as StatusObjectUUID,
  
  key crm_jest.stat  as StatusCode,
  
      cast('' as j_stsma)  as StatusProfile, 

      cast('' as vdm_j_isuserstatus ) as IsUserStatus,

      cast( '' as vdm_j_statusisactive ) as StatusIsActive,

      crm_jest.inact as StatusIsInactive

}
where crm_jest.stat like 'I%' and crm_jest.inact = 'X'

union all select from crm_jest 
//left outer join crm_jsto on crm_jest.objnr = crm_jsto.objnr 

{
  key crm_jest.objnr as StatusObjectUUID,

  key crm_jest.stat  as StatusCode,

      cast('' as j_stsma)  as StatusProfile, //crm_jsto.stsma as StatusProfile, Requested from Horst as part of the changes for incident 1980398731-- Abhishek


      cast('' as vdm_j_isuserstatus ) as IsUserStatus,

      cast('X' as vdm_j_statusisactive )as StatusIsActive,

      crm_jest.inact as StatusIsInactive

}
where crm_jest.stat like 'I%' and ( crm_jest.inact != 'X' or crm_jest.inact is null )

Learn More