topic Re: data not insert into variable from table VBPA in Application Development and Automation Discussions

data not insert into variable from table VBPA

Former Member — Fri, 04 Mar 2011 06:31:48 GMT

Dear ABAPER'S,

DATA: l_LIFNR type LIFNR

let WA_LIKP-VBELN = 1008460140

SELECT SINGLE LIFNR FROM VBPA INTO L_LIFNR WHERE PARVW = 'CR' AND VBELN = WA_LIKP-VBELN.

when i go to debug then SY-SUBRC= 4

no data come in L_LIFNR .

Please help me.

Thanks

Shashi

Moderator Message: Do a little more research before you post your questions here.

Edited by: kishan P on Mar 4, 2011 1:41 PM

Re: data not insert into variable from table VBPA

Former Member — Fri, 04 Mar 2011 06:37:12 GMT

VBPA

did u check at table level if the value is present..

i hope you did not conclude LIKP-VBELN = VBPA-VBELN.

LIKP - VBELN is delivery document not sales document..

Re: data not insert into variable from table VBPA

Former Member — Fri, 04 Mar 2011 06:37:26 GMT

Hi,

When you Passing VBELN Value to the Select Statement Pass the *WA_LIKP-VBELN' value Before to the

Select Statement to the FM CONVERSION_EXIT_ALPHA_INPUT

WA_LIKP-VBELN = 1008460140

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = WA_LIKP-VBELN

IMPORTING

OUTPUT = WA_LIKP-VBELN .

Then Pass the value to Select Statement.

Because Conversion Routine Problem is there for you.

Thanks,

Venkat.

Edited by: Venkatesh Kolluru on Mar 4, 2011 7:37 AM

Re: data not insert into variable from table VBPA

Former Member — Fri, 04 Mar 2011 06:37:55 GMT

Please try yourself before posting these type of issues.

Firstly, you cannot use SELECT SINGLE in the select because you are not using all KEY fields for the select.

Key fields are VBELN

POSNR

PARVW.

Secondly, in the WHERE condition please maintain the sequence of the fields from table level.

Try like this:

SELECT  LIFNR UPTO 1 ROWS FROM VBPA INTO L_LIFNR WHERE VBELN = WA_LIKP-VBELN and PARVW = 'CR'  .
ENDSELECT.

Also, please check that you are comparing the correct fields.

Regards

Hareesh

Re: data not insert into variable from table VBPA

Former Member — Fri, 04 Mar 2011 06:42:12 GMT

i cheked value exist in table VBPA for this scenario .

thanks

shashi

Re: data not insert into variable from table VBPA

Former Member — Fri, 04 Mar 2011 06:52:07 GMT

hi,

pass the VBELN to the FM CONVERSION_EXIT_ALPHA_INPUT

It will work.

Thanks,

Venkat.

Re: data not insert into variable from table VBPA

Former Member — Fri, 04 Mar 2011 07:07:20 GMT

Thanks Venkat.

I do as u said.

but sy-subrc = 4.

Thanks

Shashi

Re: data not insert into variable from table VBPA

ThomasZloch — Fri, 04 Mar 2011 11:50:49 GMT

Reacting to your abuse report, your question was locked because this problem was faced and solved by many people before you. You are supposed to look for existing solutions before opening the 100th redunant problem.

Hint: VBELN is not the problem, but the language dependent translation of PARVW. Why not use this as a search term?

Thomas

Edited by: Thomas Zloch on Mar 4, 2011 12:51 PM