Account numbers with unassigned Chart of accounts

[Former Member]

Hi..

Records for the cube are coming from R/3 via a program into a table. BW loads the data from the table. In the table there are some records for an account number 40200 which is assigned to Chart of Accounts and some records for the same account number 40200 which is not assigned to Chart of Accounts.

The data was loaded into BW. Now the query shows two records for the same account number.

I want to assign the Chart of accounts to the unassigned ones, in BW, so that the query shows only one record.

Is there a way to fix this issue in BW? Do I need to write some transfer routine?

Thanks,

Sai.

[Former Member]

Hi Sai,

If it is a constant you can assign the value in either the transfer or the update rules. If it based on some logic then you may need to write abap routine for the info-object in either the transfer or the update rules.

Bye

Dinesh

[Former Member]

Hi...

Thanks for the reply.

Among the two records that are shown in the report for the same account number, the account number with unassigned chart of accounts is not getting the master data texts.

Is there a way to the master data texts for the assigned account number #/40200 in the report?

Thanks,

Sai.

[Former Member]

Hi,

one way to get the account no for those which are mapped with chart of accoutns is to give the chart of account values in teh data selection tab of teh attribute infopackage.this will then just give u the account no for that relate to the chart of accounts and the text will be throught the text infopackage so u will get all the necessary text.

do let me know if it works.

ravi.

[Former Member]

Thanks for the reply. I already tried this out. In the scheduler selection, for the datasource - 0account_text, text attribute for account, I gave in the account number with no selection in chart of accounts and scheduled the package.

It is bringing the texts only for the account number which has chart of accounts assigned to it, not for unassigned ones.

any more suggestions?

thanks...sai.

[Former Member]

adding...because in RSA3 for 0account_text there is only one record ...i.e the account number with assigned chart of accounts.....1000/40200....

so it's bringing in only one record.....

thanx...sai.

[Former Member]

Hi Sai,

If you know the logic of chart of accounts determination, you can set CoA in transfer or update routine.

Best regards,

Eugene