Skip to main content

Get help for ARIS Process Mining functions and services

Configure extractions

For each SAP extraction, you must configure the tables that you want to extract from the SAP source system. You can specify the columns to read and define filters to reduce the extracted source data.

Example 212.

The following list describes the tables, columns, and filters that are used to configure the created Purchase requisition item and Purchase order item extractions.

The table and field descriptions are provided by the SAP system.



Purchase requisition item extraction

  • Table EBAN: Purchase Requisition

    Select the following fields. The fields BANFN and BNFPO combined form the identifier of a purchase requisition item in SAP.

    • BANFN: Purchase Requisition Number (key)

    • BNFPO: Item Number of Purchase Requisition (key)

    • ERNAM: Name of Person who Created the Object

    • ERDAT: Changed On

    • WERKS: Plant

    • MENGE: Purchase Requisition Quantity

    • MEINS: Purchase Requisition Unit of Measure

    • BADAT: Requisition (Request) Date

    • DISPO: MRP Controller (Materials Planner)

      Create a filter to extract all entries from this table that were created between the start and end time of our extraction interval:

      ERDAT ge '${EXTRACTION_START}' AND ERDAT le '${EXTRACTION_END}'

      "ge" means "greater or equal"

      "le" means "lower or equal"

      The filter extracts only purchase requisition documents that were changed between the timestamps contained in parameter EXTRACTION_START and EXTRACTION_END.

  • Table T024D: MRP controllers

    Select the following fields:

    • WERKS: Plant (key)

    • DISPO: MRP Controller (Materials Planner) (key)

    • DSNAM: Name of MRP controller

  • Table MAKT: Material Descriptions

    This table contains the language-depended material descriptions.

    Select the following fields:

    • MATNR: Material Number (key)

    • MAKTX: Material Description (Short Text)

      Create a filter to read the language dependent material description only in the configured language:

      SPRAS eq '${LANGUAGE}'

      "eq" means "equal"

      The SPRAS field specifies the language. The filter reads only the entries that have the same language key as the value of the LANGUAGE parameter.

Purchase order item extraction

  • Table EKKO: Purchasing Document Header

    Select the following fields:

    • EBELN: Purchasing Document Number (key)

    • BSART: Purchasing Document Type

    • AEDAT: Date on Which Record Was Created (contains the date of the last change)

    • ERNAM: Name of Person who Created the Object

      Create a filter to extract every row from this table that was created between start and end time of our extraction interval and only extract rows for purchase orders:

      AEDAT ge '${EXTRACTION_START}' AND AEDAT le '${EXTRACTION_END}' AND BSTYP eq 'F'

      The filter extracts only purchase order document headers that were changed between the timestamps contained in the EXTRACTION_START and EXTRACTION_END parameters. Additionally, only documents with BSTYP 'F' (Purchase Order) are extracted.

  • Table EKPO: Purchasing Document Item

    Select the following fields. The fields EBELN and EBELP together form the identifier of a purchase order in SAP. The fields BANFN and BNFPO contain the link to the purchase order requisition.

    • EBELN: Purchasing Document Number

    • EBELP: Item Number of Purchasing Document

    • AEDAT: Purchasing Document Item Change Date

    • MATNR: Material Number

    • MENGE: Purchase Order Quantity

    • MEINS: Purchase Order Unit of Measure

    • WERKS: Plant

    • BANFN: Purchase Requisition Number

    • BNFPO: Item Number of Purchase Requisition

      Specify a dependency filter for the EKPO and EKKO tables. The filter extracts the fields of the EKPO table depending on the previously read entries from the EKKO table. Use the EBELN field of both tables to specify the dependency.