Skip to Content
0
Former Member
Mar 27, 2009 at 06:08 AM

Fatch data in ALV Reports from multiple Tables

995 Views

Respected Sir,

How to fatch data in ALV Grid report from selected Field and selected Table.

Please Help and My require Field and Table is :

sono LIKE vbak-vbeln,

sodat LIKE vbak-erdat,

cust LIKE kna1-name1,

pono LIKE vbkd-bstkd,

podat LIKE vbkd-bstdk,

item_no LIKE vbap-posnr,

item_des LIKE vbap-arktx,

name LIKE vbak-kunnr,

pdate LIKE vbak-bstdk,

acdel LIKE lips-lgmng,

netweight LIKE likp-ntgew,

ordval LIKE VBRP-netwr,

  • CUST_MAT_NO LIKE VBAP-KDMAT,

order_qty LIKE vbap-kwmeng,

desp_qty(5) TYPE p DECIMALS 2, "LIKE lips-lfimg,

balance(5) TYPE p DECIMALS 2,

delv_no LIKE likp-vbeln,

delv_dat LIKE likp-bldat,

invoice LIKE vbrk-vbeln,

exnum like J_1IEXCHDR-exnum,

invoice_dat LIKE vbrk-fkdat,

invoice_val LIKE konv-kwert,

END OF it_out.

*Please Refere the following code and if u wnt to change at ur own ieda u can change and reply me back.*

*Thnaks In ADVANCE.*

*Please Do need full it.*

*Bhavesh Panchal*

*Baroda*

Also I Make Reports For SO : full coding is.

&----


*& Report Z_NEW1

*&

&----


*&

*&

&----


REPORT Z_NEW1.

TABLES : vbak, "Sales Document: Header Data

vbkd, "Sales Document: Business Data

likp, "SD Document: Delivery Header Data

vbrk, "Billing Document: Header Data

konv, "Conditions (Transaction Data)

lips, "SD document: Delivery: Item data

vbap, "Sales Document: Item Data

vbrp, "Billing Document: Item Data

kna1, "General Data in Customer Master

J_1IEXCHDR.

DATA : i_vbak LIKE vbak OCCURS 10 WITH HEADER LINE.

DATA : it_vbkd LIKE vbkd OCCURS 10 WITH HEADER LINE.

DATA : it_likp LIKE likp OCCURS 10 WITH HEADER LINE.

DATA : it_vbrk LIKE vbrk OCCURS 10 WITH HEADER LINE.

DATA : it_konv LIKE konv OCCURS 10 WITH HEADER LINE.

DATA : it_lips LIKE lips OCCURS 10 WITH HEADER LINE.

DATA : it_vbap LIKE vbap OCCURS 10 WITH HEADER LINE.

DATA : it_vbrp LIKE vbrp OCCURS 10 WITH HEADER LINE.

DATA : it_kna1 LIKE kna1 OCCURS 10 WITH HEADER LINE.

DATA : it_vbrp1 LIKE vbrp OCCURS 10 WITH HEADER LINE.

DATA : it_temp LIKE lips OCCURS 10 WITH HEADER LINE.

DATA : it_lips1 LIKE lips OCCURS 10 WITH HEADER LINE.

DATA : it_lips2 LIKE lips OCCURS 10 WITH HEADER LINE.

DATA : it_lips3 LIKE lips OCCURS 10 WITH HEADER LINE.

DATA : it_vbak1 LIKE vbak OCCURS 10 WITH HEADER LINE.

DATA : it_vbak2 LIKE vbak OCCURS 10 WITH HEADER LINE.

DATA : it_vbap1 LIKE vbap OCCURS 10 WITH HEADER LINE.

DATA : it_posnv LIKE zdelprt OCCURS 10 WITH HEADER LINE.

DATA : BEGIN OF it_out OCCURS 10,

sono LIKE vbak-vbeln,

sodat LIKE vbak-erdat,

cust LIKE kna1-name1,

pono LIKE vbkd-bstkd,

podat LIKE vbkd-bstdk,

item_no LIKE vbap-posnr,

item_des LIKE vbap-arktx,

name LIKE vbak-kunnr,

pdate LIKE vbak-bstdk,

acdel LIKE lips-lgmng,

netweight LIKE likp-ntgew,

ordval LIKE VBRP-netwr,

  • CUST_MAT_NO LIKE VBAP-KDMAT,

order_qty LIKE vbap-kwmeng,

desp_qty(5) TYPE p DECIMALS 2, "LIKE lips-lfimg,

balance(5) TYPE p DECIMALS 2,

delv_no LIKE likp-vbeln,

delv_dat LIKE likp-bldat,

invoice LIKE vbrk-vbeln,

exnum like J_1IEXCHDR-exnum,

invoice_dat LIKE vbrk-fkdat,

invoice_val LIKE konv-kwert,

END OF it_out.

SELECT-OPTIONS: sono FOR vbak-vbeln.

SELECT-OPTIONS: customer FOR vbak-kunnr.

SELECT-OPTIONS: d_date FOR likp-bldat.

  • LOOP AT it_OUT.

  • select * into table i_vbak from vbak

  • where vbeln IN sono.

  • sono = vbak-vbeln.

  • append it_out.

  • modify it_out.

  • endloop.

  • LOOP AT it_out.

  • SELECT single vbeln netwr FROM vbak

  • INTO (it_out-pono,it_out-podat)

  • WHERE vbeln = it_out-sono.

  • "it_out-item_no.

  • append it_out.

  • ENDLOOP.

select * into table i_vbak from vbak

where vbeln IN sono.

call function 'REUSE_ALV_GRID_DISPLAY'

exporting

i_structure_name = 'VBAK'

I_grid_title = 'Bhavesh Panchal'

tables

t_outtab = i_vbak

  • t_outtab = it_out

exceptions

others = 1.