Hello: Help in creating a query

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.