SAP Training: SAP DW Tables for AP Financial Documents
SAP DW Tables for AP Financial Documents

IC0806

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:

Not Enough Reviews Yet

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

Audience

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


Lesson Plan

Lesson Description Preview
Introduction
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



Instructor

Suzanne Callihan

No Reviews Yet

No Reviews Yet

8 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

Not Enough Reviews Yet




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



8 SAP students

students enrolled.
Join them!


SAP Student testimonial
The final exams were tough but fair and I have already used many of the theories learned in my day to day job.
-Derek  F.
General Ledger Accountant
Oce


Related Training


Training 10 or more people?

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

SAP Training for Businesses