SAP ABAP Table U_19036 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_19036	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key
3	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
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	XPLPF	☐	XPLPF_005	XFELD	CHAR	1	0	Flag: PO Box postal code required?
9	SPRAS1	☐	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	LANDA	☐	LANDA	LANDA	CHAR	3	0	Alternative Country Key
16	LANDD	☐	DUSTA	DUSTA	CHAR	3	0	DUEVO: Nationality	T5D4E
17	XEGLD	☐	XEGLD	XFELD	CHAR	1	0	Indicator: European Union Member?
18	LNBKN	☐	LNBKN_005	NUM02	NUMC	2	0	Bank account number length
19	PRBKN	☐	PRBKN_005	PR005	CHAR	1	0	Rule for checking bank account number field
20	LNBLZ	☐	LNBLZ_005	NUM02	NUMC	2	0	Bank number length
21	PRBLZ	☐	PRBLZ_005	PR005	CHAR	1	0	Rule for checking bank number field
22	LNPSK	☐	LNPSK_005	NUM02	NUMC	2	0	Post office bank current account number length
23	PRPSK	☐	PRPSK_005	PR005	CHAR	1	0	Rule for checking postal check account number field
24	LNST1	☐	LNST1_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Numbre 1
25	PRST1	☐	PRST1_005	PR005	CHAR	1	0	Rule for checking tax code 1 field
26	LNST2	☐	LNST2_005	NUM02	NUMC	2	0	Permitted Input Length for Tax Number 2
27	PRST2	☐	PRST2_005	PR005	CHAR	1	0	Rule for checking tax code 2 field
28	XPRBK	☐	XPRBK_005	XFELD	CHAR	1	0	Indicator: Use check module for bank fields ?
29	XPRSO	☐	XPRSO_005	XFELD	CHAR	1	0	Indicator: Use check module for tax fields etc. ?
30	WECHF	☐	WECHF	NUM03	NUMC	3	0	Payment period for bill of exchange
31	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
32	LKVRZ	☐	LKVRZ	CHAR7	CHAR	7	0	Short Name for Foreign Trade Statistics
33	UINLN	☐	UINLN	NUM02	NUMC	2	0	VAT registration number length
34	INTCA	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
35	INTCN	☐	INTCN	NUM03	NUMC	3	0	Intrastat Code
36	PRUIN	☐	PRUIN_005	PR005	CHAR	1	0	Rule for checking VAT registration number field
37	XDEZP	☐	XDEZP	XFELD	CHAR	1	0	Decimal point format
38	DATFM	☐	DATFM	DATFM	CHAR	1	0	Date Format
39	BNKEY	☐	BNKEY	BNKEY	CHAR	1	0	Name of the bank key
40	LNBKS	☐	LNBKS_005	NUM02	NUMC	2	0	Length of Bank Key
41	PRBKS	☐	PRBKS_005	PR005	CHAR	1	0	Rule for checking bank key field
42	CURIN	☐	CURIN	WAERS	CUKY	5	0	Currency Key of the Index-Based Currency	TCURC
43	CURHA	☐	CURHA	WAERS	CUKY	5	0	Currency key of the hard currency	TCURC
44	WAERS	☐	WAERS_005	WAERS	CUKY	5	0	Country currency	TCURC
45	KURST	☐	KURST_005	KURST	CHAR	4	0	Exchange Rate Type for Translation into Country Currency	TCURV
46	XSKFN	☐	XSKFN	XFELD	CHAR	1	0	Indicator: Discount base amount is the net value
47	XMWSN	☐	XMWSN	XFELD	CHAR	1	0	Indicator: Base amount for tax is net of discount ?
48	AFAPL	☐	AFAPL	AFAPL	CHAR	4	0	Chart of depreciaton for asset valuation	T096
49	GWGWRT	☐	GWGWRT	WERT13	CURR	13	2	Maximum low-value asset amount
50	UMRWRT	☐	UMRWRT	WERT13	CURR	13	2	Net book value for changeover of depreciation method
51	KZRBWB	☐	KZRBWB	XFELD	CHAR	1	0	Indicator post net book value for retirement
52	XANZUM	☐	XANZUM	XFELD	CHAR	1	0	Indicator transfer down payments from previous years
53	CTNCONCEPT	☐	CTNCONCEPT	CTNCONCEPT	CHAR	4	0	Withholding tax certificate numbering: Concepts	WITH_CTNCOKEY
54	KZSRV	☐	KZSRV	XFELD	CHAR	1	0	Taxes at individual service level
55	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
56	NATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in