Generi Extractor

[Former Member]

Can v create the view for the generic extractors without the common primary keys in the tables, if so let me know the procure to follow.

Regards

KK

[former_member205352 · Accepted solution]

Joins for view neednot be on primary key but if not on primary keys there will be multiple records for different combination.

You need to choose your fields wisely and create join.

If you have single table you can use view else you need some condition to join the tables.

May be for your case you can go for function module generic datasource where you can write your logic to populate data.

Hope this helps.

[Former Member · Accepted solution]

thanx for the response how i have to analyze wheather i have to create one extractor or more. since i have to extract the data from nearly 45 fields and from 7-8 differenct tables.

pls let me know what r things i need to consider for the same.

Regards

[Former Member · Accepted solution]

Hi,

U can create a generic extractor with views, its always recommended to create a view with atleast one Primary keyfield so that while populating the values u dont have any mismatch.

create views mapping all similar charecteristics from tables and then create a extractor for this. this will avoid confusion in data.

revert back if u need any help.

Regards,

Ranjith

[Former Member · Accepted solution]

Hi

I think FM is ideal since you are looking 45 fields from 8 tables.

You can create a view but the performance will be poor and you may not have primary key fields to map across the table.s

Regards,

Chandu.

[Former Member · Accepted solution]

Hi ranjith,

Thanks for the response. i have fetch the data from eban,pspr,ekko,ekpo,eket,mkpf,ekkn..table.can u pls recommend if it is possible to create the view for this tables.

it so let me know the join conditions for the same.

Regard

[Former Member · Accepted solution]

Hi KK,

Please have a detailed study of these tables and find out what all key fields they have in common.

Find all possible key fields common between these fields and make a view on them.

then u can add this view to your extractor and select what all fields u need.

the possible combinations for the tables u have given are

ekko ekpo eban mkpf eket Ekkn

mandt mandt mandt mandt mandt MANDT

ebeln ebeln ebeln EBELN

ebelp ebelp EBELP

for the above create joins on these fileds in the

please check with the name of the table PSPR. its not a standard table.

please confirm the name of the table so that i can help u. or if u find anuy of these fields in that table create a join on it. and create a view.

hope this helps if u need any help further, please revert back

regards,

ranjith

Edited by: Ranjith Kumar Murugesan on Oct 14, 2008 2:56 PM

[Former Member · Accepted solution]

Thanx Ranjith,

sorry the table name is prps not pspr. can v create a view using mandt only ?

suppose x is der in ekko and ekpo

and y is der in ekpo and ekkn

z is der in ekkn n eban

a is der in eban n ekbn

b is der in ekbn n prps.

can v create a join. but the thing is i am i going to fetch the data from all the table. i thing its going to a huge volume ??

pls reply with ur suggestion.

Regards

KK

[Former Member · Accepted solution]

Hi KK,

The table for key fields i sent u is not in the format i sent, send me ur mail id i will send u the correct fields to be mapped to generate a view.

please check with the table name PSPR and confirm so that i can help u

[Former Member · Accepted solution]

Hi KK

You can create view with the mentioned relations but it's going to be huge data and I dont think it will be accurate.

Regards,

Chandu.

[Former Member · Accepted solution]

Hi,

U have a single commmon field MANDT in all the 7 tables.

u can just have this key common and create a view,

its better u create a join with all the available keyfield combinations between ur tables. that will increse the performance.

u can map table A B C D with a single key and D with E with another key also. this should work.

Any further help needed. please revert back.

Regards,

Ranjith

[Former Member · Accepted solution]

Hi KK,

In a view u can choose the fields u want and u can just view them alone.

this will prevent u from lareger volumes of data that would hinder the performance.

select only the fields that are necessary, leave fields that u think can be manipulated from the existing fields in BW side.

Any further help needed, Please revert back.

Regards,

Ranjith

[Former Member · Accepted solution]

Thanx for ur consistent replies.

the table name is prps.

can u pls send me the the list of common fields that can be mapped to create the view on SDN itself, since i dont hav access to any outside mails.

and also could u pls provide me any side r any table where i can find the common fields in the different MM tables.

Thanks a lot for ur co operation.

Regards

KK

[Former Member · Accepted solution]

Please refer to this link for relation between MM tables.

http://www.erpgenie.com/abap/tables_mm.htm

Thanks,

Murtuza.

[Former Member · Accepted solution]

Hi KK,

Sorry for late replying

please choose all the fields,

create a join on MANDT from all the tables

create a join on EBELN from tables EKKO EKKN EKET EKPO

create a join on EBELP from tables EKKO EKKN EKET EKPO

the other three tables have no other field except MANDT in common.

please chek the view for duplicate values and confirm me.

hope this solves ur issue.

contact if u need any further help.

regards,

Ranjith

[Former Member · Accepted solution]

Hi KK,

is it working?

[Former Member · Accepted solution]

Thanx guys for ur co operation.

[Former Member · Accepted solution]

Hi KK,

thanks for assigning points.

Regards,

Ranjith

[Former Member · Accepted solution]

yes Ranjith.

The problem is solved.

i would like to ask another question.

I need to create the reports which consist fields of both the header and item level. Now my doubt is how can i move the data to the data targets. Shall i create the different DSO for Header and item and create the reports on multiprovider or infoset. or shall i create the one DSO only.

Regards

[Former Member · Accepted solution]

Hi KK

you can do it both ways.

best way is load into one ODS then do your reporting.

Regards,

Chandu.

[Former Member]

thanx

[Former Member]

Hi pls thru some light on the issue

[Former Member]

Hi,

I think it would be better u can look for the cubes which contain the data u need, create a multiprovider on them, maintain their charecteristics and create a query on this multiprovider.

i think its unnecessary to load the data again into an ODS when u already have the data in some other objects.

Maintain all the common keyfields from both the cubes and select the fields u want and create a query on then.

loading again will consume some memory, so i think its not needed.

Regards,

Ranjith