DataSource for tables T095 and T095B

[Former Member]

Hi,

I will require to work on bringing in the data from tables T095 &

T095B. I need few Information on the same.

1. Is there any content DataSources available that i can use?

2. If I need to create a custom DataSource and load the data, to which

Info Object do i need to load data. There are 3 primary keys (Chart of

account, Real Depreciation Area and Account Determination) in both of

these tables. Also, all these 3 fields has its own Master data to be

loaded.

3. Do we need to load data to Info Object or should it be a DSO?

Please clarify on these above questions. This will help me to design

accordingly.

Thanks,

Deepika

[former_member331159 · Accepted solution]

Hi,

Create a generic datasource using the tables.

Thanks.

Edited by: Pravin Wayse on Mar 4, 2009 8:14 AM

[Former Member · Accepted solution]

Hi Pravin,

The other problem is, to which Info Object we need to load the data to. There are 3 Primary keys in these tables. All 3 has its own Master data to be loaded.

Thanks,

Deepika

[Former Member · Accepted solution]

I got your question . The way is create a generic datasource using rso2 transaction .

This will use your tables that you mentioned .

Ok now thw question is move data to DSO or infoobject .

The data should be loaded to infoobject first depending upon it will be using in the other cibe or dso in the future and what i say it will be useing also . SO when we load to infoobjects SID are generated and will be usefull when we will doing trannsactional data load .

So go to BI create there infoobjects and through data source that you replicated to BI . i Mean 3 data sources one for each on the fields create the 3 infoobjects refereing the field lenths and types .

Assign marks is the best way to appreciate help whoever it is

[Former Member · Accepted solution]

so, the 3 datasources will be its own Master data load or T095 and T095B?

Basically,

Chart of Accounts, master data table is T004

Real Depreciation, master data table is T093

Account determination, master data table is T095T.

if i create info objects and load these tables data accordingly, then to which info Object do i need to load T095 or T095B table data?

Guess DSO will work right?

Thanks,

Deepika

[former_member331159 · Accepted solution]

Hi,

You can use standard infoobject 0CHART_ACCOUNT and DS 0CHRT_ACCTS_ATTR and TEXT

for char of account.

Thanks.

[Former Member · Accepted solution]

Parvin,

Thanks for the datasource you provided. But, this data will be loaded to Chart of account Info Object. But to which info objects of the 3, do i want to load T095 or T095B table data?

[Former Member · Accepted solution]

The data of T095 and T095B are being loaded into 2 seperate custom InfoObjects. There are 3 primary keys in this table. So Chart of Accounts and Account Determination is been added as compounded keys and Info Object is Depreciation area.

Thankd,

Deepika

[Former Member]

Hi Experts,

Please provide your suggestions...