topic Re: Issue with Internal Table in Application Development and Automation Discussions

Issue with Internal Table

Former Member — Tue, 07 Oct 2008 10:32:19 GMT

Hi All,

I have defined an internal table 'with occurs 0'.

While debuggining, i am observing that only 50,000 lines are getting populated in that internal table.

How to increase the capacity of the internal table, so that it can hold more number of lines?

Regards

Pavan

Re: Issue with Internal Table

Former Member — Tue, 07 Oct 2008 10:37:28 GMT

as long as your dialog work process has enough memory it will not stop at 50k records. it may just be that the debugger shows only those first 50k.

Re: Issue with Internal Table

Former Member — Tue, 07 Oct 2008 10:39:17 GMT

I think you have to check your program, an internal table can have more than 1.000.000 records so somehow there is no more input to populate your table.

Regards,

Guido

Re: Issue with Internal Table

Former Member — Tue, 07 Oct 2008 10:40:12 GMT

Hi Florian Kemmer,

Thanks for your response.

But can you explain a bit more about your answer?

I am unable to understand about dailog work process...

Regards

Pavan

Re: Issue with Internal Table

Former Member — Tue, 07 Oct 2008 10:48:47 GMT

I would like to explaing you all about this issue.

I have defined an internal table as follows...

data: IT_CATSDB TYPE BAPICATS2 OCCURS 0 WITH HEADER LINE.

I have used a BAPI called "BAPI_CATIMESHEETRECORD_GETLIST" which will retirieve the Timesheet details of all employees within a given date range.

Now, the number of entries that we got from this BAPI are stored in the internal table it_catsdb.

I have observed that this internal table is holding max of 50k lines.

If i check the database table (CATSDB) for the same conditions in SE11, i am able to get around 1L lines.

Hence my report is showing incorrect output.

Kindly help me out with some logic, so that this internal table can hold as much as data possible without any restriction.....

Regards

Pavan

Re: Issue with Internal Table

Former Member — Tue, 07 Oct 2008 10:54:33 GMT

After the select fetch type IT_CATSDB[] try this under filed names in debugging mode then hit enter the field values will show how much records it holds .Check the value of sy-dbcnt if both are same then your assumption is wrong.Pls check and let us know.

Re: Issue with Internal Table

Former Member — Tue, 07 Oct 2008 10:55:47 GMT

hi,

occurs 0 assigns a default size of 8k to internal table

a record can have varying size...so no of records held by internal table can vary

you can try higher values of n in occurs n.

Re: Issue with Internal Table

former_member182354 — Tue, 07 Oct 2008 10:58:27 GMT

Hi,

Remove the Occurs 0 clause and see. whether you can move with it..

Raghav

Re: Issue with Internal Table

Former Member — Tue, 14 Oct 2008 11:11:10 GMT

Thanks

Re: Issue with Internal Table

Former Member — Mon, 05 Jan 2009 08:17:53 GMT

Hi Pavan,

I am using the function module BAPI_CATIMESHEETRECORD_GETLIST to retrive the data from the CATSDB table , i found that in the SDN you are able to successfully read this function module and retrive data , my question is the cost centre which is there for the personnel no in pa0001 ....is the same one which i have found in CAT2 Transaction . However when i am retrieving from this Function module

i dont found cost centre as such, but i found is sender cost centre(SEND_CCTR) and receviing cost centre(REC_CCTR) which dont have any data in the internal table it_cats_rec_out. However i am able to get the personnel no , no. of hours , work data etc data has been found in the internal table it_cats_rec_out retrived from the FM .

Hence could you please let me how can i can get the cost centre details i.e the sender cost centre or receiiving cost centre , which is the one actually i have to use ? or could you please tell me

any configuration has to be done so that i can ask my functional in this regard so that i can retrive the cost centre .

regards

divya.

Re: Issue with Internal Table

Former Member — Mon, 05 Jan 2009 12:06:11 GMT

Hi Pavan

There can be 2 ways in which you can try this out.

1) Try putting a value greater then 0 with occurs clause, something like OCCURS 100.

2) Try defining the types. something like

TYPES: BEGIN OF s_lips,

vbeln TYPE vbeln,

posnr TYPE posnr,

matnr TYPE matnr,

charg TYPE charg_d,

lfimg TYPE lfimg,

meins TYPE meins, " ++MBIN ABF4363_05 02.11.2008

shkzg TYPE shkzg_va,

xchpf TYPE lips-xchpf, " ++RATH FCR21221/ACRF4363_04

brgew TYPE lips-brgew, " ++RATH FCR21221/ACRF4363_04

END OF s_lips.

DATA: t_lips TYPE STANDARD TABLE OF s_lips WITH HEADER LINE.

Hope this helps.