Skip to Content
0
Former Member
Nov 05, 2012 at 08:00 AM

how to make query from different tables

34 Views

Hi all,

i want to display data in ALV, need to fetch data from DB, below are my fields can you please guide me how can i make query for these

TYPES: BEGIN OF p_proj,
SNO TYPE int4, "Serial no
BLDAT TYPE mkpf-BLDAT, "DAte
MATKL TYPE MARA-MATKL, "Type of Addmixture
MBLNR TYPE MKPF-MBLNR, "Dellivery Receipt no
NAME1 TYPE LFA1-NAME1, "NAME
MENGE TYPE MSEG-MENGE, "QUANTITY
SGTXT TYPE MSEG-SGTXT, "Remarks
END OF p_proj.


DATA: it_proj TYPE STANDARD TABLE OF p_proj WITH HEADER LINE,
wa_proj TYPE p_proj,
VSNO TYPE INT4.

Regards