SAP Table T005
Countries
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table T005 (Countries) is a standard table in SAP ERP. It belongs to the package SZAD.
Technical Information
| Table | T005 |
| Short Text | Countries |
| Package | SZAD |
| Table Type | Transparent Table |
Fields for Table T005
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| LAND1 | ✔ | Country Key | LAND1 | CHAR | 3 | |
| LANDK | Vehicle country key | LANDK | CHAR | 3 | ||
| LNPLZ | Postal code length | LNPLZ_005 | NUMC | 2 | ||
| PRPLZ | Rule for the postal code field check | PRUEF_005 | CHAR | 1 | ||
| ADDRS | Formatting routine key for printing addresses | ADDRS_005 | CHAR | 3 | T005A | |
| XPLZS | Flag: Street address postal code required entry? | XPLZS_005 | CHAR | 1 | ||
| XPLPF | Flag: PO Box postal code required? | XPLPF_005 | CHAR | 1 | ||
| SPRAS | Language Key | SPRAS | LANG | 1 | T002 | |
| XLAND | Country version flag | XLAND_005 | CHAR | 1 | ||
| XADDR | Flag: Print country name in foreign addresses? | XADDR_005 | CHAR | 1 | ||
| NMFMT | Standard name format | NMFMT_005 | CHAR | 2 | T005N | |
| XREGS | Flag: City file address check | XREGS_005 | CHAR | 1 | ||
| XPLST | Flag: Street-specific postal code? (City file) | XPLST_005 | CHAR | 1 | ||
| INTCA | Country ISO code | INTCA | CHAR | 2 | ||
| INTCA3 | ISO country code 3 char | INTCA3 | CHAR | 3 | ||
| INTCN3 | ISO Country Code Numeric 3-Characters | INTCN3 | NUMC | 3 | ||
| XEGLD | Indicator: European Union Member? | XEGLD | CHAR | 1 | ||
| XSKFN | Indicator: Discount base amount is the net value | XSKFN | CHAR | 1 | ||
| XMWSN | Indicator: Base amount for tax is net of discount ? | XMWSN | CHAR | 1 | ||
| LNBKN | Bank account number length | LNBKN_005 | NUMC | 2 | ||
| PRBKN | Rule for checking bank account number field | PRBKN_005 | CHAR | 1 | ||
| LNBLZ | Bank number length | LNBLZ_005 | NUMC | 2 | ||
| PRBLZ | Rule for checking bank number field | PRBLZ_005 | CHAR | 1 | ||
| LNPSK | Post office bank current account number length | LNPSK_005 | NUMC | 2 | ||
| PRPSK | Rule for checking postal check account number field | PRPSK_005 | CHAR | 1 | ||
| XPRBK | Indicator: Use check module for bank fields ? | XPRBK_005 | CHAR | 1 | ||
| BNKEY | Name of the bank key | BNKEY | CHAR | 1 | ||
| LNBKS | Length of Bank Key | LNBKS_005 | NUMC | 2 | ||
| PRBKS | Rule for checking bank key field | PRBKS_005 | CHAR | 1 | ||
| XPRSO | Indicator: Use check module for tax fields etc. ? | XPRSO_005 | CHAR | 1 | ||
| PRUIN | Rule for checking VAT registration number field | PRUIN_005 | CHAR | 1 | ||
| UINLN | VAT registration number length | UINLN | NUMC | 2 | ||
| LNST1 | Permitted Input Length for Tax Numbre 1 | LNST1_005 | NUMC | 2 | ||
| PRST1 | Rule for checking tax code 1 field | PRST1_005 | CHAR | 1 | ||
| LNST2 | Permitted Input Length for Tax Number 2 | LNST2_005 | NUMC | 2 | ||
| PRST2 | Rule for checking tax code 2 field | PRST2_005 | CHAR | 1 | ||
| LNST3 | Permitted Input Length for Tax Number 3 | LNST3_005 | NUMC | 2 | ||
| PRST3 | Rule for checking tax code 3 field | PRST3_005 | CHAR | 1 | ||
| LNST4 | Permitted Input Length for Tax Number 4 | LNST4_005 | NUMC | 2 | ||
| PRST4 | Rule for checking tax code 4 field | PRST4_005 | CHAR | 1 | ||
| LNST5 | Permitted Input Length for Tax Number 5 | LNST5_005 | NUMC | 2 | ||
| PRST5 | Rule for checking tax code 5 field | PRST5_005 | CHAR | 1 | ||
| LANDD | DUEVO: Nationality | DUSTA | CHAR | 3 | T5D4E | |
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | |
| LANDA | Alternative Country Key | LANDA | CHAR | 3 | ||
| WECHF | Payment period for bill of exchange | WECHF | NUMC | 3 | ||
| LKVRZ | Short Name for Foreign Trade Statistics | LKVRZ | CHAR | 7 | ||
| INTCN | Intrastat Code | INTCN | NUMC | 3 | ||
| XDEZP | Decimal point format | XDEZP | CHAR | 1 | ||
| DATFM | Date Format | DATFM | CHAR | 1 | ||
| CURIN | Currency Key of the Index-Based Currency | CURIN | CUKY | 5 | TCURC | |
| CURHA | Currency Key of the Hard Currency | CURHA | CUKY | 5 | TCURC | |
| WAERS | Country currency | WAERS_005 | CUKY | 5 | TCURC | |
| KURST | Exchange Rate Type for Translation into Country Currency | KURST_005 | CHAR | 4 | TCURV | |
| AFAPL | Chart of depreciaton for asset valuation | AFAPL | CHAR | 4 | T096 | |
| GWGWRT | Maximum low-value asset amount | GWGWRT | CURR | 13 | ||
| UMRWRT | Net book value for changeover of depreciation method | UMRWRT | CURR | 13 | ||
| KZRBWB | Indicator post net book value for retirement | KZRBWB | CHAR | 1 | ||
| XANZUM | Indicator transfer down payments from previous years | XANZUM | CHAR | 1 | ||
| CTNCONCEPT | Withholding tax certificate numbering: Concepts | CTNCONCEPT | CHAR | 4 | WITH_CTNCOKEY | |
| KZSRV | Taxes at individual service level | KZSRV | CHAR | 1 | ||
| XXINVE | Indicator: Display Capital Goods Indicator? | XXINVE | CHAR | 1 | ||
| SUREG | Super region per country | PRQ_SUREG | CHAR | 8 | TBKS | |
| LANDGRP_VP | Country grouping for shipping schedule | LANDGRP_VP | CHAR | 2 | TJG94 |