Data extraction Issue

[Former Member]

Hi Experts,

I am trying to load data from a generic datasource, which is based on a view.

The view contains 5 tables - EKBE,EKKN,EKPO,T001 and EKKO.

The join condition is as follows:

EKKN EBELN = EKBE EBELN

EKKN EBELP = EKBE EBELP

EKPO MANDT = EKBE MANDT

T001 MANDT = EKBE MANDT

EKKO MANDT = EKBE MANDT

Now, when i try to check data in rsa3, it throws a dump.

I then tried to check out the data in the view.

I entered a particular PO Number as the selection, and then clicked on "No. of entries" button.

It takes a long time for processing and then it gives a message "Maximum Runtime Exceeded".

Kindly let me know what should be done for this.

[Former Member]

I will surely try changing the join conditions, as suggested.

But one doubt here, am i getting this issue because i have used 5 tables, since each table has many records in it.

Could this be the reason for the time out?

[Former Member]

Absolutely not,even views work with 8 tables.

I have personally worked on that.

[Former Member]

HI,

Problem is with your view joining conditions for this reason you are getting a dump.

You must needs to include the client (MNADT) of all the table in the join condition

The join condition is as follows:

EKKN EBELN = EKBE EBELN

EKBE MANDT = EKKN MANDT

EKKN MANDT = EKPO MANDT

EKKN EBELP = EKBE EBELP

EKPO MANDT = EKBE MANDT

T001 MANDT = EKBE MANDT

EKKO MANDT = EKBE MANDT

EKPO MANDT = EKBE MANDT

EKBE MANDT = T001 MANDT

T001 MANDT = EKKO MANDT

EKKO MANDT = EKBE MANDT

Regards,

Anand Tej.

[Former Member]

I tried out the join conditions suggested by you, but still i am getting the same problem.

What else can i do?

As a clarification, I actually just want data from EKBE and EKKN tables.

But because there are certain Currency/Quantity Fields being used, i had to add the base tables for those fields, and hence i got 5 tables in all.

Without that, i was not able to create the generic datasource.

[Former Member]

There is a problem in your join condition. And thats's the reason you are getting a dump. You need to include the client (MNADT) of all the table in the join condition. It has already been posted how to do so. Once you included this joiuning condition, check the no. of entries again for the PO no. I hope this time it will work.

Thanks..

Shambhu

[Former Member]

EKPO MANDT = EKBE MANDT

EKBE MANDT = T001 MANDT

T001 MANDT = EKKO MANDT

EKKO MANDT = EKBE MANDT

EKBE MANDT = EKKN MANDT

EKKN MANDT = EKPO MANDT

Client should be joined as this.

You need to include all the keys of the 5 tables in the view.

Then activate the view and make changes in the dataSource.

Check data in the extract structure and replicate the same in BI.

Assign pts if it is useful

cheers,

shana

[Former Member]

Hi,

Check :-

1 Your view is active

2 See all the possible joins for all the tables with each other is done

If this is not done the view is producing many records as joins have not been specified. This is resulting in huge no of records thus throwing dump .

Regards

Rahul Bindroo

[Former Member]

Thanks for your prompt reply.

Can you please elaborate on "See all the possible joins for all the tables with each other is done ".

How am i supposed to do this?