Hello experts,
I have some functional specifications and I would like to know how I can implement them with performant Abap syntax in BW.
A priori, the conditions will be implemented in fields’ level routines at transformation level (for example between a DSO and an Infocube or Datasource and DSO, I don’t know yet)
Here come the requirements:
The aim is to calculate a Material availability delta (Let’s say IO_MAD).The formula to be applied is:
=Delivery Date (IO_DD)
- Material Availability Date (IO_MADT)
+ Pick-Pack time (IO_PPT)
+ Loading time (IO_LT) *
+ Transit time. (IO_TT)
*Loading time determination:
If loading time (TVST-LAZBS) = A
-->Loading time will be T630L-LOADTG (I will build a master data extractor on this table)
ElseIF Loading time (TVST-LAZBS) = B
-->Loading time will be TVST-LOADTG (as before I will build an extractor on it)
One point, only working days have to be taken in account in this calculation:
Delivery Date (IO_DD)
- Material Availability Date (IO_MADT)
I heard that it exists some functions modules which can do this calculations.
Thanks for your help.
Still available if you have any questions.
Amine