HEllo Experts
I require help for following situation.
My scenario is
SOURCE ODS1: <b>ZMB_CR.</b>
Objects:
<b>1.ZQUALITY</b> (Its an indicator that consists of "S" and "X".
<b>2. ZTRPOST</b> (Its an indicator that consists of "S" and "X").
Target ODS: <b>ZFIN_ODS.</b>To the target ods the data is coming for 4 different ODS.
including ZMB_CR. We have two different infoobjects in
Target.
1. Microhold quantity: Its based on condition where (For the sales order in ods ZMB_CR. if ZQUALITY="S" Accept the BOX QTY.
2. PFD Quantity: Its based on condition where (For the sales order in ods ZMB_CR. if ZQUALITY="X" and TRPOST="S" Accept the BOX QTY.
Now my problem is the status of ZQUALITY and TRPOST keeps on changing when the goods move from one location to other. After i upload the data into target i get the correct figures where as after the status changes in the R/3, then i upload into BW the results are not displayed correctly..
Example:
Total Qty is 100.
Initial quantity(100) is considered as "Microhold QTY" because the ZQUALITY is "S".
If Quantity (50) is moved from one location to other location the ZQUALITY is "X" and TRPOST is "S". Its "PFD QTY"
Now my requirement is when ever the "X" comes into BW. The "Pfd qty" should be subtracted from "Microhold qty"
AT the first schedule the follwing will be displayed.
<b>Total Qty =100
Quality="S"
Trpost="S"
Microhold qty=100
PFD qty= -
</b>
When from the total qty 100. 50 is delivered. Now in the next schedule
<b>Total Qty=100
Quality="X"
Trpost="S"
Microhold qty=100
PFD qty=50</b>
Here i want Microhold Qty to be 50. How can i accomplish this. plz let me know for further clarification. Thanks in advance
Regards
Srikanth.
Message was edited by: Srikanth