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

SELECT statement Issue

Former Member — Thu, 19 Jun 2008 11:22:11 GMT

I have used the follwoing select statement.

select posnr kwmeng meins vbeln from VBAP

into corresponding fields of table it_vbap

where vbeln = v_vbeln.

Now, i am able to get the required fields from VBAP table without any issue.

But, it has been observed that for particluar sales document, the value for the field VBAP-MEINS is 'H' (Hours). I am able to get this value as 'H' only.

But few Sales Documents have the VBAP-MEINS value as 'D' (Day).

Then select statement should retrieve this value as 'D' only.

But instead of this, the select statement is getting this value as '1'.

When i look into SE11-->VBAP table, the table shows it as VBAP-MEINS as 'D'.

When i debug the code, the value shows as '1'.

How to resolve this issue?

Regards

Pavan

Re: SELECT statement Issue

valter_oliveira — Thu, 19 Jun 2008 11:28:23 GMT

Hi there.

That behaviour is normal, because the field MEINS has a convertion routine. The measure Day, has output format as D, but internal as 10.

Use FM CONVERSION_EXIT_CUNIT_OUTPUT after select.

To check how it works, try in SE37, with input parameter 10.

Regards.

Valter Oliveira.

Re: SELECT statement Issue

Former Member — Thu, 19 Jun 2008 11:29:32 GMT

there is CONVERSION_EXIT for MEINS so ur geting that data in that way

if you want to change 1 to d Use FM 'CONVERSION_EXIT_CUNIT_OUTPUT'.

Re: SELECT statement Issue

Former Member — Thu, 19 Jun 2008 11:30:12 GMT

Hi ,

The reaseon for it is that MEINS has a conversion routine CUNIT attached to it.

So the value which you get in the internal table will be the internal representation , but you will not have any problem when you print it or display it in ALV.

Regards

Arun

Re: SELECT statement Issue

GauthamV — Thu, 19 Jun 2008 11:31:05 GMT

hi,

use this function module

CONVERSION_EXIT_CUNIT_OUTPUT

reward if hlpful.

Re: SELECT statement Issue

Former Member — Thu, 19 Jun 2008 11:34:53 GMT

HI,

Why dont you use the conversion exit for that field of the internal table.

I guess MEINS has the conversion exit.

If it does not solve ur problem u can use CASE Statement.

Re: SELECT statement Issue

Former Member — Thu, 19 Jun 2008 11:58:33 GMT

hi pavan,

as my understanding it should not get like that.

let it be i have one solution try like this.

select posnr kwmeng meins vbeln from VBAP

into corresponding fields of table it_vbap

where vbeln = v_vbeln.

after collecting the data into the internal table write the below code.

loop at it_vbap where meins eq '1'.

it_vbap-meins = 'D'.

modify it_vbap.

endloop.

i think this may solve your problem.

Regards

Sree..

Re: SELECT statement Issue

Former Member — Mon, 23 Jun 2008 05:45:38 GMT

Thanks....