Issue with Internal Table

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[former_member182354]

Hi,

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

Raghav

[Former Member]

Thanks

[former_member217316]

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.