- Release notes
- Getting started
- Installation
- Configuration
- Integrations
- Authentication
- Working with Apps and Discovery Accelerators
- AppOne menus and dashboards
- AppOne setup
- TemplateOne 1.0.0 menus and dashboards
- TemplateOne 1.0.0 setup
- TemplateOne menus and dashboards
- TemplateOne 2021.4.0 setup
- Purchase to Pay Discovery Accelerator menus and dashboards
- Purchase to Pay Discovery Accelerator Setup
- Order to Cash Discovery Accelerator menus and dashboards
- Order to Cash Discovery Accelerator Setup
- Basic Connector for AppOne
- SAP Connectors
- Introduction to SAP Connector
- SAP input
- Checking the data in the SAP Connector
- Adding process specific tags to the SAP Connector for AppOne
- Adding process specific Due dates to the SAP Connector for AppOne
- Adding automation estimates to the SAP Connector for AppOne
- Adding attributes to the SAP Connector for AppOne
- Adding activities to the SAP Connector for AppOne
- Adding entities to the SAP Connector for AppOne
- SAP Order to Cash Connector for AppOne
- SAP Purchase to Pay Connector for AppOne
- SAP Connector for Purchase to Pay Discovery Accelerator
- Input Data of the SAP Connector for Purchase-to-Pay Discovery Accelerator
- Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator
- Configuring the activity code
- SAP Connector for Order-to-Cash Discovery Accelerator
- Superadmin
- Dashboards and charts
- Tables and table items
- Application integrity
- How to ....
- Working with SQL connectors
- Introduction to SQL connectors
- Setting up a SQL connector
- CData Sync extractions
- Running a SQL connector
- Editing transformations
- Releasing a SQL Connector
- Scheduling data extraction
- Structure of transformations
- Using SQL connectors for released apps
- Generating a cache with scripts
- Setting up a local test environment
- Separate development and production environments
- Useful resources

Process Mining
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.
Purchase requisition tables
The following table is the standard SAP Purchase requisition table.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Purchase Requisition Data |
"MANDT", "BANFN" , "BNFPO", "BSTYP", "BSART", "BADAT", "ERNAM", "AFNAM", "BANPR", "MATKL", "MATNR", "MENGE", "PREIS", "WAERS", "MEINS" |
Date:
BADAT |
Purchasing ocument tables
The following tables are the standard SAP Purchasing document tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Purchasing Document Header Data |
"MANDT", "EBELN", "BSTYP", "BSART", "AEDAT", "BUKRS", "WAERS", "WKURS", "LIFNR", "EKORG", "EKGRP", "ERNAM",
|
Date:
AEDAT |
|
|
Purchasing Document Item Data |
"MANDT", "EBELN", "EBELP", "BSTYP", "BANFN", "BNFPO", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR", "MEINS" |
|
|
|
History per Purchasing Document Data |
"MANDT", "EBELN", "EBELP", "BELNR", "BUZEI", "BEWTP", "SHKZG", "CPUDT", "CPUTM", "ERNAM", "ELIKZ" |
Date:
CPUDT |
|
|
Scheduling Agreement Schedule lines data |
"MANDT", "EBELN", "EBELP", "EINDT", "SLFDT" | |
|
|
Account Assignment in Purchasing Document data |
"MANDT", "EBELN", "EBELP", "KOKRS", "KOSTL","GSBER" |
Invoice tables
The following tables are the standard SAP invoice tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Document Header Invoice Receipt Data |
"MANDT", "BELNR", "GJAHR", "BUKRS", "CPUDT","CPUTM", "USNAM", "WAERS", "KURSF", "BLDAT", "BUDAT", "ZFBDT", "ZBD3T", "BLART", "ZLSCH", "LAND1", "ZBD1T", "ZBD1P",
"ZBD2T", "ZBD2P", "ZTERM" |
Date:
CPUDT |
|
|
Document Item Incoming Invoice Data |
"MANDT", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "MATNR", "MENGE", "MEINS", "WERKS", "WRBTR", "SHKZG" |
Accounting tables
The following tables are the standard SAP accounting tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Accounting Document Header Data |
"MANDT", "BUKRS", "BELNR", "GJAHR", "CPUDT", "CPUTM", "AWKEY", "BLART", "USNAM" |
Date:
CPUDT |
|
|
Accounting Secondary Index for Vendors Data |
"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI"
|
Date:
CPUDT |
|
|
Accounting Secondary Index for Vendors (Cleared Items) Data |
"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI" |
Date:
CPUDT |
|
|
Additional Data for Document Segment Clearing Information Data |
"MANDT", "BUKRS_CLR", "BELNR_CLR", "GJAHR_CLR", "INDEX_CLR", "CLRIN", "BUKRS", "BELNR", "GJAHR", "BUZEI", "WAERS", "WRBTR", "SHKZG" |
|
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 |
"MANDANT", "OBJECTCLAS", "OBJECTID" , "CHANGENR", "UDATE", "UTIME", "USERNAME" |
Date:
UDATE |
|
|
Change Document Item Cluster Data |
"MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABNAME", "TABKEY", "FNAME", "CHNGIND", "VALUE_OLD", "VALUE_NEW" |
`FNAME in ["KEY, "BANPR", "PROCSTAT", "FRGZU", "LOEKZ", "ABSKZ", "NETPR", "ZLSPR", "ZTERM", "ZFBDT", "ZUONR", "BVTYP", "HBKID"] AND
TABNAME in ["EBAN", "EKKO", "EKPO", "RBKP", "RSEG", "BSEG"]`
AND
CHANGENR >= '\))\))<value>' AND CHANGENR <= '\))\))<value>' (For example,
AND
CHANGENR >= '0001299707' AND CHANGENR <= '0001507899')
|
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 |
"MANDT", "BLART", "LTEXT", "SPRAS" |
|
|
|
Texts of Payment Methods for Automatic Payment Data |
"MANDT", "TEXT2", "ZLSCH", "LAND1", "SPRAS" |
|
|
|
Own explanations for Terms of Payment Data |
"MANDT", "ZTERM", "SPRAS", "TEXT1" |
|
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 |
"MANDT", "BNAME", "PERSNUMBER", "ADDRNUMBER" | |
|
|
Persons (Business Address Services) Data |
"CLIENT", "PERSNUMBER", "DATE_FROM", "DATE_TO", "NAME_FIRST", "NAME_LAST", "NATION" |
|
|
|
Person/Address Assignment (Business Address Services) Data |
"CLIENT",
"PERSNUMBER", "ADDRNUMBER", "DATE_FROM", "DATE_TO", "DEPARTMENT", "FUNCTION", "NATION" |
|
|
|
Logon Data |
"MANDT", "BNAME", "USTYP" |
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 |
"MANDT", "LIFNR", "NAME1", "NAME2", "LAND1", "REGIO", "XCPDK" | |
|
|
Country Names Data |
"MANDT", "LAND1", "LANDX", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Taxes Region Key Texts data |
"MANDT", "LAND1", "BLAND", "BEZEI", "SPRAS" |
SPRAS = 'Language'*
|
\* 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 |
"MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO" |
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 |
"MANDT", "MATNR", "MAKTX", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Material Group Descriptions Data |
"MANDT", "MATKL", "WGBEZ", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Storage Locations Data |
"MANDT", "WERKS", "LGORT", "LGOBE" | |
|
|
Assign Internal to Language-Dependent Unit Table and Data |
"MANDT", "MSEHI", "MSEHT", "SPRAS" |
SPRAS = 'Language'*
|
\* 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 |
"MANDT", "KOKRS", "KOSTL", "DATBI", "KTEXT", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Company Codes Data |
"MANDT", "BUKRS", "BUTXT", "WAERS" | |
|
|
Plants/Branches Data |
"MANDT", "WERKS", "NAME1" | |
|
|
Purchasing Groups Data |
"MANDT", "EKGRP", "EKNAM" | |
|
|
Purchasing Organizations Data |
"MANDT", "EKORG", "EKOTX" | |
|
|
Business Area Names data |
"MANDT", "SPRAS", "GSBER", "GTEXT" |
SPRAS = 'Language'*
|
\* 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 |
"MANDT", "BSART", "BSTYP", "BATXT", "SPRAS" |
SPRAS = 'Language'*
|
\* 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 |
"MANDT", "ZAHLS", "TEXTL", "SPRAS" |
SPRAS = 'Language'*
|
\* 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 |
"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "UKURS" |
KURST = 'Exchange rate type'*
|
|
|
Conversion Factors data |
"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "FFACT", "TFACT" |
KURST = 'Exchange rate type'*
|
|
|
Decimal Places in Currencies data |
"CURRKEY", "CURRDEC" |
\* Exchange rate type is the type you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
- Introduction
- Transactional data tables
- Purchase requisition tables
- Purchasing ocument tables
- Invoice tables
- Accounting tables
- Change log tables
- Master data tables
- Invoices master data tables
- User master data tables
- Supplier master data table
- Customer master data tables
- Material master data tables
- Organizational structure master data tables
- Purchasing document master data tables
- Block & cancellation reasons master data tables
- Currency master data tables