SAP Reports / Programs

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







J_1SUPAL is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for You can use this program to compare the existing SAP dataset (postal codes, cities, assignments) with the postal code dataset file supplied by the PTT (PLZ_P1_datum...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter J_1SUPAL into the relevant SAP transactions such as SE38 or SE80


Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

J1SJ - IS-M: CH/S: Prepare PCode Data


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT J_1SUPAL. "Basic submit
SUBMIT J_1SUPAL AND RETURN. "Return to original report after report execution complete
SUBMIT J_1SUPAL VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


PTT Changes - Split Entire Postal Code File
Selection Text: VERWDAU = Spool Retention Period
Selection Text: SOFORT = Print Immediately?
Selection Text: PRINTER = Printer
Selection Text: PA_LAND = Country
Selection Text: LOESCHN = Delete After Output
Selection Text: DECKTXT = Cover Sheet Text
Selection Text: DECKBL = Cover Sheet?
Selection Text: ANZCOPY = No.of Copies
Title: IS-M/SD CH/S: Comparison/Conversion for Postal Code and Cities
Text Symbol: 039 = Upgrade from Postal Convs
Text Symbol: 040 = Upgrade from Dataset File
Text Symbol: 043 = Convert CH Postal Code:
Text Symbol: 044 = PCd Types
Text Symbol: 045 = 10 Home and PO Box Addresses
Text Symbol: 046 = 20 Home Addresses
Text Symbol: 047 = 30 PO Box Adds
Text Symbol: 048 = 40 Company Adds
Text Symbol: 049 = 80 Internal PCode
Text Symbol: 050 = Post.Convers.
Text Symbol: 051 = Stock File
Text Symbol: 902 = Print Control
Text Symbol: 903 = Name of Spool List
Text Symbol: 904 = No. of Printouts
Text Symbol: 905 = Printer
Text Symbol: 906 = Delete After Print
Text Symbol: 907 = Reten.Period
Text Symbol: 908 = Cover Sht
Text Symbol: 909 = Cover Sh.Text
Text Symbol: 910 = Print Imm.
Text Symbol: 911 = Print Cover Sheet
Text Symbol: 912 = Text on Cov.Sheet
Text Symbol: 913 = Lang.
Text Symbol: 038 = Conversion Proced.
Text Symbol: 001 = Comp/Cnv.PCd+City
Text Symbol: 002 = Comparison/Conv. for PCode + City
Text Symbol: 003 = Start Report Processing:
Text Symbol: 004 = Cannot read dataset





Text Symbol: 005 = Convert City Name:
Text Symbol: 006 = Convert PCd/City Assignment:
Text Symbol: 008 = PTT-SAP Dataset Comparison for City/PCd Using
Text Symbol: 009 = Number range object J_1S_ORT not found
Text Symbol: 010 = End Report Processing:
Text Symbol: 011 = Convert Postal Code:
Text Symbol: 013 = Error logging program
Text Symbol: 015 = City Comparison/Conv.
Text Symbol: 016 = New PTT Cities
Text Symbol: 017 = SAP Cities to be Termd
Text Symbol: 018 = Postal Code Comparison/Conversion
Text Symbol: 020 = New PTT Postal Codes:
Text Symbol: 021 = Convert Postal Code Category
Text Symbol: 022 = SAP PCodes to be Terminated:
Text Symbol: 023 = Compare/Convert PCode/City Assignments
Text Symbol: 024 = New PTT PCd/City Assignments:
Text Symbol: 025 = SAP PCd/City Assgts to be Terminated:
Text Symbol: 026 = Error in Insert J_1SPUPBESTAND
Text Symbol: 028 = Function
Text Symbol: 029 = Table
Text Symbol: 030 = City No.
Text Symbol: 031 = Old Ctry
Text Symbol: 032 = Old CityNo.
Text Symbol: 033 = Old PCd
Text Symbol: 034 = New Ctry
Text Symbol: 035 = New CityNo.
Text Symbol: 036 = New PCd
Text Symbol: 037 = Various Specs
001 CCode PCd New PCd Cat. NCat HD PO MC City New City CCC OldALORT NewALORT


INCLUDES used within this REPORT J_1SUPAL

INCLUDE MJNUMTOP.
INCLUDE MJSPOTOP.
INCLUDE MJO0FA02.


TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

ISP_SUCHFELD_PHONETISCHE_SUCHE CALL FUNCTION 'ISP_SUCHFELD_PHONETISCHE_SUCHE' EXPORTING art_ph_suche = con_art_ps_ort feldname = con_ort land1 = pa_land sortierfeld = w_pupbestand-ort_name_l IMPORTING suchfeld = w_pupbestand-suchfeldo.

NUMBER_GET_NEXT CALL FUNCTION 'NUMBER_GET_NEXT' EXPORTING nr_range_nr = nr_range_nr object = object IMPORTING number = w_alort returncode = rcode_nr.

FILE_GET_NAME





CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = inp_pfad IMPORTING file_name = dsetname EXCEPTIONS file_not_found = 01.

FILE_VALIDATE_NAME call function 'FILE_VALIDATE_NAME' exporting logical_filename = inp_pfad changing physical_filename = dsetname exceptions others = 4.

ISM_CONVERT_TO_NORMAL_FORM CALL FUNCTION 'ISM_CONVERT_TO_NORMAL_FORM' EXPORTING input = p_ortsabk IMPORTING output = p_ortnameg EXCEPTIONS OTHERS = 1.



Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name J_1SUPAL or its description.