ACESOBJITEM

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 ACESOBJITEM (
    ACCRUALENGINEACCRUALOBJECTTYPE,
    ACCRUALITEMTYPE,
    ACCRUALOBJECT,
    ACCRUALOBJECTLOGICALSYSTEM,
    ACCRUALSUBOBJECT,
    COMPANYCODE,
    LEDGER,
    ACCOUNTASSIGNMENTNUMBER,
    ACCRCLSGPOSTGACCRACCOUNT,
    ACCRCLSGPOSTGDOCUMENTTYPE,
    ACCRCLSGPOSTGOFFSTGACCOUNT,
    ACCROPNGPOSTGACCRACCOUNT,
    ACCROPNGPOSTGDOCUMENTTYPE,
    ACCROPNGPOSTGOFFSTGACCOUNT,
    ACCRPERDCPOSTGACCRACCOUNT,
    ACCRPERDCPOSTGDOCUMENTTYPE,
    ACCRPERDCPOSTGOFFSTGACCT,
    ACCRSUBOBJHDRENDOFLIFEDATE,
    ACCRSUBOBJHDRSTARTOFLIFEDATE,
    ACCRUALITEMISOBSOLETE,
    ACCRUALMETHOD,
    COMPANYCODECURRENCY,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    GLOBALCURRENCY,
    PURCHASINGDOCUMENTITEM,
    TOTALACCRAMOUNTINFREEDFNDCRCY1,
    TOTALACCRAMOUNTINFREEDFNDCRCY2,
    TOTALACCRAMOUNTINFREEDFNDCRCY3,
    TOTALACCRAMOUNTINFREEDFNDCRCY4,
    TOTALACCRAMOUNTINFREEDFNDCRCY5,
    TOTALACCRAMOUNTINFREEDFNDCRCY6,
    TOTALACCRAMOUNTINFREEDFNDCRCY7,
    TOTALACCRAMOUNTINFREEDFNDCRCY8,
    TOTALACCRAMOUNTINGLOBALCRCY,
    TOTALACCRAMOUNTINTRANSCRCY,
    TOTALACCRAMTINCOMPANYCODECRCY,
    TOTALACCRUALQUANTITY,
    TOTALACCRUALQUANTITYUNIT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCRUALENGINEACCRUALOBJECTTYPE, ACCRUALITEMTYPE, ACCRUALOBJECT, ACCRUALOBJECTLOGICALSYSTEM, ACCRUALSUBOBJECT, COMPANYCODE, LEDGER)
);