Data from views

[Former Member]

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

[Former Member]

hi

chk out these threads

hope this helps

regards

Aakash Banga

[Former Member]

Hi ,

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

Thanks,

[SuhaSaha]

Hello,

You cannot extract data from these structures.

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

BR,

Suhas

[Former Member]

hi,

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

thanks

[Former Member]

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;

[Former Member]

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

[Former Member]

Hi,

IS this procedure to extract the data from views.

Thanks

[SuhaSaha]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

NO

[Former Member]

Hi,

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

Regards,

Jyothi CH.

[ThomasZloch]

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

[Former Member]

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

[Former Member]

I need to close it to open another one.