Data Load problem in ODS: 0FI_AA_11 - Urgent

[Former Member]

Hi,

I loaded the data in to the ODS: 0FI_AA_11. I am not finding the all relevent data for all Currencies (Company Code Currencies & Controlling Area Currencies)

I am able to get data only for Company Code Currency.

Please help me out how to get relevent data for Controlling Area Currency?

But i can able to see both of these Currencies data in RSA3 transaction of Data Source: 0FI_AA_11 in SAP R/3 system.

Best Regards,

Venkata

[Former Member · Accepted solution]

Looking at datasource documentation a can see only one currency:

http://help.sap.com/saphelp_erp2005vp/helpdata/en/41/655d0b58c43013e10000000a114b54/frameset.htm

What do you see in RSA3?

Regards

[Former Member]

Hi,

Thank you for response! In the data source: 0FI-AA-11 we do have Currency field taken from R/3 Table: T093B. In RSA3 transaction, We do have two Currencies: EUR and SEK. Both currencies, i am seeing. But not in ODS. Can you help me out why?

Best Regards,

Venkata

[Former Member]

Youa re seeing them where in T093B?

Against two separate company codes?

The data, for example, is taken from ANLP

The data stored here is the currency code for the Co code in T093B

[Former Member]

It depends on the key of ODS; i think you don't ave currency in the key fields.

So add it and reload data and you wil find it.

Hope it helps.

Regards

[Former Member]

I am seeing these two currencies in T093B table.I am looking these twi different currencies in the same Company Code.I do have Currency in the key fields.

[Former Member]

ahh

I understand now - T093B is fooling you

The currency codes are not against the CO Code - they are against the depreciation area and company code

So you have one co code, two depreciation areas and EUR for one depn area and SEK for the other.

Are you using the std ODS?

Have you checked the ODS for the depreciation area for the EUR (which is what I assume the controlling area currency is)

Are there any records for that depreciation area?

[Former Member]

Yes, i am using the standard ODS: 0FI-AA0-11.

How to check records for depreciation area? As i told earlier i am seeing records for Currency: EUR with deprciation area: 32 only. But i am not seeing the records in ODS for depreciation area: 01, 15, 17, 20, 30 and 31 which are having Currency as: SEK in T093B table.

Please advice.

[Former Member]

okay - so we are on the same page (sorry it took a while - my fault)

Are you running deltas?

Have you got any selection criteria in the delta infopackage

Have you run the data to the PSA? If so check the PSA for any records for those depreciation areas

Just humour me and make sure depreciation area is in the key of the ODS

[Former Member]

Check your selection in infopackage or if there're start routin in transfer or update rules that delete data.

The numbur of record loaded is the same of record added/modified in ODS?

Hope it helps.

Regards

[Former Member]

No, i am not running any delta's. Its a Full Update. I have given selection criterial as Company Code only. Its a strange to me that i observed both Currencies in PSA tables with the same company code. But they are not uploading in to ODS

[Former Member]

The currency is the by product - it's the Depreciation areas that are missing

What is they key to the ODS?

[Former Member]

AA does not support multiple currencies in R3 (remember the story goes AA was not built in house - but bought in from another german company)

If you need other currency types - then currency exchange on the fly or on update rules - but you run the chance of this not agreeing with the postings to the balance sheet

So... analyse the GL4 based cubes and look at the transaction types on the Balance Sheet accounts to get the records - and then use the LC2 key figures (if controlling area currency has been set up as Second Local in the Company Code master)

Unless anybody can think of something simpler