SAP table reference

T005

Countries

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table T005.

SAP table T005 has 2 primary key fields: MANDT,LAND1.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

T005 fields.

66 fields

Field

Description

Data type

Length

Decimals

Check table

Data element

Key MANDT

Client

CLNT

T000

MANDT

Key LAND1

Country/Region Key

CHAR

LAND1

LANDK

Vehicle Country/Region Key

CHAR

LANDK

LNPLZ

Postal code length

NUMC

LNPLZ_005

PRPLZ

Rule for the postal code field check

CHAR

PRUEF_005

ADDRS

Formatting routine key for printing addresses

CHAR

T005A

ADDRS_005

XPLZS

Flag: Street address postal code required entry?

CHAR

XPLZS_005

XPLPF

Flag: PO Box postal code required?

CHAR

XPLPF_005

SPRAS

Language Key

LANG

T002

SPRAS

XLAND

Indicator: Country/Region Version Availability

CHAR

XLAND_005

XADDR

Indicator: Print Country/Region for Addresses of Other C/R

CHAR

XADDR_005

NMFMT

Standard name format

CHAR

T005N

NMFMT_005

XREGS

Flag: City file address check

CHAR

XREGS_005

XPLST

Flag: Street-specific postal code? (City file)

CHAR

XPLST_005

INTCA

ISO Code of the Country/Region

CHAR

INTCA

INTCA3

ISO Country/Region Code 3 Characters

CHAR

INTCA3

INTCN3

ISO Country/Region Code Numeric 3-Characters

NUMC

INTCN3

XEGLD

Indicator: European Union Member?

CHAR

XEGLD

XSKFN

Indicator: Discount base amount is the net value

CHAR

XSKFN

XMWSN

Indicator: Base amount for tax is net of discount ?

CHAR

XMWSN

LNBKN

Bank account number length

NUMC

LNBKN_005

PRBKN

Rule for checking bank account number field

CHAR

PRBKN_005

LNBLZ

Bank number length

NUMC

LNBLZ_005

PRBLZ

Rule for checking bank number field

CHAR

PRBLZ_005

LNPSK

Post office bank current account number length

NUMC

LNPSK_005

PRPSK

Rule for checking postal check account number field

CHAR

PRPSK_005

XPRBK

Indicator: Use check module for bank fields ?

CHAR

XPRBK_005

BNKEY

Name of the bank key

CHAR

BNKEY

LNBKS

Length of Bank Key

NUMC

LNBKS_005

PRBKS

Rule for checking bank key field

CHAR

PRBKS_005

XPRSO

Indicator: Use check module for tax fields etc. ?

CHAR

XPRSO_005

PRUIN

Rule for checking VAT registration number field

CHAR

PRUIN_005

UINLN

VAT registration number length

NUMC

UINLN

LNST1

Permitted Input Length for Tax Numbre 1

NUMC

LNST1_005

PRST1

Rule for checking tax code 1 field

CHAR

PRST1_005

LNST2

Permitted Input Length for Tax Number 2

NUMC

LNST2_005

PRST2

Rule for checking tax code 2 field

CHAR

PRST2_005

LNST3

Permitted Input Length for Tax Number 3

NUMC

LNST3_005

PRST3

Rule for checking tax code 3 field

CHAR

PRST3_005

LNST4

Permitted Input Length for Tax Number 4

NUMC

LNST4_005

PRST4

Rule for checking tax code 4 field

CHAR

PRST4_005

LNST5

Permitted Input Length for Tax Number 5

NUMC

LNST5_005

PRST5

Rule for checking tax code 5 field

CHAR

PRST5_005

LANDD

DUEVO: Nationality

CHAR

T5D4E

DUSTA

KALSM

Procedure (Pricing, Output Control, Acct. Det., Costing,...)

CHAR

T683

KALSM_D

LANDA

Alternative Country/Region Key

CHAR

LANDA

WECHF

Bill of Exchange Payment Period

NUMC

WECHF

LKVRZ

Short Name for Foreign Trade Statistics

CHAR

LKVRZ

INTCN

Intrastat Code

NUMC

INTCN

XDEZP

Decimal Point Format

CHAR

XDEZP

DATFM

Date Format

CHAR

DATFM

CURIN

Currency Key of the Index-Based Currency

CUKY

TCURC

CURIN

CURHA

Currency Key of the Hard Currency

CUKY

TCURC

CURHA

WAERS

Reporting Currency

CUKY

TCURC

WAERS_005

KURST

Exchange Rate Type for Translation into Reporting Currency

CHAR

TCURV

KURST_005

AFAPL

Chart of Depreciaton for Asset Valuation

CHAR

T096

AFAPL

GWGWRT

Maximum Low-Value Asset Amount

CURR

GWGWRT

UMRWRT

Net Book Value for Changeover of Depreciation Method

CURR

UMRWRT

KZRBWB

Indicator Post Net Book Value for Retirement

CHAR

KZRBWB

XANZUM

Indicator transfer down payments from previous years

CHAR

XANZUM

CTNCONCEPT

Withholding Tax Certificate Numbering: Concepts

CHAR

WITH_CTNCOKEY

CTNCONCEPT

KZSRV

Taxes at individual service level

CHAR

KZSRV

XXINVE

Indicator: Display Capital Goods Indicator?

CHAR

XXINVE

NET_GROSS_POSTING_TYPE

Calculate and Post Impairment Based on Net or Gross Amount

CHAR

FINS_NET_GROSS_POSTING_TYPE

XGCCV

Indicator: GCC Member?

CHAR

XGCCV

SUREG

Super Region for Each Country/Region

CHAR

TBKS

PRQ_SUREG

/ Relationships

T005 relationships.

19 relationships

Table	Field	Check table	Description	Check field
T005	ADDRS	T005A	Address routines	MANDT
T005	AFAPL	T096	Chart of depreciation	MANDT
T005	CTNCONCEPT	WITH_CTNCOKEY	Withholding tax certificate numbering: Concepts	CTNCONCEPT
T005	CURHA	TCURC	Currency Codes	MANDT
T005	CURHA	TCURC	Currency Codes	WAERS
T005	CURIN	TCURC	Currency Codes	MANDT
T005	CURIN	TCURC	Currency Codes	WAERS
T005	KALSM	T683	Pricing procedures	KAPPL
T005	KALSM	T683	Pricing procedures	KALSM
T005	KURST	TCURV	Exchange rate types for currency translation	MANDT
T005	KURST	TCURV	Exchange rate types for currency translation	KURST
T005	LANDD	T5D4E	DEUEV Nationality Key	ENDDA
T005	MANDT	T000	Clients	MANDT
T005	NMFMT	T005N	Name formats	MANDT
T005	NMFMT	T005N	Name formats	LAND1
T005	NMFMT	T005N	Name formats	NAMEFORMAT
T005	SUREG	TBKS	Super region	MANDT
T005	WAERS	TCURC	Currency Codes	MANDT
T005	WAERS	TCURC	Currency Codes	WAERS

Back to SAP tables