topic Re: ABAP Code Error on Query in Application Development and Automation Discussions

ABAP Code Error on Query

former_member355038 — Wed, 18 Jun 2014 11:14:41 GMT

I am trying to get the material document number added to an existing report and I have used the followingcode:

* Get the material document number

Clear Z_MAT_DOC_NO.

Select VBELN FROM VBFA

WHERE VBELV = LIKP-VBELN

AND VBTYP_N = 'R'.

However I get the error "Field list without INTO clause is not allowed. not allowed. allowed."

Can you tell me what I need to change on my code

thanks

Joe

Re: ABAP Code Error on Query

Former Member — Wed, 18 Jun 2014 11:21:11 GMT

Hi Joe.

Try this :

DATA : LW_VBFA TYPE VBFA. " Workarea

Select single * from VBFA into corresponding fields of LW_VBFA where VBLV= LIKP-VBELN AND VBTYP_N = 'R'.

Now in LW_VBFA you will get the records statisfying your condition.

Thanks

Re: ABAP Code Error on Query

Former Member — Wed, 18 Jun 2014 11:24:56 GMT

Hi Joe,

Please try to use

Data: w_vbeln type vbfa-vbeln.

Clear Z_MAT_DOC_NO.

Select VBELN FROM VBFA

into w_vbeln

WHERE VBELV = LIKP-VBELN

AND VBTYP_N = 'R'.

Regards,

Prasenjit

Re: ABAP Code Error on Query

arthur_alvesteixeira — Wed, 18 Jun 2014 11:32:15 GMT

Joe,

add SINGLE and INTO

CLEAR Z_MAT_DOC_NO.

SELECT SINGLE

VBELN

FROM VBFA

INTO Z_MAT_DOC_NO

WHERE VBELV = LIKP-VBELN

AND VBTYP_N = 'R'.

Re: ABAP Code Error on Query

former_member355038 — Wed, 18 Jun 2014 12:41:09 GMT

Thanks all

I have tried the following:

* Get the material document number

Clear Z_MAT_DOC_NO.

Select single VBELN

FROM VBFA

INTO Z_MAT_DOC_NO

WHERE VBELV = LIKP-VBELN

AND VBTYP_N = 'R'.

But no data is returned, I have checked the VBFA table and there is entry where VBELV matches LIKP-VBELN

Re: ABAP Code Error on Query

Former Member — Wed, 18 Jun 2014 12:47:27 GMT

Hi ,

Please check LIKP-VBELN and VBTYP_N = 'R' in VBFA table.

It might be any good movement will not be available for this delivery.

Regards,

Prasenjit

Re: ABAP Code Error on Query

former_member355038 — Wed, 18 Jun 2014 13:27:21 GMT

I have checked and LIKP-VBELN and VBTYP_N = 'R' in VBFA table. is in table VBFA.

Do you think this has anything to do with my table join which does not have VBFA:

VIQMEL links to VBAK-VBAP-VBRP-VBRK-LIKP

if I have to add in VBFA where should this be added in the table join?

thanks

Joe

Re: ABAP Code Error on Query

former_member355038 — Wed, 18 Jun 2014 14:11:30 GMT

I have now removed the LIKP join as i do not think this is correct join, but now I get the error message "LIKP-VBELN is uknown it is not in of the specified tables or defined by a data statement.

How would I define this in the data statement of the query, what would the data section of the query need to contain?

Re: ABAP Code Error on Query

Former Member — Wed, 18 Jun 2014 14:23:31 GMT

Hi Joe ;

CLEAR : Z_MAT_DOC_NO.

SELECT SINGLE MATNR FROM VBFA

INTO Z_MAT_DOC_NO

WHERE VBELV = LIKP-VBELN AND

VBTYP_N = 'R' .

Regards

Özgün

Re: ABAP Code Error on Query

Former Member — Wed, 18 Jun 2014 14:42:56 GMT

Hello Joe ,

Try this ,

DATA : Z_MAT_DOC_NO TYPE VBFA-VBELN .

CLEAR :Z_MAT_DOC_NO.

SELECT SINGLE VBELN

FROM VBFA

INTO Z_MAT_DOC_NO

WHERE VBELV = LIKP-VBELN

AND VBTYP_N = 'R' .

Zuby Chakravorty

Re: ABAP Code Error on Query

VenkatRamesh_V — Wed, 18 Jun 2014 15:01:30 GMT

Hi Joe,

try this and see.

Clear Z_MAT_DOC_NO.

Select VBELN FROM VBFA into table itab

WHERE VBELV = LIKP-VBELN

AND VBTYP_N IN ( 'R' ).

Regards,

Venkat.