Introduction
The input data consists of two parts: transactional data and master data. Below is an overview of the SAP input tables and input data fields for the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Transactional data tables
Purchase requisition tables
The following table is the standard SAP Purchase requisition table.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Purchase Requisition Data |
|
Date: |
Purchasing document tables
The following tables are the standard SAP Purchasing document tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Purchasing Document Header Data |
|
Date: |
| Purchasing Document Item Data |
|
|
| History per Purchasing Document Data |
|
Date: |
| Scheduling Agreement Schedule lines data |
| |
| Account Assignment in Purchasing Document data |
|
Invoice tables
The following tables are the standard SAP invoice tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Document Header Invoice Receipt Data |
| Date: |
| Document Item Incoming Invoice Data |
|
Accounting tables
The following tables are the standard SAP accounting tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Accounting Document Header Data |
| Date: |
| Accounting Secondary Index for Vendors Data |
|
Date: |
| Accounting Secondary Index for Vendors (Cleared Items) Data |
|
Date: |
| Additional Data for Document Segment Clearing Information Data |
|
|
Change log tables
The following tables are the standard SAP change log tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Change Document Header Data |
|
Date: |
| Change Document Item Cluster Data |
| `FNAME in ["KEY, "BANPR", "PROCSTAT", "FRGZU", "LOEKZ", "ABSKZ", "NETPR", "ZLSPR", "ZTERM", "ZFBDT", "ZUONR", "BVTYP", "HBKID"] AND AND |
Master data tables
Invoices master data tables
The following tables are the standard SAP invoices master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Document Type Texts Data |
|
|
| Texts of Payment Methods for Automatic Payment Data |
|
|
| Own explanations for Terms of Payment Data |
|
|
User master data tables
The following tables are the standard SAP user master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| User Name/Address Key Assignment Data |
| |
| Persons (Business Address Services) Data |
|
|
| Person/Address Assignment (Business Address Services) Data |
|
|
| Logon Data |
|
Supplier master data table
The following table is the standard SAP supplier master data table.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| General Vendor Master Data |
| |
| Country Names Data |
|
|
| Taxes Region Key Texts data |
|
|
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Customer master data tables
The following tables are the standard SAP customer master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| General Customer Master Data |
|
Material master data tables
The following tables are the standard SAP material master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Material Descriptions Data |
|
|
| Material Group Descriptions Data |
|
|
| Storage Locations Data |
| |
| Assign Internal to Language-Dependent Unit Table and Data |
|
|
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Organizational structure master data tables
The following tables are the standard SAP organizational structure master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Cost Center Texts data |
|
|
| Company Codes Data |
| |
| Plants/Branches Data |
| |
| Purchasing Groups Data |
| |
| Purchasing Organizations Data |
| |
| Business Area Names data |
|
|
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Purchasing document master data tables
The following tables are the standard SAP purchasing document master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Texts for Purchasing Document Types Data |
|
|
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Block & Cancellation reasons master data tables
The following tables are the standard SAP block & cancellation reasons master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Blocking Reason Names in Automatic Payment Transactional data |
|
|
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Currency master data tables
The following tables are the standard SAP currency master data tables.
Table | Stores | Fields used in Process Mining | Filtering |
---|---|---|---|
| Exchange Rates data |
|
|
| Conversion Factors data |
|
|
| Decimal Places in Currencies data |
|
* Exchange rate type is the type you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Updated 3 months ago