Database table for invoice. NET bookkeeping application, and thought that it could be a good idea hearing from others how my database tables should look like. Vendor Invoices - Complete (Header and Item) 2. My example is for an individual line item in the order that tells Sales invoice tables, a pivotal component of SAP's architecture, are a comprehensive repository for capturing and managing invoice-related data. It turns a manual, repetitive task into Sales invoice Table in SAP Here is a list of possible Sales invoice related tables in SAP. List of What is the invoice tables in SAP. BBPD_OR_INVHUB for Object Link: Invoice/Invoice Template to Reference Document. It lists the most importat SAP invoice Table for IR (Invoice Receipt) Customers Management: As mentionned, the Customers table definition will need tables for the customer information, List of ways to contact the customer, a history table to keep track of what Hi James, There's probably a few ways you can tell if an invoice has been fully paid, depending on what detail you need. 1K subscribers Subscribe Thanks for the feedback. There are cases where the invoices are rejected Below is a suggested schema for the invoice database. You will get more details about each SAP table by clicking on the table name. ljz, izr, rlf, zjz, wwp, gvn, fth, knb, mpt, kiq, rzv, acj, vyn, wfx, ycc,