T005 is a standard Address Management/Business Address Transparent Table in SAP Basis application, which stores Countries data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for T005. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
T005 — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Data Element | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|---|
1 | MANDT | Client | MANDT | X | CLNT | 3 | T000 |
2 | LAND1 | Country | LAND1 | X | CHAR | 3 | |
3 | LANDK | Vehicle country key | LANDK | CHAR | 3 | ||
4 | LNPLZ | Version Number Component | LNPLZ_005 | NUMC | 2 | ||
5 | PRPLZ | Character Field of Length 1 | PRUEF_005 | CHAR | 1 | ||
6 | ADDRS | Address | ADDRS_005 | CHAR | 3 | T005A | |
7 | XPLZS | Character Field of Length 1 | XPLZS_005 | CHAR | 1 | ||
8 | XPLPF | Character Field of Length 1 | XPLPF_005 | CHAR | 1 | ||
9 | SPRAS | Language Key | SPRAS | LANG | 1 | T002 | |
10 | XLAND | Country Name | XLAND_005 | CHAR | 1 | ||
11 | XADDR | Flag: Print country name in foreign addresses? | XADDR_005 | CHAR | 1 | ||
12 | NMFMT | Version Number Component | NMFMT_005 | CHAR | 2 | T005N | |
13 | XREGS | Character Field of Length 1 | XREGS_005 | CHAR | 1 | ||
14 | XPLST | Character Field of Length 1 | XPLST_005 | CHAR | 1 | ||
15 | INTCA | Country ISO code | INTCA | CHAR | 2 | ||
16 | INTCA3 | ISO country code 3 char | INTCA3 | CHAR | 3 | ||
17 | INTCN3 | ISO Country Code Numeric 3-Characters | INTCN3 | NUMC | 3 | ||
18 | XEGLD | Indicator: European Union Member? | XEGLD | CHAR | 1 | ||
19 | XSKFN | Indicator: Discount base amount is the net value | XSKFN | CHAR | 1 | ||
20 | XMWSN | General flag | XMWSN | CHAR | 1 | ||
21 | .INCLUDE | 0 | |||||
22 | LNBKN | Version Number Component | LNBKN_005 | NUMC | 2 | ||
23 | PRBKN | Character Field of Length 1 | PRBKN_005 | CHAR | 1 | ||
24 | LNBLZ | Version Number Component | LNBLZ_005 | NUMC | 2 | ||
25 | PRBLZ | Character Field of Length 1 | PRBLZ_005 | CHAR | 1 | ||
26 | LNPSK | Version Number Component | LNPSK_005 | NUMC | 2 | ||
27 | PRPSK | Character Field of Length 1 | PRPSK_005 | CHAR | 1 | ||
28 | XPRBK | Character Field of Length 1 | XPRBK_005 | CHAR | 1 | ||
29 | BNKEY | Character Field of Length 1 | BNKEY | CHAR | 1 | ||
30 | LNBKS | Version Number Component | LNBKS_005 | NUMC | 2 | ||
31 | PRBKS | Character Field of Length 1 | PRBKS_005 | CHAR | 1 | ||
32 | XPRSO | Character Field of Length 1 | XPRSO_005 | CHAR | 1 | ||
33 | PRUIN | Character Field of Length 1 | PRUIN_005 | CHAR | 1 | ||
34 | UINLN | Version Number Component | UINLN | NUMC | 2 | ||
35 | LNST1 | Version Number Component | LNST1_005 | NUMC | 2 | ||
36 | PRST1 | Character Field of Length 1 | PRST1_005 | CHAR | 1 | ||
37 | LNST2 | Version Number Component | LNST2_005 | NUMC | 2 | ||
38 | PRST2 | Character Field of Length 1 | PRST2_005 | CHAR | 1 | ||
39 | LNST3 | Permitted Input Length for Tax Number 3 | LNST3_005 | NUMC | 2 | ||
40 | PRST3 | Rule for checking tax code 3 field | PRST3_005 | CHAR | 1 | ||
41 | LNST4 | Permitted Input Length for Tax Number 4 | LNST4_005 | NUMC | 2 | ||
42 | PRST4 | Rule for checking tax code 4 field | PRST4_005 | CHAR | 1 | ||
43 | LNST5 | Permitted Input Length for Tax Number 5 | LNST5_005 | NUMC | 2 | ||
44 | PRST5 | Rule for checking tax code 5 field | PRST5_005 | CHAR | 1 | ||
45 | .INCLUDE | 0 | |||||
46 | .INCLUDE | 0 | |||||
47 | LANDD | DUEVO: Nationality | DUSTA | CHAR | 3 | T5D4E | |
48 | .INCLUDE | 0 | |||||
49 | KALSM | Procedure (Pricing | KALSM_D | CHAR | 6 | T683 | |
50 | .INCLUDE | 0 | |||||
51 | LANDA | Country Key | LANDA | CHAR | 3 | ||
52 | WECHF | Payment period for bill of exchange | WECHF | NUMC | 3 | ||
53 | LKVRZ | Short name for foreign trade statistics | LKVRZ | CHAR | 7 | ||
54 | INTCN | Intrastat Code | INTCN | NUMC | 3 | ||
55 | XDEZP | Decimal Format | XDEZP | CHAR | 1 | ||
56 | DATFM | Date format | DATFM | CHAR | 1 | ||
57 | CURIN | Currency Key of the Index-Based Currency | CURIN | CUKY | 5 | TCURC | |
58 | CURHA | Currency key of the hard currency | CURHA | CUKY | 5 | TCURC | |
59 | WAERS | Currency | WAERS_005 | CUKY | 5 | TCURC | |
60 | KURST | Exch. Rate Type | KURST_005 | CHAR | 4 | TCURV | |
61 | AFAPL | Chart of depreciaton for asset valuation | AFAPL | CHAR | 4 | T096 | |
62 | GWGWRT | Maximum low-value asset amount | GWGWRT | CURR | 23 | ||
63 | UMRWRT | Net book value for changeover of depreciation method | UMRWRT | CURR | 23 | ||
64 | KZRBWB | Indicator post net book value for retirement | KZRBWB | CHAR | 1 | ||
65 | XANZUM | Indicator transfer down payments from previous years | XANZUM | CHAR | 1 | ||
66 | CTNCONCEPT | Withholding tax certificate numbering: Concepts | CTNCONCEPT | CHAR | 4 | WITH_CTNCOKEY | |
67 | KZSRV | Taxes at individual service level | KZSRV | CHAR | 1 | ||
68 | XXINVE | Indicator: Display Capital Goods Indicator? | XXINVE | CHAR | 1 | ||
69 | .INCLU--AP | 0 | |||||
70 | XGCCV | XGCCV | CHAR | 1 | |||
71 | .INCLU--AP | 0 | |||||
72 | SUREG | Super region per country | PRQ_SUREG | CHAR | 8 | TBKS |
Most searched SAP Basis Components Tables
- Business Partner Tables
- Roles Tables
- Users List Tables
- Transport Requests Tables
- Unit Of Measure Tables
- Partner Functions Tables
- Address Tables
- Authorization Objects Tables
- Background Job Tables
- Exchange Rate Tables
- Idoc Tables
- User Name Tables
- Workflow Tables
- Email Address Tables
- User Groups Tables
- Task List Tables
- Su01 Tables
- Idoc Segment Tables
- Rfc Tables
- Table Name Tables
- Language Tables
- Change Log Tables