SAP Training: SAP DW Tables for AP Financial Documents

SAP DW Tables for AP Financial Documents

Do you need to build reporting of accounts payable? Are you unsure of which SAP tables contain indicative data for vendors or which tables contain the invoice headers and lines needed for expense reporting? In this course, you will learn how various tables are related and how can they be queried to get the results you need. We will walk you through several AP tables and finish with a sample query.

In this course you will learn:

3  Reviews    5.0 of 5.0

Course Goal

  • Learn SAP tables used for storing accounts payable data
  • Learn SAP tables used for storing indicative data related to payables
  • Learn table relationships needed to query payables data


  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project team members

Lesson Plan

Lesson Description Preview
1 Welcome Preview
2 Introduction & Agenda
Overview of Accounts Payable Documents in SAP
3 Looking at the SAP documents
SAP Tables
4 SAP Tables for Vendor Indicative Data
5 Tables for Posted Accounts Payable Invoices - Posted GL Header
6 Tables for Posted Accounts Payable Invoices - Posted Vendor Header
7 Tables for Posted Accounts Payable Invoices - Posted GL Lines
Querying Accounts Payable Invoices
8 Querying Accounts Payable Overview and Linking
9 Querying Accounts Payable Example SQL Query
Summary and Appendix
10 Course Summary
11 Appendix A - Mapping Tables PDF
12 Appendix B - Course slides - PDF


Suzanne Callihan

5.0 Average Rating

3 Reviews

21 Students

1 Courses

Adjunct Instructor (STEM)

Edmond, OK, US

Lead Business Analyst, SQL Developer and CPA (FL) with over 20 years experience in designing, analyzing and troubleshooting accounting systems. SAP focus is on FICO, along with the associated tables needed for data warehousing.

SAP FI (GL, AR, AP), VIM (Vendor Invoice Management), T-SQL, PL/SQL, HANA Studio, Business Objects, SAS, Microsoft Access, EXCEL, Powerpoint, Project


Student Feedback


Average Rating







Language: English
Level: Intermediate
Duration: 1.0 hours
Type:  Instructor-led
Delivery: Online, instructor-led
Release: ECC 6.0
Category: SAP Financials

Share this course with a friend

SAP students


student views.
Join them!

SAP Student testimonial
Michael Management always provides me with top notch training with the most flexibility and affordability. With their credible SAP courses and certifications, I have kept my knowledge and skills up to date in a most competitive job market. I highly recommend Michael Management for all your SAP training!
-Kim  G.
Project Management Coordinator
Nanotechnology Research Centre, NRC

Related Training

Training 10 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses