the code...

# Import necessary classes to work with Sage X3
from x3 import BPCUSTOMER, ITMBPS, ZRAPPEL
import csv
from datetime import datetime

# Get the current year
current_year = datetime.now().year

# Perform the query
query_result = ZRAPPEL.select(
(ZRAPPEL.ZCODSGR_0 >= '70') & (ZRAPPEL.ZCODSGR_0 <= '78') &
(ITMBPS.ITMSTA_0 != 6) &
(ZRAPPEL.ZESTADO_0 == 1) &
(BPCUSTOMER.BPCSTA_0 == 2) &
((ITMBPS.ITMREFBPS_0.startswith('OF')) & (ITMBPS.ITMREFBPS_0.endswith('U')))
).join(
BPCUSTOMER, ZRAPPEL.BPCGRU_0 == BPCUSTOMER.BPCGRU_0
).join(
ITMBPS, ZRAPPEL.ZCODSGR_0 == ITMBPS.TSICOD_4
).join(
ITMBPS, ITMBPS.ITMREF_0 == ITMBPS.ITMREF_0
).select(
columns=[
ZRAPPEL.BPCGRU_0,
BPCUSTOMER.BPCNUM_0,
ITMBPS.ITMREFBPS_0,
ZRAPPEL.ZDTOPOR_0,
ZRAPPEL.ZDTODAT_0,
ZRAPPEL.ZFECHABAJA_0
]
)

# Define the CSV file path
csv_file_path = "E:/SAGE/SAGE/FOLDERS/DELMORAL/ZUNI/resultados.csv"

# Export the result to a CSV file
with open(csv_file_path, mode='w', newline='', encoding='utf-8') as csv_file:
csv_writer = csv.writer(csv_file)

# Write headers
csv_writer.writerow(["Year", "Dealer", "Client", "Product", "Discount", "Euros", "From", "To", "Participation"])

# Write data rows
for row in query_result:
csv_writer.writerow([current_year, 146, row.BPCNUM_0, row.ITMREFBPS_0, row.ZDTOPOR_0, 0, row.ZDTODAT_0, '31/12/2029' if row.ZFECHABAJA_0 < '01/01/2017' else row.ZFECHABAJA_0, 80])