Como están!! tengo una duda espero me puedan ayudar
Tengo este query:
UPDATE JDT1 SET
"U_InfoCo01" = T2."U_AMS_SocioN"
FROM "JDT1" T0
INNER JOIN "OJDT" T1 ON T0."TransId" = T1."TransId"
INNER JOIN "OMRV" T2 ON T1."TransId" = T2."TransId"
AND T2."DocNum" = T1."BaseRef" AND T1."TransType" = 162
WHERE T0."Account" IN (22050805,22051205,14051005,14050505,14050605,14051016,14051017,14100516,14100517)
AND T0."RefDate" BETWEEN [%0] AND [%1]
AND (T2."U_AMS_SocioN" IS NOT NULL OR T2."U_AMS_SocioN" <> '')
En SAP B1 for Hana 93 pl 10 funcionaba correctamente, pero luego de la migración a SAP B1 10.0 Version for Hana se genera el siguiente mensaje:
1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Base table or view not found;259 invalid table name: The table JDT1 was not found in the FROM clause. Please refer to SAP-Note 2241598. 'Valores definidos por usuario' (CSHS)
Luego intente agregando el nombre de la base de datos, el codigo quedo asi:
UPDATE "JDT1" SET
"U_InfoCo01" = T2."U_AMS_SocioN"
FROM "DATABASENAME"."JDT1" T0
INNER JOIN "DATABASENAME"."OJDT" T1 ON T0."TransId" = T1."TransId"
INNER JOIN "DATABASENAME"."OMRV" T2 ON T1."TransId" = T2."TransId"
AND T2."DocNum" = T1."BaseRef" AND T1."TransType" = 162
WHERE T0."Account" IN (22050805,22051205,14051005,14050505,14050605,14051016,14051017,14100516,14100517)
AND T0."RefDate" BETWEEN [%0] AND [%1]
AND (T2."U_AMS_SocioN" IS NOT NULL OR T2."U_AMS_SocioN" <> '')
Pero a pesar de agregar el nombre de la base de datos me muestra el mismo error de mensaje.
