Hi Expart..
My Di posting date 09.03.2008 .accroding to di date the frieght value 205 in date range 02.02.2008 to 15.03.2008.
frieght value it ll change corresponding the date .
so my requirment is frieght value transfer to main outputinternal table accronding to date 09.03.2008 .posting date is main IT table .
Pls tell me the coding transfer fright value to main It table .
my coding is
SELECT axabln alfart ainco1 avbeln abldat akunnr akunag atraid atragr dvgbel a~wadat_ist
blifnr bparvw dwerks dlfimg INTO CORRESPONDING FIELDS OF TABLE itab_output FROM likp AS a
INNER JOIN vbpa AS b ON avbeln = bvbeln
INNER JOIN vbuk AS c ON avbeln = cvbeln
INNER JOIN lips AS d ON avbeln = dvbeln
WHERE a~vbeln IN r_vbeln
AND a~wadat_ist IN s_lfdat
AND a~lfart IN s_lfart
AND a~inco1 IN s_inco1
AND b~lifnr IN s_lifnr
AND b~parvw = 'Z6'
AND c~abstk <> 'C'
AND c~wbstk <> 'A'.
itab_output is main IT table wadat_ist is date .
fdt = s_lfdat-low.
tdt = s_lfdat-high.
SELECT atragr ainco1 areswk awerks adatbi adatab b~kbetr
INTO TABLE itab_a555 FROM a555 AS a INNER JOIN konp AS b
ON aknumh = bknumh
where ( ( adatab <= fdt and adatbi >= tdt ) or ( adatab >= fdt and adatbi <= tdt )
or ( adatab <= fdt and adatbi >= fdt ) or ( adatab <= tdt and adatbi >= tdt ) ).
itab_a555 is 2nd IT table kbetr is frieght value store .
Regards
Bhabani