minerva0112
23/07/14, 13:39:40
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
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