process-mining
2021.10
true
Process Mining
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Sep 2, 2024

Input data of the SAP Connector for Order-to-Cash 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 Order-to-Cash Discovery Accelerator.

Transactional data tables

Sales document tables

The following tables are the standard SAP sales document tables.

Table

Stores

Fields used in Process Mining

Filtering

VBAK

Sales Document Header Data

"MANDT", "VBELN", "VBTYP", "AUART", "KUNNR", "BUKRS_VF", "VKORG", "VTWEG", "SPART", "VKBUR", "VKGRP", "ERNAM", "ERDAT", "ERZET", "VDATU"

VBTYP in ['C']

Date: ERDAT

VBAP

Sales Document Item Data

"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET",' "ERNAM", "MATNR", "MATKL", "WERKS", "VSTEL", "LGORT", "NETWR", "WAERK", "PSTYV", "PRCTR", "KWMENG", "VRKME"

Date: ERDAT

VBEP

Sales Document Schedule Line Data

"MANDT", "VBELN", "POSNR", "ETENR", "EDATU"
 

VBKD

Sales Document Business Data

"MANDT", "VBELN", "POSNR", "ZTERM", "INCO1", "KURSK", "PRSDT"
 

Delivery document tables

The following tables are the standard SAP delivery document tables.

Table

Stores

Fields used in Process Mining

Filtering

LIKP

Delivery Document Header Data

"MANDT", "VBELN",
"ERDAT", "ERZET", "VBTYP", "ERNAM"

VBTYP in ['J']

Date: ERDAT

LIPS

Delivery Document Item Data

"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET", "VGBEL", "VGPOS", "ERNAM"

Date: ERDAT

Billing document tables

The following tables are the standard SAP billing document tables.

Table

Stores

Fields used in Process Mining

Filtering

VBRK

Billing Document Header Data

"MANDT", "VBELN", "VBTYP", "ERNAM",
"SFAKN", "STGRD", "ERDAT", "ERZET", "FKTYP"

VBTYP in ['M', 'N']

Date: ERDAT

VBRP

Billing Document Item Data

"MANDT", "VBELN", "POSNR, "ERDAT", "ERZET", "VGBEL", "VGPOS", "ERNAM"

Date: ERDAT

Accounting document tables

The following tables are the standard SAP accounting document tables.

Table

Stores

Fields used in Process Mining

Filtering

BKPF

Payment Document Header Data

"MANDT", "BUKRS",
"BELNR", "GJAHR", "BLART", "CPUDT", "CPUTM", "USNAM",

"AWKEY"

Date: CPUDT

BSID

Accounting: Secondary Index for Customers data

"MANDT", "BUKRS",
"BELNR", "GJAHR",

"BUZEI"

BUZEI = '001'

Date: CPUDT

BSAD

Accounting Secondary Index for Customers (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", "WAERS", "WRBTR", "BUZEI", "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 ['VERKBELEG', 'LIEFERUNG', 'FAKTBELEG', 'BELEG', 'BELEGR']

Date: UDATE

CDPOS

Change Document Item Cluster Data

"MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABNAME", "TABKEY", "FNAME", "CHNGIND", "VALUE_NEW", "VALUE_OLD"

`FNAME in ['LFDAT', 'FKDAT', 'LIFSK', 'FAKSK', 'CMGST', 'WBSTK', 'PODAT', 'LFIMG', 'SKFBP', 'ZTERM', 'ZFBDT', 'ZUONR', 'BVTYP', 'ZLSPR', 'AUGBL', 'NETPR', 'ABGRU', 'FAKSP', 'WMENG', 'BMENG', 'EDATU', 'LIFSP', 'PRSDT', 'KURSK', 'WAERK', 'HBKID']

AND TABNAME in ['VBAK', 'VBAP', 'VBEP', 'VBKD', 'LIKP', 'LIPS', 'VBUK', 'VBRK', 'VBRP', 'BSEG', 'BSEGR']`

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"
 

Customer master data table

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

Table

Stores

Fields used in Process Mining

Filtering

KNA1

General Customer Master Data

"MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO"
 

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 Order-to-Cash Discovery Accelerator.

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

T001L

Storage Locations Data

"MANDT", "WERKS", "LGORT", "LGOBE"
 

T006A

Assign Internal to Language-Dependent Unit Table and Data

"MANDT", "MSEHI", "MSEHT", "SPRAS"
SPRAS = 'Language'*

T023T

Material Group Descriptions Data

"MANDT", "MATKL", "WGBEZ", "SPRAS"
SPRAS = 'Language'*

\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash 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

T001

Company Codes Data

"MANDT", "BUKRS", "BUTXT", "WAERS"
 

T001W

Plants/Branches Data

"MANDT", "WERKS", "NAME1"
 

TSPAT

Organizational Unit Sales Divisions Texts Data

"MANDT", "SPART", "VTEXT", "SPRAS"
SPRAS = 'Language'*

TVGRT

Organizational Unit Sales Groups Texts Data

"MANDT", "VKGRP", "BEZEI", "SPRAS"
SPRAS = 'Language'*

TVKBT

Organizational Unit Sales Organizations Data

"MANDT", "VKBUR", "BEZEI", "SPRAS"
SPRAS = 'Language'*

TVKOT

Organizational Unit Sales Organizations Texts Data

"MANDT", "VKORG", "VTEXT", "SPRAS"
SPRAS = 'Language'*

TVST

Organizational Unit Shipping Points Data

"MANDT", "VSTEL", "ALAND"
 

TVTWT

Organizational Unit Distribution Channels Texts Data

"MANDT", "VTWEG", "VTEXT", "SPRAS"
SPRAS = 'Language'*

\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash Discovery Accelerator.

Sales document master data tables

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

Table

Stores

Fields used in Process Mining

Filtering

TVAPT

Sales Document Item Categories Texts Data

"MANDT", "PSTYV", "VTEXT", "SPRAS"
SPRAS = 'Language'*

TVAKT

Sales Document Types Data

"MANDT", "AUART", "BEZEI", "SPRAS"
SPRAS = 'Language'*

\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash 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

TVLST

Delivery Blocking Reason Texts data

"MANDT", "LIFSP", "VTEXT", "SPRAS"

SPRAS = 'Language'

TVFST

Billing Blocking Reason Texts data

"MANDT", "FAKSP", "VTEXT", "SPRAS"

SPRAS = 'Language'

T008T

Blocking Reason Names in Automatic Payment Transactional data

"MANDT", "ZAHLS", "TEXTL", "SPRAS"

SPRAS = 'Language'

TVAGT

Rejection Reasons for Sales Documents Texts data

"MANDT", "ABGRU", "BEZEI", "SPRAS"

SPRAS = 'Language'

T041CT

Reasons for Reverse Posting (Name) data

"MANDT", "STGRD", "TXT40", "SPRAS"

SPRAS = 'Language'

\* Language is the language setting you define in the Connector Settings file. See Configuring the SAP Connector for Order-to-Cash 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 Order-to-Cash Discovery Accelerator.

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.