SAP Table T005
Countries
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
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 |