SAP R/3 table data display

[Former Member]

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

[Former Member]

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!!)

[Former Member]

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)!!

[Former Member]

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

[Former Member]

Hello SAP Experts,

It would be really great if somebody can help to resolve the above query.

Thanks a lot for your help.

Regards

Shilpa

[Former Member]

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

[Former Member]

Thanks a lot for your inputs.

Regards

Shilpa