topic Re: Issue with SELECT statement in Application Development and Automation Discussions

Issue with SELECT statement

Former Member — Mon, 02 Jun 2008 06:40:45 GMT

Hi All,

I have written a select statment to get the the Sales order Type from VBAK.

select vbeln auart from VBAK

into corresponding fields of table i_vbeln

for all entries in it_main

where vbeln = it_main-aubel

and auart = 'CR'.

Even though the database table VBAK-AUART is having the value as 'CR', the select statment is unable to fetch this value.

How to resolve this?

Regards

Pavan

Re: Issue with SELECT statement

Former Member — Mon, 02 Jun 2008 06:44:02 GMT

Hi,

Before this querry,please check whether the internal table it_main is filled.

Add the statement before select querry.

if it_main is not initial.

select.........

endif.

Also check whether the it_main contains valid 'AUBEL'.It should be matching with VBELN.

Re: Issue with SELECT statement

former_member673464 — Mon, 02 Jun 2008 06:45:57 GMT

hi,

There is conversion routine for it.Sales order type is stored in different format in database table. you have to use the internal format of the order type in select condition.Try to use 'G2' instead of 'CR' in the select query.you can use the function modules CONVERSION_EXIT_AUART_INPUT

CONVERSION_EXIT_AUART_OUTPUT for getting the corresponding sales types and conversions.

Regards,

Veeresh

Edited by: veereshbabu ponnada on Jun 2, 2008 12:23 PM

Re: Issue with SELECT statement

Former Member — Mon, 02 Jun 2008 06:46:07 GMT

Hi Pavan!

select vbeln auart from VBAK

into corresponding fields of table i_vbeln

for all entries in it_main

where vbeln = it_main-aubel

and auart = 'CR'.

try using:

select vbeln auart from VBAK

into table i_vbeln

for all entries in it_main

where vbeln = it_main-aubel

and auart = 'CR'.

kindly reward points if helpful.

Re: Issue with SELECT statement

Former Member — Mon, 02 Jun 2008 06:51:12 GMT

Dear Pawan,

Even Though You wrote

select vbeln auart from VBAK

into corresponding fields of table i_vbeln

for all entries in it_main

where vbeln = it_main-aubel

and auart = 'CR'.

you need to check internal table which having AUBEL corresponding that in VBAK values are there and Doc type is CR.

check this.

Amit.

Re: Issue with SELECT statement

asik_shameem — Mon, 02 Jun 2008 06:52:36 GMT

It internally uses CONVERSION ROUTINE. That is the problem in your case.

Use G2 instead CR.

Otherwise use FM CONVERSION_EXIT_AUART_INPUT

Re: Issue with SELECT statement

peter_ruiz2 — Mon, 02 Jun 2008 06:54:58 GMT

hi pavan,

check the table TAUUM. here, enter CR in the AUART_SPR field and you will see that it has a conversion. In our case, we have assigned 'CR' to the standard order type 'G2' of SAP.

regards,

Peter

Re: Issue with SELECT statement

Former Member — Mon, 02 Jun 2008 07:14:57 GMT

Hi Pavan,

I think you should check AUBEL and VBELN is of same type..

I am sure problem with the data type..