Input data of the SAP Purchase-to-Pay Connector for AppOne

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 Purchase-to-Pay Connector for AppOne.

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", "LFDAT", "ERNAM", "AFNAM", "LIFNR", "EKORG", "EKGRP", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS"	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", "WAERS", "WKURS", "LIFNR", "EKORG", "EKGRP", "ERNAM"	BSTYP = 'F' Date: AEDAT
EKPO	Purchasing Document Item Data	"MANDT", "EBELN", "EBELP", "BANFN", "BNFPO", "BUKRS", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR"	BSTYP = 'F'
EKBE	History per Purchasing Document Data	"MANDT", "EBELN", "EBELP", "BELNR", "BUZEI", "BEWTP", "SHKZG", "CPUDT", "CPUTM", "ERNAM", "ELIKZ", "MENGE"	BEWTP = ‘E' AND SHKZG = 'S' Date: CPUDT

Invoice Ttables

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"	Date: CPUDT
RSEG	Document Item Incoming Invoice Data	"MANDT", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "WRBTR", "SHKZG", "MENGE"

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", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"	BUZEI = 001 Date: CPUDT
BSAK	Accounting Secondary Index for Vendors (Cleared Items) Data	"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"	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_NEW", "VALUE_OLD"	`FNAME in ["KEY, "BANPR", "PROCSTAT", "FRGZU", "LOEKZ", "ABSKZ", "NETPR", "ZLSPR", "ZTERM", "ZFBDT", "ZUONR", "BVTYP", "HBKID", "AUGBL"] AND TABNAME in ["EBAN", "EKKO", "EKPO", "RBKP", "RSEG", "BSEG"]`

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"

Vendor master data table

The following table is the standard SAP vendor 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. See .

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", "LGOBE", "LGORT"

* Language is the language setting you define in the connector. See .

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"
T024	Purchasing Groups Data	"MANDT", "EKGRP", "EKNAM"
T024E	Purchasing Organizations Data	"MANDT", "EKORG", "EKOTX"

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. See .

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. See .

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. See .