I_SYSTEMUSERCHANGEDOCUMENTS

CDS View
9 Fields 2 CDS Views

Change Document for System User Status

I_SYSTEMUSERCHANGEDOCUMENTS is a CDS View in S/4HANA. Change Document for System User Status. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_DGR_StatusCD_MaxChangeNumber view from COMPOSITE
P_DGR_StatusCD_ValidStatus view from COMPOSITE

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ApplicationStatus ApplicationStatus 1
KEY ApplicationStatusObject ApplicationStatusObject 1
KEY ChangeNumber ChangeNumber 1
ChangeDocumentStatusDate StatusDate 1
ChangeDocumentStatusDateTime StatusTmstp 1
ChangeDocumentStatusIsInactive StatusInactive 1
ChangeDocumentStatusTime StatusTime 1
ChangeTransactionCode ChangeTransactionCode 1
TransactionCode TransactionCode 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.

-- Change Document for System User Status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SYSTEMUSERCHANGEDOCUMENTS (
    APPLICATIONSTATUS,
    APPLICATIONSTATUSOBJECT,
    CHANGENUMBER,
    CHANGEDOCUMENTSTATUSDATE,
    CHANGEDOCUMENTSTATUSDATETIME,
    CHANGEDOCUMENTSTATUSISINACTIVE,
    CHANGEDOCUMENTSTATUSTIME,
    CHANGETRANSACTIONCODE,
    TRANSACTIONCODE,
    PRIMARY KEY (APPLICATIONSTATUS, APPLICATIONSTATUSOBJECT, CHANGENUMBER)
);

Learn More