- 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
- SAP Connector for Order-to-Cash Discovery Accelerator
- Input data of the SAP Connector for Order-to-Cash Discovery Accelerator
- Configuring the 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 Order-to-Cash Discovery Accelerator.
Sales document tables
The following tables are the standard SAP sales document tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Sales Document Header Data |
"MANDT", "VBELN", "VBTYP", "AUART", "KUNNR", "BUKRS_VF", "VKORG", "VTWEG", "SPART", "VKBUR", "VKGRP", "ERNAM", "ERDAT", "ERZET", "VDATU" |
Date: ERDAT |
|
|
Sales Document Item Data |
"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET",' "ERNAM", "MATNR", "MATKL", "WERKS", "VSTEL", "LGORT", "NETWR", "WAERK", "PSTYV", "PRCTR", "KWMENG", "VRKME" |
Date: ERDAT |
|
|
Sales Document Schedule Line Data |
"MANDT", "VBELN", "POSNR", "ETENR", "EDATU" | |
|
|
Sales Document Business Data |
"MANDT", "VBELN", "POSNR", "ZTERM", "INCO1", "KURSK", "PRSDT" |
Delivery document tables
The following tables are the standard SAP delivery document tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Delivery Document Header Data |
"MANDT", "VBELN",
"ERDAT", "ERZET", "VBTYP", "ERNAM" |
Date: ERDAT |
|
|
Delivery Document Item Data |
"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET", "VGBEL", "VGPOS", "ERNAM" |
Date: ERDAT |
Billing document tables
The following tables are the standard SAP billing document tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Billing Document Header Data |
"MANDT", "VBELN", "VBTYP", "ERNAM",
"SFAKN", "STGRD", "ERDAT", "ERZET", "FKTYP" |
Date: ERDAT |
|
|
Billing Document Item Data |
"MANDT", "VBELN", "POSNR, "ERDAT", "ERZET", "VGBEL", "VGPOS", "ERNAM" |
Date: ERDAT |
Accounting document tables
The following tables are the standard SAP accounting document tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Payment Document Header Data |
"MANDT", "BUKRS",
"BELNR", "GJAHR", "BLART", "CPUDT", "CPUTM", "USNAM",
|
Date: CPUDT |
|
|
Accounting: Secondary Index for Customers data |
"MANDT", "BUKRS",
"BELNR", "GJAHR",
|
Date: CPUDT |
|
|
Accounting Secondary Index for Customers (Cleared Items) Data |
"MANDT", "BUKRS",
"BELNR", "GJAHR",
|
Date: CPUDT |
|
|
Additional Data for Document Segment Clearing Information Data |
"MANDT", "BUKRS_CLR",
"BELNR_CLR", "GJAHR_CLR", "INDEX_CLR","CLRIN",
"BUKRS", "BELNR", "GJAHR", "WAERS", "WRBTR", "BUZEI", "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_NEW", "VALUE_OLD" |
`FNAME in ['LFDAT', 'FKDAT', 'LIFSK', 'FAKSK', 'CMGST', 'WBSTK', 'PODAT', 'LFIMG', 'SKFBP', 'ZTERM', 'ZFBDT', 'ZUONR', 'BVTYP', 'ZLSPR', 'AUGBL', 'NETPR', 'ABGRU', 'FAKSP', 'WMENG', 'BMENG', 'EDATU', 'LIFSP', 'PRSDT', 'KURSK', 'WAERK', 'HBKID'] AND TABNAME in ['VBAK', 'VBAP', 'VBEP', 'VBKD', 'LIKP', 'LIPS', 'VBUK', 'VBRK', 'VBRP', 'BSEG', 'BSEGR']` |
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" |
Customer master data table
The following table is the standard SAP customer master data table.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
General Customer Master Data |
"MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO" | |
|
|
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 Order-to-Cash Discovery Accelerator.
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'*
|
|
|
Storage Locations Data |
"MANDT", "WERKS", "LGORT", "LGOBE" | |
|
|
Assign Internal to Language-Dependent Unit Table and Data |
"MANDT", "MSEHI", "MSEHT", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Material Group Descriptions Data |
"MANDT", "MATKL", "WGBEZ", "SPRAS" |
SPRAS = 'Language'*
|
\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash 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 |
|---|---|---|---|
|
|
Company Codes Data |
"MANDT", "BUKRS", "BUTXT", "WAERS" | |
|
|
Plants/Branches Data |
"MANDT", "WERKS", "NAME1" | |
|
|
Organizational Unit Sales Divisions Texts Data |
"MANDT", "SPART", "VTEXT", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Organizational Unit Sales Groups Texts Data |
"MANDT", "VKGRP", "BEZEI", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Organizational Unit Sales Organizations Data |
"MANDT", "VKBUR", "BEZEI", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Organizational Unit Sales Organizations Texts Data |
"MANDT", "VKORG", "VTEXT", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Organizational Unit Shipping Points Data |
"MANDT", "VSTEL", "ALAND" | |
|
|
Organizational Unit Distribution Channels Texts Data |
"MANDT", "VTWEG", "VTEXT", "SPRAS" |
SPRAS = 'Language'*
|
\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash Discovery Accelerator.
Sales document master data tables
The following tables are the standard SAP sales document master data tables.
|
Table |
Stores |
Fields used in Process Mining |
Filtering |
|---|---|---|---|
|
|
Sales Document Item Categories Texts Data |
"MANDT", "PSTYV", "VTEXT", "SPRAS" |
SPRAS = 'Language'*
|
|
|
Sales Document Types Data |
"MANDT", "AUART", "BEZEI", "SPRAS" |
SPRAS = 'Language'*
|
\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash 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 |
|---|---|---|---|
|
|
Delivery Blocking Reason Texts data |
"MANDT", "LIFSP", "VTEXT", "SPRAS" |
SPRAS = 'Language' |
|
|
Billing Blocking Reason Texts data |
"MANDT", "FAKSP", "VTEXT", "SPRAS" |
SPRAS = 'Language' |
|
|
Blocking Reason Names in Automatic Payment Transactional data |
"MANDT", "ZAHLS", "TEXTL", "SPRAS" |
SPRAS = 'Language' |
|
|
Rejection Reasons for Sales Documents Texts data |
"MANDT", "ABGRU", "BEZEI", "SPRAS" |
SPRAS = 'Language' |
|
|
Reasons for Reverse Posting (Name) data |
"MANDT", "STGRD", "TXT40", "SPRAS" |
SPRAS = 'Language' |
\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash 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" |
|
|
|
Conversion Factors data |
"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "FFACT", "TFACT" |
|
|
|
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 Order-to-Cash Discovery Accelerator.
- Introduction
- Transactional data tables
- Sales document tables
- Delivery document tables
- Billing document tables
- Accounting document tables
- Change log tables
- Master data tables
- User master data tables
- Customer master data table
- Material master data tables
- Organizational structure master data tables
- Sales document master data tables
- Block & cancellation reasons master data tables
- Currency master data tables
