SAP ABAP Table T005 (Countries)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
     ⤷ SZAD (Package) SAP Technology - Business Services: Address Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T005	Table Relationship Diagram
Short Description	Countries

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key
3	LANDK	☐	LANDK	LANDK	CHAR	3	0	Vehicle country key
4	LNPLZ	☐	LNPLZ_005	NUM02	NUMC	2	0	Postal code length
5	PRPLZ	☐	PRUEF_005	PR005	CHAR	1	0	Rule for the postal code field check
6	ADDRS	☐	ADDRS_005	ADDRS	CHAR	3	0	Formatting routine key for printing addresses	T005A
7	XPLZS	☐	XPLZS_005	XFELD	CHAR	1	0	Flag: Street address postal code required entry?
8	XPLPF	☐	XPLPF_005	XFELD	CHAR	1	0	Flag: PO Box postal code required?
9	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
10	XLAND	☐	XLAND_005	XLAND_005	CHAR	1	0	Country version flag
11	XADDR	☐	XADDR_005	XFELD	CHAR	1	0	Flag: Print country name in foreign addresses?
12	NMFMT	☐	NMFMT_005	AD_NAMFORM	CHAR	2	0	Standard name format	T005N
13	XREGS	☐	XREGS_005	XFELD	CHAR	1	0	Flag: City file address check
14	XPLST	☐	XPLST_005	XFELD	CHAR	1	0	Flag: Street-specific postal code? (City file)
15	INTCA	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
16	INTCA3	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
17	INTCN3	☐	INTCN3	NUM03	NUMC	3	0	ISO Country Code Numeric 3-Characters
18	XEGLD	☐	XEGLD	XFELD	CHAR	1	0	Indicator: European Union Member?
19	XSKFN	☐	XSKFN	XFELD	CHAR	1	0	Indicator: Discount base amount is the net value
20	XMWSN	☐	XMWSN	XFELD	CHAR	1	0	Indicator: Base amount for tax is net of discount ?
21	.INCLUDE	☐				0	0	Application base fields for table T005
22	LNBKN	☐	LNBKN_005	NUM02	NUMC	2	0	Bank account number length
23	PRBKN	☐	PRBKN_005	PR005	CHAR	1	0	Rule for checking bank account number field
24	LNBLZ	☐	LNBLZ_005	NUM02	NUMC	2	0	Bank number length
25	PRBLZ	☐	PRBLZ_005	PR005	CHAR	1	0	Rule for checking bank number field
26	LNPSK	☐	LNPSK_005	NUM02	NUMC	2	0	Post office bank current account number length
27	PRPSK	☐	PRPSK_005	PR005	CHAR	1	0	Rule for checking postal check account number field
28	XPRBK	☐	XPRBK_005	XFELD	CHAR	1	0	Indicator: Use check module for bank fields ?
29	BNKEY	☐	BNKEY	BNKEY	CHAR	1	0	Name of the bank key
30	LNBKS	☐	LNBKS_005	NUM02	NUMC	2	0	Length of Bank Key
31	PRBKS	☐	PRBKS_005	PR005	CHAR	1	0	Rule for checking bank key field
32	XPRSO	☐	XPRSO_005	XFELD	CHAR	1	0	Indicator: Use check module for tax fields etc. ?
33	PRUIN	☐	PRUIN_005	PR005	CHAR	1	0	Rule for checking VAT registration number field
34	UINLN	☐	UINLN	NUM02	NUMC	2	0	VAT registration number length
35	LNST1	☐	LNST1_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Numbre 1
36	PRST1	☐	PRST1_005	PR005	CHAR	1	0	Rule for checking tax code 1 field
37	LNST2	☐	LNST2_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 2
38	PRST2	☐	PRST2_005	PR005	CHAR	1	0	Rule for checking tax code 2 field
39	LNST3	☐	LNST3_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 3
40	PRST3	☐	PRST3_005	PR005	CHAR	1	0	Rule for checking tax code 3 field
41	LNST4	☐	LNST4_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 4
42	PRST4	☐	PRST4_005	PR005	CHAR	1	0	Rule for checking tax code 4 field
43	LNST5	☐	LNST5_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 5
44	PRST5	☐	PRST5_005	PR005	CHAR	1	0	Rule for checking tax code 5 field
45	.INCLUDE	☐				0	0
46	.INCLUDE	☐				0	0	HR-Specific Fields in Table T005
47	.INCLUDE	☐				0	0	Include T005, transport layer SPAY
48	.INCLUDE	☐				0	0	Table T005 Application Fields

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T005	ADDRS	T005A	ADDRS	REF
2	T005	MANDT	T000	MANDT	KEY
3	T005	NMFMT	T005N	NAMEFORMAT	REF
4	T005	SPRAS	T002	SPRAS	REF

History

Last changed by/on	SAP	20131122
SAP Release Created in