topic Problem in data retrieving in Application Development and Automation Discussions

Problem in data retrieving

Former Member — Tue, 06 Jul 2010 06:49:17 GMT

hi all,

i have to selet fields from table vbak, i have to use cdpos-objectid against vbak-vbeln, but i am having an error regarding

type and length, i tried using the convertion output but it seems not to solve my issue.

do you know any function module to use? or any idea, perhaps?

thanks - AUD

Re: Problem in data retrieving

Former Member — Tue, 06 Jul 2010 06:54:12 GMT

HI AUD ,

can u show thwe code? so tat i can help u .

Re: Problem in data retrieving

Former Member — Tue, 06 Jul 2010 06:57:33 GMT

Hi,

Have you used the conversion routine "CONVERSION_EXIT_ALPHA_INPUT" for CDPOS-OBJECTID?. CONDENSE cdpos-objectid before using the conversion exit. And Can i know what is your requirement using change document data ? May be function module CHANGEDOCUMENT_READ will be helpful for your requirement.

Regards

Vinod

Re: Problem in data retrieving

Former Member — Tue, 06 Jul 2010 07:00:10 GMT

Hi,

The FM to get Order details is BAPI_SALESORDER_GETLIST

try this.

Re: Problem in data retrieving

former_member222860 — Tue, 06 Jul 2010 07:26:27 GMT

Hi Aud,

Just try with the below select statement

data: begin of itab occurs 0,

vbeln like vbak-vbeln,

erdat like vbak-erdat,

end of itab.

data: begin of jtab occurs 0,

objectid like cdpos-objectid,

end of jtab.

select objectid from cdpos into table jtab

where objectid >= '0000005001' and objectid <= '0000006000'.

loop at jtab.

select vbeln erdat from vbak appending table itab

where vbeln = jtab-objectid+0(10).

endloop.

loop at itab.

write:/ itab-vbeln, itab-erdat.

endloop.

Regards

Mahesh