‎2010 Jan 15 10:15 PM
I created a Query on infoset which contains one table 'BSAK'. I used statistic list so I can just display summary of the field 'Amount in local currency' for given vendor and year/periods. However, I got message says 'Currency conversion error for statistic/ranked list'. The result seems ok. Data were correctly summed for each vendor.
Don't understand why since I only have USD in the table. SAP support does said note 41655 may help but do not want to provide more details. I read the note and still could not understand how to apply it. Any help would be appreciated. Thanks!
‎2010 Jan 16 3:27 PM
Hi Rick,
you are right, this note can not be applied, ist can just be read and understood.
Please check your infoset: For every Currency field you should also have the respective Curfrency key CUKY field in the infoset.
If the system can not determine the curreny for an amount it does not know if a conversion to the respective company code local currency is required. That'as why a conversion error is reported.
You may check in debugger, what is passed to function module 'CONVERT_TO_LOCAL_CURRENCY'.
Note 41655 just says that amounts and quantities are always connected to a currency or a unit. You can check in dictionary what is the respective reference field of BSAK .
All currency key fields must be present in the infoset:
Field RefTab RefField
DMBTR T001 WAERS
WRBTR BSAK WAERS
MWSTS T001 WAERS
WMWST BSAK WAERS
BDIFF T001 WAERS
BDIF2 BKPF HWAE2
SKFBT BSAK WAERS
SKNTO T001 WAERS
WSKTO BSAK WAERS
DMBT1 T001 WAERS
WRBT1 BSAK WAERS
DMBT2 T001 WAERS
WRBT2 BSAK WAERS
DMBT3 T001 WAERS
WRBT3 BSAK WAERS
QSSHB BSAK WAERS
QBSHB BSAK WAERS
QSFBT BKPF WAERS
DMBE2 BKPF HWAE2
DMBE3 BKPF HWAE3
DMB21 BKPF HWAE2
DMB22 BKPF HWAE2
DMB23 BKPF HWAE2
DMB31 BKPF HWAE3
DMB32 BKPF HWAE3
DMB33 BKPF HWAE3
MWST2 BKPF HWAE2
MWST3 BKPF HWAE3
SKNT2 BKPF HWAE2
SKNT3 BKPF HWAE3
BDIF3 BKPF HWAE3
KZBTR T001 WAERS
PSWBT BSAK PSWSL
PYAMT BSAK PYCUR
PPDIFF T001 WAERS
PPDIF2 BKPF HWAE2
PPDIF3 BKPF HWAE3
PENLC1 BKPF HWAER
PENLC2 BKPF HWAE2
PENLC3 BKPF HWAE3
PENFC BKPF HWAERIn you case, T001-WAERS and BKPF-HWAE2, BKPF-HWAE3 probably can not be determined.
Regards,
Clemens
‎2010 Jan 16 1:33 PM
Hi Rick,
OSS notes can be implemented using the NOTE ASSISTANT (transaction SNOTE). You first have to download the OSS note within this transaction and then you can implement the OSS note automatically. Some OSS notes contain additional manual steps, which have to be done before or after the implementation. So read the note carefully and check whether the note fits to your release and patch level.
BR, Helmut
‎2010 Jan 16 3:27 PM
Hi Rick,
you are right, this note can not be applied, ist can just be read and understood.
Please check your infoset: For every Currency field you should also have the respective Curfrency key CUKY field in the infoset.
If the system can not determine the curreny for an amount it does not know if a conversion to the respective company code local currency is required. That'as why a conversion error is reported.
You may check in debugger, what is passed to function module 'CONVERT_TO_LOCAL_CURRENCY'.
Note 41655 just says that amounts and quantities are always connected to a currency or a unit. You can check in dictionary what is the respective reference field of BSAK .
All currency key fields must be present in the infoset:
Field RefTab RefField
DMBTR T001 WAERS
WRBTR BSAK WAERS
MWSTS T001 WAERS
WMWST BSAK WAERS
BDIFF T001 WAERS
BDIF2 BKPF HWAE2
SKFBT BSAK WAERS
SKNTO T001 WAERS
WSKTO BSAK WAERS
DMBT1 T001 WAERS
WRBT1 BSAK WAERS
DMBT2 T001 WAERS
WRBT2 BSAK WAERS
DMBT3 T001 WAERS
WRBT3 BSAK WAERS
QSSHB BSAK WAERS
QBSHB BSAK WAERS
QSFBT BKPF WAERS
DMBE2 BKPF HWAE2
DMBE3 BKPF HWAE3
DMB21 BKPF HWAE2
DMB22 BKPF HWAE2
DMB23 BKPF HWAE2
DMB31 BKPF HWAE3
DMB32 BKPF HWAE3
DMB33 BKPF HWAE3
MWST2 BKPF HWAE2
MWST3 BKPF HWAE3
SKNT2 BKPF HWAE2
SKNT3 BKPF HWAE3
BDIF3 BKPF HWAE3
KZBTR T001 WAERS
PSWBT BSAK PSWSL
PYAMT BSAK PYCUR
PPDIFF T001 WAERS
PPDIF2 BKPF HWAE2
PPDIF3 BKPF HWAE3
PENLC1 BKPF HWAER
PENLC2 BKPF HWAE2
PENLC3 BKPF HWAE3
PENFC BKPF HWAERIn you case, T001-WAERS and BKPF-HWAE2, BKPF-HWAE3 probably can not be determined.
Regards,
Clemens
‎2010 Jan 19 8:31 PM
Hi Clemens,
You are life saver for me. Yes, by adding T001 to the infoset solved my problem! Thank you so much!!!
Regards,
Rick