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
Below is a list of transaction codes which are relevant to this SAP report
J1SJ - IS-M: CH/S: Prepare PCode Data
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.
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
INCLUDE MJNUMTOP.
INCLUDE MJSPOTOP.
INCLUDE MJO0FA02.
No SAP DATABASE tables are accessed within this REPORT code!
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.
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.
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.
J_1SUPAL - IS-M/SD CH/S: Comparison/Conversion for Postal Code and Cities J_1SUPAL - IS-M/SD CH/S: Comparison/Conversion for Postal Code and Cities J_1SUORT - IS-M/SD CH/S: Change Program for Cities J_1SUORT - IS-M/SD CH/S: Change Program for Cities J_1SUFIL - IS-M/SD CH/S: Create Data File on UNIX J_1SUFIL - IS-M/SD CH/S: Create Data File on UNIX