Adding Subtotal fields to 2LIS_02_SCL Extractor

07 Mar Adding Subtotal fields to 2LIS_02_SCL Extractor

ColinHames - Phoenix Endeavors Colin Hames

Subtotal 1-6 fields in 2LIS_02_SCL extractor

Are the subtotal fields BWKZWI1 – BWKZWI16 in 2LIS_02_SCL blank? Have you ever wondered why they are blank or how they can be used?

Here is how you can populate these fields using straight ECC configuration. No custom extractor enhancement necessary.

The subtotal fields in the extractor are filled with data read from table EKPO fields KZWI1 – 6. The trick is configuring ECC to populate these fields. Once populated, the standard extractor will do the remaining work. Talk with your MM/PUR team with help on the following configuration steps.

In ECC transaction SPRO go to:   “Materials a Purchasing a Conditions a Define Price Determination Process a Define Calculation Schema”

2LIS_SCL1

Here find the pricing procedure(s) you would like to modify and click on “Control data”

2LIS_SCL2

Here you can see all the conditions listed. The key column for BW is “Sub tot”.

2LIS_SCL3

A drop down list on “Su Tot” reveals a list of assignment options.     Choosing any numbers 1 – 6 will populate the corresponding EXPO KZWI 1 – 6 fields.

2LIS_SCL4

Some things to keep in mind:

  • The subtotal amounts are extracted in PO currency.
  • The standard purchasing info objects in BW for storing the subtotals are 0SUBTOT_OC1 – 0SUBTOT_OC6. Oddly, SAP chose 0LOC_CURRCY for OC1 – OC4, but 0ORDER_CURR for OC5 – OC6. In light of this, I created new Z subtotal objects that aligned the number with 0ORDER_CURR .
  • I have not found a way to populate historical purchase orders in EKPO with this configuration change, so figure this is a ‘going forward’ enhancement.
Tags:
2 Comments
  • Balji
    Posted at 07:05h, 02 March Reply

    this was so useful for me. Thanks for sharing. I was wondering if we have to pull more subtotals than 6 how would you do that?

    • Colin Hames
      Posted at 15:24h, 05 May Reply

      SAP only offers 6 standard subtotal fields in table EKPO, so you are limited to 6 using the method outlined. However, you could add additional custom Z fields in the SCL extractor and use your own calculation/lookup routines for additional amounts.

Post A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Become A Partner

If you have a strong SAP background and a
“Whatever it takes” attitude , submit your resume.