cancel
Showing results for 
Search instead for 
Did you mean: 

Texts Generic Datasource issue?

Former Member
0 Kudos

Hello Gurus,

I am thinking to create  below datasources from View/Table and Extract Structure.

I need to create a ''Generic Datasource (Texts)'' with BERID, SPARS and TXTMD.

&

I need to create a ''Generic Datasource (Attributes)'' with LGNUM, LHMG1 and LETY1 (Fields from MLGN table) and a ''Generic Datasource (Texts)'' with LGNUM, SPARS and TXTMD.

Do I need to Create both Extract structure and Table or View for all of these?

Can any one please suggest me the steps to be taken for data source creation?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Phanindra,

The field LHMG1 in the table MLGN refers to MEINS field(Base unit of measure) in the table MARA.

If you try to create data source based on table MLGN,system gives an error:invalid extract structure,because units or currency refers to different table.

So first create view on MLGN and MARA tables using SE11.In the view, include the reference field from MARA:MEINS. Then create generic data source based on that view.In this way you can create generic datasource for attributes.

what are the base tables for the text data source?

Regards

Padmaja

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks Guys

Former Member
0 Kudos

Hi,

  In the area for ‘View/Table’ give the name of the view which was created in se11. Click on ‘Save’ button. u no need to create extract structure When the DataSource is saved an extract structure is created for our DataSource.

http://help.sap.com/saphelp_erp60_sp/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/content.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40394d9b-93b9-2d10-9f9a-f13118a47...

RamanKorrapati
Active Contributor
0 Kudos

Hi Phani,

Required fields are available on one table or view, you can go for creation of generic data source fro text as well as master data attributes by using t code RSO2 and choose respective radio button to create master data data sources.

If your base table have any reference field from other tables, then you need to create extract structure too. other wise it may throw error for you.

Normally for tables/views no need to create extract structure if base tables are not used referenced fields.

Just start creation and let us know if in case of any errors.

Thanks

anindya_bose
Active Contributor
0 Kudos

Hi Phani

it depends on your base table structure.

if the tables are separate you have to create different views and extract structure would automatically be created when you create a DS based on view. ( you do not need to do anything for that).

I understand attribute DS will be based on MLGN table, what are the base of other two extracture?

Have a look at the How to Document below, in sdn we have more how to doc.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10a89c00-7dd7-2d10-6f83-cd24ee6d5...

Cheers

Anindya