topic Re: Select statement not populating the internal table in Application Development and Automation Discussions

Select statement not populating the internal table

Former Member — Wed, 13 Oct 2010 03:37:07 GMT

Hi,

I have a requirement where I have to upload a file from C drive, the fields in this file are VBELN, description & date of creation.

I am able to get this file into the internal table. After this i need to cross check the VBELN against VBRK-VBELN, if present then update a Z-table.... How do I do the cross check part ?...

if not tw_zvatcn[] is initial,

select * from vbrk

into table tw_vbrk

for all entries in tw_zvatcn

where vbeln = tw_zvztcn-vbeln

and vkorg = p_vkorg.

if sy-subrc = 0.

modify ztzb from lw_zvatcn.

endif.

Internal table tw_vbrk is coming blank, which is not correct because I see the data in db tbl VBRK

Re: Select statement not populating the internal table

GauthamV — Wed, 13 Oct 2010 03:55:38 GMT

Is p_vkorg a parameter or select option.

If it is parameter and is blank you will not get data in the table.

In that case make a condition for that field also.


if not tw_zvatcn[] is initial.
if p_vkorg is not initial.
select * from vbrk
into table tw_vbrk
for all entries in tw_zvatcn
where vbeln = tw_zvztcn-vbeln
and vkorg = p_vkorg.
if sy-subrc = 0.
modify ztzb from lw_zvatcn.
endif.
else.
select * from vbrk
into table tw_vbrk
for all entries in tw_zvatcn
where vbeln = tw_zvztcn-vbeln.
if sy-subrc = 0.
modify ztzb from lw_zvatcn.
endif.
endif.
endif.

Re: Select statement not populating the internal table

Former Member — Wed, 13 Oct 2010 03:56:41 GMT

Once you get the data from c drive to internal table, modify all VEBLN of tw_zvatcn[] into SAP format using function module CONVERSION_EXIT_ALPHA_INPUT. This might solve ur issue.

Regards

Sachin

Re: Select statement not populating the internal table

Former Member — Wed, 13 Oct 2010 03:56:53 GMT

Hi,

Check if there are any entries in table "vbrk" with vbeln and p_vkorg combination.

Also check if you need to use conversion exit for field "VBELN".

Regards,

Srini.

Re: Select statement not populating the internal table

alex_cook — Wed, 13 Oct 2010 03:57:21 GMT

Howdy,

Make sure the VBELN data in your internal table has leading zeros, eg instead of 90000123 you need 009000123.

To do the conversion use FM CONVERSION_EXIT_ALPHA_INPUT.

Cheers

Alex

Re: Select statement not populating the internal table

Former Member — Wed, 13 Oct 2010 03:59:40 GMT

Thank You Gautham, but p_vkorg is obligatory in teh selection-screen.