Generic datasource

[Former Member]

Hi Friends,

At what Instance we will create generic datasource based on function module ?

I need all your inputs for regarding this.

Thanks in advacne,

Chandu.

[Former Member]

Hi,

If there are join conditions based on logic, or if computatins are needed at the datasource level, we'll go in for function module at that time.

Cheers,

Kedar

[Former Member]

Hi Kedar,

Thanks for your reply,Still one more doubt is burning.

What kind of computatins are needed at the datasource level?what does it mean exactly?

Does it mean complex logics?

Thanks in advance,

Chandu.

[Former Member]

Hi,

It means complex logic, or deriving certain fields based on conditions between multiple tables, or calculations that are too complex to do in BW.

Cheers,

Kedar

[Former Member]

Hi,

If we want to combine 2 or more tables we will go for view or funcional module. We will go for view when we know the key relation between tables. We go for funcional module if we don't know direct key relation between tabels, so we will use some other tabels to combine the necessary tables.

Assign points if it helps.

Cheers,

Malli.

[varma_narayana]

Hi...

Generally when we need to extract the Data from more than 3 tables, where complex joins are involved we have to create a Generic Data source using Function module. Bcoz Views will give a poor performance in this case.

hope u got it.

[Former Member]

Hi Varma,

I am really thankful for your reply. I want to confirm one thing, Does views or Function module will cause poor performance?

Thanks in advance,

Chandu.

[Former Member]

Hi,

Its based on the join conditions, the volume of data. It all depends on how you design the view. There is no straight forward rule that says view will cause poor performance.

Cheers,

Kedar