dump in the internal table

[Former Member]

Hi,

I am writing a program in which i am taking data from bseg and bkpf based on certain condition and making a join internal table and putting the data in it.

I am getting a dump on the statement

append jointable.

i have heard that a internal table can store data upto 500 MB? if that is true then this will give a dump as the data is far bigger then that.

I cannot use package size as i am looping some internal table... i cannot use select endselect.

So what should my next step be?

Thanks and Regards,

Amit Kurup

[Former Member]

Arshad,

Try using FIELD GROUPS, they are exactly like your Internal tables, but can handle large amount of data.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

Hi Ravi,

i have never used field groups can you give me an example.

Thanks,

arshad

[Former Member]

Arshad,

Take a look at this example program <b> ZZBGS008 </b>

http://www.guidancetech.com/people/holland/sap/abap/

Regards,

Ravi

Note : please mark the helpful answers

[Former Member]

HI Ravi,

the program is useful. I have defined the field group join

and am taking the data

but suppose i want to expicitely give

join-buzei = wa_tempbseg-buzei.

It doesnot allow me as it says the data object join doesnot have a componenet called buzie.

Can you suggest me what may be the reason?

[Former Member]

Arshad,

I have not used this extensively myself. Here is a thought, at design time FIELD GROUP will not have a structure, so you cannot access the fields the way you were trying to.

Try using field symbols, like this.

FIELD-SYMBOLS : <FS_ANY>

ASSIGN COMPONENT 'BUZEI' OF STRUCTURE WA_TEMPSEG TO <FS_ANY>

Now the field symbol <FS_ANY> will have the value of the BUZEI field.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

hello...

bseg and bkpf are cluster table so join b/w them are nopt possible...

try to selct data in internal table one by one...

select * from bkpf into table itab

where cond.

select * from bseg into table itab1

for all entries in itab

where cond.

loop at itab1.

read table itab binary search whers cond.

itab1-field = itab-ield.

endloop.

[Former Member]

What kind of dump are you getting?

Robnd