Subscribe

UiPath Process Mining

The UiPath Process Mining Guide

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.

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

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

Date: AEDAT
EKPOPurchasing Document Item Data"MANDT", "EBELN", "EBELP", "BANFN", "BNFPO", "BUKRS", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR"BSTYP = 'F'
EKBEHistory 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.

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

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", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"BUZEI = 001

Date: CPUDT
BSAKAccounting Secondary Index for Vendors (Cleared Items) Data"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"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_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.

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"

Vendor master data table

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

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

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

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

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'*

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

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

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"

* Exchange rate type is the type you define in the connector. See Other settings.

Updated 2 months ago

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


Suggested Edits are limited on API Reference Pages

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