VATSALESPURCHASELEDGERS

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 VATSALESPURCHASELEDGERS (
    ACCOUNTINGDOCUMENT,
    ACTIONRULEISGENERATED,
    AGENTCUSTOMER,
    AGENTSUPPLIER,
    AGENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BASEAMTWITHOUTTXINCCCRCY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    COMPANYCODENAME,
    CORRECTIONINVOICE,
    CORRECTIONINVOICEDATE,
    CORRECTIONINVOICEREVISIONDATE,
    CORRECTIONINVOICEREVISIONNMBR,
    CORRECTIONINVOICEYEAR,
    CURRENCY,
    CURRENCYISOCODE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXTERNALACCTGDOCUMENTDATE,
    EXTERNALCORRECTIONINVOICE,
    EXTERNALORIGINALDOCCUSTOMER,
    EXTERNALORIGINALDOCSUPPLIER,
    EXTERNALORIGINALDOCUMENT,
    FISCALYEAR,
    FOREIGNPARTNERINN,
    FOREIGNPARTNERKPP,
    FOREIGNPARTNERNAME,
    IMPORTCUSTOMSDECLN,
    IMPRTCSTMSDECLNISREAD,
    INVOICE,
    INVOICEYEAR,
    ISREVERSAL,
    ISREVERSED,
    ITEMWITHTAX,
    LEDGERLINESIGN,
    MATLRCPTDATEISREAD,
    MATLRCPTFINDATETYPE,
    MATLRCPTMATLMGMTDATETYPE,
    ORIGINALDOCUMENT,
    ORIGINALDOCUMENTISREVERSAL,
    ORIGINALDOCUMENTISREVERSED,
    ORIGINALDOCUMENTYEAR,
    ORIGINALINVOICEREVISIONDATE,
    ORIGINALINVOICEREVISIONNUMBER,
    ORIGINALREFERENCEDOCUMENT,
    PARTNERCC,
    PARTNERCUSTOMER,
    PARTNERINN_LENGTH,
    PARTNERSUPPLIER,
    PAYMENTORDEROUTPUTTYPE,
    POSTINGDATE,
    REALPARTNERINN,
    REALPARTNERKPP,
    REALPARTNERNAME,
    REFERENCEDOCUMENTNUMBER,
    REFERENCEDOCUMENTTYPE,
    REVERSEDOCSINCURPERDARESHOWN,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    REVISIONINVOICE,
    REVISIONINVOICEYEAR,
    REVISIONNUMBER,
    RU_COMPANYCODEINN,
    RU_COMPANYCODEKPP,
    RU_ORGOPERATIONTYPE,
    RU_PARTNERORGANIZATIONINN,
    RU_PARTNERORGANIZATIONKPP,
    RU_PERSONOPERATIONTYPE,
    RU_TXRATEOUTPCOLUMN,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOITEM,
    RU_VATSUBSCENARIOVERSION,
    SELECTEDDOCUMENT,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    TAXAMOUNTINCOCODECRCY,
    TAXCODE,
    TAXINVOICENUMBER,
    TAXITEM,
    TAXREPORTINGDATE,
    TXAMTWITHTXRATE10INCCCRCY,
    TXAMTWITHTXRATE18INCCCRCY,
    TXBASEAMTWITHTXRATE0INCCCRCY,
    TXBASEAMTWITHTXRATE10INCCCRCY,
    TXBASEAMTWITHTXRATE18INCCCRCY,
    VATINTRANSIT,
    VATINTRANSITBILLINGDOCUMENT
);