query

maiintain structure of the table <b>i_plaf</b> like table

zppo_pl

if source field lenth is less its not a probs, and if u are not getting the data then u have to make use of FM

CONVERSION_EXIT_ALPHA_INPUT

regards

Prabhu

Hi

When you define the internal table i_plaf, here the field AUFNR has to be defined like ZPPO_PL-ZAUFNR.

So while you get the data from PLAF and store them into I_PLAF you have to store in I_PLAF-AUFNR in according to the value stored in ZPPO_PL-ZAUFNR.

The field PLAF-AUFNR is 10 char, so for example 10 is stored like 0000000010,

The field ZPPO_PL-ZAUFNR is 12 char, so 10 can be stored like 000000000010,

So after insert the data from PLAF to I_PLAF you have to inert two zero on the left.

U can use fm CONVERSION_EXIT_ALPHA_INPUT.

SELECT * FROM PLAF INTO TABLE I_PLAF WHERE ....

LOOP AT I_PLAF.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = I_PLAF-AUFNR

IMPORTING

OUTPUT = I_PLAF-AUFNR.

MODIFY I_PLAF.

ENDLOOP.

Anyway how to convert the the format of AUFNR depends on how the data is stored in ZPPO_PL-ZAUFNR.

Max

hi,

use CONVERSION_EXIT_ALPHA_INPUT befor the query.

it will help u.

rgds

anver

pls mark useful answers