通知を受け取る

UiPath Process Mining

UiPath Process Mining ガイド

SAP Purchase-to-Pay Connector for AppOne の入力データ

はじめに

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.

Stores

Fields used in Process Mining

フィルター

EBAN

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

Stores

Fields used in Process Mining

フィルター

EKKO

Purchasing Document Header Data

"MANDT", "EBELN, "BSTYP", "BSART", "AEDAT", "WAERS", "WKURS", "LIFNR", "EKORG", "EKGRP", "ERNAM"

BSTYP = 'F'

Date: AEDAT

EKPO

Purchasing Document Item Data

"MANDT", "EBELN", "EBELP", "BANFN", "BNFPO", "BUKRS", "NETWR", "PRDAT", "MATKL", "MATNR", "MENGE", "LGORT", "WERKS", "KUNNR"

BSTYP = 'F'

EKBE

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

Stores

Fields used in Process Mining

フィルター

RBKP

Document Header Invoice Receipt Data

"MANDT", "BELNR", "GJAHR", "BUKRS", "CPUDT","CPUTM", "USNAM", "WAERS", "KURSF", "BLDAT"

Date: CPUDT

RSEG

Document Item Incoming Invoice Data

"MANDT", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "WRBTR", "SHKZG", "MENGE"

Accounting tables

The following tables are the standard SAP accounting tables.

Stores

Fields used in Process Mining

フィルター

BKPF

Accounting Document Header Data

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

Date: CPUDT

BSIK

Accounting Secondary Index for Vendors Data

"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"

BUZEI = 001

Date: CPUDT

BSAK

Accounting Secondary Index for Vendors (Cleared Items) Data

"MANDT", "BUKRS", "BELNR", "GJAHR", "BUZEI", "EBELN", "EBELP", "ZFBDT", "ZBD1T", "ZBD2T", "ZBD3T"

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", "BUZEI", "WAERS", "WRBTR", "SHKZG"

BUZEI = 001 AND (CLRIN = '' or CLRIN = 2)

Change log tables

The following tables are the standard SAP change log tables.

Stores

Fields used in Process Mining

フィルター

CDHDR

Change Document Header Data

"MANDANT", "OBJECTCLAS", "OBJECTID" , "CHANGENR", "UDATE", "UTIME", "USERNAME"

OBJECTCLAS in [“BANF”, "EINKBELEG", "INCOMINGINVOICE", "BELEG"]

Date: UDATE

CDPOS

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

Stores

Fields used in Process Mining

フィルター

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"

Vendor master data table

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

Stores

Fields used in Process Mining

フィルター

LFA1

General Vendor Master Data

"MANDT", "LIFNR", "NAME1", "NAME2", "LAND1", "REGIO", "XCPDK"

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. See Other settings.

Customer master data tables

The following tables are the standard SAP customer master data tables.

Stores

Fields used in Process Mining

フィルター

KNA1

General Customer Master Data

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

Material master data tables

The following tables are the standard SAP material master data tables.

Stores

Fields used in Process Mining

フィルター

MAKT

Material Descriptions Data

"MANDT""MATNR""MAKTX""SPRAS"

SPRAS = 'Language'*

T023T

Material Group Descriptions Data

"MANDT""MATKL""WGBEZ""SPRAS"

SPRAS = 'Language'*

T001L

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

Stores

Fields used in Process Mining

フィルター

T001

Company Codes Data

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

T001W

Plants/Branches Data

"MANDT", "WERKS", "NAME1"

T024

Purchasing Groups Data

"MANDT", "EKGRP", "EKNAM"

T024E

Purchasing Organizations Data

"MANDT", "EKORG", "EKOTX"

Purchasing document master data tables

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

Stores

Fields used in Process Mining

フィルター

T161T

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

Stores

Fields used in Process Mining

フィルター

T008T

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

Stores

Fields used in Process Mining

フィルター

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. See Other settings.

2 か月前に更新

SAP Purchase-to-Pay Connector for AppOne の入力データ


改善の提案は、API リファレンスのページでは制限されています

改善を提案できるのは Markdown の本文コンテンツのみであり、API 仕様に行うことはできません。