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