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.
5 Reviews 4.8 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
Audience
- Consultants
- Developers
- End users
- IT/Business analysts
- Project team members
Exam/Certificate
- Certificate of Completion (more certification info)
Lesson Plan
| # | Description | |
|---|---|---|
| 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
4.8 Average Rating
5 Reviews
24 Students
1 Courses
Adjunct Instructor (STEM)
20+ Years' Experience in designing, analyzing and troubleshooting accounting systems; exceptional analytical, data mining, organizational and customer service skills.
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.
CPA (certified in Oklahoma and Florida)
MBA, University of North Florida, emphasis in Accounting
BBA, Marshall University (WV), Accounting
AAB, Columbus Technical Institute, Computer Programming
Student Feedback
4.8
Average Rating
Reviews |
Training 5 or more people?
Unlimited access for your entire SAP team including admin platform and premium reporting.SAP Training for Businesses
| Language: | English |
| Level: | Intermediate |
| Duration: | 1.0 hours |
| Type: | Instructor-led |
| Release: |
ECC 6.0 |
| Category: | SAP Financials |
