create generic extractor based on 2 tables

[Former Member]

hey BI gurus,

I have to create a generic extractor based on these 3 tables:

eban - i need all fields

vttk - i need only 4 fields i.e

route,

tknum,

datbg,

daten

ekbe - budat.

now the problem is thr is no common field between vttk & eban AND vttk & ekbe. but thr is a common field between eban & ekbe.so i can create a view only on these 2 tables but i want 3 tables

how do i proceed???

[former_member345199]

Hi,

Steps.

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

http://help.sap.com/saphelp_nw04/helpdata/en/86/1c8c3e94243446e10000000a114084/frameset.htm

Thanks,

JituK

[Former Member]

hey jitu,

thanks for rplying

ur Pdf is very useful.

but i still hv a doubt. In gen extraction by function module, is it necessry to hv common fields between tables??? coz in this select statement::

SELECT VBAK_{VBELN VBAK}ERDAT VBAK_{NETWR VBAP}MATNR VBAP_{POSNR FROM VBAK INNER JOIN VBAP on VBAK}VBELN = VBAP_{VBELN WHERE VBAK}VBELN IN SDNO.

In this ebeln is a common field in vbak & vbap.

but in my case thr r no common fields so how do i proceed???

[Former Member]

hey jitu m waiting for ur rply..

[former_member345199]

Hi,

I think an ABAPer can help you better in this.

Also see the Post by Thomas Wilson in the thread

Thanks,

JituK

[Former Member]

hey jitu!!!

It might be possible to link VTTK (Shipment Header) with the Purchase Requisition table EBAN using VFKP (Shipment Cost – Item level Table).

VTTK-TKNUM (Shipment Number) = VFKP-REBEL (Shipment Number)

VFKP is an item level table and hence there can be more than one line (Shipment Items) for each Shipment number.

Now from the records selected from VFKP the table VFKP can be linked to EBAN using:

VFKP-EBELN (PO Number) = EBAN-EBELN AND VFKP-EBELP (PO Item) = EBAN-EBELP AND VFKP-LBLNI (Service Sheet Entry) = EBAN-LBLNI

I created a view based on above approach. When I ran the view its showing me the data.

Now I created I generic extractor based on that view. After giving the data source name in RSA3 n clicking on extraction it shows me some 1000 records selectd.

Nw when I click on display list m getting a runtime error which is “field symbol hasl not yet been assigned”

can u help me out??

[Former Member]

Hi,

Try creating a generic extractor using a Function module.This is the procedure to create a generic extractor when no common fields are there in the table.

So take the help of an ABAPer in doing that.

Regards

Karthik

[Former Member]

hey raghavendra,

can u tell me the steps on how to create using fn module..

m new itno BI..

[Former Member]

Hi,

Sometimes, if your application or requirement makes it necessary, you have to create your own function module to extract the data from whatever sap system to bw.

Therefore you normally make a copy of the standard fm 'RSAX_BIW_GET_DATA_SIMPLE'. To make this new function work for you, you have to realize the following.

1.) the fm gets called by the extraction api for at least 2 times. First time is for initialization and from the 2nd time on it is for data extraction.

2.) right after the last data package (somehow you need to make sure that it is the last one) you have to raise the exception no_more_data.

Refer this links for more Info

SAP BI Generic Extraction Using a Function Module

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

SAP Network Blog: Generic Extraction via Function Module

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

Take the help of an ABAPer if your are new to this process

Regards

Karthik

Assigning points is the way to say thanks

[Former Member]

hey jitu!!!

It might be possible to link VTTK (Shipment Header) with the Purchase Requisition table EBAN using VFKP (Shipment Cost – Item level Table).

VTTK-TKNUM (Shipment Number) = VFKP-REBEL (Shipment Number)

VFKP is an item level table and hence there can be more than one line (Shipment Items) for each Shipment number.

Now from the records selected from VFKP the table VFKP can be linked to EBAN using:

VFKP-EBELN (PO Number) = EBAN-EBELN AND VFKP-EBELP (PO Item) = EBAN-EBELP AND VFKP-LBLNI (Service Sheet Entry) = EBAN-LBLNI

I created a view based on above approach. When I ran the view its showing me the data.

Now I created I generic extractor based on that view. After giving the data source name in RSA3 n clicking on extraction it shows me some 1000 records selectd.

Nw when I click on display list m getting a runtime error which is “field symbol hasl not yet been assigned”

can u help me out??

[former_member345199]

Hi,

Check this out.

Field symbols are placeholders or symbolic names for other fields. They do not physically reserve space for a field, but point to its contents. A field symbol cam point to any data object. The data object to which a field symbol points is assigned to it after it has been declared in the program.

OR Check TCode ABAPDOCU.

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3860358411d1829f0000e829fbfe/content.htm

Thanks,

JituK

[Former Member]

jitu i jus need 2 tables & not 3.

eban- all the fields

vttk - 4 fields i.e daten,datbg,tknum,route.

it ws a mistke, i dont need 3 tables.. but thr is no common field betwween thes 2 tables.

[Former Member]

hi karthik!!!

i jus need 2 tables & not 3.

eban- all the fields

vttk - 4 fields i.e daten,datbg,tknum,route.

it ws a mistke, i dont need 3 tables.. but thr is no common field betwween thes 2 tables.

[former_member345199]

Hi,

You can try the possibility of creating it based on a FM rather than a view.

Generic Extraction via Function Module

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

Thanks,

JituK

[Former Member]

jitu i jus need 2 tables & not 3.

eban- all the fields

vttk - 4 fields i.e daten,datbg,tknum,route.

it ws a mistke, i dont need 3 tables.. but thr is no common field betwween thes 2 tables.