I_ACTUALPLANJOURNALENTRYITEM

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.

-- Actual Plan for Journal Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACTUALPLANJOURNALENTRYITEM (
    ACCOUNTINGDOCUMENT,
    ACTUALPLANJOURNALENTRYITEM,
    COMPANYCODE,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    GLOBALCURRENCY,
    LEDGER,
    LEDGERFISCALYEAR,
    POSTINGDATE,
    PROJECT,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    SOURCELEDGER,
    WBSELEMENT,
    _ACCOUNTASSIGNMENTTYPE,
    _ACCOUNTINGDOCUMENTTYPE,
    _BASEUNIT,
    _BILLABLECONTROL,
    _BILLINGDOCUMENTTYPE,
    _BILLTOPARTY,
    _BUDGETINGTYPE,
    _BUDGETPERIOD,
    _BUDGETPROCESS,
    _BUSINESSAREA,
    _BUSINESSTRANSACTIONCATEGORY,
    _BUSINESSTRANSACTIONTYPE,
    _CALENDARDATE,
    _CASHLEDGERACCOUNT,
    _CASHLEDGERCOMPANYCODE,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _CONTROLLINGDEBITCREDITCODE,
    _CONTROLLINGOBJECTCURRENCY,
    _COSTANALYSISRESOURCE,
    _COSTCENTER,
    _COSTCTRACTIVITYTYPE,
    _COSTSOURCEUNIT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _CUSTOMERSUPPLIERINDUSTRYTEXT,
    _DEBITCREDITCODE,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _EMPLOYMENT,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FINANCIALTRANSACTIONTYPE,
    _FISCALCALENDARDATE,
    _FISCALPERIOD,
    _FISCALPERIODFORVARIANT,
    _FISCALYEAR,
    _FISCALYEARPERIOD,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FIXEDASSET,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _FUNCTIONALAREA,
    _FUNCTIONALCURRENCY,
    _FUND,
    _FUNDEDPROGRAM,
    _FUNDSCENTER,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _GRANT,
    _INTERNALORDER,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEAR,
    _LEDGERFISCALYEARFORVARIANT,
    _MAINTENANCEORDER,
    _MAINTENANCEORDEROPERATION,
    _MASTERFIXEDASSET,
    _MATERIAL,
    _MATERIALGROUP,
    _ORDER,
    _ORGANIZATIONDIVISION,
    _ORIGINCOSTCENTER,
    _ORIGINCOSTCTRACTIVITYTYPE,
    _ORIGINPROFITCENTER,
    _PARTNERBUDGETPERIOD,
    _PARTNERBUSINESSAREA,
    _PARTNERCOMPANY,
    _PARTNERCOMPANYCODE,
    _PARTNERCOSTCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _PARTNERFUNCTIONALAREA,
    _PARTNERFUND,
    _PARTNERGRANT,
    _PARTNERORDER,
    _PARTNERORDER_2,
    _PARTNERPROFITCENTER,
    _PARTNERPROJECT,
    _PARTNERPROJECTBASICDATA,
    _PARTNERPROJECTEXTERNALID,
    _PARTNERSEGMENT,
    _PARTNERWBSELEMENT,
    _PARTNERWBSELEMENTBASICDATA,
    _PARTNERWBSELEMENTEXTERNALID,
    _PERSONWORKAGREEMENT_1,
    _PLANNINGCATEGORY,
    _PLANT,
    _PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTGROUP_2,
    _PROFITCENTER,
    _PROJECT,
    _PROJECTBASICDATA,
    _PROJECTEXTERNALID,
    _PUBSECBUDGETACCOUNT,
    _PUBSECBUDGETACCOUNTCOCODE,
    _PUBSECBUDGETCNSMPNAMTTYPE,
    _PUBSECBUDGETCNSMPNDATE,
    _PUBSECBUDGETCNSMPNFSCLPERIOD,
    _PUBSECBUDGETCNSMPNFSCLYEAR,
    _PUBSECBUDGETCNSMPNTYPE,
    _REFERENCEQUANTITYUNIT,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _SALESORGANIZATION,
    _SEGMENT,
    _SERVICECONTRACT,
    _SERVICECONTRACTITEM,
    _SERVICECONTRACTTYPE,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTITEM,
    _SERVICEDOCUMENTTYPE,
    _SHIPTOPARTY,
    _SOLDMATERIAL,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP,
    _SOLDPRODUCTGROUP_2,
    _SOURCELEDGER,
    _SUBLEDGERACCLINEITEMTYPE,
    _SUPPLIER,
    _SUPPLIERCOMPANY,
    _TRANSACTIONCURRENCY,
    _WBSELEMENT,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    _WORKCENTER,
    _WORKPACKAGE,
    _WORKPACKAGEWORKITEM,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCTGDOCTYPEAUTHORIZATIONGROUP,
    ACTLPANDIFFVALUATIONQUANTITY,
    ACTLPLANDIFFREFERENCEQUANTITY,
    ACTLPLNDIFFAMTINCOCODECRCY,
    ACTLPLNDIFFAMTINFREEDFNDCRCY1,
    ACTLPLNDIFFAMTINFREEDFNDCRCY2,
    ACTLPLNDIFFAMTINFREEDFNDCRCY3,
    ACTLPLNDIFFAMTINFREEDFNDCRCY4,
    ACTLPLNDIFFAMTINFREEDFNDCRCY5,
    ACTLPLNDIFFAMTINFREEDFNDCRCY6,
    ACTLPLNDIFFAMTINFREEDFNDCRCY7,
    ACTLPLNDIFFAMTINFREEDFNDCRCY8,
    ACTLPLNDIFFAMTINGLOBALCRCY,
    ACTLPLNDIFFAMTINOBJECTCRCY,
    ACTLPLNDIFFAMTINTRANSCRCY,
    ACTUALAMOUNTINCOMPANYCODECRCY,
    ACTUALAMOUNTINFREEDFNDCRCY1,
    ACTUALAMOUNTINFREEDFNDCRCY2,
    ACTUALAMOUNTINFREEDFNDCRCY3,
    ACTUALAMOUNTINFREEDFNDCRCY4,
    ACTUALAMOUNTINFREEDFNDCRCY5,
    ACTUALAMOUNTINFREEDFNDCRCY6,
    ACTUALAMOUNTINFREEDFNDCRCY7,
    ACTUALAMOUNTINFREEDFNDCRCY8,
    ACTUALAMOUNTINGLOBALCURRENCY,
    ACTUALAMOUNTINOBJECTCURRENCY,
    ACTUALAMOUNTINTRANSACTIONCRCY,
    ACTUALPLANCODE,
    ACTUALQUANTITYINBASEUNIT,
    ACTUALREFERENCEQUANTITY,
    ACTUALVALUATIONQUANTITY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSEMBLY,
    ASSETACCTTRANSCLASSFCTN,
    ASSETCLASS,
    ASSETDEPRECIATIONAREA,
    ASSIGNMENTREFERENCE,
    BASEUNIT,
    BILLABLECONTROL,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BUDGETINGTYPE,
    BUDGETPERIOD,
    BUDGETPROCESS,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CASHLEDGERACCOUNT,
    CASHLEDGERCOMPANYCODE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGOBJECTCLASS,
    CONTROLLINGOBJECTCURRENCY,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTSOURCEUNIT,
    CREATIONDATE,
    CUSTOMER,
    CUSTOMERBASICAUTHORIZATIONGRP,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    EQUIPMENT,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALTRANSACTIONTYPE,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINCOCODECRCY,
    FIXEDAMOUNTINGLOBALCRCY,
    FIXEDAMOUNTINTRANSCRCY,
    FIXEDASSET,
    FIXEDQUANTITY,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    FUNCTIONALLOCATION,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GLACCOUNT,
    GLACCOUNTAUTHORIZATIONGROUP,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    ISCOMMITMENT,
    ISSTATISTICALCOSTCENTER,
    ISSTATISTICALORDER,
    ISSTATISTICALSALESDOCUMENT,
    JOINTVENTURE,
    JOINTVENTUREACCOUNTINGACTIVITY,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREPRODUCTIONDATE,
    LEDGERGLLINEITEM,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MASTERFIXEDASSET,
    MATERIAL,
    MATERIALGROUP,
    MMSERVICEPACKAGE,
    MMSERVICEPACKAGELINE,
    ORDERCATEGORY,
    ORDERID,
    ORDERITEM,
    ORDEROPERATION,
    ORDERSUBOPERATION,
    ORDERTYPE,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINPROFITCENTER,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERBUDGETPERIOD,
    PARTNERBUSINESSAREA,
    PARTNERBUSINESSPROCESS,
    PARTNERCOMPANY,
    PARTNERCOMPANYCODE,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PARTNERCOSTOBJECT,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERGRANT,
    PARTNERORDER,
    PARTNERORDER_2,
    PARTNERPROFITCENTER,
    PARTNERPROJECT,
    PARTNERPROJECTEXTERNALID,
    PARTNERPROJECTINTERNALID,
    PARTNERPROJECTNETWORK,
    PARTNERPROJECTNETWORKACTIVITY,
    PARTNERSALESDOCUMENT,
    PARTNERSEGMENT,
    PARTNERWBSELEMENT,
    PARTNERWBSELEMENTEXTERNALID,
    PARTNERWBSELEMENTINTERNALID,
    PERSONNELNUMBER,
    PLANAMOUNTINCOMPANYCODECRCY,
    PLANAMOUNTINFREEDEFINEDCRCY1,
    PLANAMOUNTINFREEDEFINEDCRCY2,
    PLANAMOUNTINFREEDEFINEDCRCY3,
    PLANAMOUNTINFREEDEFINEDCRCY4,
    PLANAMOUNTINFREEDEFINEDCRCY5,
    PLANAMOUNTINFREEDEFINEDCRCY6,
    PLANAMOUNTINFREEDEFINEDCRCY7,
    PLANAMOUNTINFREEDEFINEDCRCY8,
    PLANAMOUNTINGLOBALCURRENCY,
    PLANAMOUNTINOBJECTCURRENCY,
    PLANAMOUNTINTRANSACTIONCRCY,
    PLANNINGCATEGORY,
    PLANPRICEINCOMPANYCODECURRENCY,
    PLANPRICEINGLOBALCURRENCY,
    PLANPRICEINTRANSACTIONCURRENCY,
    PLANREFERENCEQUANTITY,
    PLANT,
    PLANVALUATIONQUANTITY,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNAMTTYPE,
    PUBSECBUDGETCNSMPNDATE,
    PUBSECBUDGETCNSMPNFSCLPERIOD,
    PUBSECBUDGETCNSMPNFSCLYEAR,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    QUANTITY,
    REALESTATEBUILDING,
    REALESTATECONTRACT,
    REALESTATEPROPERTY,
    REBUSINESSENTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REFERENCEQUANTITY,
    REFERENCEQUANTITYUNIT,
    RERENTALOBJECT,
    RESERVATION,
    RESERVATIONITEM,
    RESERVATIONTYPE,
    RESERVICECHARGEKEY,
    RESETTLEMENTUNITID,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERTYPE,
    SALESORGANIZATION,
    SEGMENT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SERVICESRENDEREDDATE,
    SETTLEMENTREFERENCEDATE,
    SHIPTOPARTY,
    SOLDMATERIAL,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    SUPPLIERBASICAUTHORIZATIONGRP,
    TRANSACTIONCURRENCY,
    VALUATIONAREA,
    VALUATIONFIXEDQUANTITY,
    VALUATIONQUANTITY,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WBSISSTATISTICALWBSELEMENT,
    WORKCENTERINTERNALID,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACTUALPLANJOURNALENTRYITEM, COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGREQTRANSSQNC, FISCALPERIOD, FISCALYEAR, FISCALYEARPERIOD, GLOBALCURRENCY, LEDGER, LEDGERFISCALYEAR, POSTINGDATE, PROJECT, PROJECTEXTERNALID, PROJECTINTERNALID, SOURCELEDGER, WBSELEMENT)
);