	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

233 COLUMNS | 1 INDEXES | ERP 6.0 | PA0245 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0245	233	1	Infotype 0245 - Annual tax calculation CZ	Personnel Administration

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, TTJJ, TTJVSA, TTJVSD, TTFB5, TFB5N, TTFB6, TFB6N, WAERS, TTFB7, TTFB8, TTFB9, TTFB10, TTFB11, TTFB12, TTFB101, TTFB102, TTFB103, TTFB104, TTFB105, TTFB106, TTFB107, TTFB108, TTFB109, TTFB110, TTFB111, TTFB112, TTFB201, TTFB202, TTFB203, TTFB204, TTFB205, TTFB206, TTFB207, TTFB208, TTFB209, TTFB210, TTFB211, TTFB212, TTFB301, TTFB302, TTFB303, TTFB304, TTFB305, TTFB306, TTFB307, TTFB308, TTFB309, TTFB310, TTFB311, TTFB312, TTFB401, TTFB402, TTFB403, TTFB404, TTFB405, TTFB406, TTFB407, TTFB408, TTFB409, TTFB410, TTFB411, TTFB412, TTKD0101, TTKD0102, TTKD0103, TTKD0104, TTKD0105, TTKD0106, TTKD0107, TTKD0108, TTKD0109, TTKD0110, TTKD0111, TTKD0112, TTKD0201, TTKD0202, TTKD0203, TTKD0204, TTKD0205, TTKD0206, TTKD0207, TTKD0208, TTKD0209, TTKD0210, TTKD0211, TTKD0212, TTKD0301, TTKD0302, TTKD0303, TTKD0304, TTKD0305, TTKD0306, TTKD0307, TTKD0308, TTKD0309, TTKD0310, TTKD0311, TTKD0312, TTKD0401, TTKD0402, TTKD0403, TTKD0404, TTKD0405, TTKD0406, TTKD0407, TTKD0408, TTKD0409, TTKD0410, TTKD0411, TTKD0412, TTKD0501, TTKD0502, TTKD0503, TTKD0504, TTKD0505, TTKD0506, TTKD0507, TTKD0508, TTKD0509, TTKD0510, TTKD0511, TTKD0512, TTKD0601, TTKD0602, TTKD0603, TTKD0604, TTKD0605, TTKD0606, TTKD0607, TTKD0608, TTKD0609, TTKD0610, TTKD0611, TTKD0612, TTKD0701, TTKD0702, TTKD0703, TTKD0704, TTKD0705, TTKD0706, TTKD0707, TTKD0708, TTKD0709, TTKD0710, TTKD0711, TTKD0712, TTKD0801, TTKD0802, TTKD0803, TTKD0804, TTKD0805, TTKD0806, TTKD0807, TTKD0808, TTKD0809, TTKD0810, TTKD0811, TTKD0812, TTKD0901, TTKD0902, TTKD0903, TTKD0904, TTKD0905, TTKD0906, TTKD0907, TTKD0908, TTKD0909, TTKD0910, TTKD0911, TTKD0912, TTKD1001, TTKD1002, TTKD1003, TTKD1004, TTKD1005, TTKD1006, TTKD1007, TTKD1008, TTKD1009, TTKD1010, TTKD1011, TTKD1012, TTKD01SU, TTKD02SU, TTKD03SU, TTKD04SU, TTKD05SU, TTKD06SU, TTKD07SU, TTKD08SU, TTKD09SU, TTKD10SU, TTKD01OB, TTKD02OB, TTKD03OB, TTKD04OB, TTKD05OB, TTKD06OB, TTKD07OB, TTKD08OB, TTKD09OB, TTKD10OB, TTFB13, TFB14N, TTFB14, TTFB15, TTFB16, TTFB17, TTFB19, TTFB19N FROM PA0245

TOP ERP 6.0 | PA0245 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	TTJJ	Year for annual tax calculation	nvarchar	4	0	NUMC	(N'0000')	Yes		P18_TJAHR	Allow NULL?
25	TTJVSA	Checkbox - Perform annual tax calculation (RZD)	char	1	0	CHAR	(N' ')	Yes		P18_TJVSA	Allow NULL?
26	TTJVSD	Period of annual tax calculation (RZD)	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TJVSD	Allow NULL?
27	TTFB5	Tax free amount - wife	char	1	0	CHAR	(N' ')	Yes		P18_TTFB5	Allow NULL?
28	TFB5N	Tax free months of a wife	nvarchar	2	0	NUMC	(N'00')	Yes		P18_TFB5N	Allow NULL?
29	TTFB6	Tax free amount - wife ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB6	Allow NULL?
30	TFB6N	Tax free months of a wife	nvarchar	2	0	NUMC	(N'00')	Yes		P18_TFB5N	Allow NULL?
31	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
32	TTFB7	Tax free amount - pensioners	decimal	9	2	CURR	((0))	Yes		P18_TTFB7
33	TTFB8	Tax free amount - gifts	decimal	9	2	CURR	((0))	Yes		P18_TTFB8
34	TTFB9	Tax free amount for EE	char	1	0	CHAR	(N' ')	Yes		P18_TTFB9	Allow NULL?
35	TTFB10	Inerests of mortgages	decimal	9	2	CURR	((0))	Yes		P18_TTF10
36	TTFB11	Supplementary pension insuracne	decimal	9	2	CURR	((0))	Yes		P18_TTF11
37	TTFB12	Private Life Insurance	decimal	9	2	CURR	((0))	Yes		P18_TTF12
38	TTFB101	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
39	TTFB102	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
40	TTFB103	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
41	TTFB104	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
42	TTFB105	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
43	TTFB106	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
44	TTFB107	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
45	TTFB108	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
46	TTFB109	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
47	TTFB110	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
48	TTFB111	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
49	TTFB112	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB1	Allow NULL?
50	TTFB201	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
51	TTFB202	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
52	TTFB203	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
53	TTFB204	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
54	TTFB205	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
55	TTFB206	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
56	TTFB207	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
57	TTFB208	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
58	TTFB209	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
59	TTFB210	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
60	TTFB211	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
61	TTFB212	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	CHAR	(N' ')	Yes		P18_TTFB2	Allow NULL?
62	TTFB301	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
63	TTFB302	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
64	TTFB303	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
65	TTFB304	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
66	TTFB305	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
67	TTFB306	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
68	TTFB307	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
69	TTFB308	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
70	TTFB309	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
71	TTFB310	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
72	TTFB311	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
73	TTFB312	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		P18_TTFB3	Allow NULL?
74	TTFB401	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
75	TTFB402	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
76	TTFB403	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
77	TTFB404	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
78	TTFB405	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
79	TTFB406	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
80	TTFB407	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
81	TTFB408	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
82	TTFB409	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
83	TTFB410	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
84	TTFB411	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
85	TTFB412	Tax free amount - studet	char	1	0	CHAR	(N' ')	Yes		P18_TTFB4	Allow NULL?
86	TTKD0101	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
87	TTKD0102	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
88	TTKD0103	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
89	TTKD0104	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
90	TTKD0105	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
91	TTKD0106	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
92	TTKD0107	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
93	TTKD0108	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
94	TTKD0109	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
95	TTKD0110	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
96	TTKD0111	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
97	TTKD0112	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
98	TTKD0201	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
99	TTKD0202	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
100	TTKD0203	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
101	TTKD0204	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
102	TTKD0205	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
103	TTKD0206	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
104	TTKD0207	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
105	TTKD0208	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
106	TTKD0209	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
107	TTKD0210	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
108	TTKD0211	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
109	TTKD0212	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
110	TTKD0301	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
111	TTKD0302	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
112	TTKD0303	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
113	TTKD0304	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
114	TTKD0305	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
115	TTKD0306	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
116	TTKD0307	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
117	TTKD0308	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
118	TTKD0309	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
119	TTKD0310	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
120	TTKD0311	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
121	TTKD0312	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
122	TTKD0401	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
123	TTKD0402	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
124	TTKD0403	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
125	TTKD0404	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
126	TTKD0405	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
127	TTKD0406	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
128	TTKD0407	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
129	TTKD0408	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
130	TTKD0409	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
131	TTKD0410	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
132	TTKD0411	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
133	TTKD0412	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
134	TTKD0501	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
135	TTKD0502	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
136	TTKD0503	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
137	TTKD0504	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
138	TTKD0505	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
139	TTKD0506	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
140	TTKD0507	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
141	TTKD0508	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
142	TTKD0509	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
143	TTKD0510	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
144	TTKD0511	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
145	TTKD0512	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
146	TTKD0601	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
147	TTKD0602	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
148	TTKD0603	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
149	TTKD0604	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
150	TTKD0605	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
151	TTKD0606	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
152	TTKD0607	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
153	TTKD0608	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
154	TTKD0609	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
155	TTKD0610	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
156	TTKD0611	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
157	TTKD0612	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
158	TTKD0701	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
159	TTKD0702	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
160	TTKD0703	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
161	TTKD0704	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
162	TTKD0705	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
163	TTKD0706	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
164	TTKD0707	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
165	TTKD0708	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
166	TTKD0709	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
167	TTKD0710	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
168	TTKD0711	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
169	TTKD0712	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
170	TTKD0801	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
171	TTKD0802	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
172	TTKD0803	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
173	TTKD0804	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
174	TTKD0805	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
175	TTKD0806	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
176	TTKD0807	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
177	TTKD0808	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
178	TTKD0809	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
179	TTKD0810	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
180	TTKD0811	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
181	TTKD0812	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
182	TTKD0901	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
183	TTKD0902	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
184	TTKD0903	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
185	TTKD0904	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
186	TTKD0905	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
187	TTKD0906	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
188	TTKD0907	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
189	TTKD0908	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
190	TTKD0909	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
191	TTKD0910	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
192	TTKD0911	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
193	TTKD0912	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
194	TTKD1001	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
195	TTKD1002	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
196	TTKD1003	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
197	TTKD1004	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
198	TTKD1005	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
199	TTKD1006	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
200	TTKD1007	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
201	TTKD1008	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
202	TTKD1009	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
203	TTKD1010	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
204	TTKD1011	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
205	TTKD1012	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	P18_KDSVH	Allow NULL?
206	TTKD01SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
207	TTKD02SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
208	TTKD03SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
209	TTKD04SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
210	TTKD05SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
211	TTKD06SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
212	TTKD07SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
213	TTKD08SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
214	TTKD09SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
215	TTKD10SU	Subtype IT0021 for IT0245	nvarchar	2	0	CHAR	(N' ')	Yes		P18_TTKSU	Allow NULL?
216	TTKD01OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
217	TTKD02OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
218	TTKD03OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
219	TTKD04OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
220	TTKD05OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
221	TTKD06OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
222	TTKD07OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
223	TTKD08OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
224	TTKD09OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
225	TTKD10OB	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
226	TTFB13	Non tax - flood gifts	decimal	9	2	CURR	((0))	Yes		P18_TTF13
227	TFB14N	Tax-free - Trade union fees	decimal	9	2	CURR	((0))	Yes		P18_TF14N
228	TTFB14	Tax-free - Trade union fees	char	1	0	CHAR	(N' ')	Yes		P18_TTF14	Allow NULL?
229	TTFB15		decimal	9	0		((0))	Yes
230	TTFB16		decimal	9	0		((0))	Yes
231	TTFB17		decimal	9	0		((0))	Yes
232	TTFB19	Discount for child placement	decimal	9	2	CURR	((0))	Yes		P18_TTF19
233	TTFB19N	Number of children with relief for child placement	nvarchar	2	0	NUMC	(N'00')	Yes		P18_TTF19N	Allow NULL?

TOP ERP 6.0 | PA0245 INDEXES

Name	Primary	Unique	Type	Columns
PA0245~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

233 COLUMNS | 1 INDEXES | ERP 6.0 | PA0245 TABLE

TOP ERP 6.0 | PA0245 COLUMNS

TOP ERP 6.0 | PA0245 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

233 COLUMNS | 1 INDEXES | ERP 6.0 | PA0245 TABLE

TOPERP 6.0 | PA0245 COLUMNS

TOPERP 6.0 | PA0245 INDEXES

TOP ERP 6.0 | PA0245 COLUMNS

TOP ERP 6.0 | PA0245 INDEXES