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.