topic Re: Provide Statement in Application Development and Automation Discussions

Provide Statement

Former Member — Fri, 13 Jun 2008 14:59:32 GMT

Hi,

I have joined 2 tables in using provide. Is there any to identify which table has caused exception (cx_sy_provide_interval_overlap) in provide statement.

PROVIDE

FIELDS

pernr begda endda name

FROM table1

INTO ls_table1 VALID l_v_org_0001

BOUNDS begda AND endda WHERE

pernr = pernr-pernr

FIELDS

pernr begda endda massn

FROM table2

INTO ls_table2 VALID l_v_org_0002

BOUNDS begda AND endda WHERE

pernr = pernr-pernr

BETWEEN '18000101' AND '99991231' INCLUDING GAPS.

CATCH cx_sy_provide_interval_overlap.

table4-pernr = ls_table1-pernr.

table4-massn = ls_table2-massn.

table4-flag1 = l_v_org_0001.

table4-flag2 = l_v_org_0002.

APPEND table4.

CATCH cx_sy_provide_table_not_sorted.

table4-pernr = ls_table1-pernr.

table4-massn = ls_table2-massn.

table4-flag1 = l_v_org_0001.

table4-flag2 = l_v_org_0002.

APPEND table4.

My requirement is to identify which table has caused exception. What is the use of Valid flag in provide?

Edited by: V Nair on Jun 13, 2008 5:11 PM

Re: Provide Statement

Former Member — Sat, 14 Jun 2008 12:18:17 GMT

hi go to the st22--~~-> choose code analysis~~it will take to you to the exact code where the error occured

Re: Provide Statement

Former Member — Mon, 16 Jun 2008 09:00:38 GMT

Hi Venkat,

Thanks for you reply. Actually I have arround 10 table joins using provide.

Now, I want to at runtime which table has caused this issue not by going to ST22.

Thxs..

Re: Provide Statement

Former Member — Mon, 16 Jun 2008 09:02:27 GMT

hi this can be seen at the debugging by looking the data at the structures that the data is flowing

Re: Provide Statement

Former Member — Mon, 16 Jun 2008 09:12:20 GMT

I got your point, but I cannot rely on this as some of the fields in structure remains blank. Is there any other way.. such as using Valid flag ?