Skip to Content
0

SAP BW Transformation Previous Month/Last 12 months

Feb 24, 2017 at 09:01 PM

36

avatar image

Hi Experts,

I’m currently working in SAP BW 7.4 SP 13.

My requirement is to calculate net of 101 receipts

Each unique 101, 102 or 122 transaction counts as 1 and it is either + or -.

  • 1.Pull all transactions for material /plant from 2LIS_03_BF for the last 12 complete months (exclude current month);
  • 2.MKPF-BUDAT is posting date - for the last 12 twelve complete months where BWART = 101, 102 or 122.
  • 3.Each unique transaction counts as 1 and it is either positive + or negative - ;
  • 4.Assign +1 or -1 to each transaction where BWART 101 = +1 and 102= '-1' and 122 = '-1'
  • 5.Add up the assigned values
  • 6.Eg. If there are 10 transactions and 5 are 101, 3 are 102 and 1 is a 122, the net on the report will be ‘1’

How do I write a function/routine to calculate this? I searched everywhere all I find is the previous month function module for ECC.

Do I write this in the DTP or Transformation Start/End Routine?

Thank you,

Kalinda.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers