topic Re: Query problem : help me in Application Development and Automation Discussions

Query problem : help me

Former Member — Thu, 20 Dec 2007 04:26:42 GMT

DATA : s_werks TYPE vbrp-werks,

BELN like vbpa-VBELN,

BITM like vbpa-POSNR,

v_adrnr like vbpa-adrnr.

tables : vbpa.

READ TABLE IT_FINAL.

beln = it_final-vbeln.

bitm = it_final-posnr.

s_werks = it_final-werks.

s_bukrs = it_final-bukrs.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = beln1

IMPORTING

OUTPUT = beln1.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = bitm1

IMPORTING

OUTPUT = bitm1.

select single *

from vbpa

where vbeln = beln

and posnr = bitm

AND PARVW EQ 'SH'.

Now i have changed the query yar, but its also not woking,

it returns sy-subrc = 4, even the condition satisfied with values.

can anyone help me on this.

Regards

Rajaram

Re: Query problem : help me

former_member194669 — Thu, 20 Dec 2007 04:31:44 GMT

Go to SE16 and use table VBPA after giving input values check whether you are getting values?

a®

Re: Query problem : help me

Former Member — Thu, 20 Dec 2007 04:40:33 GMT

hi ,

i have just made small change...more than that i could not find any error...

DATA : s_werks TYPE vbrp-werks,

BELN like vbpa-VBELN,

BITM like vbpa-POSNR,

v_adrnr like vbpa-adrnr.

tables : vbpa.

*What u are trying to read every time i think u should use index/key field

READ TABLE IT_FINAL.

if sy-subrc = 0.

beln = it_final-vbeln.

bitm = it_final-posnr.

s_werks = it_final-werks.

s_bukrs = it_final-bukrs.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = beln "not beln1

IMPORTING

OUTPUT = beln.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = bitm "not bitm1

IMPORTING

OUTPUT = bitm.

select single *

from vbpa

where vbeln = beln

and posnr = bitm

AND PARVW EQ 'SH'.

endif.

regards,

karthik

Re: Query problem : help me

Former Member — Thu, 20 Dec 2007 04:42:22 GMT

I am getting values in se16 yar, but in debugging returns

sy-subrc = 4.

Re: Query problem : help me

former_member402443 — Thu, 20 Dec 2007 04:44:25 GMT

Hi Raja,

Your code seems to be ok.

Will you can tell me the structure of IT_FINAL.

Regards

Manoj Kumar

Re: Query problem : help me

former_member194669 — Thu, 20 Dec 2007 04:46:10 GMT



select single *
from vbpa
where vbeln = beln
and posnr = bitm
AND PARVW EQ 'WE'.  "<<<<<<<

There will a conv routine behind data element PARVW please check thru SE11 .

a®

Re: Query problem : help me

Former Member — Thu, 20 Dec 2007 04:58:17 GMT

yes yar PARVW value in se11 is 'WE', but in database when i put N transaction its SH.

whats the reason actually.

Re: Query problem : help me

Former Member — Thu, 20 Dec 2007 04:59:08 GMT

hi ,

there is a conversion routine for PARVW field pls check..

regards,

karthik

Re: Query problem : help me

former_member194669 — Thu, 20 Dec 2007 05:04:47 GMT

Check the domain PARVW , in the definition tab you can find conversion routine PARVW double click on that

you can find

CONVERSION_EXIT_PARVW_INPUT

CONVERSION_EXIT_PARVW_OUTPUT

a®

Re: Query problem : help me

Former Member — Thu, 20 Dec 2007 05:14:05 GMT

i dont understand conversion routine PARVW.

pls explain me, and even if i remove PARVW condition,

the quey is not working yar, what could be the reason.

Re: Query problem : help me

Former Member — Thu, 20 Dec 2007 05:15:38 GMT

hi,

there are two function modules involved in this pls check

in se 37.

CONVERSION_EXIT_PARVW_INPUT--which converts SH to WE

CONVERSION_EXIT_PARVW_OUTPUT-which converts WE to SH

for some reason SAP has made conversion like this for many fields so we have to check when we hard code some values in query...but in se16 it will atomatically do the process...

pls check the link too...

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ee19446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2b/e9a20d3347b340946c32331c96a64e/content.htm

regards,

karthik.

Edited by: karthikeyan sukumar on Dec 20, 2007 10:47 AM

Re: Query problem : help me

Former Member — Thu, 20 Dec 2007 05:16:41 GMT

select single *

from vbpa

where vbeln = '0081600002'

and posnr = '000010'.

This query is working perfectly yar,

i thing the forwaded zeroes is the problem.

how can we solve this.

Re: Query problem : help me

former_member194669 — Thu, 20 Dec 2007 05:18:33 GMT

For checking & testing


select single *
from vbpa
where vbeln = beln
and posnr = bitm.

check whether you are getting values if not


select single *
from vbpa
where vbeln = beln.

then you can easily filter it out where the problem is

for find the conversion routines pl check function module i have give able

a®

Re: Query problem : help me

former_member282823 — Thu, 20 Dec 2007 05:28:01 GMT

Hi Raja Ram,

Even i have faced the similar problem, the problem is coming bcoz in the select query in the condition ,we will not get the leading zeros, when we go in se16 and check for that particular condition we will see there will be leading zeros, so just add the fm, convrersion_alpha_exit_input and your problem will be solved.

All the Best

Ramesh.