Input Data of the SAP Connector for Purchase-to-Pay 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 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 ocument 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 = 001 Date: CPUDT
BSAK	Accounting Secondary Index for Vendors (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", "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.