SAP ABAP Table P12BOW_T_XMLREC2_1_2009 (Belgium Tax declaration, record 2, employee information)
Hierarchy
☛
SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
⤷ PY-BE (Application Component) Belgium
⤷ PC12 (Package) HR accounting: Belgium
⤷ PY-BE (Application Component) Belgium
⤷ PC12 (Package) HR accounting: Belgium
Basic Data
Table Category | INTTAB | Structure |
Structure | P12BOW_T_XMLREC2_1_2009 | Table Relationship Diagram |
Short Description | Belgium Tax declaration, record 2, employee information |
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 | SECTN | P_99S_SECTN | P_99S_SECTN | CHAR | 4 | 0 | SAP Section Code | ||
2 | .INCLUDE | 0 | 0 | Belgium Tax declaration, record 2, employee information | |||||
3 | .INCLUDE | 0 | 0 | Belgium tax declaration, Common record information | |||||
4 | BTRID | BT_ID | NUM1 | NUMC | 1 | 0 | BELCOTAX record identification | ||
5 | BTIYR | BT_YR | GJAHR | NUMC | 4 | 0 | Income year | ||
6 | BTREG | BTREG | NUM2 | NUMC | 2 | 0 | Employer local registration | ||
7 | BTRET | BTRET | NUM2 | NUMC | 2 | 0 | Returns office local registration | ||
8 | BTADM | BTADM | NUM10 | NUMC | 10 | 0 | Employer's tax administrator reference | ||
9 | BTNM9 | PC12_BTNM9 | NUM9 | NUMC | 9 | 0 | BELCOTAX numeric 9 field | ||
10 | BTCNY | BTCNY | NUM4 | NUMC | 4 | 0 | BELCOTAX company code | ||
11 | BTVOU | P12_BTVOU | P12_BTVOU | NUMC | 5 | 0 | BELCOTAX voucher number | ||
12 | BTVSQ | BTVSQ | NUM8 | NUMC | 8 | 0 | BELCOTAX sequence number | ||
13 | .INCLUDE | 0 | 0 | Belgium tax declaration, Rec 2, EE master data | |||||
14 | BFPER | BTPER | CHAR20 | CHAR | 20 | 0 | BELCOTAX personnel number | ||
15 | BFNRG | BTNRG | NUM11 | NUMC | 11 | 0 | BELCOTAX national registration number | ||
16 | BFBIR | P12_BTBIR | NUM8 | NUMC | 8 | 0 | Birthday, form DDMMYYYY | ||
17 | BFNAM | BTNAM | CHAR41 | CHAR | 41 | 0 | BELCOTAX employee's name | ||
18 | BFSPS | BTSPS | CHAR41 | CHAR | 41 | 0 | BELCOTAX spouse name | ||
19 | BFADR | BTADR | CHAR32 | CHAR | 32 | 0 | Address | ||
20 | BFPCD | BTPCD | NUM04 | NUMC | 4 | 0 | Postal code for tax | ||
21 | BFLOC | BTLOC | CHAR27 | CHAR | 27 | 0 | Location for tax | ||
22 | BFCTY | BTCTY | NUM5 | NUMC | 5 | 0 | BELCOTAX country key | ||
23 | BFMAR | BTMAR | NUM1 | NUMC | 1 | 0 | BELCOTAX employee's marital state | ||
24 | BFFAM | BTFAM | NUM2 | NUMC | 2 | 0 | BELCOTAX family situation | ||
25 | BFENF | BTENF | NUM2 | NUMC | 2 | 0 | BELCOTAX dependent children | ||
26 | BFOCH | BTOCH | NUM2 | NUMC | 2 | 0 | Others in charge | ||
27 | BFOFS | BTOFS | CHAR1 | CHAR | 1 | 0 | BELCOTAX other family situation | ||
28 | BFSPH | BTSPH | CHAR1 | CHAR | 1 | 0 | Disabled partner | ||
29 | F2025 | NUM2 | NUM2 | NUMC | 2 | 0 | Numeric, 2-digit value | ||
30 | BFHAN | BTHAN | CHAR1 | CHAR | 1 | 0 | BELCOTAX employee's handicap | ||
31 | BFLAN | BTLAN | NUM1 | NUMC | 1 | 0 | Language key for tax | ||
32 | BFCRC | BTCRC | NUM1 | NUMC | 1 | 0 | BELCOTAX correction code | ||
33 | BF325 | BT325 | NUM1 | NUMC | 1 | 0 | BELCOTAX edit code listing 325 | ||
34 | BFBIP | P12_BTBIP | CHAR27 | CHAR | 27 | 0 | Belcotax Employee Birth Place | ||
35 | BFFPC | BTFPC | CHAR12 | CHAR | 12 | 0 | BELCOTAX foreign postal code (2.012) | ||
36 | VORSW | VORSW | TITEL | CHAR | 15 | 0 | Name Prefix | * | |
37 | .INCLUDE | 0 | 0 | Belgium tax declaration, Tax relevant incomes | |||||
38 | F2030 | P12_F2030 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.030 | ||
39 | F2031 | P12_F2031 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.031 | ||
40 | F2032 | P12_F2032 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.032 | ||
41 | F2033 | P12_F2033 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.033 | ||
42 | F2034 | P12_F2034 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.034 | ||
43 | F2035 | P12_F2035 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.035 | ||
44 | F2036 | P12_F2036 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.036 | ||
45 | F2037 | P12_F2037 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.037 | ||
46 | F2038 | P12_F2038 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.038 | ||
47 | F2039 | P12_F2039 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.039 | ||
48 | F2040 | P12_F2040 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.040 | ||
49 | F2041 | P12_F2041 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.041 | ||
50 | F2042 | P12_F2042 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.042 | ||
51 | F2043 | P12_F2043 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.043 | ||
52 | F2044 | P12_F2044 | NUM1 | NUMC | 1 | 0 | Tax declaration zone 2.044 | ||
53 | F2045 | P12_F2045 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.045 | ||
54 | F2046 | P12_F2046 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.046 | ||
55 | F2047 | P12_F2047 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.047 | ||
56 | F2048 | P12_F2048 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.048 | ||
57 | F2049 | P12_F2049 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.049 | ||
58 | F2050 | P12_F2050 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.050 | ||
59 | F2051 | P12_F2051 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.051 | ||
60 | F2052 | P12_F2052 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.052 | ||
61 | F2053 | P12_F2053 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.053 | ||
62 | F2054 | P12_F2054 | CHAR2 | CHAR | 2 | 0 | Tax declaration zone 2.054 | ||
63 | F2055 | P12_F2055 | NUM8 | NUMC | 8 | 0 | Tax declaration zone 2.055, date | ||
64 | F2056 | P12_F2056 | NUM8 | NUMC | 8 | 0 | Tax declaration zone 2.056, date | ||
65 | F2057 | P12_F2057 | NUM8 | NUMC | 8 | 0 | Tax declaration zone 2.057 | ||
66 | F2058 | P12_F2058 | NUM8 | NUMC | 8 | 0 | Tax declaration zone 2.058 | ||
67 | F2059 | P12_V2059 | CHAR | 13 | 0 | Tax declaration zone 2.059 | |||
68 | F2060 | P12_V2060 | CHAR | 11 | 0 | Tax declaration zone 2.060 | |||
69 | F2061 | P12_V2061 | CHAR | 11 | 0 | Tax declaration zone 2.061 | |||
70 | F2062 | P12_V2062 | CHAR | 11 | 0 | Tax declaration zone 2.062 | |||
71 | F2063 | P12_V2063 | CHAR | 11 | 0 | Tax declaration zone 2.063 | |||
72 | F2064 | P12_V2064 | CHAR | 11 | 0 | Tax declaration zone 2.064 | |||
73 | F2065 | P12_V2065 | CHAR | 11 | 0 | Tax declaration zone 2.065 | |||
74 | F2066 | P12_V2066 | CHAR | 11 | 0 | Tax declaration zone 2.066 | |||
75 | F2067 | P12_V2067 | CHAR | 11 | 0 | Tax declaration zone 2.067 | |||
76 | F2068 | P12_V2068 | CHAR | 11 | 0 | Tax declaration zone 2.068 | |||
77 | F2069 | P12_V2069 | CHAR | 11 | 0 | Tax declaration zone 2.069 | |||
78 | F2070 | P12_V2070 | CHAR | 11 | 0 | Tax declaration zone 2.070 | |||
79 | F2071 | P12_V2071 | CHAR | 11 | 0 | Tax declaration zone 2.071 | |||
80 | F2072 | P12_V2072 | CHAR | 11 | 0 | Tax declaration zone 2.072 | |||
81 | F2073 | P12_V2073 | CHAR | 11 | 0 | Tax declaration zone 2.073 | |||
82 | F2074 | P12_V2074 | CHAR | 11 | 0 | Tax declaration zone 2.074 | |||
83 | F2075 | P12_V2075 | CHAR | 11 | 0 | Tax declaration zone 2.075 | |||
84 | F2076 | P12_V2076 | CHAR | 11 | 0 | Tax declaration zone 2.076 | |||
85 | F2077 | P12_V2077 | CHAR | 11 | 0 | Tax declaration zone 2.077 | |||
86 | F2078 | P12_V2078 | CHAR | 11 | 0 | Tax declaration zone 2.078 | |||
87 | F2079 | P12_V2079 | CHAR | 11 | 0 | Tax declaration zone 2.079 | |||
88 | F2080 | P12_V2080 | CHAR | 11 | 0 | Tax declaration zone 2.080 | |||
89 | F2081 | P12_V2081 | CHAR | 11 | 0 | Tax declaration zone 2.081 | |||
90 | F2082 | P12_V2082 | CHAR | 11 | 0 | Tax declaration zone 2.082 | |||
91 | F2083 | P12_V2083 | CHAR | 11 | 0 | Tax declaration zone 2.083 | |||
92 | F2084 | P12_V2084 | CHAR | 11 | 0 | Tax declaration zone 2.084 | |||
93 | F2085 | P12_V2085 | CHAR | 11 | 0 | Tax declaration zone 2.085 | |||
94 | F2086 | P12_V2086 | CHAR | 11 | 0 | Tax declaration zone 2.086 | |||
95 | F2087 | P12_V2087 | CHAR | 11 | 0 | Tax declaration zone 2.087 | |||
96 | F2088 | P12_V2088 | CHAR | 11 | 0 | Tax declaration zone 2.088 | |||
97 | F2089 | P12_F2089 | NUM4 | NUMC | 4 | 0 | Tax declaration zone 2.089 | ||
98 | F2090 | P12_F2090 | NUM4 | NUMC | 4 | 0 | Tax declaration zone 2.090 | ||
99 | F2091 | P12_F2091 | NUM4 | NUMC | 4 | 0 | Tax declaration zone 2.091 | ||
100 | F2092 | P12_F2092 | NUM4 | NUMC | 4 | 0 | Tax declaration zone 2.092 | ||
101 | F2093 | P12_F2093_07 | NUMC | 8 | 0 | Tax declaration. Zone 2.093 numc8 | |||
102 | F2095 | P12_F2095_07 | NUMC | 8 | 0 | Tax declaration zone 2.095 numc8 | |||
103 | F2097 | P12_F2097_07 | NUMC | 8 | 0 | Tax declaration zone 2.097 numc8 | |||
104 | F2099 | P12_F2099 | CHAR15 | CHAR | 15 | 0 | Tax declaration zone 2.099 | ||
105 | F2100 | P12_F2100 | CHAR15 | CHAR | 15 | 0 | Tax declaration zone 2.100 | ||
106 | F2101 | P12_F2101 | CHAR12 | CHAR | 12 | 0 | Tax declaration zone 2.101 | ||
107 | F2102 | P12_F2102 | CHAR41 | CHAR | 41 | 0 | Tax declaration zone 2.102 | ||
108 | F2103 | P12_F2103 | CHAR32 | CHAR | 32 | 0 | Tax declaration zone 2.103 | ||
109 | F2104 | P12_F2104 | NUMC4 | NUMC | 4 | 0 | Tax declaration zone 2.104 | ||
110 | F2105 | P12_F2105 | CHAR27 | CHAR | 27 | 0 | Tax declaration zone 2.105 | ||
111 | F2115 | P12_V2115 | CHAR | 11 | 0 | Tax declaration zone 2.115 | |||
112 | F2116 | P12_V2116 | CHAR | 11 | 0 | Tax declaration zone 2.116 | |||
113 | F2117 | P12_V2117 | CHAR | 11 | 0 | Tax declaration zone 2.117 | |||
114 | F2118 | P12_F2118 | NUM8 | NUMC | 8 | 0 | Tax declaration zone 2.118 | ||
115 | F2107 | P12_F2107 | CHAR32 | CHAR | 32 | 0 | Tax declaration zone 2.107 | ||
116 | F2108 | P12_F2108 | NUM4 | NUMC | 4 | 0 | Tax declaration zone 2.108 | ||
117 | F2109 | P12_F2109 | CHAR27 | CHAR | 27 | 0 | Tax declaration zone 2.109 | ||
118 | F2110 | P12_F2110 | NUM12 | NUMC | 12 | 0 | Tax declaration zone 2.110 | ||
119 | F2111 | P12_F2111 | NUM12 | NUMC | 12 | 0 | Tax declaration zone 2.111 | ||
120 | F2113 | P12_V2113 | CHAR | 11 | 0 | Tax declaration zone 2.113 | |||
121 | .INCLUDE | 0 | 0 | Belgium tax declaration, Tax relevant incomes ADDED 2008 | |||||
122 | F2119 | P12_V2119 | CHAR | 11 | 0 | Tax declaration zone 2.119 | |||
123 | F2120 | P12_V2120 | CHAR | 11 | 0 | Tax declaration zone 2.120 | |||
124 | F2121 | P12_V2121 | CHAR | 11 | 0 | Tax declaration zone 2.121 | |||
125 | F2122 | P12_V2122 | CHAR | 11 | 0 | Tax declaration zone 2.122 | |||
126 | F2123 | P12_V2123 | CHAR | 11 | 0 | Tax declaration zone 2.120 | |||
127 | F2124 | P12_V2124 | CHAR | 11 | 0 | Tax declaration zone 2.124 | |||
128 | F2125 | P12_V2125 | CHAR | 11 | 0 | Tax declaration zone 2.125 | |||
129 | F2126 | P12_V2126 | CHAR | 11 | 0 | Tax declaration zone 2.126 | |||
130 | F2127 | P12_V2127 | CHAR | 11 | 0 | Tax declaration zone 2.127 | |||
131 | F2128 | P12_V2128 | CHAR | 11 | 0 | Tax declaration zone 2.128 | |||
132 | F2129 | P12_V2129 | CHAR | 11 | 0 | Tax declaration zone 2.129 | |||
133 | F2130 | P12_V2130 | CHAR | 11 | 0 | Tax declaration zone 2.130 | |||
134 | F2131 | P12_V2131 | CHAR | 11 | 0 | Tax declaration zone 2.131 | |||
135 | F2132 | P12_V2132 | CHAR | 11 | 0 | Tax declaration zone 2.132 | |||
136 | F2133 | P12_V2133 | CHAR | 11 | 0 | Tax declaration zone 2.133 | |||
137 | F2134 | P12_V2134 | CHAR | 11 | 0 | Tax declaration zone 2.134 | |||
138 | F2135 | P12_V2135 | CHAR | 11 | 0 | Tax declaration zone 2.135 | |||
139 | F2136 | P12_V2136 | CHAR | 11 | 0 | Tax declaration zone 2.136 | |||
140 | F2137 | P12_V2137 | CHAR | 11 | 0 | Tax declaration zone 2.137 | |||
141 | F2138 | P12_V2138 | CHAR | 11 | 0 | Tax declaration zone 2.138 | |||
142 | F2139 | P12_F2139 | CHAR | 132 | 0 | Tax declaration zone 2.139 | |||
143 | F2140 | P12_F2140 | CHAR | 148 | 0 | Tax declaration zone 2.140 | |||
144 | .INCLUDE | 0 | 0 | Help structure for output. | |||||
145 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | * | |
146 | BTRTL | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | * | |
147 | PERSG | PERSG | PERSG | CHAR | 1 | 0 | Employee Group | * | |
148 | PERSK | PERSK | PERSK | CHAR | 2 | 0 | Employee Subgroup | * | |
149 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
150 | ABKRS | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | * | |
151 | ORGEH | ORGEH | ORGEH | NUMC | 8 | 0 | Organizational Unit | * | |
152 | VDSK1 | VDSK1 | VDSK1 | CHAR | 14 | 0 | Organizational Key | * | |
153 | SBMOD | SBMOD | CHAR4 | CHAR | 4 | 0 | Administrator Group | ||
154 | SACHP | SACHP | SACHA | CHAR | 3 | 0 | Administrator for HR Master Data | ||
155 | SACHZ | SACHZ | SACHA | CHAR | 3 | 0 | Administrator for Time Recording | ||
156 | SACHA | SACHA | SACHA | CHAR | 3 | 0 | Payroll Administrator | ||
157 | MSTBR | MSTBR | MSTBR | CHAR | 8 | 0 | Supervisor Area | ||
158 | STAT2 | STAT2 | STATA | CHAR | 1 | 0 | Employment Status |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |