Provide Statement

[Former Member]

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

[Former Member]

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

[Former Member]

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..

[Former Member]

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

[Former Member]

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 ?