topic Re: Select statement proble in Application Development and Automation Discussions

Select statement proble

former_member382811 — Thu, 01 Dec 2011 16:20:18 GMT

Hi Experts,

i have select statement like this

data:sold_to type vbpa-kunnr

SELECT kunnr FROM vbpa INTO sold_to

WHERE vbeln = p_int_vttp_vbeln AND

posnr = '000000' AND

parvw = 'SP'.

ENDSELECT.

this query doesnt fetch any record sold_to is initial ,but in vbpa table have that related data.why i am facing this problem.

Re: Select statement proble

Former Member — Thu, 01 Dec 2011 16:35:24 GMT

is the partner at the header level (Posnr = 0?). I forget the code, but check to see what SP is translated from....it's stored differently in the DB from what you see in PARVW display. Look at the actual table content...

Re: Select statement proble

Former Member — Thu, 01 Dec 2011 17:10:37 GMT

Hi Venu,

PARVW has some internal conversion format. FOR SP, the value stored in table is AG. Just try giving AG in the select query and see if it works.

Regards,

Sindhu.

Re: Select statement proble

former_member382811 — Thu, 01 Dec 2011 17:38:21 GMT

Hi Sindhu,

SELECT SINGLE kunnr FROM vbpa INTO sold_to

WHERE vbeln = p_int_vttp_vbeln AND

posnr = '000000' AND

parvw = 'AG'.

if write like that above statement its working fine.it fetching data correctly.

Re: Select statement proble

former_member382811 — Thu, 01 Dec 2011 17:41:05 GMT

Hi sindhu,

Thanks a lot. But let me about this PARVW has some internal conversion format. FOR SP, the value stored in table is AG.

Re: Select statement proble

former_member382811 — Thu, 01 Dec 2011 17:48:48 GMT

Hi sindhu,

yes PARVW has some internal conversion format. FOR SP, the value stored in table is AG.

Thanks