Trying to find the country code table

[RogerB]

Hi, I am using ODBC to create a specific export file. In the PRODDTA_F0116 table is a 3 digit country code field (ALCTR). I am trying to find the lookup table to link it too to get the full Country Name. Does someone know if I can link to this table. Many thanks . Roger

 

[newjdedev1]

Hi Roger, country codes are stored in UDC table. You can find country codes in F0005 where DRSY = '00' and DRRT = 'CN' and DRKY = Your 3 character code (ALCTR).

 

[crs37]

The full country name is stored in UDC 00/CN. Therefore, the table that contains the full country name, in your case, would be PRODCTL.F0005

 

[Frosty the Coder]

It's a UDC.
I think 00/CN, maybe 01/CN.
Look at the data dictionary for CTR to find out.

 

[RogerB]

Thanks for the help especially newjdedev1 thats just what I needed - as a side note the DRKY field is 10 characters so you need to left pad with 7 spaces when doing a comparison.

 

[Zoltan_Gyimesi]

Hi Roger,

You can not link these tables based on F0116.CTR = F0005.KY - at least in JDE BSVW.

The main problem is that F0116.CTR is 3 char long, while KY is 10 char long and the values are left padded with spaces to 10 char in F0005 table.

Regards,

Zoltán