Kontakt

Ansicht
Dokumentation

RPUCMNI0 - HR-IT: Load external file to fill the towns table T5ITM4

RPUCMNI0 - HR-IT: Load external file to fill the towns table T5ITM4

PERFORM Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.
SAP E-Book

Description

HR-IT: RPUCMNI0 Report.

Update of the municipality table from ASCII external file.

It allows loading the list of the Italian municipalities from an external file and it carries out an automatic upload of the above-mentioned tables.

T5ITM4,T5ITM5,T5ITMX, T5ITMW, T5ITM6 and T5ITMA tables are managed by this report.

Requirements

Detailed list of the Italian municipalities with the official codes for the tax payer's reference number calculation (cadastral codes).

Example: Rome = H501.

This list can be displayed on the official site of the Finance Ministry (http://www.finanze.it/comuniaddirpef.htm) and it should be adapted according to the following structure:

  1. the first field (Input file - ASCII) should be filled in with the full name of the external file. A F4 Help (search help)is available. It opens a window wherein the external file can be saved; the file should be in ASCII format and comply with some rules in order to be correctly read by the program. The file can be created with Excel as follows:
    1. Create an Excel files with the names of all municipalities
    2. Order columns as follows:
      1st column: descriptions of municipalities (field T5ITM4-TXMUN)
      2nd column: descriptions of the municipality provinces
      (field T5ITM4-BLAND)
      3rd column: descriptions of the municipality cadastral codes (field T5ITM4-MUNICCDFS)
      4th column: descriptions of the (univocal) codes of municipalities (field T5ITM4-MUNIC)
      5th column: descriptions of the municipality regions
      (field T5ITM4-REGIO)
      6th column: descriptions of the codes of municipalities for the F24 form (field T5ITM4-MUNICF24)
      7th column: description of the municipal tax (field T5ITM5-CDTMU)
      8th column: description of the names of municipal taxes (field T5ITMW-TXTMU)
      9th column: description of the code of the taxation formula (field T5ITM6-CDFTA).
  • ALL the above-mentioned information is required; for each municipality ONLY one code should be mentioned.

  • DO NOT add any heading to the file as comments for column titles.

  • Save the Excel file in .csv format on the hard disk. The created file will be an ASCII file using the ";" as column separator. This format can be automatically obtained from an Excel file saving it as a .csv file. In this way the Excel file (binary system) will be changed into an ASCII system if a ";" is entered after each value.

  • This file is ready to be loaded by the program.

  1. Validity from date and validity to date fields: enter the default
  2. values.
    NOTE: the program does not automatically delimit the validity period.
    The delimitation of the validity period for each record on the
    table should be carried out manually.
  3. "Delete existing values"/"Only change" pushbutton: If the existing values are deleted, the values that have been already entered into tables T5ITM4 and T5ITM5 are deleted and replaced with the new ones; if the "Only change" option is selected, the existing values which are not deleted are updated.
  4. "Input for transport" indicator: The entries are saved into a transport proposal.
  5. "Only test" indicator: the running of the test to check the consistency of the entered values excluding the presence of double keys in the input file is recommended. The test produces a list with results: If the output is the list of municipalities without error messages, the update without test can be carried out.

Output

List of municipalities loaded from files

Update of the list of municipalities

The report can be run in "test" mode and the list of results will be entered into the T5ITM4 table after the program has checked the consistency of values and the uniqueness of keys in the input file. In this case no change is carried out.

If the output is the list of municipalities without error messages, the update can be carried out without test.

If the "test" mode is not selected, the database is updated and the new list of results is displayed.

Example

If the program is run and the following data is given as an input, 2 new results are obtained:

  • ROMA;RM;H501;00100;LAZ;99

  • MILANO;MI;F205;20100;LOM;88

NOTE: do not change the input data sequence.

If an entry with the same zip code (ex.: 00100 or 20100) and validity to date already exists, this entry is overwritten.






PERFORM Short Reference   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 5101 Date: 20240601 Time: 103331     sap01-206 ( 70 ms )