_INVOICE

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 _INVOICE (
    _BILLINGDOCUMENT,
    ACCOUNTINGDOCUMENT,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BILLINGDOCUMENT,
    BILLINGDOCUMENTITEM,
    BILLINGDOCUMENTITEMTEXT,
    CN_TAXENTITYID,
    CN_TAXINVCCODE,
    CN_TAXINVCCRCY,
    CN_TAXINVCNMBR,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CUSTOMER,
    FINANCIALACCOUNTTYPE,
    FISCALYEAR,
    GOODSRECEIPTISEXPECTED,
    ISCOMPLETELYDELIVERED,
    ISRETURNSITEM,
    ORDERQUANTITY,
    POSTINGDATE,
    PURCHASEORDERDATE,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERQUANTITYUNIT,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    SUPPLIER,
    TR_EDOCBUSPARTNERNAME,
    TR_ELECTRONICDOCBUSPARTNER,
    TRANSACTIONCURRENCY
);