topic Re: Hello: Help in creating a query in Application Development and Automation Discussions

Hello: Help in creating a query

Former Member — Fri, 22 Aug 2008 07:15:12 GMT

Hello All,

I have to join two tables, LIPS AND VBAP on the fields

lips-pspnr = vbap-ps_psp_pnr.

The problem i'm facing is: The table stores the value in converted form, the function is CONVERSION_EXIT_KONPD_OUTPUT.

Kindly guide me.

For the reference i'm posting my code.

select single pspnr into ppspnr from lips where vbeln = wa_hd_gen-deliv_numb.

CALL FUNCTION 'CONVERSION_EXIT_KONPD_OUTPUT'

EXPORTING

INPUT = ppspnr

IMPORTING

OUTPUT = ppspnro

PSELT =

CONCATENATE '''' PPSPNRO '''' INTO PPSPNRO .

CONCATENATE 'vbap~ps_psp_pnr = ' ppspnro INTO clause SEPARATED BY SPACE.

APPEND clause TO where_clause.

select single vbap~vbeln into s_vbeln from vbap WHERE (where_clause).

select single vbap_{vbeln into s_vbeln from vbap WHERE vbap}ps_psp_pnr = ppspnro.

Thanks.

Re: Hello: Help in creating a query

Former Member — Fri, 22 Aug 2008 07:24:35 GMT

hi Ushma..

use the following Function module

CONVERSION_EXIT_ABPRJ_INPUT

Converts External Project Number to Internal Project Number

CONVERSION_EXIT_ABPRJ_OUTPUT

Converts Internal Project Number to External Project Number

CONVERSION_EXIT_ABPSN_INPUT

Format > Without Edition (Project Number / WBS Element umber)

CONVERSION_EXIT_ABPSN_OUTPUT

Format > With Edition (Project Number / WBS Element Number)

CONVERSION_EXIT_ABPSP_INPUT

Conversion External > Internal WBS Element Number

CONVERSION_EXIT_ABPSP_OUTPUT

Conversion Internal > External WBS Element Number

Regards

Deva

Re: Hello: Help in creating a query

Former Member — Fri, 22 Aug 2008 08:48:30 GMT

Hello Deva,

Thanks a lot fora prompt reply.

Am i supposed to use all the functions or any of them.

If i'm supposed to use all of them , then inthe same sequence as you have specified?

Thanks a lot.

Re: Hello: Help in creating a query

Former Member — Sat, 23 Aug 2008 06:09:53 GMT

hi Ushma

actually the problem may be the WBS internal & external no.

so check you program in debug mode where it get failed..

Those FM are used for

1. To get WBS External no by giving WBS internal no or vice versa

2. To get PROJECT External no by giving PROJECT internal no or vice versa

Regards

Deva

Re: Hello: Help in creating a query

Former Member — Sat, 23 Aug 2008 09:58:30 GMT

Hello Deva,

Thanks for your help, my query has worked.

I have used the combination of the following FM:

conversion_exit_konpd_output ,

conversion_exit_abpsp_input.

Thanks.