Select statement proble

[former_member382811]

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.

[former_member382811]

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.

[Former Member]

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

[Former Member]

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.

[former_member382811]

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.

[former_member382811]

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.

[former_member382811]

Hi sindhu,

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

Thanks