problem in all entries

[Former Member]

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

[Former Member]

hi

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

[former_member386202]

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

[Former Member]

hi

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

[Former Member]

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

[Former Member]

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

[Former Member]

This query is solved