FAC_DART_Z3_VNDRCHGDOC_BASE_B

CDS View
14 Fields 2 CDS Views

Vendor change Document Based View

FAC_DART_Z3_VNDRCHGDOC_BASE_B is a CDS View in S/4HANA. Vendor change Document Based View. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAC_DART_Z3_VNDRCHGDOC_BASE view from Vendor change Document Base
FAC_DART_Z3_VNDRCHGDOC_BASE view union Vendor change Document Base

Fields (14)

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

-- Vendor change Document Based View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAC_DART_Z3_VNDRCHGDOC_BASE_B (
    CHANGEDOCDATABASETABLEFIELD,
    CHANGEDOCITEMCHANGETYPE,
    CHANGEDOCOBJECT,
    CHANGEDOCOBJECTCLASS,
    CHANGEDOCTABLEKEY,
    CHANGEDOCUMENT,
    DATABASETABLE,
    CHANGEDOCNEWCURRENCY,
    CHANGEDOCNEWFIELDVALUE,
    CHANGEDOCNEWUNIT,
    CHANGEDOCPREVIOUSCURRENCY,
    CHANGEDOCPREVIOUSFIELDVALUE,
    CHANGEDOCPREVIOUSUNIT,
    CHANGEDOCTEXTISCHANGED,
    PRIMARY KEY (CHANGEDOCDATABASETABLEFIELD, CHANGEDOCITEMCHANGETYPE, CHANGEDOCOBJECT, CHANGEDOCOBJECTCLASS, CHANGEDOCTABLEKEY, CHANGEDOCUMENT, DATABASETABLE)
);

Learn More