CHANGEDOCITEM

CHANGEDOCITEM is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 2
KEY ChangeDocItemChangeType ChangeDocItemChangeType 3
KEY ChangeDocObject ChangeDocObject 2
KEY ChangeDocObjectClass ChangeDocObjectClass 2
KEY ChangeDocTableKey ChangeDocTableKey 3
KEY ChangeDocument ChangeDocument 3
KEY DatabaseTable DatabaseTable 3
ChangeDocChangeType ChangeDocChangeType 1
ChangeDocNewCurrency ChangeDocNewCurrency 2
ChangeDocNewFieldValue ChangeDocNewFieldValue 2
ChangeDocNewUnit ChangeDocNewUnit 2
ChangeDocPreviousCurrency ChangeDocPreviousCurrency 2
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue 2
ChangeDocPreviousUnit ChangeDocPreviousUnit 2
ChangeTransactionCode ChangeTransactionCode 1
CreationDate CreationDate 1
CreationTime CreationTime 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CHANGEDOCITEM (
    CHANGEDOCDATABASETABLEFIELD,
    CHANGEDOCITEMCHANGETYPE,
    CHANGEDOCOBJECT,
    CHANGEDOCOBJECTCLASS,
    CHANGEDOCTABLEKEY,
    CHANGEDOCUMENT,
    DATABASETABLE,
    CHANGEDOCCHANGETYPE,
    CHANGEDOCNEWCURRENCY,
    CHANGEDOCNEWFIELDVALUE,
    CHANGEDOCNEWUNIT,
    CHANGEDOCPREVIOUSCURRENCY,
    CHANGEDOCPREVIOUSFIELDVALUE,
    CHANGEDOCPREVIOUSUNIT,
    CHANGETRANSACTIONCODE,
    CREATIONDATE,
    CREATIONTIME,
    PRIMARY KEY (CHANGEDOCDATABASETABLEFIELD, CHANGEDOCITEMCHANGETYPE, CHANGEDOCOBJECT, CHANGEDOCOBJECTCLASS, CHANGEDOCTABLEKEY, CHANGEDOCUMENT, DATABASETABLE)
);