Skip to Content
0
Nov 18, 2013 at 06:10 AM

Ad-hoc query

31 Views

Hi Team,

We have a client requirement to include an additional field in our ad-hoc query to fetch the descritpion for position from hrt1002 table for this we are using fm RH_READ_HRP1002 to first fetch details from hrp1002 table under node for org assignment.

in parameter act_begda and act_endda need to pass the value choosen in reporting period in the ad-hoc query.

CALL FUNCTION 'RH_READ_HRP1002'
EXPORTING
act_plvar = '01'
act_otype = 'S'
act_objid = p0001-plans
act_subty = '0002'
act_langu = 'E'
act_begda = syhr_evaluation_begda
act_endda = syhr_evaluation_endda
TABLES
act_p1002 = itab_plans
EXCEPTIONS
no_data_found = 1
OTHERS = 2.

But when coding the above getting syntax error

Field "SYHR_EVALUATION_BEGDA" is unknown. It is neither in one of the

specified tables nor defined by a "DATA" statement.

But when putting break point above this call fm step, we are getting value for both syhr_evaluation_begda and syhr_evaluation_endda.

Kindly advice.

Thanks,

Anju