- 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
- Input data of the SAP Purchase-to-Pay Connector for AppOne
- Other settings
- Purchase-to-Pay tags
- Purchase-to-Pay Due dates
- SAP Connector for Purchase to Pay Discovery Accelerator
- 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 Purchase-to-Pay Connector for AppOne
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 Purchase-to-Pay Connector for AppOne.
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", "LFDAT", "ERNAM", "AFNAM", "LIFNR", "EKORG", "EKGRP", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS" |
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", "WAERS", "WKURS", "LIFNR", "EKORG", "EKGRP", "ERNAM" |
Date:
AEDAT |
|
|
Purchasing Document Item Data |
"MANDT", "EBELN", "EBELP", "BANFN", "BNFPO", "BUKRS", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR" |
|
|
|
History per Purchasing Document Data |
"MANDT", "EBELN", "EBELP", "BELNR", "BUZEI", "BEWTP", "SHKZG", "CPUDT", "CPUTM", "ERNAM", "ELIKZ", "MENGE" |
Date:
CPUDT |
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" |
Date:
CPUDT |
|
|
Document Item Incoming Invoice Data |
"MANDT", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "WRBTR", "SHKZG", "MENGE" |
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", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T" |
Date:
CPUDT |
|
|
Accounting Secondary Index for Vendors (Cleared Items) Data |
"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T" |
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_NEW", "VALUE_OLD" |
`FNAME in ["KEY, "BANPR", "PROCSTAT", "FRGZU", "LOEKZ", "ABSKZ", "NETPR", "ZLSPR", "ZTERM", "ZFBDT", "ZUONR", "BVTYP", "HBKID", "AUGBL"] AND TABNAME in ["EBAN", "EKKO", "EKPO", "RBKP", "RSEG", "BSEG"]` |
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 vendor 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. See .
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", "LGOBE", "LGORT" |
* Language is the language setting you define in the connector. See .
The following tables are the standard SAP organizational structure master data tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
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" |
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. See .
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. See .
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. See .
- Introduction
- Transactional data tables
- Purchase requisition tables
- Purchasing document tables
- Invoice Ttables
- Accounting tables
- Change log tables
- Master data tables
- User master data tables
- Vendor 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
