- 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 user guide
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 Order-to-Cash Discovery Accelerator.
Transactional data tables
Sales document tables
The following tables are the standard SAP sales document tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
VBAK | Sales Document Header Data | "MANDT", "VBELN", "VBTYP", "AUART", "KUNNR", "BUKRS_VF", "VKORG", "VTWEG", "SPART", "VKBUR", "VKGRP", "ERNAM", "ERDAT", "ERZET", "VDATU" | VBTYP in ['C'] Date: ERDAT |
VBAP | Sales Document Item Data | "MANDT", "VBELN", "POSNR", "ERDAT", "ERZET",' "ERNAM", "MATNR", "MATKL", "WERKS", "VSTEL", "LGORT", "NETWR", "WAERK", "PSTYV", "PRCTR", "KWMENG", "VRKME" | Date: ERDAT |
VBEP | Sales Document Schedule Line Data | "MANDT", "VBELN", "POSNR", "ETENR", "EDATU" | |
VBKD | 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 |
|---|---|---|---|
LIKP | Delivery Document Header Data | "MANDT", "VBELN", "ERDAT", "ERZET", "VBTYP", "ERNAM" | VBTYP in ['J'] Date: ERDAT |
LIPS | 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 |
|---|---|---|---|
VBRK | Billing Document Header Data | "MANDT", "VBELN", "VBTYP", "ERNAM", "SFAKN", "STGRD", "ERDAT", "ERZET", "FKTYP" | VBTYP in ['M', 'N'] Date: ERDAT |
VBRP | 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 |
|---|---|---|---|
BKPF | Payment Document Header Data | "MANDT", "BUKRS", "BELNR", "GJAHR", "BLART", "CPUDT", "CPUTM", "USNAM", "AWKEY" | Date: CPUDT |
BSID | Accounting: Secondary Index for Customers data | "MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI" | BUZEI = '001' Date: CPUDT |
BSAD | Accounting Secondary Index for Customers (Cleared Items) Data | "MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI" | BUZEI = '001' Date: CPUDT |
BSE_CLR | 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" | BUZEI = '001' AND (CLRIN = '' OR CLRIN = 2) |
Change log tables
The following tables are the standard SAP change log tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
CDHDR | Change Document Header Data | "MANDANT", "OBJECTCLAS", "OBJECTID" , "CHANGENR", "UDATE", "UTIME", "USERNAME" | OBJECTCLAS in ['VERKBELEG', 'LIEFERUNG', 'FAKTBELEG', 'BELEG', 'BELEGR'] Date: UDATE |
CDPOS | 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'] |
Master data tables
User master data tables
The following tables are the standard SAP user master data tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
USR21 | User Name/Address Key Assignment Data | "MANDT", "BNAME", "PERSNUMBER", "ADDRNUMBER" | |
ADRP | Persons (Business Address Services) Data | "CLIENT", "PERSNUMBER", "DATE_FROM", "DATE_TO", "NAME_FIRST", "NAME_LAST", "NATION" | NATION = '' or NATION = 'I' |
ADCP | Person/Address Assignment (Business Address Services) Data | "CLIENT", "PERSNUMBER", "ADDRNUMBER", "DATE_FROM", "DATE_TO", "DEPARTMENT", "FUNCTION", "NATION" | NATION = '' or NATION = 'I' |
USR02 | 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 |
|---|---|---|---|
KNA1 | General Customer Master Data | "MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO" | |
T005T | Country Names Data | "MANDT", "LAND1", "LANDX", "SPRAS" | SPRAS = 'Language'* |
T005U | 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 |
|---|---|---|---|
MAKT | Material Descriptions Data | "MANDT", "MATNR", "MAKTX", "SPRAS" | SPRAS = 'Language'* |
T001L | Storage Locations Data | "MANDT", "WERKS", "LGORT", "LGOBE" | |
T006A | Assign Internal to Language-Dependent Unit Table and Data | "MANDT", "MSEHI", "MSEHT", "SPRAS" | SPRAS = 'Language'* |
T023T | 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 |
|---|---|---|---|
T001 | Company Codes Data | "MANDT", "BUKRS", "BUTXT", "WAERS" | |
T001W | Plants/Branches Data | "MANDT", "WERKS", "NAME1" | |
TSPAT | Organizational Unit Sales Divisions Texts Data | "MANDT", "SPART", "VTEXT", "SPRAS" | SPRAS = 'Language'* |
TVGRT | Organizational Unit Sales Groups Texts Data | "MANDT", "VKGRP", "BEZEI", "SPRAS" | SPRAS = 'Language'* |
TVKBT | Organizational Unit Sales Organizations Data | "MANDT", "VKBUR", "BEZEI", "SPRAS" | SPRAS = 'Language'* |
TVKOT | Organizational Unit Sales Organizations Texts Data | "MANDT", "VKORG", "VTEXT", "SPRAS" | SPRAS = 'Language'* |
TVST | Organizational Unit Shipping Points Data | "MANDT", "VSTEL", "ALAND" | |
TVTWT | 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 |
|---|---|---|---|
TVAPT | Sales Document Item Categories Texts Data | "MANDT", "PSTYV", "VTEXT", "SPRAS" | SPRAS = 'Language'* |
TVAKT | 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 |
|---|---|---|---|
TVLST | Delivery Blocking Reason Texts data | "MANDT", "LIFSP", "VTEXT", "SPRAS" | SPRAS = 'Language' |
TVFST | Billing Blocking Reason Texts data | "MANDT", "FAKSP", "VTEXT", "SPRAS" | SPRAS = 'Language' |
T008T | Blocking Reason Names in Automatic Payment Transactional data | "MANDT", "ZAHLS", "TEXTL", "SPRAS" | SPRAS = 'Language' |
TVAGT | Rejection Reasons for Sales Documents Texts data | "MANDT", "ABGRU", "BEZEI", "SPRAS" | SPRAS = 'Language' |
T041CT | 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 |
|---|---|---|---|
TCURR | Exchange Rates data | "MANDT", "KURST", "FCURR", "TCURR", "GDATU", "UKURS" | KURST = 'Exchange rate type' |
TCURF | Conversion Factors data | "MANDT", "KURST", "FCURR", "TCURR", "GDATU", "FFACT", "TFACT" | KURST = 'Exchange rate type' |
TCURX | 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