UiPath Documentation
process-mining
2021.10
true

Process Mining user guide

Last updated May 5, 2026

Input Data of the SAP Order-to-Cash 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 Order-to-Cash Connector for AppOne.

Transactional data tables​

Sales document tables​

The following tables are the standard SAP sales document tables.

TableStoresFields used in Process MiningFiltering
VBAKSales Document Header Data"MANDT", "VBELN", "VBTYP", "AUART", "KUNNR", "BUKRS_VF", "VKORG", "VTWEG", "SPART", "VKBUR", "VKGRP", "ERNAM"VBTYP in [‘C', ‘K', 'H] Date: ERDAT
VBAPSales Document Item Data"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET",' "VGBEL", "VGPOS", "MATNR", "MATKL", "WERKS", "VSTEL", "LGORT", "NETWR", "WAERK", "PSTYV", "PRCTR", "KWMENG"Date: ERDAT
VBEPSales Document Schedule Line Data"MANDT", "VBELN", "POSNR", "ETENR"
VBKDSales Document Business Data"MANDT", "VBELN", "POSNR", "ZTERM", "INCO1", "KURSK", "PRSDT", "FKDAT"

Delivery document tables​

The following tables are the standard SAP delivery document tables.

TableStoresFields used in Process MiningFiltering
LIKPDelivery Document Header Data"MANDT", "VBELN", "VBTYP", "KUNNR", "VKORG", "INCO1", "LGNUM", "LGBZO", "VSTEL", "ERNAM", "LFART", "WADAT"VBTYP in ['J', 'T'] Date: ERDAT
LIPSDelivery Document Item Data"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET", "VGBEL", "VGPOS", "MATNR", "MATKL", "WERKS", "VTWEG", "SPART", "VKBUR", "VKGRP", "LGORT", "PSTYV", "LFIMG"Date: ERDAT

Billing document tables​

The following tables are the standard SAP billing document tables.

TableStoresFields used in Process MiningFiltering
VBRKBilling Document Header Data"MANDT", "VBELN", "VBTYP", "ERNAM", "SFAKN", "STGRD", "ERDAT", "ERZET", "FKDAT", "FKTYP"VBTYP in ['M', ‘N', 'O’, 'S’] Date: ERDAT
VBRPBilling Document Item Data"MANDT", "VBELN", "POSNR", "ERDAT", "ERZET", "VGBEL", "VGPOS"Date: ERDAT

Accounting document tables​

The following tables are the standard SAP accounting document tables.

TableStoresFields used in Process MiningFiltering
BKPFPayment Document Header Data"MANDT", "BUKRS", "BELNR", "GJAHR", "BLART", "CPUDT", "CPUTM", "USNAM", "AWKEY"Date: CPUDT
BSIDAccounting: Secondary Index for Customers data"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"BUZEI = '001' Date: CPUDT
BSADAccounting Secondary Index for Customers (Cleared Items) Data"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI", "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", "WAERS", "WRBTR", "BUZEI"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 ['VERKBELEG', 'LIEFERUNG', 'FAKTBELEG', 'BELEG', 'BELEGR'] Date: UDATE
CDPOSChange Document Item Cluster Data"MANDANT", "OBJECTCLAS", "OBJECTID", "CHANGENR", "TABNAME", "TABKEY", "FNAME", "VALUE_NEW", "VALUE_OLD", "CHNGIND"FNAME in ['LFDAT', ‘FKDAT', 'LIFSK', 'FAKSK', 'CMGST', 'WBSTK','PODAT', 'LFIMG', 'SKFBP', 'ZTERM', 'ZFBDT','ZUONR', 'BVTYP', 'ZLSPR', 'AUGBL', 'NETPR', 'ABGRU','FAKSP', 'WMENG', 'BMENG', 'EDATU', 'LIFSP', 'KOSTK', 'HBKID’,’PRSDT, 'KURSK', 'WAERK'] 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.

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", "ADDRNUMBER", "PERSNUMBER", "DATE_FROM", "DATE_TO", "DEPARTMENT", "FUNCTION", "NATION"NATION = '' or NATION = 'I'
USR02Logon Data"MANDT", "BNAME", "USTYP"

Customer master data table​

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

TableStoresFields used in Process MiningFiltering
KNA1General Customer Master Data"MANDT", "KUNNR", "NAME1", "NAME2", "LAND1", "REGIO"
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.

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'*
  • Language is the language setting you define in the connector..

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"
T001KValuation Area Data"MANDT", "BUKRS", "BWKEY"
T001LStorage Locations Data"MANDT", "WERKS", "LGORT", "LGOBE"
T001WPlants/Branches Data"MANDT", "WERKS", "NAME1", "BWKEY"
TSPATOrganizational Unit Sales Divisions Texts Data"MANDT", "SPART", "VTEXT", "SPRAS"SPRAS = 'Language'*
TVGRTOrganizational Unit Sales Groups Texts Data"MANDT", "VKGRP", "BEZEI", "SPRAS"SPRAS = 'Language'*
TVKBTOrganizational Unit Sales Organizations Data"MANDT", "VKBUR", "BEZEI", "SPRAS"SPRAS = 'Language'*
TVKOTOrganizational Unit Sales Organizations Texts Data"MANDT", "VKORG", "VTEXT", "SPRAS"SPRAS = 'Language'*
TVSTOrganizational Unit Shipping Points Data"MANDT", "VSTEL", "ALAND"
TVTWTOrganizational Unit Distribution Channels Texts Data"MANDT", "VTWEG", "VTEXT", "SPRAS"SPRAS = 'Language'*
  • Language is the language setting you define in the connector..

Sales document master data tables​

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

TableStoresFields used in Process MiningFiltering
TVAPTSales Document Item Categories Texts Data"MANDT", "PSTYV", "VTEXT", "SPRAS"SPRAS = 'Language'*
TVAKTSales Document Types Data"MANDT", "AUART", "BEZEI", "SPRAS"SPRAS = 'Language'*
TVLKTDelivery Type Texts Data"MANDT", "LFART", "VTEXT", "SPRAS"SPRAS = 'Language'*
  • Language is the language setting you define in the connector..

Block & cancellation reasons master data tables​

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

TableStoresFields used in Process MiningFiltering
TVLSTDelivery Blocking Reason Texts data"MANDT", "LIFSP", "VTEXT", "SPRAS"SPRAS = 'Language'
TVFSTBilling Blocking Reason Texts data"MANDT", "FAKSP", "VTEXT", "SPRAS"SPRAS = 'Language'
T008TBlocking Reason Names in Automatic Payment Transactional data"MANDT", "ZAHLS", "TEXTL", "SPRAS"SPRAS = 'Language'
TVAGTRejection Reasons for Sales Documents Texts data"MANDT", "ABGRU", "BEZEI", "SPRAS"SPRAS = 'Language'
T041CTReasons for Reverse Posting (Name) data"MANDT", "STGRD", "TXT40", "SPRAS"SPRAS = 'Language'
  • Language is the language setting you define in the connector..

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

Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated