cancel
Showing results for 
Search instead for 
Did you mean: 

Extractor check shows data but Data load has no records

bhat_vaidya2
Active Participant
0 Kudos

hello,

I have tried to extract full load for selected materials without success because the infopackage monitors says that "

No data available in the source system for this selection"

I checked the extractor checker RSA3 in R/3 and could see data for the selected materials.

for some reason, I can't extract data for full load.  I am working on COPA 1_CO_PA120ZBIL_06 extractor.

any idea where  I can find the reason why there is no data.

thanks

Bhat

Accepted Solutions (1)

Accepted Solutions (1)

mohd_abdullah
Contributor
0 Kudos

Hi,

How are you entring the materal number in the selection field ?Is it alfa converted ?

For Eg : IF you have a material no 12345 and the length of this field from the source is 10 then preceed five zeros before your materal number which in this case will be 0000012345 .

Try this and let us know if it works !

Regards.

bhat_vaidya2
Active Participant
0 Kudos

Hi Mohammed,

Thanks for the tip. I have tried with 0000123456 ( 10 digits) and it didnt' work. so I checked OMSL for the lenght and saw that it is 18.

I am now able to extract data in BW after using 18 characters for the material.

thanks,

Bhat

mohd_abdullah
Contributor
0 Kudos

Hi,

That 10 digits was just an example dude

Glad to know it worked !!

Regards.

bhat_vaidya2
Active Participant
0 Kudos

Hi,

I am not getting all the data as required as I am extracting 35974 records out of 35936 records. My transformation is 1:1 mapping and I can't fathom out how I got to miss some records.

- Bhat

mohd_abdullah
Contributor
0 Kudos

Can you be more specific ? I mean where excatly you are checking the records..... at PSA or DSO ?

If it is at PSA then your transformation has nothing to do with the missing records and if it is at DSO, Possibility is there that there were some duplicate records arriving from source and based on the key combination of your DSO it got overwirte and hence you see such count of records.

Regards.

Answers (2)

Answers (2)

former_member976
Active Contributor
0 Kudos

Hi,

give the some slections at info package data selections

ex- company code.

please check the data in RSA3 and same selecitons give the info package data selections.

Thanks,

phani.

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Try to run info pack with some selections like  fiscyear/calday/fiscper or valuetype/comp code

Play with selection and try to load data.

Thanks