I_STATUSOBJECTACTIVESTATUS

CDS View
7 Fields 19 CDS Views

Status Object Active Status

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

CDS Views using this table (19)

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_MaintPlanStatus view_entity 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

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.

-- Status Object Active Status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STATUSOBJECTACTIVESTATUS (
    STATUSCODE,
    STATUSOBJECT,
    STATUSPROFILE,
    _STATUSCODE,
    _STATUSOBJECT,
    _STATUSPROFILE,
    ISUSERSTATUS,
    PRIMARY KEY (STATUSCODE, STATUSOBJECT, STATUSPROFILE)
);

Learn More