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