SQL - Como hago consulta por rango de fechas

Hola Tengo problemas con el siguiente código necesito hacer una consulta por rango de fechas pero como es muy grande la base de datos y la informacion que colapsa entonces no se si hacer una condición o otro tipo de código para que me traiga la informacion e la consulta por solo un día.

SELECT 'CO-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_COLOMBIA.OJDT T0
INNER JOIN "SBO_COLOMBIA".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_COLOMBIA".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_COLOMBIA".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_COLOMBIA".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'CO-ALP' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_ALPHA_PHARMA_CO.OJDT T0
INNER JOIN "SBO_ALPHA_PHARMA_CO".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_ALPHA_PHARMA_CO".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_ALPHA_PHARMA_CO".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_ALPHA_PHARMA_CO".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'CL-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_CHILE.OJDT T0
INNER JOIN "SBO_CHILE".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_CHILE".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_CHILE".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_CHILE".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'CL-ALP' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_ALPHA_PHARMA_CHILE.OJDT T0
INNER JOIN "SBO_ALPHA_PHARMA_CHILE".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_ALPHA_PHARMA_CHILE".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_ALPHA_PHARMA_CHILE".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_ALPHA_PHARMA_CHILE".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'SV-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_EL_SALVADOR.OJDT T0
INNER JOIN "SBO_EL_SALVADOR".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_EL_SALVADOR".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_EL_SALVADOR".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_EL_SALVADOR".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'DR-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_REPUBLICA_DOMINICANA.OJDT T0
INNER JOIN "SBO_REPUBLICA_DOMINICANA".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_REPUBLICA_DOMINICANA".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_REPUBLICA_DOMINICANA".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_REPUBLICA_DOMINICANA".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'EC-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SP_ECUADOR.OJDT T0
INNER JOIN "SP_ECUADOR".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SP_ECUADOR".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SP_ECUADOR".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SP_ECUADOR".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'CR-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_COSTA_RICA.OJDT T0
INNER JOIN "SBO_COSTA_RICA".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_COSTA_RICA".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_COSTA_RICA".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_COSTA_RICA".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'PE-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SP_PERU.OJDT T0
INNER JOIN "SP_PERU".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SP_PERU".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SP_PERU".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SP_PERU".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'GT-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_GUATEMALA.OJDT T0
INNER JOIN "SBO_GUATEMALA".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_GUATEMALA".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_GUATEMALA".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_GUATEMALA".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'HN-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_HONDURAS.OJDT T0
INNER JOIN "SBO_HONDURAS".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_HONDURAS".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_HONDURAS".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_HONDURAS".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'NI-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_NICARAGUA.OJDT T0
INNER JOIN "SBO_NICARAGUA".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_NICARAGUA".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_NICARAGUA".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_NICARAGUA".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'PA-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_PANAMA.OJDT T0
INNER JOIN "SBO_PANAMA".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_PANAMA".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_PANAMA".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_PANAMA".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

UNION ALL

SELECT 'PY-SEV' AS PAIS, T0."RefDate",T0."Number", T0."BaseRef", T0."TransId" as TR,T0."TransType",T1."Account",T2."AcctName", T0."Memo" as Observaciones,T3."CardName",T1."Debit",T1."Credit",T11."U_NAME",T1."ProfitCode" as functionalareas, T1."OcrCode2" as businessunit, T1."OcrCode3" as therapeuticalline, T1."OcrCode4" as businessline, T1."Project" as Proyecto, T1."U_EXX_SocioNegocio"
FROM SBO_PARAGUAY.OJDT T0
INNER JOIN "SBO_PARAGUAY".JDT1 T1 ON T0."TransId" = T1."TransId"
INNER JOIN "SBO_PARAGUAY".OACT T2 ON T1."Account" = T2."AcctCode"
INNER JOIN "SBO_PARAGUAY".OCRD T3 ON T1."U_EXX_SocioNegocio" = T3."CardCode"
INNER JOIN "SBO_PARAGUAY".OUSR T11 ON T0."UserSign"=T11."INTERNAL_K"

Este es el código amigos

¿Que motor de base de datos estas ocupando?, ¿Donde se encuentra tu WHERE?

Mi motor de base de datos es HANA / SQL del software de SAP

Ok, pero debe haber un FILTRO WHERE para tus fechas

eso es lo que me falta una consulta no se si usar where o una condicion para unificar todo y que me saque el reporte por fechas

Veo que tu consultas UNIFICA los datos de varias tablas (COLOMBIA, EL SALVADOR, CHILE, etc.), coloca tu resultado en una tabla de salida y de ahi, haces tu select con tu where