Skip to Content
author's profile photo Former Member
Former Member

PO item 2LIS_02_ITM - data is comining in reverse way

Hi,

I am facing one issue with 2lis_02_itm.

A Purchase order has been created, delivered and Invoiced in R/3.

when i extracted this data in RSA3, i am getting 4 records(say 1 to 4).

in BW when i extracted this records i am getting in reverse way all records(4 to 1)

because of this my ODS /Cube is is overwriting the 4th record with first record and also loosing some indicators say final invoice indicator, delivery indicator.

I checked in PSA, even PSA also i can see the records in reverse(4 to 1).

if any body come across this , pl Help me.

I really appreciate.

Madhu

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2007 at 06:30 AM

    Hi madhu,

    1) Make the indicator as one of the Key fields in the ODS.

    2) Review your ODS/cube design to identify all the Characteristics needed to keep the

    information relevant.

    Good luck, BB

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi BB,

      Thanks for solutions.

      I didn't get answers, if you don't mide can you clear the 2 solutions which you provided.

      1.) Make the indicator as one of the Key fields in the ODS.

      I can't make the delivery indicator or invoice indicator as key figure , because these fields only filled with value ,when they do delivery or invoice otherwise these indicators alwasy blank.

      2) Review your ODS/cube design to identify all the Characteristics needed to keep the information relevant.

      what exactly it means?

      I am just again writting what i am facing the pbm is.

      The sequence of records i can see in R/3(in RSA3) ARE comining in BW in reverse order sequence.

      Thanks

      Madhu

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2007 at 08:07 PM

    for sure there is process issue, and I don't think it has design issue.

    Normally, the extactor sends based on time stamp when the change

    is made. Check if there is any conf can be made in r/3 side

    Thanks

    Wind

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.