T005 is a standard Address Management/Business Address Transparent Table in SAP Basis application, which stores Countries data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, 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 — Meta Data

Description: Countries
Main Category: Basis
Sub Category: Address Management/Business Address
Table type: Transparent Table (TRANSP)

T005 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 LAND1 Country X CHAR 3
    3 LANDK Vehicle country key CHAR 3
    4 LNPLZ Version Number Component NUMC 2
    5 PRPLZ Character Field of Length 1 CHAR 1
    6 ADDRS Address CHAR 3 T005A
    7 XPLZS Character Field of Length 1 CHAR 1
    8 XPLPF Character Field of Length 1 CHAR 1
    9 SPRAS Language Key LANG 1 T002
    10 XLAND Country Name CHAR 1
    11 XADDR Flag: Print country name in foreign addresses? CHAR 1
    12 NMFMT Version Number Component CHAR 2 T005N
    13 XREGS Character Field of Length 1 CHAR 1
    14 XPLST Character Field of Length 1 CHAR 1
    15 INTCA Country ISO code CHAR 2
    16 INTCA3 ISO country code 3 char CHAR 3
    17 INTCN3 ISO Country Code Numeric 3-Characters NUMC 3
    18 XEGLD Indicator: European Union Member? CHAR 1
    19 XSKFN Indicator: Discount base amount is the net value CHAR 1
    20 XMWSN General flag CHAR 1
    21 .INCLUDE 0
    22 LNBKN Version Number Component NUMC 2
    23 PRBKN Character Field of Length 1 CHAR 1
    24 LNBLZ Version Number Component NUMC 2
    25 PRBLZ Character Field of Length 1 CHAR 1
    26 LNPSK Version Number Component NUMC 2
    27 PRPSK Character Field of Length 1 CHAR 1
    28 XPRBK Character Field of Length 1 CHAR 1
    29 BNKEY Character Field of Length 1 CHAR 1
    30 LNBKS Version Number Component NUMC 2
    31 PRBKS Character Field of Length 1 CHAR 1
    32 XPRSO Character Field of Length 1 CHAR 1
    33 PRUIN Character Field of Length 1 CHAR 1
    34 UINLN Version Number Component NUMC 2
    35 LNST1 Version Number Component NUMC 2
    36 PRST1 Character Field of Length 1 CHAR 1
    37 LNST2 Version Number Component NUMC 2
    38 PRST2 Character Field of Length 1 CHAR 1
    39 LNST3 Permitted Input Length for Tax Number 3 NUMC 2
    40 PRST3 Rule for checking tax code 3 field CHAR 1
    41 LNST4 Permitted Input Length for Tax Number 4 NUMC 2
    42 PRST4 Rule for checking tax code 4 field CHAR 1
    43 LNST5 Permitted Input Length for Tax Number 5 NUMC 2
    44 PRST5 Rule for checking tax code 5 field CHAR 1
    45 .INCLUDE 0
    46 .INCLUDE 0
    47 LANDD DUEVO: Nationality CHAR 3 T5D4E
    48 .INCLUDE 0
    49 KALSM Procedure (Pricing CHAR 6 T683
    50 .INCLUDE 0
    51 LANDA Country Key CHAR 3
    52 WECHF Payment period for bill of exchange NUMC 3
    53 LKVRZ Short name for foreign trade statistics CHAR 7
    54 INTCN Intrastat Code NUMC 3
    55 XDEZP Decimal Format CHAR 1
    56 DATFM Date format CHAR 1
    57 CURIN Currency Key of the Index-Based Currency CUKY 5 TCURC
    58 CURHA Currency key of the hard currency CUKY 5 TCURC
    59 WAERS Currency CUKY 5 TCURC
    60 KURST Exch. Rate Type CHAR 4 TCURV
    61 AFAPL Chart of depreciaton for asset valuation CHAR 4 T096
    62 GWGWRT Maximum low-value asset amount CURR 23
    63 UMRWRT Net book value for changeover of depreciation method CURR 23
    64 KZRBWB Indicator post net book value for retirement CHAR 1
    65 XANZUM Indicator transfer down payments from previous years CHAR 1
    66 CTNCONCEPT Withholding tax certificate numbering: Concepts CHAR 4 WITH_CTNCOKEY
    67 KZSRV Taxes at individual service level CHAR 1
    68 XXINVE Indicator: Display Capital Goods Indicator? CHAR 1
    69 .INCLU--AP 0
    70 XGCCV CHAR 1
    71 .INCLU--AP 0
    72 SUREG Super region per country CHAR 8 TBKS

SAP Help, Wiki Resources, and Forum Discussions on T005

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
T001 Company Codes FI - Financial Accounting
T005T Country Names Basis - Address Management/Business Address
MARA General Material Data Logistics - Material Master
EKPO Purchasing Document Item MM - Purchasing
BSEG Accounting Document Segment FI - Financial Accounting
T001W Plants/Branches Logistics - Plant Master
VBAK Sales Document: Header Data SD - Sales

Transaction Codes for SAP Table T005

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SE16 Data Browser Basis - Workbench Utilities
SM30 Call View Maintenance Basis - Table Maintenance Tool
SE38 ABAP Editor Basis - ABAP Editor
OY01 Customize: set up countries CA - Globales Organisationscustomizing
VA01 Create Sales Order SD - Sales
SU01 User Maintenance Basis - User and Authorization Management

FMs for SAP Table T005

FM Description Functional Area
F4IF_INT_TABLE_VALUE_REQUEST F4 help also returning the value to be displayed in internal table Basis - F4 Help
CLOSE_FORM SAPscript: End layout set printing Basis - SAPscript
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
WRITE_FORM SAPscript: Output text element in form window Basis - SAPscript
OPEN_FORM SAPscript: Open form printing Basis - SAPscript
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
ADDRESS_INTO_PRINTFORM Address Format According to Post Office Guidelines Basis - Address Management/Business Address

ABAP Reports for SAP Table T005

ABAP REPORT Description Functional Area
CL_ABAP_TYPEDESCR=============CP Include LDMEE1_ABACIH
SPRSL TEXT 630 - Workbench Tools: Editors
SAPLSPO1 ?...
CONTEXT_X_SP_INFO SAP Applications: Products and Identification FI - Financial Accounting
RVADTABL INCLUDE for General Table Descriptions for Print Programs SD - Output Determination
SAPLSTR8 CTS: Modules for Interaction
SAPL080E Model View Maintenance
MAILDATA WFMC: Data Definitions for Mail SD - Output Determination

BW Datasources for SAP Table T005

BW DATASOURCE Description Functional Area
0VENDOR_ATTR Vendor Number MM - Materials Management
0COUNTRY_TEXT Country -
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management

Authorization Objects for SAP Table T005

AUTHORIZATION OBJECT Description Functional Area
C_VKORG Transfer of Sales Organization Data
S_IWB Knowledge Warehouse
F_BKPF_KOA Accounting Document: Authorization for Account Types
WLM Assignment of Articles to Layout Modules
J_1IRG23D Authorisation object for Depo Transactions
M_MATE_STA Material Master: Maintenance Statuses
S_CARRID Authorization Object for Airlines
S_USER_SAS User Master Maintenance: System-Specific Assignments