on 2008 Nov 12 11:35 AM
Hello All,
In SAP R/3 in tcode SE11 when I display data for table EKBE, for few currencies amount is different in tabular layout and display mode of individual record. Let me expalin it in detail.
In table EKBE when I display data for any particular purchase order then following values are displayed in tabular layout.
DMBTR 100.05
WRBTR 100.05
But when I select this record and click on display button(F2 function key)
DMBTR 100.05
WRBTR 10005
When I extract this data in BW I get
DMBTR 100.05
WRBTR 100.05
Can anybody please help me to understand
which value is correct ?
why is there a difference in amount in tabular layout and display mode ?
why only WRBTR is different as both are of CURR datatype and created using same Domain.
In ME80FN Amount is displayed as 10005 and user is expecting this in BW output, when I checked in R/3 table I found discrepancy. Your help is greatly appreciated.
Thanks for your help.
Regards
Shilpa
Data is held at the oracle level always with 2 decimal places
The currency table TCURX decides how to format the data
Example:
1000 HUF
is held in the base tables as 10.00
TCURX shows HUF as having zero decimal places
Some R3 table fields work this way and some dont - but this shoudl give you an idea of whats happening (ie dont trust the raw tables!!)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just to clarify - I would expect in your DSO and your cube to see 100.05
Then in your query I would expect to see 10005 with whatever currency is being used
Bex will also look up TCURX to display the data correctly (ie one of the reasons you should never hard code 2 decimal places in infoobjects)
In some version of BW it showed very weirdly - it converted to the correct figure but still put 2 decimals on - a workaroudn was to create a CKF on top of the raw key figure and multiple it by 1
Then for some reason it worked (ie originally in the query it showed 10005.00 and not 10005)!!
Hi Simon,
Thanks for your inputs.
Why the amount is changed in display mode only for WRBTR and not for DMBTR as both are of CURR datatype and created using same domain. I fail to understand any logic behind this.
I have even created a ABAP report on this table which displys fields DMBTR and WRBTR, and in the report output following values are displayed.
DMBTR 100.05
WRBTR 100.05
If anybody else has come across this before and has any clue please help.
Thanks and Regards
Shilpa
In the ABAP you have to use the write currency command and that reads the TCURRX table same as all the other ABAPS that read curr fields..
The F2 is incorrect - I dont know why - raise an OSS if you are that bothered about it
In the meantime just use the advice given - you still didnt reply on the values of the currency in TCURRX
User | Count |
---|---|
62 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.