SE11 ABAP Dictionary SE11 T005

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

T005

Countries

SAP SAP Transparent Table 59 Fields

Primary Key:

MANDT LAND1

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	LAND1	KEY	Country	CHAR	3	-	T005	Country Key
3	LANDK	-	Vehicle	CHAR	3	-	-	Vehicle country key
4	LNPLZ	-	Postal code length	NUMC	2	-	-	Postal code length
5	PRPLZ	-	Rule for the postal code field check	CHAR	1	-	-	Rule for the postal code field check
6	ADDRS	-	Formatting routine key for printing addresses	CHAR	3	-	-	Formatting routine key for printing addresses
7	XPLZS	-	Pst.cod.rq	CHAR	1	-	-	Flag: Street address postal code required entry?
8	XPLPF	-	PO Pcode	CHAR	1	-	-	Flag: PO Box postal code required?
9	SPRAS	-	Language	LANG	1	-	T002	Language Key
10	XLAND	-	Cntry vers	CHAR	1	-	-	Country version flag
11	XADDR	-	Flag: Print country name in foreign addresses?	CHAR	1	-	-	Flag: Print country name in foreign addresses?
12	NMFMT	-	Name formt	CHAR	2	-	-	Standard name format
13	XREGS	-	City file	CHAR	1	-	-	Flag: City file address check
14	XPLST	-	Street PCd	CHAR	1	-	-	Flag: Street-specific postal code? (City file)
15	INTCA	-	ISO code	CHAR	2	-	-	Country ISO code
16	INTCA3	-	ISO code3	CHAR	3	-	-	ISO country code 3 char
17	INTCN3	-	ISO CodeN3	NUMC	3	-	-	ISO Country Code Numeric 3-Characters
18	XEGLD	-	EU Country	CHAR	1	-	-	Indicator: European Union Member?
19	XSKFN	-	DiscBaseNt	CHAR	1	-	-	Indicator: Discount base amount is the net value
20	XMWSN	-	TaxBaseNet	CHAR	1	-	-	Indicator: Base amount for tax is net of discount ?
21	LNBKN	-	Bank account number length	NUMC	2	-	-	Bank account number length
22	PRBKN	-	Rule for checking bank account number field	CHAR	1	-	-	Rule for checking bank account number field
23	LNBLZ	-	Bank number length	NUMC	2	-	-	Bank number length
24	PRBLZ	-	Rule for checking bank number field	CHAR	1	-	-	Rule for checking bank number field
25	LNPSK	-	Post office bank current account number length	NUMC	2	-	-	Post office bank current account number length
26	PRPSK	-	Rule for checking postal check account number field	CHAR	1	-	-	Rule for checking postal check account number field
27	XPRBK	-	Indicator: Use check module for bank fields ?	CHAR	1	-	-	Indicator: Use check module for bank fields ?
28	BNKEY	-	Name of the bank key	CHAR	1	-	-	Name of the bank key
29	LNBKS	-	Length of Bank Key	NUMC	2	-	-	Length of Bank Key
30	PRBKS	-	Rule for checking bank key field	CHAR	1	-	-	Rule for checking bank key field
31	XPRSO	-	Indicator: Use check module for tax fields etc. ?	CHAR	1	-	-	Indicator: Use check module for tax fields etc. ?
32	PRUIN	-	VAT reg.no	CHAR	1	-	-	Rule for checking VAT registration number field
33	UINLN	-	VAT reg.no	NUMC	2	-	-	VAT registration number length
34	LNST1	-	Permitted Input Length for Tax Numbre 1	NUMC	2	-	-	Permitted Input Length for Tax Numbre 1
35	PRST1	-	Rule for checking tax code 1 field	CHAR	1	-	-	Rule for checking tax code 1 field
36	LNST2	-	Permitted Input Length for Tax Number 2	NUMC	2	-	-	Permitted Input Length for Tax Number 2
37	PRST2	-	Rule for checking tax code 2 field	CHAR	1	-	-	Rule for checking tax code 2 field
38	LANDD	-	Nat.	CHAR	3	-	-	DUEVO: Nationality
39	KALSM	-	Procedure	CHAR	6	-	-	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
40	LANDA	-	Alternative Country Key	CHAR	3	-	-	Alternative Country Key
41	WECHF	-	Payment period for bill of exchange	NUMC	3	-	-	Payment period for bill of exchange
42	LKVRZ	-	Short name	CHAR	7	-	-	Short Name for Foreign Trade Statistics
43	INTCN	-	Intra.code	NUMC	3	-	-	Intrastat Code
44	XDEZP	-	Dec.format	CHAR	1	-	-	Decimal point format
45	DATFM	-	Date form.	CHAR	1	-	-	Date Format
46	CURIN	-	Index curr	CUKY	5	-	-	Currency Key of the Index-Based Currency
47	CURHA	-	Hard curr.	CUKY	5	-	-	Currency Key of the Hard Currency
48	WAERS	-	Currency	CUKY	5	-	TCURC	Country currency
49	KURST	-	ExRateType	CHAR	4	-	-	Exchange Rate Type for Translation into Country Currency
50	AFAPL	-	Ch. of dep	CHAR	4	-	-	Chart of depreciaton for asset valuation
51	GWGWRT	-	LVA amount	CURR	13	2	-	Maximum low-value asset amount
52	UMRWRT	-	Chnge.NBV	CURR	13	2	-	Net book value for changeover of depreciation method
53	KZRBWB	-	Post NBV	CHAR	1	-	-	Indicator post net book value for retirement
54	XANZUM	-	Tran DP	CHAR	1	-	-	Indicator transfer down payments from previous years
55	CTNCONCEPT	-	Concept	CHAR	4	-	-	Withholding tax certificate numbering: Concepts
56	KZSRV	-	Srv. taxes	CHAR	1	-	-	Taxes at individual service level
57	XXINVE	-	Cap. Goods	CHAR	1	-	-	Indicator: Display Capital Goods Indicator?
58	SUREG	-	Super reg.	CHAR	8	-	-	Super region per country
59	LANDGRP_VP	-	CGrpSSch.	CHAR	2	-	-	Country grouping for shipping schedule

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk T005.

Interactive ERD Diagrams

Belum terpasang pada pin diagram ERD.

Standard T-Codes

SE11 SE16

Related Tables

T002 TCURC

ANSI SQL Query

SELECT a.LAND1,
       a.LANDK,
       a.LNPLZ,
       a.PRPLZ,
       a.ADDRS,
       a.XPLZS
FROM T005 AS a
WHERE a.LAND1 = '0001';

ABAP OpenSQL (7.40+)

SELECT a~land1,
       a~landk,
       a~lnplz,
       a~prplz,
       a~addrs,
       a~xplzs
  FROM t005 AS a
  WHERE a~land1 = '0001'
  INTO TABLE @DATA(lt_t005)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 T005

T005

Dictionary Fields Fields

Related References & SQL