topic Re: problem in all entries in Application Development and Automation Discussions

problem in all entries

Former Member — Wed, 02 Apr 2008 09:34:23 GMT

Hi Friends,

I have useing this code to pick remark

SELECT vbeln

adrnr

FROM vbpa

INTO TABLE i_vbpa

FOR ALL ENTRIES IN i_vbtab

WHERE vbeln = i_vbtab-vbeln

AND posnr EQ '0'

AND parvw = 'AG'.

SELECT addrnumber

remark

FROM adrct

INTO TABLE i_adrct

FOR ALL ENTRIES IN i_vbpa

WHERE addrnumber = i_vbpa-adrnr.

but problem is in i_vbpa

its coming vbeln from 1100050017 & adrnr = 0000024278

but in adrct table addrnumber start from 0000022329.

so its not picking.

can any one help me..

Re: problem in all entries

former_member386202 — Wed, 02 Apr 2008 09:40:17 GMT

Hi,

Before applying for all entries check internal table is initial or not.

if not it_vbtab[] is initial.

SELECT vbeln

adrnr

FROM vbpa

INTO TABLE i_vbpa

FOR ALL ENTRIES IN i_vbtab

WHERE vbeln = i_vbtab-vbeln

AND posnr EQ '0'

AND parvw = 'AG'.

endif.

if not it_vbpa[] is initial.

SELECT addrnumber

remark

FROM adrct

INTO TABLE i_adrct

FOR ALL ENTRIES IN i_vbpa

WHERE addrnumber = i_vbpa-adrnr.

endif.

regards,

Prashant

Re: problem in all entries

Former Member — Wed, 02 Apr 2008 09:42:00 GMT

WHAT ABOUT THE 1ST SLECT QUERY

WHAT EVER VALUES YOU GET THERE IT WILL TAKE FROM THAT ONLY

SUPPOSE IN i_vbtab IF YOU DON'T GET THESE VALUES THEN HOW CAN IT WILL GIVE IN THE SECOND SELECT QUERY

SECOND SELECT QUERY WILL TAKE THE VBELN FROM THE 1ST SELECT QUERY

Re: problem in all entries

Former Member — Wed, 02 Apr 2008 09:42:26 GMT

in second query don't use for all entries..

try like this...

loop at i_vbpa.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = i_vbpa-adrnr

importing

output = i_vbpa-adrnr.

SELECT addrnumber remark FROM adrct appending corresponding fields of TABLE i_adrct

where addrnumber = i_vbpa-adrnr.

clear: i_vbap.

endloop.

hope this will help you...

Regards

Sugumar G

Re: problem in all entries

Former Member — Wed, 02 Apr 2008 09:43:34 GMT

NORMALLY IT WILL LOOK LIKE THIS

SELECT OTYPE

OBJID

AEDTM

UNAME

DELET

CANCR

FROM HRP1026

INTO TABLE IT_HRP1026

FOR ALL ENTRIES IN IT_SOBID

WHERE OBJID = IT_SOBID-SOBID

AND ( OTYPE = 'E' OR OTYPE = 'ET' )

AND DELET = 'X' AND

BEGDA GE DATE-LOW AND

ENDDA LE DATE-HIGH.

IF SY-SUBRC EQ 0.

SELECT OBJID

STEXT

FROM HRP1000

INTO TABLE IT_HRP1000

FOR ALL ENTRIES IN IT_SOBID

WHERE OBJID = IT_SOBID-SOBID AND

BEGDA GE DATE-LOW AND

ENDDA LE DATE-HIGH.

SELECT CANCR

CANCRT

FROM T77CRT

INTO TABLE IT_REASON

FOR ALL ENTRIES IN IT_HRP1026

WHERE CANCR = IT_HRP1026-CANCR

AND LANGU = 'E' .

ENDIF

Re: problem in all entries

Former Member — Wed, 02 Apr 2008 13:08:23 GMT

This query is solved