Skip to Content
0
Former Member
Oct 19, 2005 at 05:10 AM

Sales order Tracking

59 Views

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