topic Re: Data from views in Application Development and Automation Discussions

Data from views

Former Member — Thu, 19 Feb 2009 09:43:53 GMT

Hi friends,

Does anyone know how to extract data from views in a poduction system for e.g

TXW_ANLA

TXW_ANLB

TXW_ANLC

TXW_ASSCLA

Thanks.

kris

Re: Data from views

Former Member — Thu, 19 Feb 2009 09:45:50 GMT

chk out these threads

hope this helps

regards

Aakash Banga

Re: Data from views

Former Member — Thu, 19 Feb 2009 09:48:24 GMT

Hi ,

We are trying to extrct data for the audit , it is a ECC production system , not related to BW.

Thanks,

Re: Data from views

SuhaSaha — Thu, 19 Feb 2009 09:50:27 GMT

Hello,

You cannot extract data from these structures.

Data can be extracted only from DB tables & DB Views.

BR,

Suhas

Re: Data from views

Former Member — Thu, 19 Feb 2009 09:53:05 GMT

hi,

you cannot get data from it ....u can get data from database tables only and not structures

thanks

Re: Data from views

Former Member — Thu, 19 Feb 2009 09:57:55 GMT

Hi;

[Query|http://help.sap.com/saphelp_erp2005/helpdata/en/f6/c39138e4a0341fe10000009b38f8cf/content.htm]

Below are the steps to create an infoset.

1. Go to transaction SQ02.

2. Create a Zinfoset. (give a name for infoset and click on create).

3. Select "Direct Read of Table" in the Data source tab and provide the name of the table (in your case BSEG).

4. In the next pop-up, Choose "Select all fields".

5. Save the infoset.

Now, you go to RSO2 and create a data source based on this infoset.

You need to Generate the infoset.

Hope this helps

Regards

Shashi

Re: Data from views

Former Member — Thu, 19 Feb 2009 10:01:24 GMT

Hi,

You can not extract data from structures, you can get data only from the database tables.

Regards,

Jyothi CH.

Re: Data from views

Former Member — Thu, 19 Feb 2009 10:06:05 GMT

Hi Friends,

What is the solution to extract data from this views, is there any procedure, is there any sql stattemnet or is there any ABAP program for extracting the data.

Please help me.

Thanks;

Re: Data from views

Former Member — Thu, 19 Feb 2009 10:07:09 GMT

Hi,

IS this procedure to extract the data from views.

Thanks

Re: Data from views

SuhaSaha — Thu, 19 Feb 2009 10:22:47 GMT

Hello Kris,

As mentioned in the other posts you cannot extract data from structures.

Can i know form where did you get these structures?

Anyways there are corresponding asset tables: ANLA, ANLB, ANLC. You can extract data form these tables.

BR,

Suhas

Re: Data from views

Former Member — Thu, 19 Feb 2009 10:48:58 GMT

Those views are given by the user to extract data for an audit.

How can i extract data from this tables related to the particular views.

Re: Data from views

Former Member — Thu, 19 Feb 2009 14:30:53 GMT

You need to educate your users. These are structures that contain no data.

Then you need to find out from what tables these structures are filled and use these to get your data.

Rob

Re: Data from views

ThomasZloch — Thu, 19 Feb 2009 14:57:39 GMT

These structures are related to the "Data Retention Tool" (DART). Find out more here:

http://help.sap.com/erp2005_ehp_04/helpdata/EN/3b/162b97c35511d1801b00c04fada2a1/frameset.htm

Thomas

Re: Data from views

Former Member — Wed, 13 May 2009 01:30:34 GMT

Hi Kris,

As Thomas says, TXW_* are DART structures. DART extracts data from DB tables and stores it on flat files for you to use in an audit. The program that creates the flat file is at transaction FTW1A, but you first need to do configuration of the DART application. I believe instructions on how it is configured can probably be found in the documentation mentioned by Thomas. (for a quick idea of what is contained in DART, you can go to area menu FTW0 (that's zero, not oh).

Good luck,

Katherine

Re: Data from views

Former Member — Thu, 21 May 2009 14:28:28 GMT

I need to close it to open another one.

Re: Data from views

Former Member — Thu, 21 May 2009 14:32:59 GMT