SAP ABAP Table SMOT005 (Countries)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	*
2	SFAT005	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
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	*
8	XPLPF	☐	XPLPF_005	XFELD	CHAR	1	0	Flag: PO Box postal code required?
9	SPRAS	☐	SMO_LANGU	SMO_LANGU	CHAR	2	0	Language
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	*
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	LNBKN	☐	SMO3LNBKN	NUM02	NUMC	2	0	Bank account number length
17	PRBKN	☐	SMO3PRBKN	PR005	CHAR	1	0	Rule for checking bank account number field
18	LNBLZ	☐	SMO3LNBLZ	NUM02	NUMC	2	0	Bank number length
19	PRBLZ	☐	SMO3PRBLZ	PR005	CHAR	1	0	Rule for checking bank number field
20	LNPSK	☐	SMO3LNPSK	NUM02	NUMC	2	0	Post office bank current account number length
21	PRPSK	☐	SMO3PRPSK	PR005	CHAR	1	0	Rule for checking postal check account number field
22	XPRBK	☐	SMO3XPRBK	XFELD	CHAR	1	0	Indicator: Use check module for bank fields ?
23	BNKEY	☐	SMO3BNKEY	SMO3BNKEY	CHAR	1	0	Name of the bank key
24	LNBKS	☐	SMO3LNBKS	NUM02	NUMC	2	0	Length of the bank key
25	PRBKS	☐	SMO3PRBKS	PR005	CHAR	1	0	Rule for checking bank key field
26	XPRSO	☐	SMO3XPRSO	XFELD	CHAR	1	0	Indicator: Use check module for tax fields etc. ?
27	PRUIN	☐	SMO3PRUIN	PR005	CHAR	1	0	Rule for checking VAT registration number field
28	UINLN	☐	SMO3UINLN	NUM02	NUMC	2	0	VAT registration number length
29	LNST1	☐	SMO3LNST1	NUM02	NUMC	2	0	Permitted input length for tax code 1
30	PRST1	☐	SMO3PRST1	PR005	CHAR	1	0	Rule for checking tax code 1 field
31	LNST2	☐	SMO3LNST2	NUM02	NUMC	2	0	Permitted input length for tax code 2
32	PRST2	☐	SMO3PRST2	PR005	CHAR	1	0	Rule for checking tax code 2 field
33	LANDA	☐	SMO3LANDA	SMO3LANDA	CHAR	3	0	Alternative country key
34	LANDD	☐	SMO3DUSTA	SMO3DUSTA	CHAR	3	0	DUEVO: Nationality
35	XEGLD	☐	SMO3XEGLD	XFELD	CHAR	1	0	Indicator: European Union member ?
36	WECHF	☐	SMO3WECHF	NUM03	NUMC	3	0	Payment period for bill of exchange
37	KALSM	☐	SMO3KALSM3	SMO3KALSM	CHAR	6	0	Procedure (pricing, output control, acct. det., costing,...)
38	LKVRZ	☐	SMO3LKVRZ	CHAR7	CHAR	7	0	Short name for foreign trade statistics
39	INTCN	☐	SMO3INTCN	NUM03	NUMC	3	0	Intrastat code
40	XDEZP	☐	SMO3XDEZP	XFELD	CHAR	1	0	Decimal point format
41	DATFM	☐	SMO3DATFM	SMO3DATFM	CHAR	1	0	Date format
42	CURIN	☐	SMO3CURIN	WAERS	CUKY	5	0	Currency key of the index-based currency	*
43	CURHA	☐	SMO3CURHA	WAERS	CUKY	5	0	Currency key of the hard currency	*
44	WAERS	☐	SMO3WAERS1	WAERS	CUKY	5	0	Country currency	*
45	KURST	☐	SMO3KURST1	KURST	CHAR	4	0	Exchange rate type for translation into country currency	*
46	XSKFN	☐	SMO3XSKFN	XFELD	CHAR	1	0	Indicator: Discount base amount is the net value
47	XMWSN	☐	SMO3XMWSN	XFELD	CHAR	1	0	Indicator: Base amount for tax is net of discount ?
48	AFAPL	☐	SMO3AFAPL	SMO3AFAPL	CHAR	4	0	Chart of depreciaton for asset valuation
49	GWGWRT	☐	SMO_GWGWRT	SMO_CURRCY	CURR	28	9	Maximum Low Value Asset Amount
50	UMRWRT	☐	SMO_UMRWRT	SMO_CURRCY	CURR	28	9	Remaining Value for Changeover of Depreciation Method
51	KZRBWB	☐	SMO3KZRBW	XFELD	CHAR	1	0	Indicator post net book value for retirement
52	XANZUM	☐	SMO3XANZU	XFELD	CHAR	1	0	Indicator transfer down payments from previous years
53	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
54	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
55	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
56	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
57	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
58	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
59	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
60	XPLZS	☐	XPLZS_005	XFELD	CHAR	1	0	Flag: Street address postal code required entry?

History

Last changed by/on	SAP	20130604
SAP Release Created in