Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member204860
Active Participant

                Postal code is a unique data more helpful to track any address.     But in customer / vendor Master data often either  user skips this fields or fill something irrelevant if it supposed to be mandatory.     To create a validation rule for postal code I suggest a simple solution which an ABAPER can do without much effort.

                The first 2 digit of the postal code represents the State as given below :

  First 2
  Digits of PIN

  Circle

  11

  Delhi 

  12 and 13

  Haryana

  14 to 16

  Punjab

  17

  Himachal Pradesh

  18 to 19

  Jammu & Kashmir

  20 to 28

  Uttar Pradesh and Uttaranchal

  30 to 34

  Rajasthan

  36 to 39

  Gujarat

  40 to 44

  Maharashtra

  45 to 49

  Madhya Pradesh and Chattisgarh

  50 to 53

  Andhra Pradesh

  56 to 59

  Karnataka

  60 to 64

  Tamil Nadu

  67 to 69

  Kerala

  70 to 74

  West Bengal

  75 to 77

  Orissa

  78

  Assam

  79

  North Eastern

  80 to 85

  Bihar and Jharkand

  90 to 99

  Army Postal Service (APS)

Except 90- 99  all the ranges are possible values in postal code.    The “ Region”  field is used to capture the State.    The Pincode already entered by user can be verified by the Region selected by the user . 
For example  

First 2 digit of Pincode 60,61,62,63,64  are possible values for Region = 22  ( ie. Tamilnadu )

This simple validation will be more useful even though not cent percent accuracy to some extent validate the data entered.  

I invite all to improve the validation further towards more accuracy.

Selvakumar.N

Labels in this area