SAP ABAP Table REEXC_COUNTRY (Country (T005))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_EX_CA (Package) RE: Cross Application

Basic Data

Table Category	INTTAB	Structure
Structure	REEXC_COUNTRY	Table Relationship Diagram
Short Description	Country (T005)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Countries
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
4	LANDK	☐	LANDK	LANDK	CHAR	3	0	Vehicle country key
5	LNPLZ	☐	LNPLZ_005	NUM02	NUMC	2	0	Postal code length
6	PRPLZ	☐	PRUEF_005	PR005	CHAR	1	0	Rule for the postal code field check
7	ADDRS	☐	ADDRS_005	ADDRS	CHAR	3	0	Formatting routine key for printing addresses	T005A
8	XPLZS	☐	XPLZS_005	XFELD	CHAR	1	0	Flag: Street address postal code required entry?
9	XPLPF	☐	XPLPF_005	XFELD	CHAR	1	0	Flag: PO Box postal code required?
10	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
11	XLAND	☐	XLAND_005	XLAND_005	CHAR	1	0	Country version flag
12	XADDR	☐	XADDR_005	XFELD	CHAR	1	0	Flag: Print country name in foreign addresses?
13	NMFMT	☐	NMFMT_005	AD_NAMFORM	CHAR	2	0	Standard name format	T005N
14	XREGS	☐	XREGS_005	XFELD	CHAR	1	0	Flag: City file address check
15	XPLST	☐	XPLST_005	XFELD	CHAR	1	0	Flag: Street-specific postal code? (City file)
16	INTCA	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
17	INTCA3	☐	INTCA3	INTCA3	CHAR	3	0	ISO country code 3 char
18	INTCN3	☐	INTCN3	NUM03	NUMC	3	0	ISO Country Code Numeric 3-Characters
19	XEGLD	☐	XEGLD	XFELD	CHAR	1	0	Indicator: European Union Member?
20	XSKFN	☐	XSKFN	XFELD	CHAR	1	0	Indicator: Discount base amount is the net value
21	XMWSN	☐	XMWSN	XFELD	CHAR	1	0	Indicator: Base amount for tax is net of discount ?
22	.INCLUDE	☐				0	0	Application base fields for table T005
23	LNBKN	☐	LNBKN_005	NUM02	NUMC	2	0	Bank account number length
24	PRBKN	☐	PRBKN_005	PR005	CHAR	1	0	Rule for checking bank account number field
25	LNBLZ	☐	LNBLZ_005	NUM02	NUMC	2	0	Bank number length
26	PRBLZ	☐	PRBLZ_005	PR005	CHAR	1	0	Rule for checking bank number field
27	LNPSK	☐	LNPSK_005	NUM02	NUMC	2	0	Post office bank current account number length
28	PRPSK	☐	PRPSK_005	PR005	CHAR	1	0	Rule for checking postal check account number field
29	XPRBK	☐	XPRBK_005	XFELD	CHAR	1	0	Indicator: Use check module for bank fields ?
30	BNKEY	☐	BNKEY	BNKEY	CHAR	1	0	Name of the bank key
31	LNBKS	☐	LNBKS_005	NUM02	NUMC	2	0	Length of Bank Key
32	PRBKS	☐	PRBKS_005	PR005	CHAR	1	0	Rule for checking bank key field
33	XPRSO	☐	XPRSO_005	XFELD	CHAR	1	0	Indicator: Use check module for tax fields etc. ?
34	PRUIN	☐	PRUIN_005	PR005	CHAR	1	0	Rule for checking VAT registration number field
35	UINLN	☐	UINLN	NUM02	NUMC	2	0	VAT registration number length
36	LNST1	☐	LNST1_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Numbre 1
37	PRST1	☐	PRST1_005	PR005	CHAR	1	0	Rule for checking tax code 1 field
38	LNST2	☐	LNST2_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 2
39	PRST2	☐	PRST2_005	PR005	CHAR	1	0	Rule for checking tax code 2 field
40	LNST3	☐	LNST3_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 3
41	PRST3	☐	PRST3_005	PR005	CHAR	1	0	Rule for checking tax code 3 field
42	LNST4	☐	LNST4_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 4
43	PRST4	☐	PRST4_005	PR005	CHAR	1	0	Rule for checking tax code 4 field
44	LNST5	☐	LNST5_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 5
45	PRST5	☐	PRST5_005	PR005	CHAR	1	0	Rule for checking tax code 5 field
46	.INCLUDE	☐				0	0
47	.INCLUDE	☐				0	0	HR-Specific Fields in Table T005
48	LANDD	☐	DUSTA	DUSTA	CHAR	3	0	DUEVO: Nationality	T5D4E
49	.INCLUDE	☐				0	0	Include T005, transport layer SPAY
50	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
51	.INCLUDE	☐				0	0	Table T005 Application Fields
52	LANDA	☐	LANDA	LANDA	CHAR	3	0	Alternative Country Key
53	WECHF	☐	WECHF	NUM03	NUMC	3	0	Payment period for bill of exchange
54	LKVRZ	☐	LKVRZ	CHAR7	CHAR	7	0	Short Name for Foreign Trade Statistics
55	INTCN	☐	INTCN	NUM03	NUMC	3	0	Intrastat Code
56	XDEZP	☐	XDEZP	XFELD	CHAR	1	0	Decimal point format
57	DATFM	☐	DATFM	DATFM	CHAR	1	0	Date Format
58	CURIN	☐	CURIN	WAERS	CUKY	5	0	Currency Key of the Index-Based Currency	TCURC
59	CURHA	☐	CURHA	WAERS	CUKY	5	0	Currency key of the hard currency	TCURC
60	WAERS	☐	WAERS_005	WAERS	CUKY	5	0	Country currency	TCURC
61	KURST	☐	KURST_005	KURST	CHAR	4	0	Exchange Rate Type for Translation into Country Currency	TCURV
62	AFAPL	☐	AFAPL	AFAPL	CHAR	4	0	Chart of depreciaton for asset valuation	T096
63	GWGWRT	☐	GWGWRT	WERT13	CURR	13	2	Maximum low-value asset amount
64	UMRWRT	☐	UMRWRT	WERT13	CURR	13	2	Net book value for changeover of depreciation method
65	KZRBWB	☐	KZRBWB	XFELD	CHAR	1	0	Indicator post net book value for retirement
66	XANZUM	☐	XANZUM	XFELD	CHAR	1	0	Indicator transfer down payments from previous years
67	CTNCONCEPT	☐	CTNCONCEPT	CTNCONCEPT	CHAR	4	0	Withholding tax certificate numbering: Concepts	WITH_CTNCOKEY
68	KZSRV	☐	KZSRV	XFELD	CHAR	1	0	Taxes at individual service level
69	XXINVE	☐	XXINVE	XFELD	CHAR	1	0	Indicator: Display Capital Goods Indicator?
70	.INCLU--AP	☐				0	0	Appendix to T005
71	SUREG	☐	PRQ_SUREG	PRQ_CH8	CHAR	8	0	Super region per country	TBKS
72	.INCLU--AP	☐				0	0	IS-M/SD: Append Structure
73	LANDGRP_VP	☐	LANDGRP_VP	LANDGRP_VP	CHAR	2	0	Country grouping for shipping schedule	TJG94

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REEXC_COUNTRY	ADDRS	T005A	ADDRS	REF
2	REEXC_COUNTRY	AFAPL	T096	AFAPL	REF	1	CN
3	REEXC_COUNTRY	CTNCONCEPT	WITH_CTNCOKEY	CTNCONCEPT		1	CN
4	REEXC_COUNTRY	CURHA	TCURC	WAERS	REF	1	CN
5	REEXC_COUNTRY	CURIN	TCURC	WAERS	REF	1	CN
6	REEXC_COUNTRY	KALSM	T683	KALSM	REF	C	CN
7	REEXC_COUNTRY	KURST	TCURV	KURST
8	REEXC_COUNTRY	LANDD	T5D4E	DUNAT	KEY	1	CN
9	REEXC_COUNTRY	LANDGRP_VP	TJG94	LANDGRP_VP
10	REEXC_COUNTRY	MANDT	T000	MANDT	KEY
11	REEXC_COUNTRY	NMFMT	T005N	NAMEFORMAT	REF
12	REEXC_COUNTRY	SPRAS	T002	SPRAS	REF
13	REEXC_COUNTRY	SUREG	TBKS	SUREG	REF	C	CN
14	REEXC_COUNTRY	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20131127
SAP Release Created in	500