on 09-14-2012 3:47 PM
Hi All,
I want to write a macro in SNP based on following situation we are facing:
Req.min.shelf life = 10 days (maintained in product master)
Expected Wastage Qty = 500 KG calculated on 17th Oct 2012 ( based on demand situation & std macro)
Additional KF = Expected Wastage Qty but this should populate values based on req.min shelf life days on 7th Oct 2012 ( 17th Oct - 10 days)
Additional KF (7th Oct 2012) = 500
Regards,
Raj
Hi Raj,
You can use the macro function TIMESHIFT_BACKWARDS.
TIMESHIFT_BACKWARDS( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) shifts the values of time series X1 through Xn backward in time by the number of periods given in time series Y1 through Yn. Example:
The time series look like this: X 10 20 30 40 50 Y 1 2 1 3 1. The result looks like this: 30 40 30 - 50 -
The value 10 is shifted back one period in time, the value 20 is shifted back two periods in time, and so on.
SAP example:
Thanks,
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.