MUNDOSAP

MUNDOSAP (foro/index.php)
-   Programación ABAP IV (foro/forumdisplay.php?f=4)
-   -   Ejecutar Procedure de sql en abap (foro/showthread.php?t=72135)

minerva0112 23/07/14 13:39:40

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


Husos Horarios son GMT. La hora en este momento es 22:22:00.

www.mundosap.com 2006 - Spain
software crm, crm on demand, software call center, crm act, crm solutions, crm gratis, crm web