INVOICEJOURNAL

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 INVOICEJOURNAL (
    ACCOUNTINGDOCUMENT,
    ACTIONRULEISGENERATED,
    BUSINESSPARTNERNAME,
    BUYER,
    COMMSNTRADEINVCLINKEDVATAMOUNT,
    COMMSNTRADEINVOICELINKEDAMOUNT,
    COMMSNTRADEINVOICELINKINGCRCY,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CORRECTIONINVOICE,
    CORRECTIONINVOICEDATE,
    CORRECTIONINVOICEYEAR,
    CURRENCY,
    DEBITCREDITCODE,
    EXTERNALCORRECTIONINVOICE,
    EXTERNALINVOICE,
    FISCALYEAR,
    INCGINVOICEACCOUNTINGDOCUMENT,
    INCGINVOICEACCTGDOCFISCALYEAR,
    INCINVBUSINESSPARTNERNAME,
    INCINVPARTNERORGANIZATIONINN,
    INCINVPARTNERORGANIZATIONKPP,
    INCOMINGINVOICEDATE,
    INCOMINGINVOICENUMBER,
    INVOICE,
    INVOICEDATE,
    INVOICEYEAR,
    ITEMWITHTAX,
    ORIGINALINVOICEREVISIONDATE,
    ORIGINALINVOICEREVISIONNUMBER,
    POSTINGDATE,
    REVISIONINVOICEDATE,
    REVISIONNUMBER,
    REVISIONTAXREPORTINGDATE,
    RU_COMMISSIONTRADECUSTOMERINN,
    RU_COMMISSIONTRADECUSTOMERKPP,
    RU_COMMISSIONTRADECUSTOMERNAME,
    RU_COMMISSIONTRADESUPPLIERINN,
    RU_COMMISSIONTRADESUPPLIERKPP,
    RU_COMMISSIONTRADESUPPLIERNAME,
    RU_CUSTOMEROUTPUTTYPE,
    RU_INCOMINGINVOICECOMPANYCODE,
    RU_ORGOPERATIONTYPE,
    RU_PARTNERORGANIZATIONINN,
    RU_PARTNERORGANIZATIONKPP,
    RU_REGISTRATIONINVOICEDATE,
    RU_SUBAGENTOUTPUTTYPE,
    RU_SUPPLIERAGENTOUTPUTTYPE,
    RU_SUPPLIEROUTPUTTYPE,
    RU_VATRETURNSECTION,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOVERSION,
    SALESDEALTYPE,
    SELLER,
    SELLERAGENT,
    SUBAGENT,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXREPORTINGDATE
);