Skip to Content
0
Former Member
Jan 07, 2008 at 03:29 PM

Problem with extractor

28 Views

Hi Experts,

I have a generic extractor which is build on Function Module, We extract Purchase order history data from R3 to BW based on last 30 days PO Creations and PO chnages (PO created and PO changed date).

My Problem is I am missing some material documents with this selection.

For example : I will extract the data once in a week based on above selections (PO created and PO change date). Assume that I have done a load

1st load 3rd Dec 2007 -- Selections-- PO Created from 3rd Nov 2007 to 3rd Dec 2007 and PO Changed from 3rd Nov 2007 to 3rd Dec 2007.

2nd load 10th Dec 2007 -- Selections-- PO Created from 10th Nov 2007 to 10th Dec 2007 and PO Changed from 10th Nov 2007 to 10th Dec 2007.

This is how I extract the PO history data.

Now the user is going to created (assign) some Material documents (GR/IR) for a PO on 4th December for the PO which is created on 5th Nov 2007. In this case I am missing the 4th Dec 2007 data because my selection is PO created and PO changed and this changed will not be consider as PO changes.

Can any one provide me the solution for this issue.

Please ask me if you cannot understand the problem.

Thanks in Advance

Narendra