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]

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

[Former Member]

Hi Wide,

Thanks for your information.

I appricated if you can provide , what type of config change can be happend in R/3 so that i can look into it.

Thanks

Madhu

[Former Member]

Hi Mdhu!!!

For specific delta extraction what is the value in 0RECORDMODE (ROCANCEL)? The value should be either blank, X, R and N, regardless of the order the delta will delete, add, or reverse the records. If the same record has more than one Blank, X, R or N then that is the problem, the system should send only one change at a time. And also check what setting you have in your DSO, do you have overwrite or addition? Waiting to here from you.

thanks.

Wond

[Former Member]

Hi

Thanks for your help.

The prob is i have po, which is created , deliveried and invoiced.

i ran the setup table to extract the PO item data, then i went and checked in RSA3 , where i can 4 records.

Example

1

2

3

4

then i went ran the Infopackge to extract this data into bw and i select load into PSA.

where i can the records in PSA as

4

3

2

1

Hope you can understand my pbm.

I think it is not issue with delta, because i am running my initial load.

let me know..if you need further info

Thanks

Madhu

[Former Member]

I had worked with this extractor and if I remember it properly the standard content doesn't come with DSO, it actually load data from source directly to Cube, you must have custom DSO in the middle and if you have custom DSO then it is very important you properly assign the key fields in the DSO, otherwise, it is going to overwrite with the latest one.

If your design needs to have DSO in the middle for some valid reason, then make sure you get all combination of data that could uniquely identify the record and make then key field in the ods, in this case it seems like you need to have all the statuses.

thanks.

Wond

[Former Member]

Hi,

Its not issue with DSO ,i am checking the data in PSA itself.

In PSA ifself i am gettting the records in reverse order.

Thanks

Madhu

[Former Member]

How the extractor sends is really shouldn't be a problem, that is why I was telling you the Record Mode in my previous posting, in your case you are not talking about delta loads but init. Even in Init loads, one purchase order number with line item will have only one status at a time from EKPO table, I don't really understand what you mean that reverse order, but if you are talking about purchase order schedule line item level, then you need to have Delivery Schedule (ETENR) in your DSO, so that one wouldn't overwrite the other.

My assumption is if you are not working only with 2LIS_02_ITM but also 2LIS_02_SCL, if that is the case you need to have Delivery Schedule (ETENR) in your DSO. Again, this is not right way of modeling, since you schedule line item will have multiple values which will correspond to multiple line items, that is why even SAP never provided to you the DSO.

My recommendation here is that just stick with the standard content and remove the DSO from the middle, otherwise, if not get the status field in the ods.

Note: don't worry about the order:

Example:

Purchase Order No.----

---

Line Item Number -

---

Sch. Line Item No. Qty.

100020--

---

100

---

10--

---

10

100020--

---

100

---

20--

---

12

Really doesn't matter how these has been sent by extractor as long as my DSO handles it properly. And dso will handle it properly if I have all the three as key field in my DSO, but it I have the Order and line Item in my dso, then it won't work.

I hope I am clear.

thanks.

Wond

[Former Member]

Hi,

I got your solution.

thanks for that.

but my problem is

say for example.

if we created po then deliveried and invoiced.

how many records this extractor pulls? current my extractor(2LIS_02_ITM) is pulling the records as

po poitem delind invoiceind

100 1

100 1 X

100 1 X

in PSA I CAN SEE THESE RECORDS AS

po poitem delind invoiceind

100 1 X

100 1 X

100 1

Because of above order my DSO is overwritting with last record.

Thanks

Madhu

[Former Member]

Hi Madhu,

I have the same problem and I can´t correct it yet.

Are not how to get the solution; you have it?

Thanks a lot

Monica

[Former Member]

Hi,

if you get the solution, Pl reply to this post.

or send a mail to

madhu.kummetha@gmail.com

Thanks

Madhu

[Former Member]

Hi ,

did you got the solution.

please let me know

Madhu

[Former Member]

You can sort the PSA:

-First the X records

-Then the ' ' records

-The 'R' records should be managed in a different way...

If you are overwritting, you just have to delete the X records, they are not useful for you. In this case, the R records needs to be threated in a different way, as well

Zorion

[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