topic Re: Zip Codes in SAP in Application Development and Automation Discussions

Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 19:54:55 GMT

Hi,

I have solved the problem where in the incoming flat file has no value for zip code... now my program picks up the country checks the postal length & insert that many no. of zero's & my record is able to go in SAP... but it failing for countries like Poland where the length is 6 but in the 3rd place it asks for a "-" other e.g. is US where the postal code length is 10 ... my prg put is '0000000000' ... but the record fails & asks for a "-" in 6th place... where in SAP can I get this info? which table does it store that for US in the 6th place a "-" should come ??....

Can anybody help me in this ??

Thank You,

SB.

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 19:56:56 GMT

Hi ,

I have given the answer in the previous postings..

Any ways.check for the table T005 & field PRPLZ.It has definitions for the type of postal code.It doesnt specify regarding the '-' used in the postal codes,but tells you whether the postal code for any country is purely numeric or any character can be used or not.

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 19:59:19 GMT

Hi SB,

Try table T005 and T005T.

Hope this will help.

Regards,

Ferry Lianto

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 20:07:34 GMT

Ok Phani PRPLZ rule 9 may be applicable for me ... "Check against country specific edit format" ... but how do I use it in my logic saying if country is PL then in 3rd place put a "-" ??.... if country is US then "-" in 6th place...

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 20:16:48 GMT

Hi ,

For that purpose use FM ADDR_POSTAL_CODE_CHECK.

Enter the Country & postal code.IF you enter any other character than '-',it will give you error saying the 6th character should be '-'.

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 20:19:25 GMT

Look at function module ADDR_POSTAL_CODE_CHECK. In there it checks for each postal country in a CASE statement. You can make your postal code to follow that format.

Search for 'CASE t005-landk' in there.

Srinivas

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 21:13:26 GMT

Hi Sri...

Currently this is what my code doing

Zip code length (check if street is not blank & zip code is blank)

IF T_INPUTFILE196(35) <> '/' AND T_INPUTFILE276(10) = '/'.

READ TABLE T_POSTCODE WITH KEY LAND1 = T_INPUTFILE+331(3).

IF SY-SUBRC = 0.

V_CTR = T_POSTCODE-LNPLZ.

ENDIF.

V_CTR = V_CTR - 1.

DO V_CTR TIMES.

CONCATENATE V_PC '0' INTO V_PC.

ENDDO.

condense v_pc no-gaps.

MOVE V_PC TO T_INPUTFILE+276(10).

So how do I use the FM that u have just suggested??

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 21:21:21 GMT

I cannot tell much from this code as I don't know the definitions of the variables or how they are filled in, but what I told earlier is to look at that function module at the line mentioned. See how the checks are made and may be based on that you will come up with a common logic to format the postal code.

The function module checks the given postal code for valid format, but not the reverse way. It will not build the postal code for you.

How is your input? Please give an example of how the input postal code will be and how you want that to be converted.

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 21:30:55 GMT

Well in my case if street values is coming from the inputfile & the zip code value is blank , then according to the configuration set here the vendor will not be updated in SAP ... the business wants this to be handled logically ... So currently my code picks up the LAND1 value checks the postal length and put that many number of zero's in the place where zipcode comes from the inputfile... my prg is failing where country like PL (poland) or KR (Korea) is coming ... now the error coming is "The postal code should have "-" in the 3rd place" (this error for PL) ... for KR The postal code should have "-" in the 4th place" ...

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 21:32:47 GMT

If you look at the code between CASE and ENDCASE, you will understand what format each country is following. It gets little complicated with some coutries where it is just using some routine to check instead of a format. But here are the ones that do have a format.


    CASE t005-landk.      " T005 <-> postal_address-country !!
      WHEN 'CDN'.
        postal_codemask = 'ANA NAN   '.
      WHEN 'NL '.
        postal_codemask = 'NNNN BB   '.
      WHEN 'PL '.
        postal_codemask = 'NN-NNN    '.
      WHEN 'S  '.
        postal_codemask = 'NNN NN    '.
      WHEN 'ROK'.
        postal_codemask = 'NNN-NNN   '.
      WHEN 'SK '.
        postal_codemask = 'NNN NN    '.
      WHEN 'CZ '.
        postal_codemask = 'NNN NN    '.

I know that N is for numeric and A is for Alpha but I don't know what B stands for in the Netherland format.

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 21:43:50 GMT

Actually the '-' is not important as long as you follow the length restrictions and the rule. The fields that are important in this are T005-LNPLZ and T005-PRPLZ. As long as you follow those rules, you should be fin.

For instance, for US it can be just 5 or 9 or 5-4. Any of these values will pass the test. Simlarly you need to find out all the combinations for each country. I don't think there is any easy way to format except hardcoding for each country.

Re: Zip Codes in SAP

Former Member — Thu, 23 Feb 2006 22:10:19 GMT

ANd how do I bring the effect of field PRPLZ in my code ??

Re: Zip Codes in SAP

Former Member — Tue, 24 Oct 2006 22:02:48 GMT

Has anyone run across any documentation that outlines all the various rules by country?

Re: Zip Codes in SAP

nils_buerckel — Fri, 15 Nov 2013 09:25:27 GMT

Hi,

see http://en.wikipedia.org/wiki/List_of_postal_codes

Best regards,

Nils Buerckel