CCD File Format for inflated currencies

[prakhar_prakash]

Hi Team,

Can you please let me know on how we can handle amounts with digits greater than 8 places after the decimal in CCD file. We have a situation wherein employee has incurred transaction in VND currency wherein amounts exceeds 8 places (Eg. 269480855 VND), bank too has supplied the file in the transaction currency and transaction amounts (with the local currency conversion as applicable).

On converting the file in standard CCD format we are restricted to 8 places (after decimal) , consequently one digit is truncated.

Please let us know whether SAP has an extended structure for CCD format to handle the inflated currencies.

Kindly guide on how to handle this,

Thanks,

Prakhar

[former_member131723]

Hi Prakhar

With the note 1712292 and the constant NORND maintained in table V_T706S_CONST and with this class that is delivered (CL_FITV_CCC_ROUNDING) as well as the notes 1766030 and 1806736 the local currency amounts can be accurately controlled but the other option is also the BAdI FITV_REP_CCC.  (Basically the bigger problem is that TCURR has some technical restrictions on the amount of decimals that can be entered)

Take a look at this wiki page for more info too:

http://wiki.sdn.sap.com/wiki/x/5onuDQ

cheers

Sally

[Former Member]

Hi Prakhar,

This should be possible in the standard CCD format because the amount in purchasing currency can be up to 10 digits.  The number of decimal places which are used is then determined by the number in position 116.  Normally this is set to 2 for 2 decimal places which would give you 8 numbers before the decimal and 2 after.  For example: 12345678.99.

Please try this out and let me know how you get on.  A good way to test is to use tcode PRCCT to generate test files and then manually change the entries in the file before loading with PRCC.

Cheers,

Jack