Saludos querida comunidad
Comparto con ustdes esta opción que tengo para ejecutar vistas calculadas desde query manager y con parametros.
DECLARE fechafin date;
SELECT TOP 1 P0."RateDate" into fechafin FROM ORTT P0 WHERE P0."RateDate" = '[%2]';
SELECT ROW_NUMBER()
OVER (PARTITION BY T0."BusinessPartnerCode" ORDER BY,
*
FROM "_SYS_BIC"."sap.sbodemocl.ar.case/CustomerReceivableAgingFact"(PLACEHOLDER."$$P_AgingDate$$" => ADD_DAYS(:fechafin,1)) T0
LEFT JOIN OCRD T2 ON T0."BusinessPartnerCode" = T2."CardCode"
LEFT JOIN (SELECT top 1 Z0."CardCode", Z0."City", Z0."Street" FROM CRD1 Z0 group by Z0."CardCode", Z0."City", Z0."Street") T21 ON T2."CardCode" = T21."CardCode" and T2."MailAddres" = T21."Street"
LEFT JOIN OINV T3 ON T0."BaseDocumentTypeCode" = T3."ObjType"
AND T0."BaseDocumentInternalKey" = T3."DocEntry"
AND T0."BaseDocumentNumber" = T3."DocNum"
LEFT JOIN ORIN T4 ON T0."BaseDocumentTypeCode" = T4."ObjType"
AND T0."BaseDocumentInternalKey" = T4."DocEntry"
AND T0."BaseDocumentNumber" = T4."DocNum";
Estas consuta la probe en versiones de 9.2 y 9.3, sobre la version SAP 9.3 pl10 no funciona, no entiendo el porque