SAP ABAP View U_19036 (Country)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	U_19036
Short Description	Country
Root table	T005	Countries

Entity Type	DM02L
Short text	Country

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T005	T005
2	T005T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T005	MANDT	JL	EQ				0	0
2	T005T	MANDT	JR	EQ			AND	0	0
3	T005	LAND1	JL	EQ				0	0
4	T005T	LAND1	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T005	MANDT		☐	MANDT	☐	Client
2	LAND1	T005	LAND1		☐	LAND1	☐	Country Key
3	SPRAS	T005T	SPRAS		☐	SPRAS	☐	Language Key
4	LANDK	T005	LANDK		☐	LANDK	☐	Vehicle country key
5	LNPLZ	T005	LNPLZ		☐	LNPLZ_005	☐	Postal code length
6	PRPLZ	T005	PRPLZ		☐	PRUEF_005	☐	Rule for the postal code field check
7	ADDRS	T005	ADDRS		☐	ADDRS_005	☐	Formatting routine key for printing addresses
8	XPLPF	T005	XPLPF		☐	XPLPF_005	☐	Flag: PO Box postal code required?
9	SPRAS1	T005	SPRAS		☐	SPRAS	☐	Language Key
10	XLAND	T005	XLAND		☐	XLAND_005	☐	Country version flag
11	XADDR	T005	XADDR		☐	XADDR_005	☐	Flag: Print country name in foreign addresses?
12	NMFMT	T005	NMFMT		☐	NMFMT_005	☐	Standard name format
13	XREGS	T005	XREGS		☐	XREGS_005	☐	Flag: City file address check
14	XPLST	T005	XPLST		☐	XPLST_005	☐	Flag: Street-specific postal code? (City file)
15	LANDA	T005	LANDA		☐	LANDA	☐	Alternative Country Key
16	LANDD	T005	LANDD		☐	DUSTA	☐	DUEVO: Nationality
17	XEGLD	T005	XEGLD		☐	XEGLD	☐	Indicator: European Union Member?
18	LNBKN	T005	LNBKN		☐	LNBKN_005	☐	Bank account number length
19	PRBKN	T005	PRBKN		☐	PRBKN_005	☐	Rule for checking bank account number field
20	LNBLZ	T005	LNBLZ		☐	LNBLZ_005	☐	Bank number length
21	PRBLZ	T005	PRBLZ		☐	PRBLZ_005	☐	Rule for checking bank number field
22	LNPSK	T005	LNPSK		☐	LNPSK_005	☐	Post office bank current account number length
23	PRPSK	T005	PRPSK		☐	PRPSK_005	☐	Rule for checking postal check account number field
24	LNST1	T005	LNST1		☐	LNST1_005	☐	Permitted Input Length for Tax Numbre 1
25	PRST1	T005	PRST1		☐	PRST1_005	☐	Rule for checking tax code 1 field
26	LNST2	T005	LNST2		☐	LNST2_005	☐	Permitted Input Length for Tax Number 2
27	PRST2	T005	PRST2		☐	PRST2_005	☐	Rule for checking tax code 2 field
28	XPRBK	T005	XPRBK		☐	XPRBK_005	☐	Indicator: Use check module for bank fields ?
29	XPRSO	T005	XPRSO		☐	XPRSO_005	☐	Indicator: Use check module for tax fields etc. ?
30	WECHF	T005	WECHF		☐	WECHF	☐	Payment period for bill of exchange
31	KALSM	T005	KALSM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
32	LKVRZ	T005	LKVRZ		☐	LKVRZ	☐	Short Name for Foreign Trade Statistics
33	UINLN	T005	UINLN		☐	UINLN	☐	VAT registration number length
34	INTCA	T005	INTCA		☐	INTCA	☐	Country ISO code
35	INTCN	T005	INTCN		☐	INTCN	☐	Intrastat Code
36	PRUIN	T005	PRUIN		☐	PRUIN_005	☐	Rule for checking VAT registration number field
37	XDEZP	T005	XDEZP		☐	XDEZP	☐	Decimal point format
38	DATFM	T005	DATFM		☐	DATFM	☐	Date Format
39	BNKEY	T005	BNKEY		☐	BNKEY	☐	Name of the bank key
40	LNBKS	T005	LNBKS		☐	LNBKS_005	☐	Length of Bank Key
41	PRBKS	T005	PRBKS		☐	PRBKS_005	☐	Rule for checking bank key field
42	CURIN	T005	CURIN		☐	CURIN	☐	Currency Key of the Index-Based Currency
43	CURHA	T005	CURHA		☐	CURHA	☐	Currency key of the hard currency
44	WAERS	T005	WAERS		☐	WAERS_005	☐	Country currency
45	KURST	T005	KURST		☐	KURST_005	☐	Exchange Rate Type for Translation into Country Currency
46	XSKFN	T005	XSKFN		☐	XSKFN	☐	Indicator: Discount base amount is the net value
47	XMWSN	T005	XMWSN		☐	XMWSN	☐	Indicator: Base amount for tax is net of discount ?
48	AFAPL	T005	AFAPL		☐	AFAPL	☐	Chart of depreciaton for asset valuation
49	GWGWRT	T005	GWGWRT		☐	GWGWRT	☐	Maximum low-value asset amount
50	UMRWRT	T005	UMRWRT		☐	UMRWRT	☐	Net book value for changeover of depreciation method
51	KZRBWB	T005	KZRBWB		☐	KZRBWB	☐	Indicator post net book value for retirement
52	XANZUM	T005	XANZUM		☐	XANZUM	☐	Indicator transfer down payments from previous years
53	CTNCONCEPT	T005	CTNCONCEPT		☐	CTNCONCEPT	☐	Withholding tax certificate numbering: Concepts
54	KZSRV	T005	KZSRV		☐	KZSRV	☐	Taxes at individual service level
55	LANDX	T005T	LANDX		☐	LANDX	☐	Country Name
56	NATIO	T005T	NATIO		☐	NATIO	☐	Nationality

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20140121
SAP Release Created in