JOURNALENTRYITEM

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 JOURNALENTRYITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    COMPANYCODE,
    FISCALYEAR,
    FISCALYEARPERIOD,
    GLACCOUNT,
    LEDGER,
    LEDGERGLLINEITEM,
    PERFORMANCEOBLIGATION,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXITEM,
    _BALANCETRANSACTIONCURRENCY,
    _BUSINESSTRANSACTIONTYPE,
    _CO_DIANCITYCODE,
    _CO_DIANCOUNTRYMAPPING,
    _CO_DIANTAXMAPPING,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _CUSTOMER,
    _DEBITCREDITCODE,
    _FINANCIALACCOUNTTYPE,
    _FISCALYEAR,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLOBALCURRENCY,
    _JOURNALENTRY,
    _LEDGER,
    _ONETIMEACCOUNTBP,
    _REFERENCEDOCUMENTTYPE,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    _TRANSACTIONCURRENCY,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGPRINCIPLE,
    ADDITIONALLASTNAME,
    ALTERNATIVEGLACCOUNT,
    ALTERNATIVEGLACCOUNTISUSED,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINREPORTINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BALANCETRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPLACE,
    BUSINESSTRANSACTIONTYPE,
    CAISDOWNPAYMENTREQUEST,
    CHARTOFACCOUNTS,
    CITYCODE,
    CITYNAME,
    CLEARINGDATE,
    CO_DIANAMOUNTCLASSIFICATION,
    CO_DIANBPTAXLONGNUMBER,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    CONDITIONTYPENAME,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINREPORTINGCRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMER,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINREPORTINGCURRENCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    ENDINGBALANCEAMTINCOCODECRCY,
    ENDINGBALANCEAMTINTRANSCRCY,
    EXCHANGERATE,
    FINANCIALACCOUNTTYPE,
    FIRSTNAME,
    FISCALPERIOD,
    FISCALYEARVARIANT,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    ISNATURALPERSON,
    ISREVERSAL,
    ISREVERSED,
    JRNLENTRYCNTRYSPECIFICREF5,
    LASTNAME,
    MIDDLENAME,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OPENINGBALANCEAMTINCOCODECRCY,
    OPENINGBALANCEAMTINTRANSCRCY,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    PAYMENTMETHOD,
    PLANT,
    POSTINGDATE,
    PROFITCENTER,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    REGION,
    REPORTEDTAXNUMBER,
    REPORTINGCURRENCY,
    REVENUEACCOUNTINGCONTRACT,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    SALESDOCUMENT,
    SPECIALGLCODE,
    STREETNAME,
    SUPPLIER,
    TAXCODE,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, COMPANYCODE, FISCALYEAR, FISCALYEARPERIOD, GLACCOUNT, LEDGER, LEDGERGLLINEITEM, PERFORMANCEOBLIGATION, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXITEM)
);