topic If condition-- mapping in Application Development and Automation Discussions

If condition-- mapping

Former Member — Thu, 17 Apr 2008 23:18:10 GMT

Hi,

I want to print the company description using the following mappings :

0268 = x.

0278 = y.

2706 = z.

how can i do this with this select statements.

select bukrs docdat ntgew brgew anzpk nfnum from J_1BNFDOC

into corresponding fields of int_output where

DOCNUM = int_output-docnum.

here,

bukrs is company code.

Pls reply asap.

Stal.

Former Member — Thu, 17 Apr 2008 23:53:23 GMT

After your select statement,

You can write the below select to get the company description.

select bukrs butxt

from t001

into table i_t001

for all entries in int_output

where bukrs = int_output-bukrs.

Once you get the values then you can loop and move the company code description to the final internal table...and you can do the further process.

Thanks,

Srinivas