Regarding select query

Former Member — Wed, 11 Jul 2007 14:12:51 GMT

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

Re: Regarding select query

Former Member — Wed, 11 Jul 2007 15:31:11 GMT

NO NEED FOR ANU BUTTON , CLICK ON RADIOBUTTON AND CLICK ON EXCUTE BUTTON SO THAT U WILL GET OUT PUT

PLZ DON'T GO FOR JOINS

U WILL GET PERFORMANCE PROBLEM

BETTER YOU GO FOR FOR ALL ENTRIES

Re: Regarding select query

Former Member — Wed, 11 Jul 2007 15:31:56 GMT

SEND ME EXACT PROBLEM , IF POSSIBLE I WILL SOLVE IT

BYE REGARDS

NARESH

topic Regarding select query in Application Development and Automation Discussions

Regarding select query

Re: Regarding select query

Re: Regarding select query