ACCDOC

9 Fields

ACCDOC is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY GLAccount GLAccount 2
KEY Product Product 2
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentDate InvoiceDate 2
IsReversal IsReversal 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 ACCDOC (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    GLACCOUNT,
    PRODUCT,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    DOCUMENTDATE,
    ISREVERSAL,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, GLACCOUNT, PRODUCT)
);

Learn More