Skip to Content
0
Former Member
May 10, 2010 at 01:15 PM

After Transporting Report Request Report is displaying Null values

52 Views

Hi All,

I have make a report and after testing that the DATA is coming from DEV server is OK,than i transport it to QAS and PRD.

But the problem i'm facing is that when i execute the Report, both in QAS and PRD, it gives me NULL values.

I am giving you the whole coding of my Report.

INCLUDE zalsd_alv_incl.

tables: LFA1,LFM2,WYT1T.

TYPES:

begin of ty_detail,

LIFNR like LFA1-LIFNR,"Vendor Code.

NAME1 like LFA1-NAME1,"Vendor Name.

KTOKK like LFA1-KTOKK,"Vendor account group

STRAS LIKE LFA1-STRAS,"Adress.

ORT01 LIKE LFA1-ORT01,"City.

EKORG like LFM2-EKORG,"Purchase Organization.

EKGRP like LFM2-EKGRP,"Purchase in Group.

LTSNR like LFM2-LTSNR,"Subrange

LTSBZ like WYT1T-LTSBZ,"Description of Vendor Subrange

end of ty_detail.

data: gi_main type TABLE OF ty_detail WITH HEADER LINE.

data: gi_detail type TABLE OF ty_detail WITH HEADER LINE.

SELECT-OPTIONS: p_lifnr FOR LFA1-LIFNR MATCHCODE OBJECT kred,

p_ekorg FOR LFM2-EKORG MEMORY ID eko,

p_sortl FOR LFA1-SORTL,

p_ktokk FOR LFA1-KTOKK.

START-OF-SELECTION.

PERFORM getdata.

PERFORM displayreport.

----


*& Form GETDATA

&----


FORM GETDATA.

SELECT LFA1LIFNR LFA1NAME1 LFA1KTOKK LFA1STRAS LFA1ORT01 WYT1TLTSNR WYT1T~LTSBZ

from LFA1

INNER JOIN WYT1T

on lfa1lifnr = WYT1Tlifnr

INTO CORRESPONDING FIELDS OF TABLE gi_main

where LFA1~LIFNR IN p_lifnr

and WYT1T~LIFNR in p_lifnr

AND LFA1~KTOKK IN p_ktokk

AND LFA1~SORTL IN p_sortl

and WYT1T~spras eq 'E'.

loop at gi_main.

SELECT single EKORG EKGRP

into CORRESPONDING FIELDS OF gi_main

from LFM1

where lifnr = gi_main-lifnr

and ekorg in p_ekorg.

if sy-subrc eq 0.

MOVE-CORRESPONDING gi_main to gi_detail.

APPEND gi_detail.

endif.

MODIFY gi_main INDEX sy-tabix.

ENDLOOP.

endform. "GETDATA

&----


*& Form displayreport

&----


  • text

----


FORM displayreport .

PERFORM fill_fieldcat USING 'LIFNR' 10 'Vendor Code' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'NAME1' 20 'Vendor Name' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'KTOKK' 10 'Search Item' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'STRAS' 25 'Adress' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'ORT01' 20 'City' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'EKORG' 20 'Purchase Oragnization' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'EKGRP' 20 'Purchase in Group' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'LTSNR' 10 'Subrange' 'GI_DETAIL'.

PERFORM fill_fieldcat USING 'LTSBZ' 25 'Description of Vendor Subrange' 'GI_DETAIL'.

PERFORM add_heading_alv USING c_alv_head_header '' 'Cherat Cement Company Ltd.'.

PERFORM add_heading_alv USING c_alv_head_selection '' 'Vendor Report'.

PERFORM display_alv USING gi_detail[].

ENDFORM.