Create a dimension table for purchase order items

Create a transformation statement that creates a table with dimensional information for Create purchase order item activities from the EKPO and EKKO source tables.

The statement joins columns from EKPO and EKKO tables and provides them with the ACTVITY_ID of the related activities.

The procedure is similar to the one described in the Create a dimension table for purchase requisition items chapter.

The statement looks like this:

Here you can find the sample transformation statement as an SQL code snippet. You can use the snippet to follow the described example:

SELECT
CONCAT('EKPO-', EKPO.EBELN, '-', EKPO.EBELP) AS ACTIVITY_ID,
EKPO.EBELN AS EKPO_EBELN,
EKPO.EBELP AS EKPO_EBELP,
EKPO.AEDAT AS EKPO_AEDAT,
EKPO.MATNR AS EKPO_MATNR,
EKPO.WERKS AS EKPO_WERKS,
EKPO.MENGE AS EKPO_MENGE,
EKPO.MEINS AS EKPO_MEINS,
EKPO.BANFN AS EKPO_BANFN,
EKPO.BNFPO AS EKPO_BNFPO,
EKKO.EBELN AS EKKO_EBELN,
EKKO.BSART AS EKKO_BSART,
EKKO.AEDAT AS EKKO_AEDAT,
EKKO.ERNAM AS EKKO_ERNAM
FROM `PURCHASE_ORDER_ITEM.EKPO` AS EKPO
LEFT OUTER JOIN `PURCHASE_ORDER_ITEM.EKKO` AS EKKO ON EKPO.EBELN = EKKO.EBELN

Get help for ARIS Process Mining functions and services

Create a dimension table for purchase order items

Search results