topic Re: data not displaying in Report in Application Development and Automation Discussions

data not displaying in Report

Former Member — Tue, 21 Sep 2010 08:55:23 GMT

hi all, i have created a report in which i have created internal table.When i debug the code,in my internal table giving my required data but when i execute it doesn't display my data.Following are the code for Report:

<pre class="jive-pre"><code class="jive-code jive-java">PARAMETERS:

p_ekorg type ekko-ekorg.

SELECT-OPTIONS:

s_ebeln FOR ekko-ebeln,

s_submi FOR ekko-submi,

s_lifnr FOR ekko-lifnr,

s_anfnr FOR ekpo-anfnr,

s_matnr FOR ekpo-matnr.

DATA: BEGIN OF gi_rfq OCCURS 0,

matnr LIKE ekpo-matnr,

ematn like ekpo-ematn, "Material Number

txz01 like ekpo-txz01, "Mareial Description

menge like ekpo-menge, "Quantity

netpr like ekpo-netpr, "Rate

ebeln like ekpo-ebeln, "PO Number

anfnr LIKE ekpo-anfnr, "RFQ No.

banfn like ekpo-banfn, "PR Number

ebelp LIKE ekpo-ebelp,

END OF gi_rfq,

BEGIN OF gi_ekko OCCURS 0,

ebeln LIKE ekko-ebeln,

ekorg LIKE ekko-ekorg,

BSTYP LIKE ekko-BSTYP, "Purchasing Document Category

submi LIKE ekko-submi, "Collective Number

lifnr LIKE ekko-lifnr, "Vendor Number

bedat LIKE ekko-bedat,

END OF gi_ekko,

BEGIN OF gi_reqdate OCCURS 0,

banfn LIKE eban-banfn, "Purchase Requisition Number

bedat LIKE eban-bedat, "PO Date

badat LIKE eban-badat, "PR Date

END OF gi_reqdate,

BEGIN OF gv_lfa1 OCCURS 0,

name1 like lfa1-name1, "Vendor Name

lifnr LIKE lfa1-lifnr,

END OF gv_lfa1,

BEGIN OF gv_final OCCURS 0,

ebeln LIKE ekko-EBELN,

bedat LIKE ekko-bedat,

anfnr LIKE ekpo-anfnr,

matnr LIKE ekpo-matnr,

submi LIKE ekko-submi,

lifnr LIKE ekko-lifnr,

END OF gv_final,

BEGIN OF gi_final OCCURS 1,

matnr LIKE ekpo-matnr,

ematn like ekpo-ematn, "Material Number

txz01 like ekpo-txz01, "Mareial Description

menge like ekpo-menge, "Quantity

netpr like ekpo-netpr, "Rate

ebeln like ekpo-ebeln, "PO Number

anfnr LIKE ekpo-anfnr, "RFQ No.

banfn like ekpo-banfn, "PR Number

ebelp LIKE ekpo-ebelp,

ekorg LIKE ekko-ekorg,

BSTYP LIKE ekko-BSTYP, "Purchasing Document Category

submi LIKE ekko-submi, "Collective Number

lifnr LIKE ekko-lifnr, "Vendor Number

bedat LIKE ekko-bedat,

badat LIKE eban-badat, "PR Date

name1 like lfa1-name1, "Vendor Name

END OF gi_final.

data: lv_bedat type ekko-bedat,

lv_netpr TYPE ekpo-netpr,

gi_main LIKE ekko,

gi_eban LIKE eban,

gi_lfa1 LIKE lfa1,

gi_detail LIKE STANDARD TABLE OF ekpo WITH HEADER LINE.

START-OF-SELECTION.

PERFORM f_get_data.

PERFORM f_orgdata.

PERFORM f_display_report.

FORM f_get_data .

IF sy-subrc EQ 0.

SELECT MAX( bedat ) into lv_bedat

from ekko

WHERE ebeln IN s_ebeln

AND submi in s_submi

group by lifnr.

SELECT submi BSTYP ebeln lifnr

FROM ekko

INTO CORRESPONDING FIELDS OF gi_ekko

WHERE ebeln IN s_ebeln

AND submi in s_submi

and bedat eq lv_bedat

AND spras = 'E'.

Append gi_ekko.

EndSelect.

Endselect.

SELECT MIN( netpr ) into lv_netpr

from ekpo

WHERE ebeln IN s_ebeln

group by anfnr.

SELECT ematn txz01 menge anfnr banfn

INTO CORRESPONDING FIELDS OF TABLE gi_rfq

FROM ekpo

WHERE ebeln IN s_ebeln.

APPEND gi_rfq.

ENDSELECT.

SELECT name1

FROM lfa1

INTO CORRESPONDING FIELDS OF TABLE gv_lfa1

WHERE lifnr eq gi_lfa1-lifnr.

endif.

endform.

FORM f_orgdata.

LOOP AT gi_rfq.

MOVE-CORRESPONDING gi_ekko to gi_final.

CLEAR gi_ekko.

READ TABLE gi_ekko WITH KEY ebeln = gi_ekko-ebeln.

MOVE gi_ekko-bedat to gi_main-bedat.

MOVE gi_ekko-bstyp to gi_main-bstyp.

MOVE gi_ekko-submi to gi_main-submi.

MOVE gi_ekko-lifnr to gi_main-lifnr.

MOVE-CORRESPONDING gv_lfa1 to gi_final.

CLEAR gv_lfa1.

READ TABLE gv_lfa1 with key lifnr = gi_lfa1-lifnr.

MOVE gi_lfa1-name1 to gi_lfa1-name1.

MOVE-CORRESPONDING gi_rfq to gi_final.

CLEAR gi_rfq.

READ TABLE gi_rfq WITH KEY ebeln = gi_rfq-ebeln.

MOVE gi_rfq-ematn to gi_detail-ematn.

MOVE gi_rfq-txz01 to gi_detail-txz01.

MOVE gi_rfq-menge to gi_detail-menge.

MOVE gi_rfq-netpr to gi_detail-netpr.

MOVE gi_rfq-banfn to gi_detail-banfn.

MOVE gi_rfq-anfnr to gi_detail-anfnr.

APPEND gi_detail.

CLEAR gi_final.

endloop.

ENDFORM.

FORM f_display_report .

DATA: fname(30) TYPE c.

CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'

EXPORTING

formname = 'ZCCL_RATE_COMPARISION2'

IMPORTING

fm_name = fname

EXCEPTIONS

no_form = 1

no_function_module = 2

OTHERS = 3.

IF sy-subrc = 0.

CALL FUNCTION fname

EXPORTING

gs_main = gi_main

gs_eban = gi_eban

gs_lfa1 = gi_lfa1

TABLES

it_detail = gi_detail.

ENDIF.

ENDFORM.

</code></pre>

Thanks,

sapabappk

Re: data not displaying in Report

Former Member — Tue, 21 Sep 2010 09:00:48 GMT

Hi!

You called a smartform, not a report for displaying.

Check the smartform's interface (using SMARTFORMS transaction), it has to refer the same structures, you are using in your report.

gi_main LIKE ekko,

gi_eban LIKE eban,

gi_lfa1 LIKE lfa1,

gi_detail LIKE STANDARD TABLE OF ekpo WITH HEADER LINE.

Regards

Tamá

Re: data not displaying in Report

Former Member — Tue, 21 Sep 2010 09:22:10 GMT

hi Tamás Nyisztor,

i have changed the structure used in my coding with samrtforms but still i can't get the desired result.Do you any other suggestion..?

Thanks & Regards,

sapabapk

Re: data not displaying in Report

Former Member — Tue, 21 Sep 2010 09:25:43 GMT

Hi!

Well, there should be many problems, but there are not problems in your program, but in your SMARTFORM.

You have to modify your smartform to your needs, but because you didn't tell, what's the problem exactly with your smartform, and what do you want to see on the output, unfortunately I can't help you more.

Regards

Tamá

Re: data not displaying in Report

Former Member — Tue, 21 Sep 2010 09:25:57 GMT

you are getting the smartform as an output or getting some error.

Re: data not displaying in Report

Former Member — Tue, 21 Sep 2010 09:38:44 GMT

hi Mayank Modi,

Yes im getting SMART FROM as an output and i don't got any error only the issue is that when i execute it with debug i check my internal table i-e GI_RFQ,GI_EKKO and GI_DETAIL giveing me data.

Thanks & Regards,

sapabappk

Re: data not displaying in Report

kesavadas_thekkillath — Tue, 21 Sep 2010 09:45:20 GMT


    CALL FUNCTION fname
      EXPORTING
        gs_main    =  gi_main
        gs_eban    =  gi_eban
        gs_lfa1    =  gi_lfa1
 
      TABLES
        it_detail  =  gi_detail[].  "<---

Tyr this.

Re: data not displaying in Report

Former Member — Tue, 21 Sep 2010 09:49:50 GMT

hi Tamás Nyisztor,

well when i execute my coding,these field i-e PR DATE , PR.NO, * PR.DATE* and RATE is given me 0 values and last field is

RFQ No. which im displaying 9 times which is different from each other.

Thanks & Regards,

sapabappk