CHG

CHG is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 7
KEY ChangeDocItemChangeType ChangeDocItemChangeType 7
KEY ChangeDocument ChangeDocument 7
KEY DatabaseTable DatabaseTable 7
_ChangeDocChangeIndT _ChangeDocChangeIndT 7
_ChangeDocFieldNamesT _ChangeDocFieldNamesT 6
ChangeDocNewFieldValue ChangeDocNewFieldValue 7
ChangeDocNewUnit ChangeDocNewUnit 1
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue 7
ChangeDocPreviousUnit ChangeDocPreviousUnit 1
ChgDocNewValBasicSearch ChgDocNewValBasicSearch 7
ChgDocPrevValBasicSearch ChgDocPrevValBasicSearch 7
CreatedByUser CreatedByUser 5
CreationDate ChangeDocCreationDate,CreationDate 7
CreationTime CreationTime 7

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CHG (
    CHANGEDOCDATABASETABLEFIELD,
    CHANGEDOCITEMCHANGETYPE,
    CHANGEDOCUMENT,
    DATABASETABLE,
    _CHANGEDOCCHANGEINDT,
    _CHANGEDOCFIELDNAMEST,
    CHANGEDOCNEWFIELDVALUE,
    CHANGEDOCNEWUNIT,
    CHANGEDOCPREVIOUSFIELDVALUE,
    CHANGEDOCPREVIOUSUNIT,
    CHGDOCNEWVALBASICSEARCH,
    CHGDOCPREVVALBASICSEARCH,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    PRIMARY KEY (CHANGEDOCDATABASETABLEFIELD, CHANGEDOCITEMCHANGETYPE, CHANGEDOCUMENT, DATABASETABLE)
);