点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
错误:
"无法执行'CALL" _SYS_BIC"。" EVALUADOR_LOCAL/EVAL_PROMOS_L2"'在806毫秒15微秒内。SAP DBTech JDBC:[9]:索引超出范围:" _SYS_BIC"。" EVALUADOR_LOCAL/EVAL_PROMOS_L2":第21行 第2列(在pos 828处):[9](范围3):索引超出范围:参数索引超出了参数大小0,但为1"
代码:
BEGIN DECLARE COTA1,COTA2日期; DECLARE EXIST_TABLE INTEGER; 从" EVALUADOR_LOCAL"中选择MIN(PER_START_DT)放入COTA1。" PERIODOS"; 从" EVALUADOR_LOCAL"中选择MAX(PER_END_DT)放入COTA2。" PERIODOS"; EXIST_TABLE = 0; 从schemasname ='EVALUADOR_LOCAL'和table_name ='KPI_PERIODOS'的表中选择count(*)到EXIST_TABLE; 如果(EXIST_TABLE> 0)然后删除表EVALUADOR_LOCAL.KPI_PERIODOS; 万一; 创建列表EVALUADOR_LOCAL.KPI_PERIODOS AS(选择PER.CADENA,PER.LOCATION_ID,PER.N_PROMO,PER.PERIODO,SUM(DI.MONTO_NETO)作为VENTA_NETA,COUNT(DISTINCT(在DI.PARTY_ID时为!='-2'THEN DI.PARTY_ID END))作为CLIENTES_FID,SUM(DI.ITEM_QTY_UMB)作为UNIDADES,COUNT(DISTINCT(DI.LOCATION_ID || DI.POS_REGISTER_ID || DI.TRAN_START_DT || DI.TRAN_START_TM || DI.TRAN_NUM))AS TRX, SUM(DI.MARCA_TMAS ='1'时的情况,然后DI.MONTO_NETO ELSE 0 END)* 1.0 AS VENTA_NETA_TC,CASE WHEN(SUM(DI.MONTO_NETO))!= 0则然后(SUM(CASE WHEN DI.MARCA_TMAS ='1' THEN DI.MONTO_NETO ELSE 0 END)* 1.0)* 1.0/(SUM(DI.MONTO_NETO))END AS PART_VENTA_TC,SUM(DI.WEIGHTED_AVERAGE_COST_AMT)AS COSTO,COUNT(DISTINCT(在DI.CHAIN_CD IN('JU', 'JS')AND SVJ.SEGMENT_VALUE_CD ='P'然后当DI.CHAIN_CD IN('SA')和SVS.SEGMENT_VALUE_CD ='P'THEN DI.PARTY_ID END))AS CLIENTES_FID_PREF从CL_SUPER_DIM.DIM_DIA_ID_ITE_ITE 像PER.CADENA ||''%'和DI.LOC一样,在DI.LOCATION_ID上按" EVALUADOR_LOCAL"。" PERIODOS" ATION_ID = PER.LOCATION_ID和DI.TRAN_START_DT在PER.PER_START_DT和PER.PER_END_DT之间加入" EVALUADOR_LOCAL"。" cpintom_SMK_PROMOS_SKU",作为SKU在PER.N_PROMO = SKU.N_PROMO和PER.CADENA = SKU.CADENA '000000000000000000'|| SKU.SKU,18)联接" EVALUADOR_LOCAL"。" IQPROD_JPCORDOVA_MESES" AS M ON DI.CODMES = M.CODMES左联接CL_SUPER_DIM.SEG_CRM_MONTHLY_SEGMENT_VALUE_JUMBO AS SVJ联接DI.PARTY_ID = .M_1左联接CL_SUPER_DIM.SEG_CRM_MONTHLY_SEGMENT_VALUE_SISA作为DI上的SVS.PARTY_ID = SVS.PARTY_ID和SVS.CODMES = M.M_1 DI.TRAN_START_DT在COTA1和COTA2之间以及DI.LOCATION_IDID内(在LOCALATION_IDID内) 不在(从EVALUADOR_LOCAL.SMK_LOCALES_NEGRA中选择LOCATION_ID)按PER.CADENA,PER.LOCATION_ID,PER.N_PROMO,PER.PERIODO分组; END;
是否可以从indexserver.trc文件(而不是警报文件)粘贴更详细的跟踪。
一周热门 更多>