SAP TABLES | Basis Components | Basis Services / Communication Interfaces | Address Management/Business Address(BC-SRV-ADR) SAP BC

T005 SAP Countries Table and data

T005 is a standard SAP Table which is used to store Countries data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP T005 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: C - Customizing table, Maintenance only by customer and not updated by SAP import

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

Text table = T005T

SAP T005 Table fields within data Dictionary

FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
LANDKLANDKCHAR3 Vehicle country key
LNPLZLNPLZ_005NUMC2 Postal code length
PRPLZPRUEF_005CHAR1 Rule for the postal code field check
ADDRSADDRS_005CHAR3 T005AFormatting routine key for printing addresses
XPLZSXPLZS_005CHAR1 Flag: Street address postal code required entry?
XPLPFXPLPF_005CHAR1 Flag: PO Box postal code required?
XLANDXLAND_005CHAR1 Country version flag
XADDRXADDR_005CHAR1 Flag: Print country name in foreign addresses?
NMFMTNMFMT_005CHAR2 T005NStandard name format
XREGSXREGS_005CHAR1 Flag: City file address check
XPLSTXPLST_005CHAR1 Flag: Street-specific postal code? (City file)
INTCA3INTCA3CHAR3 ISO country code 3 char
INTCN3INTCN3NUMC3 ISO Country Code Numeric 3-Characters
XEGLDXEGLDCHAR1 Indicator: European Union Member?
XSKFNXSKFNCHAR1 Indicator: Discount base amount is the net value
XMWSNXMWSNCHAR1 Indicator: Base amount for tax is net of discount ?
.INCLUDESI_T005ABA Application base fields for table T005
LNBKNLNBKN_005NUMC2 Bank account number length
PRBKNPRBKN_005CHAR1 Rule for checking bank account number field
LNBLZLNBLZ_005NUMC2 Bank number length
PRBLZPRBLZ_005CHAR1 Rule for checking bank number field
LNPSKLNPSK_005NUMC2 Post office bank current account number length
PRPSKPRPSK_005CHAR1 Rule for checking postal check account number field
XPRBKXPRBK_005CHAR1 Indicator: Use check module for bank fields ?
BNKEYBNKEYCHAR1 Name of the bank key
LNBKSLNBKS_005NUMC2 Length of Bank Key
PRBKSPRBKS_005CHAR1 Rule for checking bank key field
XPRSOXPRSO_005CHAR1 Indicator: Use check module for tax fields etc. ?
PRUINPRUIN_005CHAR1 Rule for checking VAT registration number field
UINLNUINLNNUMC2 VAT registration number length
LNST1LNST1_005NUMC2 Permitted Input Length for Tax Numbre 1
PRST1PRST1_005CHAR1 Rule for checking tax code 1 field
LNST2LNST2_005NUMC2 Permitted Input Length for Tax Number 2
PRST2PRST2_005CHAR1 Rule for checking tax code 2 field
LNST3LNST3_005NUMC2 Permitted Input Length for Tax Number 3
PRST3PRST3_005CHAR1 Rule for checking tax code 3 field

LNST4LNST4_005NUMC2 Permitted Input Length for Tax Number 4
PRST4PRST4_005CHAR1 Rule for checking tax code 4 field
LNST5LNST5_005NUMC2 Permitted Input Length for Tax Number 5
PRST5PRST5_005CHAR1 Rule for checking tax code 5 field
.INCLUDESI_T005HR HR-Specific Fields in Table T005
.INCLUDESI_T005SPAY Include T005, transport layer SPAY
KALSMKALSM_DCHAR6 T683Procedure (Pricing, Output Control, Acct. Det., Costing,...)
.INCLUDESI_T005 Table T005 Application Fields
LANDALANDACHAR3 Alternative Country Key
WECHFWECHFNUMC3 Payment period for bill of exchange
LKVRZLKVRZCHAR7 Short Name for Foreign Trade Statistics
XDEZPXDEZPCHAR1 Decimal point format
CURINCURINCUKY5 TCURCCurrency Key of the Index-Based Currency
CURHACURHACUKY5 TCURCCurrency Key of the Hard Currency
WAERSWAERS_005CUKY5 TCURCCountry currency
KURSTKURST_005CHAR4 TCURVExchange Rate Type for Translation into Country Currency
AFAPLAFAPLCHAR4 T096Chart of depreciaton for asset valuation
GWGWRTGWGWRTCURR13(2) Maximum low-value asset amount
UMRWRTUMRWRTCURR13(2) Net book value for changeover of depreciation method
KZRBWBKZRBWBCHAR1 Indicator post net book value for retirement
XANZUMXANZUMCHAR1 Indicator transfer down payments from previous years
CTNCONCEPTCTNCONCEPTCHAR4 WITH_CTNCOKEYWithholding tax certificate numbering: Concepts
KZSRVKZSRVCHAR1 Taxes at individual service level
XXINVEXXINVECHAR1 Indicator: Display Capital Goods Indicator?
.APPENDT005APP Appendix to T005
SUREGPRQ_SUREGCHAR8 TBKSSuper region per country
.APPENDT005ISP IS-M/SD: Append Structure
LANDGRP_VPLANDGRP_VPCHAR2 TJG94Country grouping for shipping schedule

Key field
Non-key field