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

SAP Help, Wiki, Q&A and other resources for 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
T005T Country Names Basis - Address Management/Business Address
T001 Company Codes FI - Financial Accounting
T005S Taxes: Region (Province) Key Basis - Address Management/Business Address
KNA1 General Data in Customer Master Logistics - Customer Master
DFKKREPZM Recording Data for EC Sales List FI - Contract Accounts Receivable and Payable

Transaction Codes for SAP Table T005

TCODE Description Functional Area
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SM30 Call View Maintenance Basis - Table Maintenance Tool
SU52 Maintain Own User Parameters Basis - User and Authorization Management
OY01 Customize: set up countries CA - Globales Organisationscustomizing
SE16 Data Browser Basis - Workbench Utilities
OY17 Countries - field checks Cross Application - Bank

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
ADDR_POSTAL_CODE_CHECK BC - Address Management/Business Address
JURISDICTION_DETERMINE_CHECK Determine or check jurisdiction code from master record using CAM FI - Basic Functions
TZON_LOCATION_TIMEZONE Basis - Time Zones
CLOSE_FORM SAPscript: End layout set printing Basis - SAPscript
CONVERT_TO_LOCAL_CURRENCY Translate foreign currency amount to local currency Basis - Currency Conversion/Expiring Currency

ABAP Reports for SAP Table T005

ABAP REPORT Description Functional Area
RFASLD02 EC Sales List (Belgium, Luxembourg) FI - Information System
RFASLD20 EC Sales List in Data Medium Exchange Format FI - General Ledger Accounting
RFASLM00 EC Sales List FI - Information System
SAPFSYSCALLS System Routines for Communication SAPMSSYD - Services DO NOT MODIFY Basis - Graphical User Interface
SAPMSSYD Screen Exits Basis - Syntax, Compiler, Runtime
SAPLOLEA SAP OLE Automation Controller

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
S_IWB Knowledge Warehouse
WLM Assignment of Articles to Layout Modules
F_BKPF_KOA Accounting Document: Authorization for Account Types
J_1IRG23D Authorisation object for Depo Transactions
M_MATE_STA Material Master: Maintenance Statuses
S_BTCH_EXT External Scheduler

Most searched SAP Basis Components Tables