Steps to create a query

Former Member — Fri, 23 Feb 2007 09:14:32 GMT

Hi ,

i need to bulid a query for tc : mb51 , tables mch1 and mska , query is to pull a field licha on to mb51 transaction.May i know the steps pls..

Thxs,

vind.

Re: Steps to create a query

Former Member — Fri, 23 Feb 2007 09:23:19 GMT

Hi,

MB51 uses the data from MKPF and MSEG tables.

Take the MATNR CHARG and LIFNR fields from MSEG and pass them to MCH1 table to get the LICHA field.

If MSEG data is in Int table ITAB.

if not ITAB[] is initial.

select matnr charg lifnr licha from mch1 into table <itab2>

for all entries in ITAB where

matnr = itab-matnr and

charg = itab-charg and

lifnr = itab-lifnr.

endif.

Then read the licha with key fields and add into final data int table.

Regards,

Anji