Regarding select query
Hi all
I hav the situation
When radio button =Storage location
Extract the data specified by parameter and store in the internal table.
ISEG-MATNR　(Material number) = <Selection screen>MATNR(Material number)
ISEG-WERKS　(Plant) = <Selection screen>WERKS(Plant)
ISEG-LGORT　(Storage location)= <Selection screen>LGORT(Storage location)
IKPF-GJAHR　(Fiscal year) =Fiscal year obtained in 2.
IKPF-ZLDAT　(Count date)=Initial value
ISEG-ERFMG　(Unit of entry quantity)=Initial value
ISEG-XNULL　(Count result zero)=Blank
Join：
ISEG inner IKPF
join
ISEG inner MARA
join
ISEG inner MARC
join
ISEG inner T064B
join
ISEG inner MAKT
join
ISEG-IBLNR　(Physical inventory document) =IKPF-IBLNR　(Physical inventory document)
ISEG-GJAHR　(Fiscal year)=IKPF-GJAHR　(Fiscal year)
ISEG-MATNR　(Material number) =MARA-MATNR　(Material number)
ISEG-MATNR　(Material number) =MARC-MATNR　(Material number)
ISEG-WERKS　(Plant)=MARC-WERKS　(Plant)
ISEG-BSTAR　(Stock type)=T064B-BSTAR　(Stock type)
T064B-SPRAS　(Language key)=SY-LANGU
MAKT-SPRAS　(Language key) =SY-LANGU
I hav to extract
ISEG-MATNR Material number
ISEG-WERKS Plant
ISEG-LGORT Storage location
IKPF-IBLNR Physical inventory document
IKPF-GJAHR Fiscal year
IKPF-BLDAT Document date of document
IKPF-GIDAT Inventory count plan date
IKPF-ZLDAT Count date
ISEG-ZEILI Item
ISEG-CHARG Batch number
ISEG-SOBKZ Special stock indicator
ISEG-BSTAR Stock type
ISEG-KUNNR Customer number
ISEG-KDAUF Sales order number
ISEG-KDPOS Sales order item number
ISEG-ERFMG Quantity of unit entry
ISEG-MEINS Base unit of measure
ISEG-XNULL Count result zero
MARA-MEINSSERIAL Serial number profile
MARA-PRDHA Material hierarchy
MARA-MATKL Material group
MARC-BWTTY Valuation category
T064B-BTEXT Stock type text
MAKT-MAKTX Material text
how can i write the query shall i use all join or i wil go to For all Entries
and how can i fix the button
pl its very urgent