ACITEM

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 ACITEM (
    ACCOUNTINGDOCUMENT,
    ACTUALPLANCODE,
    ACTUALPLANJOURNALENTRYITEM,
    COMPANYCODE,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    GRANTID,
    LEDGER,
    SOURCELEDGER,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _BUDGETINGTYPE,
    _BUSINESSTRANSACTIONTYPE,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _COUNTRYCHARTOFACCOUNTS,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _DISTRIBUTIONCHANNEL,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FINANCIALTRANSACTIONTYPE,
    _FISCALPERIODFORVARIANT,
    _FISCALYEAR,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FUNCTIONALAREA,
    _FUND,
    _GLACCOUNTINCOMPANYCODE,
    _GLACCOUNTTYPE,
    _GLOBALCURRENCY,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEARFORVARIANT,
    _LOGICALSYSTEM,
    _ORDER,
    _PREDECESSORREFERENCEDOCTYPE,
    _PROFITCENTER,
    _PUBSECBDGTCNSMPNTYPE,
    _PUBSECBUDGETCNSMPNAMTTYPE,
    _PUBSECBUDGETCNSMPNTYPE,
    _REFERENCEDOCUMENTTYPE,
    _SALESDOCUMENT,
    _SALESORGANIZATION,
    _SEGMENT,
    _SERVICEDOCUMENT,
    _SOURCELEDGER,
    _SPECIALGLCODE,
    _SUBLEDGERACCLINEITEMTYPE,
    _SUPPLIER,
    _WBSELEMENTEXTERNALID,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    ASSETCLASS,
    ASSIGNMENTREFERENCE,
    BUDGETINGTYPE,
    BUDGETPROCESS,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONDATE,
    CREATIONDATETIME,
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FOLLOWONDOCUMENTTYPE,
    FUNCTIONALAREA,
    FUND,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISOPENITEMMANAGED,
    ISREVERSAL,
    ISREVERSED,
    LASTCHANGEDATETIME,
    LEDGERFISCALYEAR,
    LEDGERGLLINEITEM,
    LOGICALSYSTEM,
    ORDERID,
    ORGANIZATIONDIVISION,
    ORIGINOBJECTTYPE,
    PLANNINGCATEGORY,
    PLANT,
    POSTINGDATE,
    PREDECESSORREFERENCEDOCCNTXT,
    PREDECESSORREFERENCEDOCITEM,
    PREDECESSORREFERENCEDOCTYPE,
    PREDECESSORREFERENCEDOCUMENT,
    PROFITCENTER,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNAMTTYPE,
    PUBSECBUDGETCNSMPNDATE,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTITEMGROUP,
    REFERENCEDOCUMENTTYPE,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    SALESDOCUMENT,
    SALESORGANIZATION,
    SEGMENT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTTYPE,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    SPECIALGLCODE,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONAREA,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACTUALPLANCODE, ACTUALPLANJOURNALENTRYITEM, COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, GRANTID, LEDGER, SOURCELEDGER)
);