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,
    ACCOUNTINGDOCUMENTTYPE,
    ACTIONNO_ID,
    ASSETDEPRECIATIONAREA,
    BUSINESSPARTNERTYPE,
    COMPANYCODE,
    FISCALYEAR,
    INSURPLCYINSURCONTR,
    INSURPLCYJRNLNMBR,
    INSURPLCYORDERNUMBER,
    JOURNALBO_ID,
    LEDGER,
    LEDGERGLLINEITEM,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REVERSALREFERENCEDOCUMENTTYPE,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _ACCOUNTINGDOCUMENTTYPETEXT,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CUSTOMER,
    _DEBITCREDITCODE,
    _FISCALPERIOD,
    _FISCALYEAR,
    _LEDGER,
    _ONETIMEACCOUNTBP,
    _SUPPLIER,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTITEMTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    AR_BRANCH,
    AR_OFFICIALDOCUMENTCLASS,
    AR_OFFICIALDOCUMENTNUMBER,
    AR_OFFICIALDOCUMENTTYPE,
    AR_PRINTCHARACTER,
    BUSINESSPARTNERFULLNAME,
    CALENDARYEARMONTH,
    CHANGE_TS,
    CHANGEUSR_TT,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COSTCENTER,
    COUNTRYCURRENCY,
    COV_ID,
    COVCPCO_ID,
    COVPAC_ID,
    CUSTOMER,
    DEBITCREDITCODE,
    DELIVOFGOODSDESTCOUNTRY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DOCUMENTNETDUEDATE,
    DOCUMENTREFERENCEID,
    DOCUMENTTRANSACTION,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    EXCHANGERATEEFFECTIVEDATE,
    EXCHANGERATETYPE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALPERIODDATE,
    FUNCTIONALCURRENCY,
    GLACCOUNT,
    GLOBALCURRENCY,
    GROSSAMTINCCRCY,
    GROSSAMTINFDCRCY1,
    GROSSAMTINFDCRCY2,
    GROSSAMTINTC,
    ISREVERSAL,
    ISREVERSED,
    JOURNALENTRYTYPE,
    LEDGERFISCALPERIOD,
    LEDGERFISCALYEAR,
    MODNAME_TT,
    NETDUEDATE,
    ODNDOCUMENTCLASS,
    OFFSETTINGACCOUNT,
    ORDERID,
    ORDERNO_ID,
    ORIGINALDOCUMENTREFERENCEID,
    PE_CONVENTIONAVOIDDOUBLETXN,
    PE_DOCUMENTSERIALNUMBER,
    PE_OFFICIALDOCUMENTNUMBER,
    PE_OFFICIALDOCUMENTTYPE,
    PE_ORIGINALDOCUMENTDATE,
    PE_SUNATCOUNTRYCODE,
    PROC_ID,
    QUANTITY,
    RECORD_TS,
    RECORDUSR_TT,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    SEGMENT,
    SPECIALGLCODE,
    SUPPLIER,
    SUPPLIERNAME,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXCONVERSIONISNOTENABLED,
    TAXNUMBER1,
    TAXNUMBERTYPE,
    TAXREPORTINGDATE,
    TOTALGROSSAMOUNTINCOCODECRCY,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VALID_FROM_DT,
    VATREGISTRATION,
    WBSELEMENT,
    WHLDGTAXAMTINADDLCRCY1,
    WHLDGTAXAMTINADDLCRCY2,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXAMTINTRANSACCRCY,
    WHLDGTAXBASEAMTINADDLCRCY1,
    WHLDGTAXBASEAMTINADDLCRCY2,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    WITHHOLDINGTAXPERCENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, ACTIONNO_ID, ASSETDEPRECIATIONAREA, BUSINESSPARTNERTYPE, COMPANYCODE, FISCALYEAR, INSURPLCYINSURCONTR, INSURPLCYJRNLNMBR, INSURPLCYORDERNUMBER, JOURNALBO_ID, LEDGER, LEDGERGLLINEITEM, ORIGINALREFERENCEDOCUMENT, POSTINGDATE, REFERENCEDOCUMENT, REFERENCEDOCUMENTCONTEXT, REVERSALREFERENCEDOCUMENTTYPE, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);