topic Re: Empty Internal table? in Application Development and Automation Discussions

Empty Internal table?

Former Member — Thu, 05 Jul 2007 19:27:59 GMT

Hi Guys,

I am having a problem while writing the code The code is below.

SELECT *

INTO TABLE lt_JEST

FROM JEST

FOR ALL ENTRIES IN lt_PROJ

WHERE OBJNR EQ lt_PROJ-OBJNR.

In the code above i want to keep a condition that if there is no data in PROJ internal table Then this Select Statement should not be executed.Can anybody tell me how to do it?

Thanks,

Gopi.

Re: Empty Internal table?

Former Member — Thu, 05 Jul 2007 19:30:33 GMT


IF NOT lt_PROJ[] IS INITIAL.
SELECT *
INTO TABLE lt_JEST
FROM JEST
FOR ALL ENTRIES IN lt_PROJ
WHERE OBJNR EQ lt_PROJ-OBJNR.
ENDIF.

Greetings,

Blag.

Re: Empty Internal table?

RichHeilman — Thu, 05 Jul 2007 19:31:07 GMT

Sure...

if not it_proj[] is initial.
SELECT *
INTO TABLE lt_JEST
FROM JEST
FOR ALL ENTRIES IN lt_PROJ
WHERE OBJNR EQ lt_PROJ-OBJNR.

endif.

Regards,

Rich Heilman

Re: Empty Internal table?

former_member194669 — Thu, 05 Jul 2007 19:31:25 GMT

Hi,

If not lt_proj[] is initial.

SELECT *

INTO TABLE lt_JEST

FROM JEST

FOR ALL ENTRIES IN lt_PROJ

WHERE OBJNR EQ lt_PROJ-OBJNR.

endif,

aRs

Re: Empty Internal table?

RichHeilman — Thu, 05 Jul 2007 19:32:20 GMT

Or if you are on a newer version, you can do this too.

if lines( it_proj ) > 0.

SELECT *
INTO TABLE lt_JEST
FROM JEST
FOR ALL ENTRIES IN lt_PROJ
WHERE OBJNR EQ lt_PROJ-OBJNR.

Endif.

Regards,

RIch Heilman

Re: Empty Internal table?

Former Member — Thu, 05 Jul 2007 19:44:24 GMT

DESCRIBE TABLE lt_proj LINES g_rows.

IF g_rows <> 0.

SELECT *

INTO TABLE lt_JEST

FROM JEST

FOR ALL ENTRIES IN lt_PROJ

WHERE OBJNR EQ lt_PROJ-OBJNR.

Endif.

Re: Empty Internal table?

Former Member — Thu, 05 Jul 2007 19:51:28 GMT

Hello,

you can do this:

data: lines type i.

describe table lt_PROJ LINES lines.

if lines > 1.

SELECT *

INTO TABLE lt_JEST

FROM JEST

FOR ALL ENTRIES IN lt_PROJ

WHERE OBJNR EQ lt_PROJ-OBJNR.

endif.

regards

David

Re: Empty Internal table?

Former Member — Thu, 05 Jul 2007 22:12:36 GMT

Hi Gopi,

try this out.

IF NOT IT_PROJ[] IS INITIAL.

SELECT * from JEST

INTO TABLE IT_JEST

FOR ALL ENTRIES IN IT_PROJ

WHERE OBJNR = PROJ-OBJNR.

<b>(CHECK IF U WANT TO COMPARE WITH PROJ OR IT_PROJ, IF U R CHECKING IN IT_PROJ, THEN IT_PROJ-OBJNR. (<i>I THINK IT SHOULD BE IT_PROJ-OBJNR</i>)</b>

ELSE.

ENDIF.

REWARD POINTS IF USEFUL

THANKS

Sujay

Re: Empty Internal table?

kesavadas_thekkillath — Fri, 06 Jul 2007 05:44:40 GMT

describe table it_proj[].

if sy-tfill > 0.

execute the statement.

endif.