SAP Accounts Payable

• Process description
  • Available tags & due dates
• Extraction
  • System configuration
  • Extraction tool configuration
• Input data
  • Input types
  • Input tables & fields
• Configuring transformations
  • Seed files
  • Dbt variables
• Design specifications
  • Entities
  • Activities
  • Design details

Process description

The Accounts Payable process is a process which revolves around receiving invoices and paying vendors and is part of the purchase-to-pay process.

The end-to-end process typically starts with a purchase request and ends with the payment of the invoice, covering the following processes in the procurement lifecycle:

• Buying
• Delivery
• Payment

The Accounts Payable app template focusses mostly on the Payment process.

Buying

The process starts with a buyer from the company who wants to buy some goods. The buyer requests the purchase, using a purchase requisition. Procurement is involved to get the best deal. This could mean negotiation for a new contract or adapting to an already available contract. Procurement converts the requisition to a purchase order and makes sure the missing information is filled where needed. Procurement approves the purchase order (PO), which is then sent to the vendor.

Delivery

The warehouse department (if available) waits for the goods to be received. When goods arrive, the inventory is checked and updated. The goods are received by the initial buyer, who accepts the goods.

Payment

The finance department awaits the invoice to be received. When the invoice arrives, it is administrated. The invoice is paid by accounts payable. Accounting administrates the payment.

Available tags & due dates

The following tags are available by default.

The following due dates are available by default.

Extraction

System configuration

This app template uses the Material Management (MM) and Financial Accounting (FI) modules of SAP.

Extraction tool configuration

The data extraction is developed for SAP and is using Theobald Xtract Universal. In general, you should follow the steps as described in Loading Data Using Theobald Xtract Universal (Automation Cloud) to set up data loading using Theobald Xtract Universal. Note: If you are using Automation Suite, make sure to select AUTOMATION SUITE as the DELIVERY option on the documentation page. In addition, select the Automation Suite version you are using to open the appropriate Loading Data Using Theobald Xtract Universal page.

Importing the template extractions

1. Download the XU_template_extractions.zip file with template extractions for Automation Cloud or the XU_template_extractions_as.zip file with template extractions for Automation Suite.
2. This file contains the folders destinations, extractions, and sources. Copy the folders from the downloaded zip file to the config folder of Xtract Universal. The location of this folder is [XU_installation_path]/config.
3. Open Xtract Universal Designer and click on the refresh button to load all extractions.

Configuring the extraction script

1. Download the extract_theobald.zip to load data for Automation Cloud or extract_theobald_as.zip to load data for Automation Suite.
2. This file contains the extract_theobald.ps1 script and the config.json file. Unzip the content on the server where Theobald Xtract Universal is installed.
3. Configure the variables for the script.

Running the extraction script

The extraction script can be executed by calling the Powershell script extract_theobald.ps1. In case you are not authorized to run scripts on your system, you can temporarily bypass the check by calling the following command before executing the script: Set-ExecutionPolicy Bypass -Scope Process

Input data

Input types

The following table provides an overview of the different field types and their default format settings.

Input tables & fields

The following tables are extracted from the source system:

Purchase requisition tables

EBAN

Stores Purchase Requisition Data.

Filtering: BSTYP = 'B', Date: BADAT

Purchasing document tables

EKKO

Stores Purchasing Document Header Data.

Filtering: BSTYP = 'F', Date: AEDAT

EKPO

Stores Purchasing Document Item Data.

Filtering: BSTYP = 'F'

EKBE

Stores History per Purchasing Document Data.

Filtering: BEWTP = 'E' AND SHKZG = 'S', Date: CPUDT

EKET

Stores Scheduling Agreement Schedule Lines Data.

EKKN

Stores Account Assignment in Purchasing Document Data.

Invoice tables

RBKP

Stores Document Header Invoice Receipt Data.

Filtering: Date: CPUDT

RSEG

Stores Document Item Incoming Invoice Data.

Accounting tables

BKPF

Stores Accounting Document Header Data.

Filtering: Date: CPUDT

BSIK

Stores Accounting Secondary Index for Vendors Data.

Filtering: BUZEI = 001, Date: CPUDT

BSAK

Stores Accounting Secondary Index for Vendors (Cleared Items) Data.

Filtering: BUZEI = 001, Date: CPUDT

BSE_CLR

Stores Additional Data for Document Segment Clearing Information Data.

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

Change log tables

CDHDR

Stores Change Document Header Data.

Filtering: OBJECTCLAS in ["BANF", "EINKBELEG", "INCOMINGINVOICE", "BELEG"], Date: UDATE

CDPOS

Stores Change Document Item Cluster Data.

Filtering: FNAME in ["KEY", "BANPR", 'BLDAT', 'BUDAT', 'MENGE', "PROCSTAT", 'RMWWR', "FRGZU", "LOEKZ", "ABSKZ", "NETPR", 'WRBTR', "ZLSPR", "ZTERM", "ZFBDT", "ZUONR", "BVTYP", "HBKID", "AUGBL"] AND TABNAME in ["EBAN", "EKKO", "EKPO", "RBKP", "RSEG", "BSEG", "BSEGR"] AND CHANGENR >= '<value>' AND CHANGENR <= '<value>' (For example, AND CHANGENR >= '0001299707' AND CHANGENR <= '0001507899')

User master data tables

USR21

Stores User Name/Address Key Assignment Data

ADRP

Stores Persons (Business Address Services) Data

Filtering: NATION = '' or NATION = 'I'

ADCP

Stores Person/Address Assignment (Business Address Services) Data

Filtering: NATION = '' or NATION = 'I'

USR02

Stores Logon Data

Supplier master data tables

LFA1

Stores General Vendor Master Data

T003T

Stores Document Type Texts

Filtering: SPRAS = 'Language'

T005T

Stores Country Names Data

Filtering: SPRAS = 'Language'

T005U

Stores Taxes Region Key Texts Data

Filtering: SPRAS = 'Language'

T052U

Stores Own Explanations for Terms of Payment

Filtering: SPRAS = 'Language'

Customer master data tables

KNA1

Stores General Vendor Master Data

Material master data tables

MAKT

Stores Material Descriptions Data

Filtering: SPRAS = 'Language'

T023T

Stores Material Group Descriptions Data

Filtering: SPRAS = 'Language'

T001L

Stores Storage Locations Data

T006A

Stores Assign Internal to Language-Dependent Unit Table and Data

Filtering: SPRAS = 'Language'

Organizational structure master data tables

CSKT

Stores Cost Center Texts Data

Filtering: SPRAS = 'Language' AND DATBI = "99991231"

T001

Stores Company Codes Data

T001W

Stores Plants/Branches Data

T024

Stores Purchasing Groups Data

T024E

Stores Purchasing Organizations Data

TGSBT

Stores Business Area Names Data

Filtering: SPRAS = 'Language'

Purchasing document master data tables

T161T

Stores Texts for Purchasing Document Types Data

Filtering: SPRAS = 'Language'

Block & Cancellation reasons master data tables

T008T

Stores Blocking Reason Names in Automatic Payment Transactional Data

Filtering: SPRAS = 'Language'

Currency master data tables

TCURR

Stores Exchange Rates Data

Filtering: KURST = 'Exchange rate type'

TCURF

Stores Conversion Factors Data

Filtering: KURST = 'Exchange rate type'

TCURX

Stores Decimal Places in Currencies data

Configuring transformations

Seed files

Currently no seed files are used for this app template.

Dbt variables

Note that while there is a date format that can be configured in the dbt variables, there is no time format defined. The time format is implemented via a custom macro. This is done because SQL server does not support converting the 6 digits time format to time data type.

Design specifications

Entities

The following diagram shows all entities that are used for the process.

Process entities

Master data entities

Activities

Design details

Accounting documents without invoice

The SAP system allows accounting documents in the BKPF table to be created in multiple ways. The default way is when an invoice (in the RBKP table) is created and released into accounting. However, it is also possible to create an accounting document without an invoice. In this case the accounting document is linked to purchase order items directly, using the EBELN and EBELP fields available on the BSIK and BSAK tables. This sub-process is used to gather additional events for the event log, which is done in the Entity_relations.sql table.

Change log

The Change log, created by joining the CDHDR and CDPOS tables, is not an entity on its own, but is used for all entities to generate the corresponding events. By default the Change log contains only changes for the default activities, gained by filtering on the FNAME field from the CDPOS table during data extraction.

For each entity its 'change events' are created as follows:

• Retrieve the changes relevant for this particular entity by filtering the Change log on the TABNAME field.
• Define the activities using this filtered data, based on the FNAME, VALUE_OLD and VALUE_NEW fields.
• Generate the events by joining the resulting activities to the corresponding entity table, based on the TABKEY field, which contains the ID of the entity (Sales Order, Invoice, etc.) on which the activity occurred.

Automated events

An event can be labeled as automated. This is dependent on the user_type associated with the event. The user_type stems from the USR02 table. If the value of the field USTYP is B or C, meaning System or Communications Data, respectively, the event is labeled as 'Automated'.

Currency conversion

Price-related information is given in a certain currency. These prices and corresponding currency are stored in the document tables. These currencies vary between items. To be able to analyze all of them in one app template, all prices are converted from their document currency to a single currency, referred to as the reporting currency. This conversion is done based on the exchange rate information stored in the TCURR, TCURF, and TCURX tables. In case the exchange rates listed are an indirect rate, they contain a - to indicate this.

For both accounting documents and purchase order items the currency conversion takes place in two steps:

• From document currency to local currency;
• and from local currency to reporting currency.

The local currency is the currency of the company. This local currency can be found in the company table T001. On the document table there is an exchange rate available to convert the document currency to the local currency. This exchange rate can be the same as the exchange rate in the currency exchange rate table TCURR or manually adjusted to any other rate. The conversion to the reporting currency is again done based on the exchange rate information in the currency information tables as mentioned above.

Troubleshooting

• Data not recorded in CDHDR/CDPOS or JCDS objects: Change and Status events have to be configured in the environment in order to be tracked; these configurations are not retroactive to previously registered records.