SAP© Data Warehouse Manual

Complete with Table extracts with fields and table relationships

Examples of all my nightly extracts with a complete listing of all fields available

2. Example of linking to an external database with the MSACCESS© database such as Vantive ©(trouble ticket database)

3. SAP major table structures with key field relationships

a. Financial Accounting and Controlling Module

· Profit Center

· Custom Ledger

· Cost Center

· Reconciliation

b. Accounts Payable

c. Accounts Receivable

d. Material Management

· Goods Receipts

e. Purchasing

· Purchasing Requisition

f. Project Planning

· Projects

· WBS with status codes

· Schedules

g. Sales and Distribution

· Sales/Order

· Shipping/Delivery

· Billing

4. Some examples of linking SAP© tables for reporting

5. Example of how to use the SE17 Tran code

6. Listing of my favorite Transaction codes

1. Search over 18,000 SAP tables by description or category --- eg Description - use a % in front and end of search - eg %asset% ---

2. Search 143 major SAP tables by field names or description --- eg field EBELN (PO Number)---

Use PDM to do nightly extracts of data/tables that are automatically placed into an MSACCESS© database. When you come into work the next morning you are ready to do your reporting for management with fresh data. PDM automates the process and makes working with SAP data easier to use and will make you a hero with your fellow workers. It is well worth the money spent (current price $200/user or $1,000/company). You can find more information about PDM at http://www.pdm.lu/

There is a complete Table of Contents and Index for easy references to the 127 pages.

COST - $100 per copy plus ($5 shipping inside US or $10 Outside US)

Send check to Charles Powell

PO Box 116762

Carrollton, TX 75011-6762

email: cpow@comcast.net

Major credit cards also accepted