Generic Datasource - How to Use open cursor and Fetch next for three tables ?

[rogerio_vazdesouza2]

Hi Gurus,

I need create a datasource by module function

to cross and load data from three Tables.

How does Open cursor and fech next in which case where

I need to use loop in a table to read the too ?

Thanks !

[ravi_chandra3 · Accepted solution]

Hi

Once try with the inner join like

select matnr~mara  maktx~makt ....... ( use inner join....)

Pls once try with the above logic and let me know.

[rogerio_vazdesouza2 · Accepted solution]

Hi Ravi,

Thank you,

I did as you said and it worked.

Now in that case,

I have two fields one creation date other date modification.

How do I use them to create a delta ?

Thank You !!!

[rogerio_vazdesouza2 · Accepted solution]

the model below not this respecting filters:

open cursor with hold s_cursor for

       select dbp~insobject    dbp~partner

              dbp~zzcod_territ dbp~zznom_territ

              dbp~zzcod_surc   dbp~zznon_surc

              dbp~zzcod_corr   dbp~zznon_corr

              dbp~zzproduto    dbp~zzriskfr

              dbp~zzriskto     dbp~zzcontract

              dbp~zzpmtfr_apol dbp~erdat

              dbp~aedat        dbp~zzpmtfr_end

              dbc~bcon_id      dbc~bcon_item_id

              db~insobjectext  db~insobjecttyp

              from dimaiobpar as dbp

              inner join dimaiobbcon   as dbc

                      on dbp~insobject eq dbc~insobject

              inner join dimaiob       as db

                      on dbc~insobject eq db~insobject

              where dbp~insobject = l_r_insobject-low and

                         ( dbp~erdat >= l_r_erdat-low and

                           dbp~erdat <  sy-datum )    or

                         ( dbp~aedat >= l_r_erdat-low and

                           dbp~aedat <  sy-datum ).

[ravi_chandra3 · Accepted solution]

Hi

For delta u need to write the extra code, pls search in google u wil find it .

Regards,

RaviChandra.

[ravi_chandra3 · Accepted solution]

Hi

Pls refer the below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30f1a423-02ae-2e10-bd85-bde64e61f...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70806d62-1c59-2e10-7597-91c114600...

https://scn.sap.com/message/8123081

Regards,

RaviChandra.

[Former Member]

see this links:

http://scn.sap.com/thread/3174025

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8d...