I_RSHORDERUSERSTATUS
Order User Status
I_RSHORDERUSERSTATUS is a CDS View in S/4HANA. Order User Status. It contains 2 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_RSHOrderActiveUserStatus | view | from | CONSUMPTION | Maintenance order active status |
Fields (2)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | StatusCode | StatusCode | 1 |
| KEY | StatusProfile | StatusProfile | 1 |
@AbapCatalog.sqlViewName: 'IRSHORDUSRSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Order User Status'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
/*
CONTRACT*************************************************************************************************************************************
Specification: This view will retrieve all Status Object equivalent for all PM Orders along with all active User Status Codes
Requires: NA
Ensures: that only the active user status of the orders will be returned
Owners: GG
Contributors:
Unit Test required Y/N: Y
Additional comments None
END OF CONTRACT******************************************************************************************************************************
*/
define view I_RSHOrderUserStatus as select from P_RSHUserStatus
{
key StatusObject,
key StatusCode,
key StatusProfile,
UserStatusName as StatusName,
cast( UserStatusShortName as co_asttx ) as StatusShortName
} where obtyp = 'ORI'
and UserStatusShortName <> ''