topic Re: Dump issue in Application Development and Automation Discussions

Dump issue

Former Member — Mon, 07 May 2007 07:48:33 GMT

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.

Re: Dump issue

Former Member — Mon, 07 May 2007 07:50:28 GMT

Hi,

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

Best regards,

Prashant

Re: Dump issue

Former Member — Mon, 07 May 2007 07:50:47 GMT

try this..

select bsgrd

from pa0008

into corresponding fields of 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!!!!!

Re: Dump issue

Former Member — Mon, 07 May 2007 07:53:16 GMT

first check ST22 ti get some idea.

and also check internal table Format.

select pernr bsgrd

from pa0008

into corroesponding fields of table it_p0008for all entries in t_txt_upload

where pernr = t_txt_upload-pernr.

Regards

Prabhu

Re: Dump issue

Former Member — Mon, 07 May 2007 07:55:35 GMT

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

Re: Dump issue

Former Member — Mon, 07 May 2007 07:56:50 GMT

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

Re: Dump issue

Former Member — Mon, 07 May 2007 07:57:32 GMT

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.

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.

Re: Dump issue

Former Member — Mon, 07 May 2007 08:12:53 GMT

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,