Programme SAP J_1SUPAL - IS-M/SD CH/S: Comparison/Conversion for Postal Code and Cities

Purpose
You can use this program to compare the existing SAP dataset (postalcodes, cities, assignments) with the postal code dataset file suppliedby the PTT (PLZ_P1_datum.txt) or to process the postal code conversionfile supplied by the PTT (PLZ_P1UP_datum.txt).
The differences or formatted conversions identified are listed togetherwith the following information in table J_1SPUPBESTAND:

  • Postal unit affected (POSTAL CODE, CITIES, POSTAL CODE/CITY)

  • Types of differences/conversions found (function = 1, 2A, 2B, 2C, 2D, 3)

  • Information on the differences/conversions (for example, old postal code
  • and new postal code)

    Integration
    Please adhere to the processing sequence (reports, maintenance views).
    PTT Conversion Processing
    1) J_1SNFIL (create temporary file)
    2) J_1SUPAL (dataset comparison/conversion for postal code/cityassignments)
    3) J_1SVPUPBESTAND (maintenance view for result of postal code/citycomparison)
    4) J_1SUPLZ (format UPDA records for postal code/city assignments)
    5) J_1SUBAL (dataset comparison for streets)
    6) J_1SUSTR (format UPDA records for streets)
    7) J_1SVSUPBESTAND (maintenance view for result of street comparison)
    8) POSTÄNDERUNGSDIENST (process change number)
    9) J_1SUBOT (carrier data upgrade)

    Prerequisites
    The assignment between the logical and physical paths must bemaintained:
    Physical path: ISP_PTT_ALL
    Logical path: ISP_PTT_ALL
    The following logical file names must be maintained:
    ISP_PTT_ORT_DAT (Temporary city file)
    ISP_PTT_PLZ_DAT (Temporary postal code file)
    ISP_PTT_STR_DAT (Temporary street file)
    ISP_PTT_BOT_DAT (Temporary carrier file)
    Please note: The physical file name depends on the settings for thelogical files.
    Tables:
    Table J_1SPUPBESTAND must be empty.
    Open change numbers:
    There should not be any open changes in tables JSTPLZUPDA, JSTPLOUPDA,JSTORTUPDA, and JSPLZZUOUPDA.
    Temporary files:
    You should have run program J_1SNFIL (create temporary file) with thePTT dataset files or the PTT conversion files.
    Program J_1SUPAL can be restarted if the requirements are met.

    Selection
    Country
    Country for which the comparison/conversion is to be carried out(default = 'CH').
    Upgrade from postal conversions:
    The PTT conversion file (PLZ_P1UP_datum.txt) is processed using theconversion code. The formatted changes are written to tableJ_1SPUPBESTAND.
    Please ensure that conversion processing is sequential (dataset:May 2002, conversion: June 2002, July 2002, August 2002 and soon).
    Upgrade from dataset file:
    The PTT dataset file (PLZ_P1_datum.txt) is compared with the SAP tables(JSTORTPRO, JSTPLZPRO, JSTPLZORT, J_1SPLZZUO). Differences identifiedare written to table J_1SPUPBESTAND. Dataset comparisons must be carriedoutusing PTT files that are more up to date than the SAP dataset.
    Postal code categories (PTT classification):
    10 Home and PO box addresses
    20 Home addresses
    30 PO box addresses
    40 Company addresses
    80 Internal postal codes for postal service
    Printer controls:
    Various settings for log output.
    Caution: Please ensure that you select the same postal codecategories as you selected for program J_1SNFIL.

    Input
    Temporary postal code file:
    ISP_PTT_PLZ_DAT.
    SAP city file:
    JSTORTPRO.
    SAP postal code tables:
    JSTPLZPRO
    JSTPLZORT
    J_1SPLZZUO

    Output
    Log (SPOOL):
    Information on the number of differences/conversions processed.
    Results table from dataset comparison/conversion for postal code andcity:
    The differences/conversions processed are listed in table J_1SPUPBESTANDusing the following function codes:

    • 1 = New PTT record

    • 2A = Postal code conversion (postal code is replaced with a new postal
    • code)
      • 2B = Conversion postal code category (change of postal code usage)

      • 2C = Conversion of city text

      • 2D = Conversion of CH postal code data (home delivery postal code, home
      • delivery city, etc.)
        • 3 = Delete record and transfer to existing record if applicable
        • Activities
          1) Check whether the requirements are met
          2) Enter selection criteria on selection screen
          3) Execute program
          4) Check log
          5) Check table J_1SPUPBESTAND and make manual corrections if necessary