topic Re: Dynamic table : need support in Application Development and Automation Discussions

Dynamic table : need support

Former Member — Tue, 15 Dec 2009 11:24:05 GMT

Hi experts,

I`m creating a method to check absence/overtime records.

In fact, In my import param, i have the pernr, the INFTYP, , begda and endda and wanna select the employee record in this dynamic table. I still have errors. CAn you check please ?

*****************

DATA : return_enq TYPE bapireturn1,

return_deq TYPE bapireturn1.

DATA: w_tabname TYPE w_tabname,

w_dref TYPE REF TO data,

p_table(5) TYPE c.

CONCATENATE `P` im_req-infty INTO p_table.

FIELD-SYMBOLS: <t_itab> TYPE ANY TABLE .

w_tabname = p_table.

CREATE DATA w_dref TYPE TABLE OF (w_tabname).

ASSIGN w_dref->* TO <t_itab>.

SELECT * FROM (w_tabname) INTO TABLE <t_itab> WHERE begda = im_req-begda AND endda EQ im_req-endda AND pernr = im_req-pernr .

Re: Dynamic table : need support

Former Member — Tue, 15 Dec 2009 12:59:40 GMT

Hi!

Please check out the following link.

Regards

Tamá

Re: Dynamic table : need support

Former Member — Tue, 15 Dec 2009 13:04:47 GMT

Hi,

check the below link for creating dynamic internal tbale.

[http://wiki.sdn.sap.com/wiki/display/Snippets/DynamicInternalTable]

[http://wiki.sdn.sap.com/wiki/display/Snippets/Creatingadynamicinternaltablebasedon+data]

Re: Dynamic table : need support

Former Member — Tue, 15 Dec 2009 13:12:42 GMT

Hi,

Check this link.

It may help u.

Re: Dynamic table : need support

Former Member — Tue, 15 Dec 2009 14:26:04 GMT

Thanks guys

Re: Dynamic table : need support

former_member224404 — Tue, 15 Dec 2009 14:26:57 GMT

Hi kraiem,

I copied your code snippet and executed and found one problem. You are concatenating 'P' to infotype to resove the table name. But I think you need to concatenate 'PA' to infotype to achieve this. I changed it to my program and the select query was successful.

Hope it helps.

Thanks,

Mainak

Re: Dynamic table : need support

Former Member — Tue, 15 Dec 2009 14:30:53 GMT

Hi,

I already did it and it`s working. Thanks a lot for your help.