_JOURNALENTRY

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 _JOURNALENTRY (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    COMPANYCODE,
    FISCALYEAR,
    POSTINGDATE,
    TAXREPORTINGDATE,
    _BUSINESSTRANSACTIONTYPE,
    _FINANCIALMANAGEMENTAREA,
    _LEDGER,
    _LOGICALSYSTEM,
    _TRANSACTIONCURRENCY,
    ABSOLUTEEXCHANGERATE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCLASS,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTISREVERSIBLE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCTGDOCUMENTWORKFLOWSTATUS,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY1ROLE,
    ADDITIONALCURRENCY2,
    ADDITIONALCURRENCY2ROLE,
    ALTERNATIVEREFERENCEDOCUMENT,
    BATCHINPUTSESSION,
    BRANCH,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODECURRENCY,
    COMPANYCODENAME,
    CREATIONDATETIME,
    CREATIONTIME,
    CTRYCRCYTXABSOLUTEEXCHANGERATE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EFFECTIVEEXCHANGERATE,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    EXCHRATEISINDIRECTQUOTATION,
    FINANCIALMANAGEMENTAREA,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FULLNAME,
    INTERCOMPANYTRANSACTION,
    INVOICERECEIPTDATE,
    ISREVERSAL,
    ISREVERSED,
    JOURNALENTRYLASTCHANGEDATETIME,
    JRNLENTRYCNTRYSPECIFICBP1,
    JRNLENTRYCNTRYSPECIFICBP2,
    JRNLENTRYCNTRYSPECIFICDATE1,
    JRNLENTRYCNTRYSPECIFICDATE2,
    JRNLENTRYCNTRYSPECIFICDATE3,
    JRNLENTRYCNTRYSPECIFICDATE4,
    JRNLENTRYCNTRYSPECIFICDATE5,
    JRNLENTRYCNTRYSPECIFICREF1,
    JRNLENTRYCNTRYSPECIFICREF2,
    JRNLENTRYCNTRYSPECIFICREF3,
    JRNLENTRYCNTRYSPECIFICREF4,
    JRNLENTRYCNTRYSPECIFICREF5,
    LASTAUTOMATICCHANGEDATE,
    LASTCHANGEDATE,
    LASTMANUALCHANGEDATE,
    LATEPAYMENTREASON,
    LEDGER,
    LEDGERGROUP,
    LOGICALSYSTEM,
    MARKETDATAABSOLUTEEXCHANGERATE,
    NETAMOUNTISPOSTED,
    NMBROFPAGES,
    ORIGINALREFERENCEDOCUMENT,
    PARKEDBYUSER,
    PARKINGDATE,
    PARKINGDATETIME,
    PARKINGTIME,
    PLANNEDREVERSALDATE,
    RECURRINGACCOUNTINGDOCUMENT,
    REFERENCE1INDOCUMENTHEADER,
    REFERENCE2INDOCUMENTHEADER,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    REVERSALISPLANNED,
    REVERSALREASON,
    REVERSALREFERENCEDOCUMENT,
    REVERSEDDOCUMENT,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    REVERSEDREFERENCEDOCUMENT,
    SALESDOCUMENTCONDITION,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    SOURCECOMPANYCODE,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTTYPE,
    TAXABSOLUTEEXCHANGERATE,
    TAXBASEAMOUNTISNETAMOUNT,
    TAXBASEAMOUNTORIGIN,
    TAXCALCULATIONTYPE,
    TAXCOUNTRY,
    TAXEFFECTIVEEXCHANGERATE,
    TAXEXCHANGERATE,
    TAXEXCHRATEISINDIRECTQUOTATION,
    TAXFULFILLMENTDATE,
    TAXISCALCULATEDAUTOMATICALLY,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    WITHHOLDINGTAXREPORTINGDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTHEADERTEXT, COMPANYCODE, FISCALYEAR, POSTINGDATE, TAXREPORTINGDATE)
);