Background documentationCountry Table T005

 

Country Key (T005-LAND1)

Values that are used to check entries are defined in the country key.

Example Example

Length of postal code or bank account number.

End of the example.

The two-character ISO code proposed by SAP is normally used as the country key.

Caution Caution

Since the definition can vary depending on the customer installation, it is not possible to use the country key for programming in SAP standard programs. If a specific country is to be queried in the program, the ISO code T005-INTCA should be queried instead.

End of the caution.

Note Note

Customers are advised to maintain the ISO code field and, if possible, also the vehicle country key for each country because these fields are queried by programs.

End of the note.

The country keys are defined in the global settings during system implementation. The parameters listed below are dependent on the country key.

Length of postal code (T005-LNPLZ)

The maximum permitted length of a postal code is defined here for the country key.

Rule for the postal code check (T005-PRPLZ)

This key defines how the check of the Postal code field is to be carried out.

Predefined checks are triggered for values from 1 to 8. The entry is checked for numerical content, length and gaps. The following variations are possible:

Value

Description

1

Maximum value length, without gaps

2

Maximum value length, numerical, without gaps

3

Length to be kept to exactly, without gaps

4

Length to be kept to exactly, numerical, without gaps

5

Maximum value length

6

Maximum value length, numerical

7

Length to be kept to exactly

8

Length to be kept to exactly, numerical

Note Note

These checks of the content of the Postal code field are only carried out if the field is not empty.

End of the note.

A country-specific special check is activated by the key 9. The entry is checked against a template defined in the system. Templates are currently defined for Canada, the Netherlands, Poland, Sweden, Slovakia, the Czech Republic, South Korea, and Portugal (A = letter, N = number):

Canada

ANA NAN

Netherlands

NNNN AA

Poland

NN-NNN

Sweden, Slovakia, the Czech Republic

NNN NN

South Korea

NNN-NNN

Portugal

NNNN-NNN or NNNN

Note Note

USA: It is checked, independently of check rule '9', whether the postal code number of an address in the USA has the format NNNNN or NNNNN-NNNN (ZIP + 4).

End of the note.

With the check rule, you can determine, for example, whether the length is to be adhered to exactly or whether it is a maximum length. You can also determine whether numeric characters only are allowed or whether alphanumeric characters can also be used, for example.

Indicator Postal code: Required entry for street address (T005-XPLZS)

If this indicator is activated, the postal code has to be entered when a street address is maintained. The check only takes effect when at least one of the following fields is filled:

  • Street,

  • House number,

  • Street 2, 3, 4 or 5

  • District

  • Other city.

It is not possible to make the Postal code field into a (undefined) required field by setting this indicator.

Indicator P.O. Box postal code: Required entry (T005-XPLPF)

If this indicator is activated, the postal code of the P.O. Box has to be specified when a P.O. Box address is maintained (that is, either the P.O. Box was entered or the "P.O. Box without number" indicator was set).

As soon as the country of the address is specified, the country-dependent check rules are determined and the following checks are carried out:

  • Is the region (other region), if specified, valid for the country (see table T005S)? If it is not, the check returns an error.

  • Was a postal code specified for the street address if the indicator Postal code: Required entry for street address (T005-XPLZS) is set? If it is not, the check returns an error.

  • Was a postal code specified for the P.O. Box address if the indicator P.O. Box Postal code: Required entry (T005-XPLPF) is set? If it is not, the check returns an error.

  • The case where the P.O. Box is entered and the "P.O. Box without number" indicator is set should not occur. If it does, however, the check returns an error.

  • The postal code is checked according to the check rule (T005-PRPLZ) and the length (T005-LNPLZ).

    Note Note

    Another city (P.O. Box city) can only be specified if the P.O. Box address is specified or if the company postal code is entered.

    End of the note.

If one of these checks returns an error, the address is not accepted in this form and cannot be saved.

Note Note

The function module POSTAL_CODE_CHECK is used in some applications. This function module covers part of the checks mentioned above. It was also used in the customer master and the vendor master up to Release 4.0.

End of the note.

The function module ADDR_POSTAL_CODE_CHECK carries out more checks because it considers a larger number of fields due to the more extensive BAS data structure.