Skip to Content
0
Former Member
May 27, 2008 at 12:36 PM

Problem in Report

27 Views

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