Question Re: Missing documents? in Technology Q&A

Missing documents?

Former Member — Wed, 12 Jul 2006 17:13:35 GMT

Hi all,

I loaded data from R/3 to BW and use ODS to run the query. However, I found that there are some data record missing. EX: There are some sales transations missing. Any advices?

Thanks

Re: Missing documents?

Former Member — Wed, 12 Jul 2006 17:16:09 GMT

Hi John,

If your datasource permits, you can try to load the data for these missing documents. But it would be good to find out why they are missing so that you can prevent this sitaution in the future...

Re: Missing documents?

Former Member — Wed, 12 Jul 2006 17:20:00 GMT

Hi John:

if you are using an delta and if you know that some transactions are missing in BW then go to PSA( if you update through PSA) and check for the sales doc #, and see if you have it there. if its there then you can push the data from PSA to ODS as in this case, it didnt picked the delta's.

or else go to SE11 and see the records which were created according to the date, you will find and then you do a load. as mentioned by Bhanu, its good to investigate into the missing records so as to avoid the same in the future

hope it helps.

assign points if helpful

kalyan

Re: Missing documents?

Former Member — Wed, 12 Jul 2006 18:16:24 GMT

Hi all,

No, I didn't use delta load. We have a problem to setup delta load and are trying to fix not. But We had init load and i found some sales transactions are missing in this ODS when I check with R/3. I would like to know why (problem) it happened? and how to fix based on the problem. Any advices?

Re: Missing documents?

Former Member — Wed, 12 Jul 2006 18:25:58 GMT

John:

i had a similar problem with our PO's.

the reason why some times, you cannot see record(s)which are in R/3 but are not seen in BW may be:

i was having some records missing ib BW too. the PO's(in my case) were <b>not released</b> in r/3 side by the functional people. so they were in "held" status. In the mean while, if your v3 updates are schduled during that time, it will not fetch any records as they are in hold status. once they are released, then they will show up in ( lbwq, rsa7) the next data load update in BW

i suggest you do a load now and you can do the reconcile and hopefully you will see the missing records now

assign point if helpful

kalyan

Re: Missing documents?

Former Member — Wed, 12 Jul 2006 18:40:58 GMT

John,

check in RSA3? Can you able to see the data? if you couldn't see the data you need to do it again as Bhanu said. you the data is in RSA3 and PSA. not comming to BW. you need to check the Update Rules.

If you couldn't see the data in RSA3, if it is LO extractor try to fill the set up tables again? check why these documents are not getting populated.

All the best.

Regards,

Nagesh Ganisetti.

Re: Missing documents?

Former Member — Wed, 12 Jul 2006 18:42:34 GMT

HI,

Suggest, you look at the R3 side documents to check their status and also check if you're pulling those documents for that particular status, ex you might be pulling data for just completed transactions, etc.

Also, check the tables on the R3 side to see if the sales transactions were captured in those tables.

If both the above conditions are fine, suggest you do a full pull on the BW side after the R3 extract jobs are run to see if you pull in all the data.

Cheers,

Kedar

Re: Missing documents?

Former Member — Thu, 13 Jul 2006 04:38:18 GMT

Hi all,

I found that some missing transactions not coming BW and some missing transaction are in RSA3 but not in R/3 report.

I am wondering

1)how can those transations not showing in R/3 report but in RSA3?

2)If missing tranactions are not in BW but in RSA3, then what do I need to check in the update rules?

Thanks

Re: Missing documents?

Former Member — Thu, 13 Jul 2006 04:50:02 GMT

Hi John,

Try to execute transaction RSA3 give the name of your datasource,under this to the lefthandside your can find Settings, select 2nd and 3rd wchich can change the Data Records / Calls (100) and Display Extr. Calls (20) and this will extract 2000 records, now you try to execute it again.

Hope this helps...

Best Regards,

DMK

*Assign points if it helps...

Re: Missing documents?

Former Member — Thu, 13 Jul 2006 13:37:54 GMT

John,

go through this link in order to validate the data, there is no need to debugg the update rules or transfer rules.

1. check what is the importence of these documents?how these are different from other documents? this thing will be useful to investigate in Update Rules.

2. /people/sap.user72/blog/2006/07/11/tracing-data-transformation-in-sap-bw-without-debugging

it's really good blog how to use simulate option. you will know where exactly the records are missing.

Please update the thread.

All the best.

Regards,

Nagesh Ganisetti.