Ansicht
Dokumentation

RPR_UPDATE_COMCODENR_FROM_FILE - Community Code Numbers: Update from File

CL_GUI_FRONTEND_SERVICES - Frontend Services   General Data in Customer Master  
This documentation is copyright by SAP AG.

Purpose

Report for uploading Austrian community code numbers to table T706_CITY_CD_D.

Integration

You can look up community code number data for Austrian towns and cities on the Statistics Austria website at www.statistik.at/web_de/statistiken/regionales/regionale_gliederungen/Ortschaften/index.html

Download the table called "Ortschaften sortiert nach Gemeindekennziffer mit Postleitzahlen" (towns sorted by community code numbers with postal codes) 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_gemeindekennziffer_mit_postleitzahlen_csv_ca._90_022963.csv )

SAP AG cannot accept any responsibility for errors or omissions in the data. Customers are responsible for processing and maintaining enterprise-specific data - for example, by maintaining view V_T706_CITY_CODE.

Prerequisites

Features

This program enables you to upload the community code numbers and other data regarding Austrian communities and towns into the table T706_CITY_CD_D of your SAP system.

After uploading the data, you can adjust it using maintenance view V_T706_CITY_CODE.

Selection

"Scope of Validity"

Input field "Trip Provision Variant"

Trip provision variant for which entries in table T706_CITY_CD_D are processed. The program leaves entries of other trip provision variants unchanged.

"Program Parameters"

Radio button "Rebuild Database"

This option completely deletes existing entries in the scope of validity of 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 the scope of validity in table T706_CITY_CD_D, and displays an overview of the entries to be deleted, changed, and inserted. In the overview, you can then choose which changes are to be performed in the database. This enables you to retain your own or your modified entries; plus you can perform the updates selectively.

Radio button "Fill City in Uppercase"

This option fills the columns for "City in Uppercase" and "District in Uppercase" for existing entries in table T706_CITY_CD_D. These columns contain the same entries as in the city and district columns but the entries have been converted into uppercase letters. Since these columns were created as part of an enhancement, they may initially be empty. However, the new non-case-sensitive search can only work if these columns are filled.

Checkbox "Simulation"

If you select this option (default setting), the upload of the selected files will only be simulated, which means the data will not actually be transferred to the database.

Checkbox "Transport Connection"

This option lets you automatically record the changes using a transport request, and transports these changes to your other systems. Choose the "Transport Connection" option when executing the program without activating simulation mode.

Standard Variants

Output

The program changes the data in table T706_CITY_CD_D according to your selection. Once the program has run successfully, it displays an overview of changes made in the table.

Activities

Run the program in simulation mode first, and specify the .CSV file you downloaded earlier. If no problems occur in simulation mode, run the program again without activating simulation mode.

Example

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 4294 Date: 20240601 Time: 061355     sap01-206 ( 77 ms )