Buenos días comunidad
Presento el siguiente problema al crear un script view en HANA a partir de vistas calculadas.
/********* Begin Procedure Script ************/
BEGIN
var_1 = select *,
case when "ROW"=1 then "QuantityIni"+"Quantity" else "Quantity" end "QuanRow1",
case when "ROW"=1 then "Valor_TransIni"+"Valor_Trans" else "Valor_Trans" end "ValTransRow1"
from(SELECT
ROW_NUMBER () OVER(PARTITION BY "ItemCode" order by "PostingDate") "ROW",
"ItemCode",
"ItemDescription",
"PostingDate",
"DocumentTypeCode",
"DocumentTypeDisplayName",
"WarehouseCode",
"WarehouseName",
"DocmentNumber",
sum("InboundInventoryQuantity") - sum("OutboundInventoryQuantity") AS "Quantity",
(
select sum(T1."InboundInventoryQuantity") - sum(T1."OutboundInventoryQuantity")
FROM "_SYS_BIC"."sap.donucol.stock/InventoryTransactionDocumentsQuery" T1
where T1."PostingDate" < :FechaIni
and T1."ItemCode"=T0."ItemCode"
) "QuantityIni",
abs("InboundItemCostLC"-"OutboundItemCostLC") "Costo",
sum("InboundInventoryValueLC") -sum("OutboundInventoryValueLC") AS "Valor_Trans",
(
select sum(T2."InboundInventoryValueLC") -sum(T2."OutboundInventoryValueLC")
FROM "_SYS_BIC"."sap.SEIDOR/SEI_INVENTORYTRANSACTIONDOCUMENTSQUERY" T2
where T2."PostingDate" < :FechaIni
--and T2."ItemCode" IN {?Seleccionar Art @from oitm}
) "Valor_TransIni"
FROM "_SYS_BIC"."sap.SEIDOR/SEI_INVENTORYTRANSACTIONDOCUMENTSQUERY" T0
where "PostingDate" between :FechaIni and :FechaFin
--and "ItemCode" IN {?Seleccionar Art @from oitm}
GROUP BY "ItemCode",
"ItemDescription",
"PostingDate",
"DocumentTypeCode",
"DocumentTypeDisplayName",
"WarehouseCode",
"WarehouseName",
"DocmentNumber",
"InboundItemCostLC",
"OutboundItemCostLC"
--order by "PostingDate"
)LL order by "ROW";
var_out = CE_PROJECTION(:var_1);
END /********* End Procedure Script ************/
El script funciona bien cuando lo ejecuto en HANA, los parametros los toma pero cuando importo el script a SAP Business One y lo consulto a traves de Excel Interactive Analysis
Sale el siguiente error
Saben si esto es una limitante del excel interactive analysis o tengo algo mal en el script.
Gracias por su colaboracion