SAP table T5BX4 (Belgium tax declaration, assign wages to zone)

SAP table T5BX4 has 5 primary key fields being MANDT,BV281,LGART,SEQNO,ENDDA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BV281 Code for 281 Tax Slip CHAR 2 0 T5B17 P12_BV281
LGART Wage Type CHAR 4 0 T512W LGART
SEQNO Sequence Number CHAR 3 0 SEQNO
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
BTSGN Arithmetic symbol CHAR 1 0 P_RECHZ
+ Addition
- Subtraction
BTNRA Value Retrieved from Wage Type (Rate, Number, Amount) CHAR 1 0 P12_BTNRA
A Amount
B Amount plus S.I.
D Amount dismissal period
E Amount dismissal allowance
M Evaluation class 14
N Number
R Rate
S Amount minus S.I.
BELCO BELCOTAX definition NUMC 5 0 BELCO
GENFI Name of FINPROF Form to be generated CHAR 5 0 PC12_BTVOU
BTIND Indication of FINPROF sum type CHAR 1 0 PC12_BTIND
1 Add to taxable amount
2 Add to taxes
3 Add to special cotisation
8 For annual declaration only
9 Not added
R Outstanding taxes for normal shift exemption
S Transferable tax exemption (normal shift)
T Outstanding taxes for full cont. shift exemption
W Transferable tax exemption (full cont. shift)
BTNEG Flag to allow negative amounts CHAR 1 0 P12_BTNEG
Negative amounts not allowed
X Negative amounts allowed
BTVOU BELCOTAX Voucher Number NUMC 5 0 P12_BTVOU
28100 281.00 Information insurance institutions
28101 281.01 Dereliction of the collection of withholding tax
28110 281.10 Incomes
28111 281.11 Pensions
28112 281.12 Substitution incomes reclaim of overpaid allowances
28113 281.13 Unemployment allowances
28114 281.14 Substitution incomes insurance institutions
28115 281.15 Incomes, Pension fund
28116 281.16 Disability allowances
28117 281.17 Pre-pension allowance
28118 281.18 Substitution incomes, extra allow., Illnes allow.
28120 281.20 Incomes, Management
28125 281.25 Reimbursed incomes
28129 281.29 Income from sharing economy
28130 281.30 Attendance fee, prizes, subsidy, lump sum
28140 281.40 Life annuity
28145 281.45 Copyright and related rights
28148 281.48 Revenue from users of digital collaboration platform
28149 281.49 Parliamentary allowances
28150 281.50 Commissions, brokerage and other advantages
28160 281.60 Receipt of payments for pension saving schemes
28161 281.61 Loans: repayments-interest
28162 281.62 Life insurance
28163 281.63 Tax reduction legal aid
28171 281.71 Attestation of gifts
28172 281.72 Immovable Heritage Monuments
28177 281.77 Tax Reduction (FIRST) Tax shelter “COVID-19”
28178 281.78 Exemption Socially passive
28179 281.79 Exemption international pensions
28180 281.80 Attestation PWA / ALE-cheques
28181 281.81 Attestation services cheques
28182 281.82 Attestation financial responsability
28183 281.83 Tax Reduction (SECOND) Tax shelter “COVID-19”
28184 281.84 Attestation starter fund
28185 281.85 Tax shelter
28186 281.86 Childcare costs
28187 281.87 Loss private Privak
28188 281.88 Tax Shelter Scale Up
28190 281.90 Attestation restitution soc ins. contr self employed
28192 281.92 Support measures for agricultural policy
28193 281.93 Information public services
28199 281.99 Information public services - COVID support measures
BOWQU Belcotax Payment Description Code CHAR 4 0 T5BX12 P12_BOW_QUALIFICATION_CODE
BINRA BELCOTAX: Fiscal Year Indicator CHAR 1 0 P12_BTNRA_INDICATOR_INCOMEYEAR
Actual and previous (Default)
A Actual I fit is for amount from current income year only.
P Previous if it is for amount from previous income year only.

T5BX4 foreign key relationships

Table Field Check Table Check Field
0 T5BX4 BOWQU T5BX12 HR-Belgium: Belcotax Qualification Code List MANDT
0 T5BX4 BOWQU T5BX12 HR-Belgium: Belcotax Qualification Code List BOWQU
0 T5BX4 BOWQU T5BX12 HR-Belgium: Belcotax Qualification Code List ENDDA
1 T5BX4 BV281 T5B17 Fiche 281.## MANDT
1 T5BX4 BV281 T5B17 Fiche 281.## BV281
0 T5BX4 LGART T512W Wage Type Valuation MANDT
0 T5BX4 LGART T512W Wage Type Valuation MOLGA
0 T5BX4 LGART T512W Wage Type Valuation ENDDA