- 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 fashboards
- 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
Input Data of the SAP Connector for Purchase-to-Pay Discovery Accelerator
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.
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 |
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" |
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" |
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" |
|
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')
|
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" |
|
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" |
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.
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" |
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.
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.
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.
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.
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