SAP Table T005

Countries

T005 (Countries) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T005 to other SAP tables.

T005 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LAND1 Country Key LAND1 CHAR 3 0
LANDK Vehicle country key LANDK CHAR 3 0
LNPLZ Postal code length LNPLZ_005 NUMC 2 0
PRPLZ Rule for the postal code field check PRUEF_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
ADDRS Formatting routine key for printing addresses ADDRS_005 T005A CHAR 3 0
XPLZS Flag: Street address postal code required entry? XPLZS_005 CHAR 1 0
X Yes
NULL No
XPLPF Flag: PO Box postal code required? XPLPF_005 CHAR 1 0
X Yes
NULL No
SPRAS Language Key SPRAS T002 LANG 1 0
XLAND Country version flag XLAND_005 CHAR 1 0
NULL Not relevant for IMG or country program
I Only relevant for IMG
X Relevant for both IMG and country program
XADDR Flag: Print country name in foreign addresses? XADDR_005 CHAR 1 0
X Yes
NULL No
NMFMT Standard name format NMFMT_005 T005N CHAR 2 0
XREGS Flag: City file address check XREGS_005 CHAR 1 0
X Yes
NULL No
XPLST Flag: Street-specific postal code? (City file) XPLST_005 CHAR 1 0
X Yes
NULL No
INTCA Country ISO code INTCA CHAR 2 0
INTCA3 ISO country code 3 char INTCA3 CHAR 3 0
INTCN3 ISO Country Code Numeric 3-Characters INTCN3 NUMC 3 0
XEGLD Indicator: European Union Member? XEGLD CHAR 1 0
X Yes
NULL No
XSKFN Indicator: Discount base amount is the net value XSKFN CHAR 1 0
X Yes
NULL No
XMWSN Indicator: Base amount for tax is net of discount ? XMWSN CHAR 1 0
X Yes
NULL No
LNBKN Bank account number length LNBKN_005 NUMC 2 0
PRBKN Rule for checking bank account number field PRBKN_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNBLZ Bank number length LNBLZ_005 NUMC 2 0
PRBLZ Rule for checking bank number field PRBLZ_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNPSK Post office bank current account number length LNPSK_005 NUMC 2 0
PRPSK Rule for checking postal check account number field PRPSK_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
XPRBK Indicator: Use check module for bank fields ? XPRBK_005 CHAR 1 0
X Yes
NULL No
BNKEY Name of the bank key BNKEY CHAR 1 0
1 Bank number
2 Obsolete
3 Assign internally
4 Assign externally
LNBKS Length of Bank Key LNBKS_005 NUMC 2 0
PRBKS Rule for checking bank key field PRBKS_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
XPRSO Indicator: Use check module for tax fields etc. ? XPRSO_005 CHAR 1 0
X Yes
NULL No
PRUIN Rule for checking VAT registration number field PRUIN_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
UINLN VAT registration number length UINLN NUMC 2 0
LNST1 Permitted Input Length for Tax Numbre 1 LNST1_005 NUMC 2 0
PRST1 Rule for checking tax code 1 field PRST1_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNST2 Permitted Input Length for Tax Number 2 LNST2_005 NUMC 2 0
PRST2 Rule for checking tax code 2 field PRST2_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNST3 Permitted Input Length for Tax Number 3 LNST3_005 NUMC 2 0
PRST3 Rule for checking tax code 3 field PRST3_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNST4 Permitted Input Length for Tax Number 4 LNST4_005 NUMC 2 0
PRST4 Rule for checking tax code 4 field PRST4_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LNST5 Permitted Input Length for Tax Number 5 LNST5_005 NUMC 2 0
PRST5 Rule for checking tax code 5 field PRST5_005 CHAR 1 0
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
9 Check against country-specific edit format
0 Deactivate Postal Code Check for USA
LANDD DUEVO: Nationality DUSTA T5D4E CHAR 3 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D T683 CHAR 6 0
LANDA Alternative Country Key LANDA CHAR 3 0
WECHF Payment period for bill of exchange WECHF NUMC 3 0
LKVRZ Short Name for Foreign Trade Statistics LKVRZ CHAR 7 0
INTCN Intrastat Code INTCN NUMC 3 0
XDEZP Decimal point format XDEZP CHAR 1 0
X Yes
NULL No
DATFM Date Format DATFM CHAR 1 0
1 DD.MM.YYYY
2 MM/DD/YYYY
3 MM-DD-YYYY
4 YYYY.MM.DD
CURIN Currency Key of the Index-Based Currency CURIN TCURC CUKY 5 0
CURHA Currency Key of the Hard Currency CURHA TCURC CUKY 5 0
WAERS Country currency WAERS_005 TCURC CUKY 5 0
KURST Exchange Rate Type for Translation into Country Currency KURST_005 TCURV CHAR 4 0
AFAPL Chart of depreciaton for asset valuation AFAPL T096 CHAR 4 0
GWGWRT Maximum low-value asset amount GWGWRT CURR 13 2
UMRWRT Net book value for changeover of depreciation method UMRWRT CURR 13 2
KZRBWB Indicator post net book value for retirement KZRBWB CHAR 1 0
X Yes
NULL No
XANZUM Indicator transfer down payments from previous years XANZUM CHAR 1 0
X Yes
NULL No
CTNCONCEPT Withholding tax certificate numbering: Concepts CTNCONCEPT WITH_CTNCOKEY CHAR 4 0
KZSRV Taxes at individual service level KZSRV CHAR 1 0
X Yes
NULL No
XXINVE Indicator: Display Capital Goods Indicator? XXINVE CHAR 1 0
X Yes
NULL No
SUREG Super region per country PRQ_SUREG TBKS CHAR 8 0
LANDGRP_VP Country grouping for shipping schedule LANDGRP_VP TJG94 CHAR 2 0

T005 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T005 ADDRS T005 ADDRS T005A Address routines ADDRS
T005 ADDRS T005 MANDT T005A Address routines MANDT
T005 AFAPL T005 AFAPL T096 Chart of depreciation AFAPL
T005 AFAPL SYST MANDT T096 Chart of depreciation MANDT
T005 CTNCONCEPT T005 CTNCONCEPT WITH_CTNCOKEY Withholding tax certificate numbering: Concepts CTNCONCEPT
T005 CURHA SYST MANDT TCURC Currency Codes MANDT
T005 CURHA T005 CURHA TCURC Currency Codes WAERS
T005 CURIN SYST MANDT TCURC Currency Codes MANDT
T005 CURIN T005 CURIN TCURC Currency Codes WAERS
T005 KALSM T005 KALSM T683 Pricing procedures KALSM
T005 KALSM T005 MANDT T683 Pricing procedures MANDT
T005 KALSM 'A' T683 Pricing procedures KVEWE
T005 KALSM 'TX' T683 Pricing procedures KAPPL
T005 KURST T005 KURST TCURV Exchange rate types for currency translation KURST
T005 KURST T005 MANDT TCURV Exchange rate types for currency translation MANDT
T005 LANDD T005 LANDD T5D4E DEUEV Nationality Key DUNAT
T005 LANDD * T5D4E DEUEV Nationality Key ENDDA
T005 LANDGRP_VP T005 MANDT TJG94 Country Grouping for Shipping Schedule MANDT
T005 LANDGRP_VP T005 LANDGRP_VP TJG94 Country Grouping for Shipping Schedule LANDGRP_VP
T005 MANDT T005 MANDT T000 Clients MANDT
T005 NMFMT T005 MANDT T005N Name formats MANDT
T005 NMFMT T005 LAND1 T005N Name formats LAND1
T005 NMFMT T005 NMFMT T005N Name formats NAMEFORMAT
T005 SPRAS T005 SPRAS T002 Language Keys (Component BC-I18) SPRAS
T005 SUREG T005 MANDT TBKS Super region MANDT
T005 SUREG T005 SUREG TBKS Super region SUREG
T005 WAERS T005 MANDT TCURC Currency Codes MANDT
T005 WAERS T005 WAERS TCURC Currency Codes WAERS