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"`