regarding conversion exit for fetching kunnar value

[Former Member]

hi gurus,

this is my syntax for fetching kunnar value

IF IT_FINAL1[] IS NOT INITIAL.

SELECT SINGLE KUNNR FROM VBPA

INTO WA_VBPA1 WHERE VBELN = IT_FINAL1-VBELN AND PARVW = 'SP'.

MOVE WA_VBPA1-KUNNR TO WA_FINAL1-KUNNR.

IF SY-SUBRC EQ 0.

MESSAGE E000(0) WITH 'VALUE NOT THERE' .

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_FINAL1-KUNNR

IMPORTING

OUTPUT = WA_FINAL1-KUNNR.

MODIFY IT_FINAL1 FROM WA_FINAL1 .

ENDIF.

data is not coming in debugging mode.

please tell me where is the fault..

thanks

subhasis

[Former Member]

you need to use select statement in for all entreis it_final table or loop at it_final . then you will get partner values.

[Former Member]

Hi,

Why dont you put KUNNR directly into WA_FINAL1-KUNNR , this way you can avoid the conversion exit also.

Also, you need to loop @ the table IT_FINAL1.

IF IT_FINAL1[] IS NOT INITIAL.
LOOP AT IT_FINAL1 INTO WA_FINAL1.
SELECT SINGLE KUNNR FROM VBPA
INTO WA_FINAL1-KUNNR 
WHERE VBELN = WA_FINAL1-VBELN AND PARVW = 'SP'.
IF SY-SUBRC <> 0.
MESSAGE E000(0) WITH 'VALUE NOT THERE' .
ELSE.
MODIFY IT_FINAL1 FROM WA_FINAL1 
INDEX SY-TABIX TRANSPORTING KUNNR.
ENDIF.
ENDLOOP.
ENDIF.

Cheers,

Aditya

Edited by: Aditya Laud on Feb 12, 2008 2:23 AM

[Former Member]

hi,

thanks...but i put the coading u provided...but kunnar value no coming...please help me...its very simple..for u..i want only kunnar value from vbpa.i thing conversion exit necessary.

because in database kunnar value is like 00010000.

so plaese help me...guru

thanks

[Former Member]

Hi,

Problem is not with KUNNR it is with the partner function.

Dont check against SP instead use AG.

In your query, replace

PARVW EQ 'SP'

with

PARVW EQ 'AG'.

Cheers,

Aditya