cancel
Showing results for 
Search instead for 
Did you mean: 

Extractor for R/3 table T030

Former Member
0 Kudos

Hi folks,

we are in need to extract the T030 table (standard accounts table).

Is there any BI content extractor/datasource which we can use for extracting that table?

Thanks for your help,

Best regrads,

bivision

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

You can create the DataSource based on Table T030(Standard Accounts Table).

Follow bellow steps:

1. Create the Generic Datasource by useing RSO2.

Datasource can be created for

a). Transaction Data

b). Master data Attributes

c). Master data Text

2.Select Application component(SD/MM/FI)

3.Select extraction method extracts the data from a transparent table or database view.

4. Assign Table to Datasource

5. Once you specify Table in Data source, the extract structure willgenerate.

6. then select the filds in selection column.

7. Save and Activate the Datasource.

8. Check the Data in RSA3.

9. Replicate the Datasouce in BI side

Regards,

Suman

Former Member
0 Kudos

Hi,

Try this Datasource 0FI_AA_11 .

If this is not working please create a generic datasource as per the requirement by creating a view

Santosh

n_ruffini
Member
0 Kudos

Hi Bivision,

I don't think there is standard one available. Just create a custom datasource in your R/3 system with transaction RSO2.

Choose bullit 'Masterdata attributes' and create a datasource based on Table T030.

Regards,

Norbert.

Former Member
0 Kudos

Hi,

I don't think there is no stadard extractor based on the table T030.

Please check the below Link for Source Tables for Stadrad Extractors ( SD,MM&FI)

http://wiki.sdn.sap.com/wiki/display/BI/BWSDMMFIDATASOURCES

Regards

Ram.