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 Purchase-to-Pay Discovery Accelerator.
Transactional data tables
Purchase requisition tables
The following table is the standard SAP Purchase requisition table.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
EBAN | Purchase Requisition Data | "MANDT", "BANFN" , "BNFPO", "BSTYP", "BSART", "BADAT", "ERNAM", "AFNAM", "BANPR", "MATKL", "MATNR", "MENGE", "PREIS", "WAERS", "MEINS" | BSTYP = 'B'Date: BADAT |
Purchasing document tables
The following tables are the standard SAP Purchasing document tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
EKKO | Purchasing Document Header Data | "MANDT", "EBELN", "BSTYP", "BSART", "AEDAT", "BUKRS", "WAERS", "WKURS", "LIFNR", "EKORG", "EKGRP", "ERNAM","PROCSTAT" | BSTYP = 'F'Date: AEDAT |
EKPO | Purchasing Document Item Data | "MANDT", "EBELN", "EBELP", "BSTYP", "BANFN", "BNFPO", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR", "MEINS" | BSTYP = 'F' |
EKBE | History per Purchasing Document Data | "MANDT", "EBELN", "EBELP", "BELNR", "BUZEI", "BEWTP", "SHKZG", "CPUDT", "CPUTM", "ERNAM", "ELIKZ" | BEWTP = ‘E' AND SHKZG = 'S'Date: CPUDT |
EKET | Scheduling Agreement Schedule lines data | "MANDT", "EBELN", "EBELP", "EINDT", "SLFDT" | |
EKKN | Account Assignment in Purchasing Document data | "MANDT", "EBELN", "EBELP", "KOKRS", "KOSTL","GSBER" |
Invoice tables
The following tables are the standard SAP invoice tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
RBKP | Document Header Invoice Receipt Data | "MANDT", "BELNR", "GJAHR", "BUKRS", "CPUDT","CPUTM", "USNAM", "WAERS", "KURSF", "BLDAT", "BUDAT", "ZFBDT", "ZBD3T", "BLART", "ZLSCH", "LAND1", "ZBD1T", "ZBD1P","ZBD2T", "ZBD2P", "ZTERM" | Date: CPUDT |
RSEG | Document Item Incoming Invoice Data | "MANDT", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "MATNR", "MENGE", "MEINS", "WERKS", "WRBTR", "SHKZG" |
Accounting tables
The following tables are the standard SAP accounting tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
BKPF | Accounting Document Header Data | "MANDT", "BUKRS", "BELNR", "GJAHR", "CPUDT", "CPUTM", "AWKEY", "BLART", "USNAM" | Date: CPUDT |
BSIK | Accounting Secondary Index for Vendors Data | "MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI" | BUZEI = 001Date: CPUDT |
BSAK | Accounting Secondary Index for Vendors (Cleared Items) Data | "MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI" | BUZEI = 001Date: CPUDT |
BSE_CLR | 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" | 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 [“BANF”, "EINKBELEG", "INCOMINGINVOICE", "BELEG"]Date: UDATE |
CDPOS | Change Document Item Cluster Data | "MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABNAME", "TABKEY", "FNAME", "CHNGIND", "VALUE_OLD", "VALUE_NEW" | FNAME in ["KEY, "BANPR", "PROCSTAT", "FRGZU", "LOEKZ", "ABSKZ", "NETPR", "ZLSPR", "ZTERM", "ZFBDT", "ZUONR", "BVTYP", "HBKID"] AND TABNAME in ["EBAN", "EKKO", "EKPO", "RBKP", "RSEG", "BSEG"]AND CHANGENR >= '<value>' AND CHANGENR <= '<value>' (For example,AND CHANGENR >= '0001299707' AND CHANGENR <= '0001507899') |
Master data tables
Invoices master data tables
The following tables are the standard SAP invoices master data tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
T003T | Document Type Texts Data | "MANDT", "BLART", "LTEXT", "SPRAS" | SPRAS = 'Language' |
T042ZT | Texts of Payment Methods for Automatic Payment Data | "MANDT", "TEXT2", "ZLSCH", "LAND1", "SPRAS" | SPRAS = 'Language' |
T052U | Own explanations for Terms of Payment Data | "MANDT", "ZTERM", "SPRAS", "TEXT1" | SPRAS = 'Language' |
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" |
Supplier master data table
The following table is the standard SAP supplier master data table.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
LFA1 | General Vendor Master Data | "MANDT", "LIFNR", "NAME1", "NAME2", "LAND1", "REGIO", "XCPDK" | |
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 Purchase-to-Pay Discovery Accelerator.
Customer master data tables
The following tables are the standard SAP customer master data tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
KNA1 | General Customer Master Data | "MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO" |
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'* |
T023T | Material Group Descriptions Data | "MANDT", "MATKL", "WGBEZ", "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'* |
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay 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 |
|---|---|---|---|
CSKT | Cost Center Texts data | "MANDT", "KOKRS", "KOSTL", "DATBI", "KTEXT", "SPRAS" | SPRAS = 'Language'* |
T001 | Company Codes Data | "MANDT", "BUKRS", "BUTXT", "WAERS" | |
T001W | Plants/Branches Data | "MANDT", "WERKS", "NAME1" | |
T024 | Purchasing Groups Data | "MANDT", "EKGRP", "EKNAM" | |
T024E | Purchasing Organizations Data | "MANDT", "EKORG", "EKOTX" | |
TGSBT | Business Area Names data | "MANDT", "SPRAS", "GSBER", "GTEXT" | SPRAS = 'Language'* |
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay Discovery Accelerator.
Purchasing document master data tables
The following tables are the standard SAP purchasing document master data tables.
| Table | Stores | Fields used in Process Mining | Filtering |
|---|---|---|---|
T161T | Texts for Purchasing Document Types Data | "MANDT", "BSART", "BSTYP", "BATXT", "SPRAS" | SPRAS = 'Language'* |
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay 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 |
|---|---|---|---|
T008T | Blocking Reason Names in Automatic Payment Transactional data | "MANDT", "ZAHLS", "TEXTL", "SPRAS" | SPRAS = 'Language'* |
* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Purchase-to-Pay 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 Purchase-to-Pay Discovery Accelerator.
Updated 2 months ago