topic Re: Mismatch between data sent from print program and SAP script. in Application Development and Automation Discussions

Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 11:02:45 GMT

Hello Experts,

I have an issue in which the value of wrbtr (which is being fetched from BSEG table in print program) is getting changed when read in SAP script. The value which is being fetched is 10000.00 and when it reaches sap script it becomes 1.000.000. I debugged and didn't find any code to change the value from 10000.00 to 1.000.000 and when i changed the value to a random value say 8765433.00 in print program then in sap script it is being read as 876.543.300. I am not getting what is making this value to change. Only similarity between these values is total number of digits.

Thank,

Aparajita.

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 11:22:06 GMT

Hi Aparajita,

From the thing you explained it seems that difference is due to the currency conversion. May be your document contains the wrbtr in some other currency and due to this you are getting this result.So do a check on this and do paste a screenshot for us to understand better.

Regards

Nav

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 11:33:43 GMT

hi Aparajita,

This may be due to Currency settings in User profile.

You can check this at Main menu -> system settings...here, just see the current decimal notation maintained, accordingly the conversion is happening.

Change the required selection here and check your print.

Regards,

Suren.

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 11:37:07 GMT

Also, the fact that there is 3 dp's seems to suggest that the field is being written without a reference field containing the currency or that it is being written (by a WRITE statement) without a CURRENCY clause.

Regards,

Rich

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 11:38:51 GMT

Check table TCURX you will get a list of decimal places for currencies of different countries .

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 11:45:35 GMT

mostly this happens when moving values between field of different types.

also check conversion.

what is the output command in the sapscript text?

regards

Stefan Seeburger

Re: Mismatch between data sent from print program and SAP script.

RaymondGiuseppi — Tue, 25 Aug 2015 12:01:16 GMT

Is the currency field associated in ddic (e.g. T001-WAERS, BKPF-WAERS or BKPF-HWAER) available in the SAPscript form ?

Regards,

Raymond

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 13:01:33 GMT

Hello everyone,

Thanks for the responses. I am still looking for the cause. Some more input from my side.Here wrbtr (se11) is 10.000,00

but when I select one record and display it, it appears as 1.000.000. Very strange

Thanks,

Aparajita.

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 13:06:36 GMT

Looks the same to me.

Re: Mismatch between data sent from print program and SAP script.

JL23 — Tue, 25 Aug 2015 13:15:19 GMT

This is a stone old problem.

The currency JPY does not have any decimals, nevertheless it is stored with decimals in the tables, as the field has 2 decimals by definition.

Have a look into OSS note 1176399 , its has a table with examples

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 13:24:25 GMT

For me it is working as expected since the currency is JPY as already explained by Jürgen L

Check the FI doc via FB03 / Any standard transaction and I am sure you will get the same result.

Re: Mismatch between data sent from print program and SAP script.

RaymondGiuseppi — Tue, 25 Aug 2015 13:28:51 GMT

In SE16/SE16N

WRBTR is associated to BKPF-WAERS, not available, so displayed with default values of most currencies (2 decimals)
PSWBT is associated to BSEG-PSWSL, available, so displayed without decimal (JPY, check table TCURX)

Hint: Better look with FB03 or another FI transaction as FBL3N.

Regards,

Raymond

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 14:24:36 GMT

Hi Jurgen,

Thanks for your response. Do you mean that, this may be the cause of my problem? And there is problem in standard code?

Aparajita

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 14:25:36 GMT

Sorry my mistake, m refering to pswbt

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 14:27:08 GMT

Hello raymond,

Doess it means, what is appearing in se16n shouldn't impact the my output of sapscript?

Aparajita.

Re: Mismatch between data sent from print program and SAP script.

JL23 — Tue, 25 Aug 2015 14:30:50 GMT

No there is not a problem in standard code, the problem is that the person who is looking into the table with a table browser has trouble to understand the SAP design. SAP is using conversion routines according to the currency decimals to display it right in any functional transaction. This is not the case in SE16, as this is not an end user transaction, here you are supposed to see the values how they are stored in the table.

Re: Mismatch between data sent from print program and SAP script.

Former Member — Tue, 25 Aug 2015 14:34:55 GMT

Ok. Still the earlier problem is unresolved. Why is there a difference between wrbtr value in pp and sap script for jpy but no problem exists for usd.

Re: Mismatch between data sent from print program and SAP script.

JL23 — Tue, 25 Aug 2015 14:41:08 GMT

Because JPY has 2 decimals in the table and 0 in the reality and hence on the documents.

and USD has 2 decimals in the table and 2 decimals in reality.

Just remove the decimal delimiter from your mind when reading a JPY value in a table and everything is in order, isn't it?

Re: Mismatch between data sent from print program and SAP script.

RaymondGiuseppi — Tue, 25 Aug 2015 14:44:08 GMT

SE16/SE16N are only developpert/support tool, there are not intended to replace an actual display transaction, so as already written try FB03 on document.

Hint: Try some search at help.sap.com with keywords: SAPscript Fields Currencies Quantities

Regards,

Raymond

Re: Mismatch between data sent from print program and SAP script.

Former Member — Wed, 26 Aug 2015 04:06:44 GMT

Hi Aparajita,

As explained by everyone here you are having 5 decimal places in the currency so if you want to get it upto 2 decimal places then multiply it by 1000.

Regards

Nav