ACCTDOCITM

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 ACCTDOCITM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSAREA,
    COMPANYCODE,
    COSTCENTER,
    FISCALYEAR,
    GLACCOUNT,
    GLACCOUNTINPURCHASEORG,
    JP_VATRETURNRULE,
    TAXCODE,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCUMENTITEMTYPE,
    ACTUALAMOUNTINCOMPANYCODECRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    CARECONCILIATIONKEY,
    COMPANYCODECURRENCY,
    DEBITCREDITCODE,
    DISTRIBUTEDTAXAMOUNTINCCRCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    HAVEONLYONEBSET,
    ISVSTMST,
    JP_DCBLNATLPRTAMTINCOCODECRCY,
    JP_VATRETURNRULENAME,
    JP_VATRETURNRULES,
    JP_VATRETURNRULETAXRATEDESC,
    MATERIAL,
    ORIGINALREFERENCEDOCUMENT,
    ORIGLTAXBASEAMOUNTINCOCODECRCY,
    POSTINGDATE,
    POSTINGKEY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITY,
    RECONCILIATIONACCOUNTTYPE,
    REFERENCEDOCUMENTTYPE,
    RULEORDER,
    STATRYRPTRUN,
    SYSTEMMESSAGEIDENTIFICATION,
    T_DEBITCREDITCODE,
    T_TAXCODE,
    T_TAXITEMGROUP,
    TAXAMT,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMT,
    TAXBASEAMTTCC,
    TAXBRKDWNAMOUNT1INCOCODECRCY,
    TAXBRKDWNAMOUNT2INCOCODECRCY,
    TAXBRKDWNAMOUNT3INCOCODECRCY,
    TAXDISTRIBUTIONCODE1,
    TAXDISTRIBUTIONCODE2,
    TAXDISTRIBUTIONCODE3,
    TAXITEMGROUP,
    TAXRATE,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ACCOUNTINGDOCUMENTTYPE, BUSINESSAREA, COMPANYCODE, COSTCENTER, FISCALYEAR, GLACCOUNT, GLACCOUNTINPURCHASEORG, JP_VATRETURNRULE, TAXCODE)
);