US Postal Code with 10 digits

[Former Member]

Hello Experts,

   I have an issue which i think you might experienced before. We have some one time customers created in the ERP system and their postal codes are in the format XXXXX-XXXX. The data is transferred to the TM system it is. I have two issues with this kind of postal code format.Our LTL Carrier selection is based on TCM rates maintained with the destination postal code range and we have uploaded the data subscribed from CZARLITE which is a 5 digit range. When we kick-off carrier selection it dumps and SAP says they can't support a hyphen. The next issue is when i manually enter a carrier into the freight order and start charge calculation it is not able to look up the value as we get a CX_SY_CONVERSION_NO_NUM exception. Any advise on how best we can handle this problem ?

Thanks,

Regards,

Yuvaraj

[former_member186731 · Accepted solution]

Well, first of all country specific checks including postal code format are activated under SAP NetWeaver->General settings->Set Countries->Set Country-Specific Checks.

If I understood it correctly your locations have a 10 character postal code (sounds like the transfer into the TM has been fine), but your rates are 5 digits. One idea would be to adjust the rates to 10 characters also. Second idea would be to modify the standard search code.

[Former Member · Accepted solution]

Hi Marcus,

   Thanks for the suggestion. I see the most appropriate way is to modify the standard search code because the 10 digit will vary based on the PO box number. Any hint on which spot ( either a Badi or enhancement spot) where I can modify the search?  Please advise.

Thanks,

Regards,

Yuvaraj

[Former Member · Accepted solution]

Hi Marcus,

  We found a solution for this issue. I thought it is worth sharing to everyone reading this post. We created a new calculation base copying the standard calculation base for postal code range. Also we copied the helper class /SCMTMS/CL_TCC_CB_LOC_PCRAN_01 configured for the standard calculation base into a new class starting with Z_*********. In the method get_location_data we coded with a logic saying that if the country code is US then consider only the first 5 digits and ignore the rest. We assigned this new class to the new calculation base that we configured and we used this calculation base for all the rate tables. Now it works fine.

Thank you very much for some useful advise.

Regards,

Yuvaraj

[Former Member · Accepted solution]

Thanks for sharing this Bala.

BR

narender