- 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
- Input Data of the SAP Connector for Order-to-Cash Discovery Accelerator
- Configuring the SAP Connector for Order-to-Cash Discovery Accelerator
- 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
Input Data of the SAP Connector for Order-to-Cash Discovery Accelerator
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 |
---|---|---|---|
|
Sales Document Header Data |
|
Date: ERDAT |
|
Sales Document Item Data |
|
Date: ERDAT |
|
Sales Document Schedule Line Data |
|
|
|
Sales Document Business Data |
|
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 |
|
Date: ERDAT |
|
Delivery Document Item Data |
|
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 |
|
Date: ERDAT |
|
Billing Document Item Data |
|
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 |
|
Date: CPUDT |
|
Accounting: Secondary Index for Customers data |
|
Date: CPUDT |
|
Accounting Secondary Index for Customers (Cleared Items) Data |
|
Date: CPUDT |
|
Additional Data for Document Segment Clearing Information Data |
|
|
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 |
|
Date: UDATE |
|
Change Document Item Cluster Data |
|
`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 |
---|---|---|---|
|
User Name/Address Key Assignment Data |
|
|
|
Persons (Business Address Services) Data |
|
|
|
Person/Address Assignment (Business Address Services) Data |
|
|
|
Logon Data |
|
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 |
|
|
|
Country Names Data |
|
|
|
Taxes Region Key Texts data |
|
|
\* 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 |
|
|
|
Storage Locations Data |
|
|
|
Assign Internal to Language-Dependent Unit Table and Data |
|
|
|
Material Group Descriptions Data |
|
|
\* 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 |
|
|
|
Plants/Branches Data |
|
|
|
Organizational Unit Sales Divisions Texts Data |
|
|
|
Organizational Unit Sales Groups Texts Data |
|
|
|
Organizational Unit Sales Organizations Data |
|
|
|
Organizational Unit Sales Organizations Texts Data |
|
|
|
Organizational Unit Shipping Points Data |
|
|
|
Organizational Unit Distribution Channels Texts Data |
|
|
\* 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 |
|
|
|
Sales Document Types Data |
|
|
\* 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 |
|
SPRAS = 'Language' |
|
Billing Blocking Reason Texts data |
|
SPRAS = 'Language' |
|
Blocking Reason Names in Automatic Payment Transactional data |
|
SPRAS = 'Language' |
|
Rejection Reasons for Sales Documents Texts data |
|
SPRAS = 'Language' |
|
Reasons for Reverse Posting (Name) data |
|
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 |
|
|
|
Conversion Factors data |
|
|
|
Decimal Places in Currencies data |
|
\* 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