Skip to Content
author's profile photo Former Member
Former Member

Texts Generic Datasource issue?

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 20, 2013 at 01:36 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2013 at 01:39 AM

    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-cd24ee6d517c?overridelayout=true

    Cheers

    Anindya

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2013 at 03:30 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2013 at 11:27 AM

    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-f13118a4776d?overridelayout=true

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2013 at 08:30 AM

    Thanks Guys

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.