Dump issue

[Former Member]

Experts can you please tell me Why it is giving DUMP.

I have stuck up with this. Please guide me. reading Personal Numbers from Flat file and storing into t_txt_upload. then reading the data from PA0008 for all the Personal No in t_txt_upload i need to fetch the data from PA0008. when i'm trying to do the same its giving DUMP. please help me.

• internal table for Basic pay.

DATA: BEGIN OF IT_P0008 OCCURS 0, "

Pernr like p0008-pernr,

bsgrd like p0008-bsgrd, "Full time equivalent

END OF IT_P0008.

***--->uploading Flat file to internal table.

PERFORM file_UPLOAD.

sort t_txt_upload by pernr. "sorting uploaded internal table by pernr.

if not t_txt_upload[] is initial. "checking for the data.

• Reading data from PA0008.

select bsgrd

from pa0008

into table it_p0008

for all entries in t_txt_upload

where pernr = t_txt_upload-pernr.

if sy-subrc ne 0.

message e063.

endif.

sort it_p0008 by pernr.

endif.

Regards

vamsi.

[Former Member]

Hi,

Put a break-point on the SELECT Query. It seems the data which is uploaded in internal table <b>t_txt_upload</b> is not in correct format. Check the internal table content in debug mode.

Best regards,

Prashant

[Former Member]

try this..

select bsgrd

from pa0008

<b>into corresponding fields of </b> table it_p0008

for all entries in t_txt_upload

where pernr = t_txt_upload-pernr.

pls try to reward points , i have never seen you rewarding!!!!!

[Former Member]

first check ST22 ti get some idea.

and also check internal table Format.

select pernr bsgrd

from pa0008

<b>into corroesponding fields of table it_p0008</b>for all entries in t_txt_upload

where pernr = t_txt_upload-pernr.

Regards

Prabhu

[Former Member]

IF it_tab[] IS NOT INITIAL.

sort by per num.

and in select use pernr also so that system n u shld i denify for wat valu of pernr does bsgrd belong

select bsgrd pernr

from pa0008

into table it_p0008

for all entries in t_txt_upload

where pernr = t_txt_upload-pernr

regds

[Former Member]

Hello,

Declare pernr as charecter field.

• internal table for Basic pay.

DATA: BEGIN OF IT_P0008 OCCURS 0, "

Pernr(8) type c,

bsgrd like p0008-bsgrd, "Full time equivalent

END OF IT_P0008.

Regards

[Former Member]

Hi,

You are not selectiong both the fields PERNR & BSGRD from PA0008. You are selecting only BSGRD.

Either select both fields or user INTO CORRESPONDING FIELDS.

select PERNR bsgrd

from pa0008

into table it_p0008

for all entries in t_txt_upload

where pernr = t_txt_upload-pernr.

OR

select bsgrd

from pa0008

into CORRESPONDING FIELDS OF table it_p0008

for all entries in t_txt_upload

where pernr = t_txt_upload-pernr.

See if it helps.

Regards,

Hemant.

[Former Member]

Hi,

The sequence of d/b selection & internal table declaration does not match.

so you should use into corresponding fields of .....like:-

select bsgrd

from pa0008

into corresponding fields of table it_p0008

for all entries in t_txt_upload

where pernr = t_txt_upload-pernr.

rgds,