EKKO EKPO EKET join BODS3.1

[former_member1199727]

Hi,

We are developing a GR interface in BODS 3.1. Kindly find attached the strategy for it. We are trying to pull MSEG,MKPF,MCHA,EKKO,EKPO,EKET,EKBE, EBAN TABLE join to fetch the data monthwise and saved in SQL server 2005. As we know these tables contained huge data(more than 10 million). we break the joins but still we are getting session time out issue. For testing we join only ekko,ekpo,eket table and try to pull one month data in one data flow. But no luck. Can anybody help me?

Regards,

Nikhil

[kamal264]

HI Nikhil,

I hope you are following the below points ;-

1. In 1st Dataflow Extract the ERP table data into SQL database

2. Then apply join in coming dataflows

Data is huge so either you have to go with very High Config system or

Filter the data with where condition and apply the loop.

i=0

while(i < max of EKKO-EBELN)

{

i = i+10000

DF1

EKKO ----- where EBELN < i------ join with EKPO where EBELN <i

}

~Kamal