	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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0257 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0257	208	1	Infotype 0257 - Annual tax calculation SK	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, TTFB13, 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, DDPN, DDPZ_PRED FROM PA0257

TOP ERP 6.0 | PA0257 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		PSK_TJAHR	Allow NULL?
25	TTJVSA	Checkbox - Perform annual tax calculation (RZD)	char	1	0	CHAR	(N' ')	Yes		PSK_TJVSA	Allow NULL?
26	TTJVSD	Period of annual tax calculation (RZD)	nvarchar	2	0	CHAR	(N' ')	Yes		PSK_TJVSD	Allow NULL?
27	TTFB5	Tax free amount - wife	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB5	Allow NULL?
28	TFB5N	Tax free months of a wife	nvarchar	2	0	NUMC	(N'00')	Yes		PSK_TFB5N	Allow NULL?
29	TTFB6	Tax free amount - wife ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB6	Allow NULL?
30	TFB6N	Tax free months of a wife	nvarchar	2	0	NUMC	(N'00')	Yes		PSK_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		PSK_TTFB7
33	TTFB8	Tax free amount - gifts	decimal	9	2	CURR	((0))	Yes		PSK_TTFB8
34	TTFB9	Tax free amount for EE	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB9	Allow NULL?
35	TTFB10	Additional modification of partial tax base	decimal	9	2	CURR	((0))	Yes		PSK_TTF10
36	TTFB11		decimal	9	0		((0))	Yes
37	TTFB12		decimal	9	0		((0))	Yes
38	TTFB13		nvarchar	25	0		(N' ')	Yes			Allow NULL?
39	TTFB101	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
40	TTFB102	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
41	TTFB103	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
42	TTFB104	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
43	TTFB105	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
44	TTFB106	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
45	TTFB107	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
46	TTFB108	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
47	TTFB109	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
48	TTFB110	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
49	TTFB111	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
50	TTFB112	Tax free amount - part disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB1	Allow NULL?
51	TTFB201	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
52	TTFB202	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
53	TTFB203	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
54	TTFB204	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
55	TTFB205	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
56	TTFB206	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
57	TTFB207	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
58	TTFB208	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
59	TTFB209	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
60	TTFB210	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
61	TTFB211	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
62	TTFB212	Tax free amount - full disability	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB2	Allow NULL?
63	TTFB301	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
64	TTFB302	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
65	TTFB303	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
66	TTFB304	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
67	TTFB305	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
68	TTFB306	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
69	TTFB307	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
70	TTFB308	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
71	TTFB309	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
72	TTFB310	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
73	TTFB311	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
74	TTFB312	Tax free amount ZTP-P	char	1	0	CHAR	(N' ')	Yes		PSK_TTFB3	Allow NULL?
75	TTFB401		char	1	0		(N' ')	Yes			Allow NULL?
76	TTFB402	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
77	TTFB403	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
78	TTFB404	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
79	TTFB405	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
80	TTFB406	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
81	TTFB407	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
82	TTFB408	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
83	TTFB409	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
84	TTFB410	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
85	TTFB411	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
86	TTFB412	Reserve	char	1	0	CHAR	(N' ')	Yes		PSK_TTFCR	Allow NULL?
87	TTKD0101	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
88	TTKD0102	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
89	TTKD0103	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
90	TTKD0104	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
91	TTKD0105	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
92	TTKD0106	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
93	TTKD0107	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
94	TTKD0108	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
95	TTKD0109	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
96	TTKD0110	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
97	TTKD0111	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
98	TTKD0112	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
99	TTKD0201	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
100	TTKD0202	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
101	TTKD0203	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
102	TTKD0204	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
103	TTKD0205	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
104	TTKD0206	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
105	TTKD0207	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
106	TTKD0208	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
107	TTKD0209	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
108	TTKD0210	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
109	TTKD0211	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
110	TTKD0212	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
111	TTKD0301	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
112	TTKD0302	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
113	TTKD0303	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
114	TTKD0304	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
115	TTKD0305	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
116	TTKD0306	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
117	TTKD0307	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
118	TTKD0308	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
119	TTKD0309	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
120	TTKD0310	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
121	TTKD0311	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
122	TTKD0312	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
123	TTKD0401	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
124	TTKD0402	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
125	TTKD0403	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
126	TTKD0404	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
127	TTKD0405	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
128	TTKD0406	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
129	TTKD0407	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
130	TTKD0408	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
131	TTKD0409	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
132	TTKD0410	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
133	TTKD0411	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
134	TTKD0412	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
135	TTKD0501	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
136	TTKD0502	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
137	TTKD0503	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
138	TTKD0504	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
139	TTKD0505	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
140	TTKD0506	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
141	TTKD0507	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
142	TTKD0508	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
143	TTKD0509	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
144	TTKD0510	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
145	TTKD0511	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
146	TTKD0512	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
147	TTKD0601	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
148	TTKD0602	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
149	TTKD0603	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
150	TTKD0604	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
151	TTKD0605	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
152	TTKD0606	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
153	TTKD0607	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
154	TTKD0608	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
155	TTKD0609	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
156	TTKD0610	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
157	TTKD0611	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
158	TTKD0612	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
159	TTKD0701	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
160	TTKD0702	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
161	TTKD0703	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
162	TTKD0704	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
163	TTKD0705	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
164	TTKD0706	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
165	TTKD0707	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
166	TTKD0708	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
167	TTKD0709	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
168	TTKD0710	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
169	TTKD0711	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
170	TTKD0712	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
171	TTKD0801	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
172	TTKD0802	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
173	TTKD0803	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
174	TTKD0804	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
175	TTKD0805	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
176	TTKD0806	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
177	TTKD0807	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
178	TTKD0808	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
179	TTKD0809	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
180	TTKD0810	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
181	TTKD0811	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
182	TTKD0812	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
183	TTKD0901	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
184	TTKD0902	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
185	TTKD0903	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
186	TTKD0904	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
187	TTKD0905	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
188	TTKD0906	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
189	TTKD0907	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
190	TTKD0908	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
191	TTKD0909	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
192	TTKD0910	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
193	TTKD0911	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
194	TTKD0912	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
195	TTKD1001	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
196	TTKD1002	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
197	TTKD1003	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
198	TTKD1004	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
199	TTKD1005	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
200	TTKD1006	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
201	TTKD1007	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
202	TTKD1008	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
203	TTKD1009	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
204	TTKD1010	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
205	TTKD1011	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
206	TTKD1012	Children tax exepmtion	nvarchar	2	0	CHAR	(N' ')	Yes	T577	PSK_KDSVH	Allow NULL?
207	DDPN		nvarchar	12	0		(N' ')	Yes			Allow NULL?
208	DDPZ_PRED		nvarchar	12	0		(N' ')	Yes			Allow NULL?

TOP ERP 6.0 | PA0257 INDEXES

Name	Primary	Unique	Type	Columns
PA0257~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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0257 TABLE

TOP ERP 6.0 | PA0257 COLUMNS

TOP ERP 6.0 | PA0257 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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0257 TABLE

TOPERP 6.0 | PA0257 COLUMNS

TOPERP 6.0 | PA0257 INDEXES

TOP ERP 6.0 | PA0257 COLUMNS

TOP ERP 6.0 | PA0257 INDEXES