Output t-code itvcl

[Former Member]

Hi Guys,

I ve a Problem about the Italian Report " Spesometro " (ITVCL).

Executive with F8 the report, the value of  Base Amount and Tax Ammount are perfect. These s for all invoice of vendors.

When i want download the file on Subdirectory (hard disk) PC with RFASLDPC.

Opening the file in txt, the amounts are "truncated" or the decimals of amounts re rounded or excess or defect.

For example: An  invoice on SAP  is :           Base ammount 1,07            tax ammount 0,11

dowload the  file  is Base ammount  1            tax ammount: is null like if is 0 dont write the value

I think is no correct. especially for a tax ammount like null

Someone can help me? Or it s uppen that?

Kind regards

Sandro

[Former Member]

Why do you need to open this file in .txt format. Did you try to use xlm format. Now excel support this format.

Excel can now read and write xml files. An ABAP program can create an xml file and it can be opened directly into Excel.

The advantages and possibilities are endless:

• An xml file is plain text so can be created on the presentation server or application server;
• alternatively, it can be sent as an attachment to an email, or can be provided as a parameter to a web service;
• colours, fonts, number formats and so on can be specified;
• formatting can be applied to rows, columns or single cells;
• column heights and widths can be specified, or auto-formatted;
• multiple worksheets can be created;
• formulas can be entered in cells

Please confirm.

Thanks

Naseem

[Former Member]

Mr Nassem,

I ve download it in format txt, like the Note OSS 1816815. There 's a document Spesometro 2013 (EN)_update. This document explaine how  executive the ITVCL.
U can see it on pag. 7.

Kind Regards.

Alessandro