Ver Mensaje Individual
  #1  
Viejo 23/07/14, 13:39:40
minerva0112 minerva0112 is offline
Senior Member
 
Fecha de Ingreso: nov 2009
Mensajes: 116
Question Ejecutar Procedure de sql en abap

Hola

tengo un programa que me conecta con sql, en esta herramienta se ejecuta el siguiente select:

Select BKG1.BKG_ID as "T0_DQ_ID", BKG1.BKG_CHANGE_COUNT as "T0_DQ_CC", RES1.RES_ID as "T1_DQ_ID", RES1.RES_CHANGE_COUNT as "T1_DQ_CC", RES2.RES_ID as "T2_DQ_ID", RES2.RES_CHANGE_COUNT as "T2_DQ_CC", /* BKGTimeHours */ DBO.RIC3_303B9BF98C6701E1AEBCEE36D3D7FDEB6A06( BKG1.BKG_ID, '20140701 00:00:00', '20140731 00:00:00') as "CALC3" from (BKG BKG1 Left Outer Join RES RES1 on RES1.RES_ID = BKG1.BKG_RES_ID Left Outer Join RES RES2 on RES2.RES_ID = BKG1.BKG_RES_ID ) where (((BKG1.BKG_ID <> 0) AND (UPPER(RES2.RES_DESCR) not like UPPER( '%vacante%' )) AND ((BKG1.BKG_START <= '20140801' and BKG1.BKG_END >= '20140701')) AND ( (BKG_STATUS='P' AND BKG_GHOST IN ('C','D')) )))

el cual realiza un procedure o fuction para unos calculos los cuales se quieren ejecutar desde abap, ya realizo la coneccion y la consulta de tablas con EXEC SQL pero como ejecuto el select mostrado en abap cual seria la sintaxis correcta.

Gracias
Responder Con Cita