T005 SAP (Countries) Table details

Dictionary Type: Table
Description: Countries




ABAP Code to SELECT data from T005
Related tables to T005
Access table T005




Table field list including key, data, relationships and ABAP select examples

T005 is a standard SAP Table which is used to store Countries data and is available within R/3 SAP systems depending on the version and release level.

The T005 table consists of various fields, each holding specific information or linking keys about Countries data available in SAP. These include LAND1 (Country Key), LANDK (Vehicle country key), LNPLZ (Postal code length), PRPLZ (Rule for the postal code field check).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = T005T


SAP T005 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LAND1Country Key LAND1CHAR3LAND1LND
LANDKVehicle country key LANDKCHAR3LANDK
LNPLZPostal code length LNPLZ_005NUMC2NUM02
PRPLZRule for the postal code field check PRUEF_005CHAR1PR005
ADDRSFormatting routine key for printing addresses ADDRS_005CHAR3T005AADDRS
XPLZSFlag: Street address postal code required entry? XPLZS_005CHAR1XFELD
XPLPFFlag: PO Box postal code required? XPLPF_005CHAR1XFELD
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
XLANDCountry version flag XLAND_005CHAR1XLAND_005
XADDRFlag: Print country name in foreign addresses? XADDR_005CHAR1XFELD
NMFMTStandard name format NMFMT_005CHAR2T005NAD_NAMFORM
XREGSFlag: City file address check XREGS_005CHAR1XFELD
XPLSTFlag: Street-specific postal code? (City file) XPLST_005CHAR1XFELD
INTCACountry ISO code INTCACHAR2INTCAF4_INTCA
INTCA3ISO country code 3 char INTCA3CHAR3INTCA3
INTCN3ISO Country Code Numeric 3-Characters INTCN3NUMC3NUM03
XEGLDIndicator: European Union Member? XEGLDCHAR1XFELD
XSKFNIndicator: Discount base amount is the net value XSKFNCHAR1XFELD
XMWSNIndicator: Base amount for tax is net of discount ? XMWSNCHAR1XFELD
LNBKNBank account number length LNBKN_005NUMC2NUM02
PRBKNRule for checking bank account number field PRBKN_005CHAR1PR005
LNBLZBank number length LNBLZ_005NUMC2NUM02
PRBLZRule for checking bank number field PRBLZ_005CHAR1PR005
LNPSKPost office bank current account number length LNPSK_005NUMC2NUM02
PRPSKRule for checking postal check account number field PRPSK_005CHAR1PR005
XPRBKIndicator: Use check module for bank fields ? XPRBK_005CHAR1XFELD
BNKEYName of the bank key BNKEYCHAR1BNKEY
LNBKSLength of Bank Key LNBKS_005NUMC2NUM02
PRBKSRule for checking bank key field PRBKS_005CHAR1PR005
XPRSOIndicator: Use check module for tax fields etc. ? XPRSO_005CHAR1XFELD
PRUINRule for checking VAT registration number field PRUIN_005CHAR1PR005
UINLNVAT registration number length UINLNNUMC2NUM02
LNST1Permitted Input Length for Tax Numbre 1 LNST1_005NUMC2NUM02
PRST1Rule for checking tax code 1 field PRST1_005CHAR1PR005
LNST2Permitted Input Length for Tax Number 2 LNST2_005NUMC2NUM02
PRST2Rule for checking tax code 2 field PRST2_005CHAR1PR005
LNST3Permitted Input Length for Tax Number 3 LNST3_005NUMC2NUM02
PRST3Rule for checking tax code 3 field PRST3_005CHAR1PR005
LNST4Permitted Input Length for Tax Number 4 LNST4_005NUMC2NUM02
PRST4Rule for checking tax code 4 field PRST4_005CHAR1PR005
LNST5Permitted Input Length for Tax Number 5 LNST5_005NUMC2NUM02
PRST5Rule for checking tax code 5 field PRST5_005CHAR1PR005
LANDDDUEVO: Nationality DUSTACHAR3T5D4EDUSTA
KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_DCHAR6T683KALSM
LANDAAlternative Country Key LANDACHAR3LANDA
WECHFPayment period for bill of exchange WECHFNUMC3NUM03
LKVRZShort Name for Foreign Trade Statistics LKVRZCHAR7CHAR7
INTCNIntrastat Code INTCNNUMC3NUM03
XDEZPDecimal point format XDEZPCHAR1XFELD
DATFMDate Format DATFMCHAR1DATFM
CURINCurrency Key of the Index-Based Currency CURINCUKY5TCURCWAERS
CURHACurrency Key of the Hard Currency CURHACUKY5TCURCWAERS
WAERSCountry currency WAERS_005CUKY5TCURCWAERS
KURSTExchange Rate Type for Translation into Country Currency KURST_005CHAR4TCURVKURST
AFAPLChart of depreciaton for asset valuation AFAPLCHAR4T096AFAPLAFPH_AFAPL
GWGWRTMaximum low-value asset amount GWGWRTCURR13(2) WERT13
UMRWRTNet book value for changeover of depreciation method UMRWRTCURR13(2) WERT13
KZRBWBIndicator post net book value for retirement KZRBWBCHAR1XFELD
XANZUMIndicator transfer down payments from previous years XANZUMCHAR1XFELD
CTNCONCEPTWithholding tax certificate numbering: Concepts CTNCONCEPTCHAR4WITH_CTNCOKEYCTNCONCEPT
KZSRVTaxes at individual service level KZSRVCHAR1XFELD
XXINVEIndicator: Display Capital Goods Indicator? XXINVECHAR1XFELD
.INCLU--AP 0
SUREGSuper region per country PRQ_SUREGCHAR8TBKSPRQ_CH8
.INCLU--AP 0
LANDGRP_VPCountry grouping for shipping schedule LANDGRP_VPCHAR2TJG94LANDGRP_VP

Key field Non-key field



How do I retrieve data from SAP table T005 using ABAP code

The following ABAP code Example will allow you to do a basic selection on T005 to SELECT all data from the table
DATA: WA_T005 TYPE T005.

SELECT SINGLE *
FROM T005
INTO CORRESPONDING FIELDS OF WA_T005
WHERE...

How to access SAP table T005

Within an ECC or HANA version of SAP you can also view further information about T005 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!