Subscribe

UiPath Process Mining

The UiPath Process Mining Guide

SAP Purchase-to-Pay input fields

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 app template.

Transactional data tables

Purchase requisition tables

The following table is the standard SAP Purchase requisition table.

TableStoresFields used in Process MiningFiltering
EBANPurchase 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.

TableStoresFields used in Process MiningFiltering
EKKOPurchasing Document Header Data"MANDT", "EBELN", "BSTYP", "BSART", "AEDAT", "BUKRS", "WAERS", "WKURS", "LIFNR", "EKORG", "EKGRP", "ERNAM",
"PROCSTAT"
BSTYP = 'F'

Date: AEDAT
EKPOPurchasing Document Item Data"MANDT", "EBELN", "EBELP", "BSTYP", "BANFN", "BNFPO", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR", "MEINS"BSTYP = 'F'
EKBEHistory per Purchasing Document Data"MANDT", "EBELN", "EBELP", "BELNR", "BUZEI", "BEWTP", "SHKZG", "CPUDT", "CPUTM", "ERNAM", "ELIKZ"BEWTP = ‘E' AND SHKZG = 'S'

Date: CPUDT
EKETScheduling Agreement Schedule lines data"MANDT", "EBELN", "EBELP", "EINDT", "SLFDT"
EKKNAccount Assignment in Purchasing Document data"MANDT", "EBELN", "EBELP", "KOKRS", "KOSTL","GSBER"

Invoice tables

The following tables are the standard SAP invoice tables.

TableStoresFields used in Process MiningFiltering
RBKPDocument Header Invoice Receipt Data"MANDT", "BELNR", "GJAHR", "BUKRS", "CPUDT","CPUTM", "USNAM"Date: CPUDT
RSEGDocument Item Incoming Invoice Data"MANDT", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP"

Accounting tables

The following tables are the standard SAP accounting tables.

TableStoresFields used in Process MiningFiltering
BKPFAccounting Document Header Data"MANDT", "BUKRS", "BELNR", "GJAHR", "CPUDT", "CPUTM", "AWKEY", "BLART", "USNAM"Date: CPUDT
BSIKAccounting Secondary Index for Vendors Data"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI"BUZEI = 001

Date: CPUDT
BSAKAccounting Secondary Index for Vendors (Cleared Items) Data"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI"BUZEI = 001

Date: CPUDT
BSE_CLRAdditional 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.

TableStoresFields used in Process MiningFiltering
CDHDRChange Document Header Data"MANDANT", "OBJECTCLAS", "OBJECTID" , "CHANGENR", "UDATE", "UTIME", "USERNAME"OBJECTCLAS in [“BANF”, "EINKBELEG", "INCOMINGINVOICE", "BELEG"]

Date: UDATE
CDPOSChange 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", "AUGBL"] AND TABNAME in ["EBAN", "EKKO", "EKPO", "RBKP", "RSEG", "BSEG", "BSEGR"] AND CHANGENR >= '\<*value*>' AND CHANGENR <= '<value>'
(For example,
AND CHANGENR >= '0001299707' AND CHANGENR <= '0001507899'

Master data tables

User master data tables

The following tables are the standard SAP user master data tables.

TableStoresFields used in Process MiningFiltering
USR21User Name/Address Key Assignment Data"MANDT", "BNAME", "PERSNUMBER", "ADDRNUMBER"
ADRPPersons (Business Address Services) Data"CLIENT", "PERSNUMBER", "DATE_FROM", "DATE_TO", "NAME_FIRST", "NAME_LAST", "NATION"NATION = '' or NATION = 'I'
ADCPPerson/Address Assignment (Business Address Services) Data"CLIENT",
"PERSNUMBER", "ADDRNUMBER", "DATE_FROM", "DATE_TO", "DEPARTMENT", "FUNCTION", "NATION"
NATION = '' or NATION = 'I'
USR02Logon Data"MANDT", "BNAME", "USTYP"

Supplier master data table

The following table is the standard SAP supplier master data table.

TableStoresFields used in Process MiningFiltering
LFA1General Vendor Master Data"MANDT", "LIFNR", "NAME1", "NAME2", "LAND1", "REGIO", "XCPDK"
T005TCountry Names Data"MANDT", "LAND1", "LANDX", "SPRAS"SPRAS = 'Language'*
T005UTaxes Region Key Texts data"MANDT", "LAND1", "BLAND", "BEZEI", "SPRAS"SPRAS = 'Language'*

Customer master data tables

The following tables are the standard SAP customer master data tables.

TableStoresFields used in Process MiningFiltering
KNA1General Customer Master Data"MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO"

Material master data tables

The following tables are the standard SAP material master data tables.

TableStoresFields used in Process MiningFiltering
MAKTMaterial Descriptions Data"MANDT", "MATNR", "MAKTX", "SPRAS"SPRAS = 'Language'*
T023TMaterial Group Descriptions Data"MANDT", "MATKL", "WGBEZ", "SPRAS"SPRAS = 'Language'*
T001LStorage Locations Data"MANDT", "WERKS", "LGORT", "LGOBE"
T006AAssign Internal to Language-Dependent Unit Table and Data"MANDT", "MSEHI", "MSEHT", "SPRAS"SPRAS = 'Language'*

Organizational structure master data tables

The following tables are the standard SAP organizational structure master data tables.

TableStoresFields used in Process MiningFiltering
CSKTCost Center Texts data"MANDT", "KOKRS", "KOSTL", "DATBI", "KTEXT", "SPRAS"SPRAS = 'Language'*
AND
DATBI = "99991231"
T001Company Codes Data"MANDT", "BUKRS", "BUTXT", "WAERS"
T001WPlants/Branches Data"MANDT", "WERKS", "NAME1"
T024Purchasing Groups Data"MANDT", "EKGRP", "EKNAM"
T024EPurchasing Organizations Data"MANDT", "EKORG", "EKOTX"
TGSBTBusiness Area Names data"MANDT", "SPRAS", "GSBER", "GTEXT"SPRAS = 'Language'*

Purchasing document master data tables

The following tables are the standard SAP purchasing document master data tables.

TableStoresFields used in Process MiningFiltering
T161TTexts for Purchasing Document Types Data"MANDT", "BSART", "BSTYP", "BATXT", "SPRAS"SPRAS = 'Language'*

Block & Cancellation reasons master data tables

The following tables are the standard SAP block & cancellation reasons master data tables.

TableStoresFields used in Process MiningFiltering
T008TBlocking Reason Names in Automatic Payment Transactional data"MANDT", "ZAHLS", "TEXTL", "SPRAS"SPRAS = 'Language'*

Currency master data tables

The following tables are the standard SAP currency master data tables.

TableStoresFields used in Process MiningFiltering
TCURRExchange Rates data"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "UKURS"KURST = 'Exchange rate type'*
TCURFConversion Factors data"MANDT", "KURST", "FCURR", "TCURR", "GDATU", "FFACT", "TFACT"KURST = 'Exchange rate type'*
TCURXDecimal Places in Currencies data"CURRKEY", "CURRDEC"

Updated 18 days ago

SAP Purchase-to-Pay input fields


Suggested Edits are limited on API Reference Pages

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