PO item 2LIS_02_ITM - data is comining in reverse way

[Former Member]

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

[Former Member]

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

[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