SAP Program RPR_UPDATE_COMCODENR_FROM_FILE - Community Code Numbers: Update from File

Purpose
Report program for uploading Austrian community code numbers to tableT706_CITY_CD_D.

Integration
You can look up community code number data for Austrian towns and citieson the Statistics Austria website at www.statistik.at/web_de/statis
tiken/regionales/regionale_gliederungen/Ortschaften/index.html
Download the table called "Ortschaften sortiert nach Gemeindekennziffermit Postleitzahlen" (towns sorted by community code numbers with postalcodes) in the following format:

  • Komma-separierte Werte (comma-separated values), CSV ca. 900KB (current
    • link: http://www.statistik.at/web_de/static/ortschaften_sortiert_nach_ge
    meindekennziffer_mit_postleitzahlen_csv_ca._90_022963.csv )
    SAP AG cannot accept any responsibility for errors or omissions in thedata. Customers are responsible for processing and maintainingenterprise-specific data - for example, by maintaining viewV_T706_CITY_CODE.

    Features
    This program enables you to upload the community code numbers and otherdata regarding Austrian communities and towns into the tableT706_CITY_CD_D of your SAP system.
    After uploading the data, you can adjust it using maintenance viewV_T706_CITY_CODE.

    Selection
    "Scope of Validity"
    Input field "Trip Provision Variant"
    Trip provision variant for which entries in table T706_CITY_CD_D areprocessed. The program leaves entries of other trip provision variantsunchanged.
    "Program Parameters"
    Radio button "Rebuild Database"
    This option completely deletes existing entries in the scope of validityof table T706_CITY_CD_D, and inserts new entries from the uploaded file.
    You also need to specify the date from which the entries are to be valid(for example, starting on January 1, 2008).
    Radio button "Reconcile Database (Delta)"
    This option first compares the uploaded data with the entries within thescope of validity in table T706_CITY_CD_D, and displays an overview ofthe entries to be deleted, changed, and inserted. In the overview youthen can choose which changes are to be performed in the database. Thisenables you to retain your own, or your modified, entries; plus you canperform the updates selectively.
    Checkbox "Simulation"
    If you select this option (default setting), the upload of the selectedfiles will only be simulated, which means the data will not actually betransferred to the database.
    Checkbox "Transport Connection"
    This option lets you automatically record the changes using a transportrequest, and transports these changes to your other systems. Choose the"Transport Connection" option if you execute the program withoutactivating simulation mode.

    Output
    The program changes the data in table T706_CITY_CD_D according to yourselection. When the run is successful, the program lists an overview ofchanges made in the table.

    Activities
    Run the program in simulation mode first, and specify the .CSV file youdownloaded earlier. If the simulation is successful, run the programagain without activating simulation mode.