on 05-19-2013 10:45 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Guys
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Cheers
Anindya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.