Subscribe

UiPath Process Mining

The UiPath Process Mining Guide

Input Data of the SAP Purchase-to-Pay Connector

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.

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 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"

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", "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"]

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'

ACDP

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 Other Settings.

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 Other Settings.

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 Other Settings.

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 Other Settings.

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 = 'M'

TCURF

Conversion Factors data

"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "FFACT", "TFACT"

KURST = 'M'

TCURX

Decimal Places in Currencies data

"CURRKEY", "CURRDEC"

Updated 11 days ago


See Also

SAP Input

Input Data of the SAP Purchase-to-Pay Connector


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.