PTI

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 PTI (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    TAXBOX,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    VALIDFROM,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINREPORTINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPLACE,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COUNTRYCURRENCY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FISCALPERIOD,
    GLACCOUNT,
    NETDUEDATE,
    POSTINGDATE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    TARGETTAXCODE,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXCALCULATIONPROCEDURE,
    TAXJURISDICTION,
    TAXREPORTINGDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, TAXBOX, TAXCODE, TAXDECLNAMOUNTTYPE, VALIDFROM)
);