SAP ABAP Table P12BOW_REC2_TEMSE_1_2009 (Rec 2, employee information, TEMSE structure)
Hierarchy
SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
   PY-BE (Application Component) Belgium
     PC12 (Package) HR accounting: Belgium
Basic Data
Table Category INTTAB    Structure 
Structure P12BOW_REC2_TEMSE_1_2009   Table Relationship Diagram
Short Description Rec 2, employee information, TEMSE structure    
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 .INCLUDE       0   0   Belgium tax declaration, Common record information  
2 BTRID BT_ID NUM1 NUMC 1   0   BELCOTAX record identification  
3 BTIYR BT_YR GJAHR NUMC 4   0   Income year  
4 BTREG BTREG NUM2 NUMC 2   0   Employer local registration  
5 BTRET BTRET NUM2 NUMC 2   0   Returns office local registration  
6 BTADM BTADM NUM10 NUMC 10   0   Employer's tax administrator reference  
7 BTNM9 PC12_BTNM9 NUM9 NUMC 9   0   BELCOTAX numeric 9 field  
8 BTCNY BTCNY NUM4 NUMC 4   0   BELCOTAX company code  
9 BTVOU P12_BTVOU P12_BTVOU NUMC 5   0   BELCOTAX voucher number  
10 BTVSQ BTVSQ NUM8 NUMC 8   0   BELCOTAX sequence number  
11 .INCLUDE       0   0   Belgium tax declaration, Rec 2, EE master data  
12 BFPER BTPER CHAR20 CHAR 20   0   BELCOTAX personnel number  
13 BFNRG BTNRG NUM11 NUMC 11   0   BELCOTAX national registration number  
14 BFBIR P12_BTBIR NUM8 NUMC 8   0   Birthday, form DDMMYYYY  
15 BFNAM BTNAM CHAR41 CHAR 41   0   BELCOTAX employee's name  
16 BFSPS BTSPS CHAR41 CHAR 41   0   BELCOTAX spouse name  
17 BFADR BTADR CHAR32 CHAR 32   0   Address  
18 BFPCD BTPCD NUM04 NUMC 4   0   Postal code for tax  
19 BFLOC BTLOC CHAR27 CHAR 27   0   Location for tax  
20 BFCTY BTCTY NUM5 NUMC 5   0   BELCOTAX country key  
21 BFMAR BTMAR NUM1 NUMC 1   0   BELCOTAX employee's marital state  
22 BFFAM BTFAM NUM2 NUMC 2   0   BELCOTAX family situation  
23 BFENF BTENF NUM2 NUMC 2   0   BELCOTAX dependent children  
24 BFOCH BTOCH NUM2 NUMC 2   0   Others in charge  
25 BFOFS BTOFS CHAR1 CHAR 1   0   BELCOTAX other family situation  
26 BFSPH BTSPH CHAR1 CHAR 1   0   Disabled partner  
27 F2025 NUM2 NUM2 NUMC 2   0   Numeric, 2-digit value  
28 BFHAN BTHAN CHAR1 CHAR 1   0   BELCOTAX employee's handicap  
29 BFLAN BTLAN NUM1 NUMC 1   0   Language key for tax  
30 BFCRC BTCRC NUM1 NUMC 1   0   BELCOTAX correction code  
31 BF325 BT325 NUM1 NUMC 1   0   BELCOTAX edit code listing 325  
32 BFBIP P12_BTBIP CHAR27 CHAR 27   0   Belcotax Employee Birth Place  
33 BFFPC BTFPC CHAR12 CHAR 12   0   BELCOTAX foreign postal code (2.012)  
34 VORSW VORSW TITEL CHAR 15   0   Name Prefix *
35 .INCLUDE       0   0   Belgium tax declaration, Tax relevant incomes  
36 F2030 P12_F2030 NUM1 NUMC 1   0   Tax declaration zone 2.030  
37 F2031 P12_F2031 NUM1 NUMC 1   0   Tax declaration zone 2.031  
38 F2032 P12_F2032 NUM1 NUMC 1   0   Tax declaration zone 2.032  
39 F2033 P12_F2033 NUM1 NUMC 1   0   Tax declaration zone 2.033  
40 F2034 P12_F2034 NUM1 NUMC 1   0   Tax declaration zone 2.034  
41 F2035 P12_F2035 NUM1 NUMC 1   0   Tax declaration zone 2.035  
42 F2036 P12_F2036 NUM1 NUMC 1   0   Tax declaration zone 2.036  
43 F2037 P12_F2037 NUM1 NUMC 1   0   Tax declaration zone 2.037  
44 F2038 P12_F2038 NUM1 NUMC 1   0   Tax declaration zone 2.038  
45 F2039 P12_F2039 NUM1 NUMC 1   0   Tax declaration zone 2.039  
46 F2040 P12_F2040 NUM1 NUMC 1   0   Tax declaration zone 2.040  
47 F2041 P12_F2041 NUM1 NUMC 1   0   Tax declaration zone 2.041  
48 F2042 P12_F2042 NUM1 NUMC 1   0   Tax declaration zone 2.042  
49 F2043 P12_F2043 NUM1 NUMC 1   0   Tax declaration zone 2.043  
50 F2044 P12_F2044 NUM1 NUMC 1   0   Tax declaration zone 2.044  
51 F2045 P12_F2045 CHAR2 CHAR 2   0   Tax declaration zone 2.045  
52 F2046 P12_F2046 CHAR2 CHAR 2   0   Tax declaration zone 2.046  
53 F2047 P12_F2047 CHAR2 CHAR 2   0   Tax declaration zone 2.047  
54 F2048 P12_F2048 CHAR2 CHAR 2   0   Tax declaration zone 2.048  
55 F2049 P12_F2049 CHAR2 CHAR 2   0   Tax declaration zone 2.049  
56 F2050 P12_F2050 CHAR2 CHAR 2   0   Tax declaration zone 2.050  
57 F2051 P12_F2051 CHAR2 CHAR 2   0   Tax declaration zone 2.051  
58 F2052 P12_F2052 CHAR2 CHAR 2   0   Tax declaration zone 2.052  
59 F2053 P12_F2053 CHAR2 CHAR 2   0   Tax declaration zone 2.053  
60 F2054 P12_F2054 CHAR2 CHAR 2   0   Tax declaration zone 2.054  
61 F2055 P12_F2055 NUM8 NUMC 8   0   Tax declaration zone 2.055, date  
62 F2056 P12_F2056 NUM8 NUMC 8   0   Tax declaration zone 2.056, date  
63 F2057 P12_F2057 NUM8 NUMC 8   0   Tax declaration zone 2.057  
64 F2058 P12_F2058 NUM8 NUMC 8   0   Tax declaration zone 2.058  
65 F2059 P12_F2059   NUMC 12   0   Tax declaration zone 2.059  
66 S2059 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
67 F2060 P12_F2060   NUMC 10   0   Tax declaration zone 2.060  
68 S2060 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
69 F2061 P12_F2061   NUMC 10   0   Tax declaration zone 2.061  
70 S2061 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
71 F2062 P12_F2062   NUMC 10   0   Tax declaration zone 2.062  
72 S2062 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
73 F2063 P12_F2063   NUMC 10   0   Tax declaration zone 2.063  
74 S2063 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
75 F2064 P12_F2064   NUMC 10   0   Tax declaration zone 2.064  
76 S2064 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
77 F2065 P12_F2065   NUMC 10   0   Tax declaration zone 2.065  
78 S2065 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
79 F2066 P12_F2066   NUMC 10   0   Tax declaration zone 2.066  
80 S2066 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
81 F2067 P12_F2067   NUMC 10   0   Tax declaration zone 2.067  
82 S2067 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
83 F2068 P12_F2068   NUMC 10   0   Tax declaration zone 2.068  
84 S2068 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
85 F2069 P12_F2069   NUMC 10   0   Tax declaration zone 2.069  
86 S2069 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
87 F2070 P12_F2070   NUMC 10   0   Tax declaration zone 2.070  
88 S2070 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
89 F2071 P12_F2071   NUMC 10   0   Tax declaration zone 2.071  
90 S2071 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
91 F2072 P12_F2072   NUMC 10   0   Tax declaration zone 2.072  
92 S2072 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
93 F2073 P12_F2073   NUMC 10   0   Tax declaration zone 2.073  
94 S2073 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
95 F2074 P12_F2074   NUMC 10   0   Tax declaration zone 2.074  
96 S2074 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
97 F2075 P12_F2075   NUMC 10   0   Tax declaration zone 2.075  
98 S2075 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
99 F2076 P12_F2076   NUMC 10   0   Tax declaration zone 2.076  
100 S2076 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
101 F2077 P12_F2077   NUMC 10   0   Tax declaration zone 2.077  
102 S2077 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
103 F2078 P12_F2078   NUMC 10   0   Tax declaration zone 2.078  
104 S2078 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
105 F2079 P12_F2079   NUMC 10   0   Tax declaration zone 2.079  
106 S2079 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
107 F2080 P12_F2080   NUMC 10   0   Tax declaration zone 2.080  
108 S2080 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
109 F2081 P12_F2081   NUMC 10   0   Tax declaration zone 2.081  
110 S2081 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
111 F2082 P12_F2082   NUMC 10   0   Tax declaration zone 2.082  
112 S2082 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
113 F2083 P12_F2083   NUMC 10   0   Tax declaration zone 2.083  
114 S2083 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
115 F2084 P12_F2084   NUMC 10   0   Tax declaration zone 2.084  
116 S2084 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
117 F2085 P12_F2085   NUMC 10   0   Tax declaration zone 2.085  
118 S2085 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
119 F2086 P12_F2086   NUMC 10   0   Tax declaration zone 2.086  
120 S2086 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
121 F2087 P12_F2087   NUMC 10   0   Tax declaration zone 2.087  
122 S2087 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
123 F2088 P12_F2088   NUMC 10   0   Tax declaration zone 2.088  
124 S2088 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
125 F2089 P12_F2089 NUM4 NUMC 4   0   Tax declaration zone 2.089  
126 F2090 P12_F2090 NUM4 NUMC 4   0   Tax declaration zone 2.090  
127 F2091 P12_F2091 NUM4 NUMC 4   0   Tax declaration zone 2.091  
128 F2092 P12_F2092 NUM4 NUMC 4   0   Tax declaration zone 2.092  
129 F2093 P12_F2093_07   NUMC 8   0   Tax declaration. Zone 2.093 numc8  
130 F2095 P12_F2095_07   NUMC 8   0   Tax declaration zone 2.095 numc8  
131 F2097 P12_F2097_07   NUMC 8   0   Tax declaration zone 2.097 numc8  
132 F2099 P12_F2099 CHAR15 CHAR 15   0   Tax declaration zone 2.099  
133 F2100 P12_F2100 CHAR15 CHAR 15   0   Tax declaration zone 2.100  
134 F2101 P12_F2101 CHAR12 CHAR 12   0   Tax declaration zone 2.101  
135 F2102 P12_F2102 CHAR41 CHAR 41   0   Tax declaration zone 2.102  
136 F2103 P12_F2103 CHAR32 CHAR 32   0   Tax declaration zone 2.103  
137 F2104 P12_F2104 NUMC4 NUMC 4   0   Tax declaration zone 2.104  
138 F2105 P12_F2105 CHAR27 CHAR 27   0   Tax declaration zone 2.105  
139 F2115 P12_F2115   NUMC 10   0   Tax declaration zone 2.115  
140 S2115 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
141 F2116 P12_F2116   NUMC 10   0   Tax declaration zone 2.116  
142 S2116 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
143 F2117 P12_F2117   NUMC 10   0   Tax declaration zone 2.117  
144 S2117 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
145 F2118 P12_F2118 NUM8 NUMC 8   0   Tax declaration zone 2.118  
146 F2107 P12_F2107 CHAR32 CHAR 32   0   Tax declaration zone 2.107  
147 F2108 P12_F2108 NUM4 NUMC 4   0   Tax declaration zone 2.108  
148 F2109 P12_F2109 CHAR27 CHAR 27   0   Tax declaration zone 2.109  
149 F2110 P12_F2110 NUM12 NUMC 12   0   Tax declaration zone 2.110  
150 F2111 P12_F2111 NUM12 NUMC 12   0   Tax declaration zone 2.111  
151 F2113 P12_F2113   NUMC 10   0   Tax declaration zone 2.113  
152 S2113 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
153 .INCLUDE       0   0   Belgium tax declaration, Tax relevant incomes ADDED for 2008  
154 F2119 P12_F2119   NUMC 10   0   Tax declaration zone 2.119  
155 S2119 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
156 F2120 P12_F2120   NUMC 10   0   Tax declaration zone 2.120  
157 S2120 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
158 F2121 P12_F2121   NUMC 10   0   Tax declaration zone 2.121  
159 S2121 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
160 F2122 P12_F2122   NUMC 10   0   Tax declaration zone 2.122  
161 S2122 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
162 F2123 P12_F2123   NUMC 10   0   Tax declaration zone 2.123  
163 S2123 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
164 F2124 P12_F2124   NUMC 10   0   Tax declaration zone 2.124  
165 S2124 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
166 F2125 P12_F2125   NUMC 10   0   Tax declaration zone 2.125  
167 S2125 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
168 F2126 P12_F2126   NUMC 10   0   Tax declaration zone 2.126  
169 S2126 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
170 F2127 P12_F2127   NUMC 10   0   Tax declaration zone 2.127  
171 S2127 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
172 F2128 P12_F2128   NUMC 10   0   Tax declaration zone 2.128  
173 S2128 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
174 F2129 P12_F2129   NUMC 10   0   Tax declaration zone 2.129  
175 S2129 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
176 F2130 P12_F2130   NUMC 10   0   Tax declaration zone 2.130  
177 S2130 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
178 F2131 P12_F2131   NUMC 10   0   Tax declaration zone 2.131  
179 S2131 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
180 F2132 P12_F2132   NUMC 10   0   Tax declaration zone 2.132  
181 S2132 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
182 F2133 P12_F2133   NUMC 10   0   Tax declaration zone 2.133  
183 S2133 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
184 F2134 P12_F2134   NUMC 10   0   Tax declaration zone 2.134  
185 S2134 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
186 F2135 P12_F2135   NUMC 10   0   Tax declaration zone 2.135  
187 S2135 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
188 F2136 P12_F2136   NUMC 10   0   Tax declaration zone 2.136  
189 S2136 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
190 F2137 P12_F2137   NUMC 10   0   Tax declaration zone 2.137  
191 S2137 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
192 F2138 P12_F2138   NUMC 10   0   Tax declaration zone 2.138  
193 S2138 BTSGN CHAR1 CHAR 1   0   Sign of the preceeding field  
194 F2139 P12_F2139   CHAR 132   0   Tax declaration zone 2.139  
195 F2140 P12_F2140   CHAR 148   0   Tax declaration zone 2.140  
196 .INCLUDE       0   0   Help structure for output.  
197 WERKS PERSA PERSA CHAR 4   0   Personnel Area *
198 BTRTL BTRTL BTRTL CHAR 4   0   Personnel Subarea *
199 PERSG PERSG PERSG CHAR 1   0   Employee Group *
200 PERSK PERSK PERSK CHAR 2   0   Employee Subgroup *
201 GSBER GSBER GSBER CHAR 4   0   Business Area *
202 ABKRS ABKRS ABKRS CHAR 2   0   Payroll Area *
203 ORGEH ORGEH ORGEH NUMC 8   0   Organizational Unit *
204 VDSK1 VDSK1 VDSK1 CHAR 14   0   Organizational Key *
205 SBMOD SBMOD CHAR4 CHAR 4   0   Administrator Group  
206 SACHP SACHP SACHA CHAR 3   0   Administrator for HR Master Data  
207 SACHZ SACHZ SACHA CHAR 3   0   Administrator for Time Recording  
208 SACHA SACHA SACHA CHAR 3   0   Payroll Administrator  
209 MSTBR MSTBR MSTBR CHAR 8   0   Supervisor Area  
210 STAT2 STAT2 STATA CHAR 1   0   Employment Status  
History
Last changed by/on SAP  20110809 
SAP Release Created in 600