Solución de Sub Consulta en Sap Hana

[tnlgortiz]

Hola a todos,
Por favor necesito su ayuda, tengo el siguiente script, donde muestro los datos de una hoja de ruta de un camión, pero al migrar el script a Hana me muestra error en una sub consulta.

SELECT DISTINCT   
  TO_VARCHAR(T08."AliasName") "NombreCompañia",  
  T08."TaxIdNum",  
  T08."Phone1",  
  T08."Phone2",  
  T08."CompnyAddr",  
  T01."CardCode" "CodCliente",  
  T01."CardName" "NombreCliente",  
  (SELECT TOP 1 "Street" FROM CRD1 T08 WHERE T08."AdresType" = 'B' AND T01."CardCode" = T08."CardCode") "Street",   
  T02."PrioCode" "CodRuta",  
  T02."PrioDesc" "DesRuta",  
  T05."TipoDoc",  
  T05."DocDate",  
  T05."FolioNum",  
  T05."DocTotal",  
  T09."SeriesName" "DocNum", -- || '#' || RIGHT(Replicate('0', 7) || TO_VARCHAR(T05.DocNum), 7),  
  T05."U_NroDespacho" "10",  
  T05."U_TRANSPORTE" "CodTransporte",  
  T06."U_PLACA" "Placa",  
  T05."U_TRANSPORTISTA" "CodTransportista",  
  T07."Name" "NameTransportista",  
  T05."U_ObservDespacho" "Observaciones"  
 FROM OCRD T01 INNER JOIN   
  OBPP T02 ON T01."Priority" = T02."PrioCode" INNER JOIN  
  (SELECT   
   'FAC' "TipoDoc",  
   "FolioNum",  
   "DocTotal",  
   "DocNum",  
   "CardCode",  
   "DocDate",  
   "U_NroDespacho",  
   "U_TRANSPORTE",  
   "U_TRANSPORTISTA",  
   "U_ObservDespacho",  
   "Series"  
  FROM OINV  
  WHERE "U_NroDespacho" = 10  
  UNION  
  SELECT  
   'GR' "TipoDoc",  
   "FolioNum",  
   0,  
   "DocNum",  
   "CardCode",  
   "DocDate",  
   "U_NroDespacho",  
   "U_TRANSPORTE",  
   "U_TRANSPORTISTA",  
   "U_ObservDespacho",  
   "Series"  
  From ODLN  
  Where "U_NroDespacho" = 10) T05 ON T01."CardCode" = T05."CardCode" INNER JOIN  
  NNM1 T09 on T05."Series" = T09."Series" inner join   
  "@EXXIS_TRANSPORTE" T06 on T06."Code" = T05."U_TRANSPORTE"  
  INNER JOIN "@EXX_TRANSPORTISTA" T07 on T07."Code" = T05."U_TRANSPORTISTA",  
  OADM T08
  ORDER BY "CodCliente", "FolioNum";

Ëste es el error!
Could not execute ‘SELECT DISTINCT TO_VARCHAR(T08.“AliasName”) “NombreCompañia”, T08.“TaxIdNum”, T08.“Phone1”, …’
SAP DBTech JDBC: [309]: correlated subquery cannot have TOP or ORDER BY

[andresramirez]

Hola @tnlgortiz
Te invitamos a pasar por la seccion de #presentaciones, ya que es una politica de obligatorio cumplimiento.
Prueba eliminar la subconsulta y tomar la direccion de alguno de estos campos OCRD.“Address”, OCRD.“MailAddres”

Andres Ramirez Jaramillo