How to Extract data from Cluster table and transperant table

[Former Member]

Hello BW Experts ,

I want to extract the data from cluster table BSEG and a transperant table BKPF .

The primary fields are BELNR , GJHAR and BUKRS.

the fields of table BKPF to extarct is BUDAT and fields of BSEG table is HKONT , BSCHL , ZUONR and POSID.

I can not create a view over these two tables as BSEG is a Cluster table.

Please guide me.

Regadrs ,

Amol.

[Former Member · Accepted solution]

Hello Aagain ,

I also want to extract the data of field DMBTR ( Amount in local currency ) from table BSEG.

Regards ,

Amol

[Former Member · Accepted solution]

Hi Amol,

You can choose Function module for extracting data from these two tables...using fm create a datasource-generic.

thanks,

Vachan

[Former Member · Accepted solution]

Hello VACHAN ,

But in FM there are import and export parameters .

The ABAPer is asking me to tell that .

What should be the import export parameters in the FM ?

I am not getting anything.

Amol.

[edwin_harpino · Accepted solution]

hi Amol,

take a look Sigg's weblog

/people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

you can use RSAX_BIW_GET_DATA_SIMPLE as sample, there specified import parameters

FUNCTION RSAX_BIW_GET_DATA_SIMPLE.

*"----

---

""Lokale Schnittstelle:

*" IMPORTING

*" VALUE(I_REQUNR) TYPE SRSC_S_IF_SIMPLE-REQUNR

*" VALUE(I_DSOURCE) TYPE SRSC_S_IF_SIMPLE-DSOURCE OPTIONAL

*" VALUE(I_MAXSIZE) TYPE SRSC_S_IF_SIMPLE-MAXSIZE OPTIONAL

*" VALUE(I_INITFLAG) TYPE SRSC_S_IF_SIMPLE-INITFLAG OPTIONAL

*" VALUE(I_READ_ONLY) TYPE SRSC_S_IF_SIMPLE-READONLY OPTIONAL

*" TABLES

*" I_T_SELECT TYPE SRSC_S_IF_SIMPLE-T_SELECT OPTIONAL

*" I_T_FIELDS TYPE SRSC_S_IF_SIMPLE-T_FIELDS OPTIONAL

*" E_T_DATA STRUCTURE SFLIGHT OPTIONAL

*" EXCEPTIONS

*" NO_MORE_DATA

*" ERROR_PASSED_TO_MESS_HANDLER

[Former Member · Accepted solution]

Hello AHP ,

I am not getting whether I need to create a new FM as per the sample FM RSAX_BIW_GET_DATA_SIMPLE or I need to modify this sample FM ?

Amol.

[edwin_harpino · Accepted solution]

hi Amol,

you need to create a new function module (SE37).

hope this helps.

[Former Member · Accepted solution]

Hello AHP ,

Ok. I will create a new functional module .

Thanks very much.

Amol.

[Former Member · Accepted solution]

HI Amol,

Can you pleae share the code with me?

Thanks.

Pranav Kulkarni