data not insert into variable from table VBPA

[Former Member]

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

[Former Member]

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

[Former Member]

i cheked value exist in table VBPA for this scenario .

thanks

shashi

[Former Member]

hi,

pass the VBELN to the FM CONVERSION_EXIT_ALPHA_INPUT

It will work.

Thanks,

Venkat.

[Former Member]

Thanks Venkat.

I do as u said.

but sy-subrc = 4.

Thanks

Shashi

[Former Member]

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

[Former Member]

Hi

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

[ThomasZloch]

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