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.
Updated 3 months ago