I_USERSTATUS

CDS View
6 Fields 9 CDS Views

User Status

I_USERSTATUS is a CDS View in S/4HANA. User Status. It contains 6 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_DFS_MaintEquipUserStatusVH view_entity inner CONSUMPTION Equipment User Status Profiles
C_IntOrderOverallUserStatus view_entity inner CONSUMPTION Internal order overall user status
I_DFS_MaintEquipOplStatusVH view inner COMPOSITE Operational Status Value help
I_EAMObjectUsrStatusWithNumber view inner BASIC EAM Object User Status with Number
I_GhoUserStatus_Db view from BASIC User Status for UOM
I_IntOrderActiveUserStatus view_entity inner COMPOSITE Internal Order Active User Status
P_StatusCode view union_all BASIC
R_IntOrderNumberedUserStatusTP view_entity from TRANSACTIONAL Internal order user status with number
R_IntOrdUnnumberedUserStatusTP view_entity from TRANSACTIONAL Int. order user status without number

Fields (6)

KeyField CDS FieldsUsed in Views
KEY StatusProfile StatusProfile 2
KEY UserStatus UserStatus 1
_StatusProfile _StatusProfile 1
_UserStatusText _UserStatusText 1
StatusAuthorizationKey StatusAuthorizationKey 1
StatusSequenceNumber StatusSequenceNumber 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- User Status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_USERSTATUS (
    STATUSPROFILE,
    USERSTATUS,
    _STATUSPROFILE,
    _USERSTATUSTEXT,
    STATUSAUTHORIZATIONKEY,
    STATUSSEQUENCENUMBER,
    PRIMARY KEY (STATUSPROFILE, USERSTATUS)
);

Learn More