Downloading WBS Elements from Table PRPS

[Former Member]

Experts,

I am trying to download a full list of WBS Elements I have created from Table PRPS in SE16.

In the table- it shows I have created 11,831 WBS Elements- however, when I download these to my local drive in an Excel Format- it only downloads roughly 8,000 WBS Elements.

I have tried to download it numerous times in different formats- and still it is not allowing me to download the complete set of 11,831.

Does anyone have any experience of this and how can I resolve this issue to download them all?

Thank you,

M.S.K.A

[Former Member]

Experts,

I am trying to download a full list of WBS Elements I have created from Table PRPS in SE16.

In the table- it shows I have created 11,831 WBS Elements- however, when I download these to my local drive in an Excel Format- it only downloads roughly 8,000 WBS Elements.

I have tried to download it numerous times in different formats- and still it is not allowing me to download the complete set of 11,831.

Does anyone have any experience of this and how can I resolve this issue to download them all?

Thank you,

M.S.K.A

[former_member222709]

Hi M.S.K.A.,

If you can check with a breakpoint for the number of records in your internal table. This will help in locating the point of issue. Is your select query fetching less records or the is it that 11,000 records in your internal table are restricted to 8,000?

Regards,

Pranav.

[Former Member]

Hi Pranav,

Thank you for your help - I downloaded the data in TXT format then changed it into Excel format- which allowed me to have all the WBS Elements.

Kind Regards,

M.S.K.A

[former_member222709]

Hi M.S.K.A,

Since the text file downloads the data completely, excel is encountering a special character which skips data.

For e.g., if there is quotes in your data, then, excel will considers it as comments and skips the data until it encounters another quotes. In your case you might have to do this exercise of verifying the exact location or part of the record that is getting skipped. Then, in the DEBUG Mode, you need to check your internal table and you might get some further help.

So, you can still use excel if you want the output in an excel format.

Regards,

Pranav.

Edited by: Pranav Mandelia on Oct 28, 2011 10:27 AM

[Former Member]

Hi Pranav,

Many thanks for your help- you are correct.

Thank you,

Muna