cancel
Showing results for 
Search instead for 
Did you mean: 

Issue in billing extractor

former_member183113
Active Participant
0 Kudos

Hello All,

We have more than 400 records difference between R/3 and Bw data. 1400 records are then in r/3 for some billing types.

And in BW only 1000 records we can see. Data source is 2lis_13_vditm. from this data source data is being loaded to masterdata(Billing doc  header infoobject) and in other r flow  Billing dso, then Billing cube. So how  to find out why this difference occurred?  we can reload the data from setup..but how it missed . And the load is hourly delta.

Any inputs?

Regards,

Raki

Accepted Solutions (1)

Accepted Solutions (1)

RamanKorrapati
Active Contributor
0 Kudos

Hi,

At which day you missed those?

if you know the day then you can cross check your whole data flow logs.

if any failures then how they reloaded  failed request?

What steps they did, you need to analyze your data flow.

Note the 1400 records data from ECC and analyze with help of source team.

Whether they canceled any orders? check in functional way.Some data sources won't pull canceled data as well. note the 400 records compare with other records which we pulled into bw. you may see some difference.

Even some times data sources won't pull data which is maintained at source thru abnormal methods.

If we enter transactions into SAP standard method then only data sources pulls data.

Thanks

Answers (1)

Answers (1)

former_member976
Active Contributor
0 Kudos

HI,

in RSA3 extractor have 1400 records but in PSA have 1000 records.

select the data source -> right click -> manage -> select the request -> put the number of hits -999999

continue.

now you will get all the 1400 records.

if you are using any filters at info package level please check.

-Phani.

former_member183113
Active Participant
0 Kudos

hi...am saying R/3 not rsa3....i mean t osay ECC....

former_member976
Active Contributor
0 Kudos

Hi,

if we say RSA3 that is the ECC system.

please cross check with the ECC RSA3 and BW PSA data.

former_member183113
Active Participant
0 Kudos

dont mind for making confusion.....in ECC i ahve seen in table level..there are 1400 records. but in BW 800 are there....its hourly load and dela. if i check in rsa3 what is use??? RSA3 wil lextract from setup ryt? setup is empty now....i need to fill again..i did it...and can see datanow..but question is why tehy have missed earlier?

former_member976
Active Contributor
0 Kudos

Hi,

can you cross check the records based on the changed/created date.

may be you will get the right informaiton.

cross check with the RSA7 and PSA data.

Thanks,

Phani.

former_member223480
Active Contributor
0 Kudos

Hi Raki

If you haven't done it yet please check carefully the following logs

sm13 for any update errors

sm58 if you had any issue with the trfc

sm21 for any issues regarding the specific date and time of the update.

Normally those issues is because the records are deleted from the queue.

Thank you

Yiannis