Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding select query

Former Member
0 Kudos

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&#12288;(Material number) = <Selection screen>MATNR(Material number)

ISEG-WERKS&#12288;(Plant) = <Selection screen>WERKS(Plant)

ISEG-LGORT&#12288;(Storage location)= <Selection screen>LGORT(Storage location)

IKPF-GJAHR&#12288;(Fiscal year) =Fiscal year obtained in 2.

IKPF-ZLDAT&#12288;(Count date)=Initial value

ISEG-ERFMG&#12288;(Unit of entry quantity)=Initial value

ISEG-XNULL&#12288;(Count result zero)=Blank

Join&#65306;

ISEG inner IKPF

join

ISEG inner MARA

join

ISEG inner MARC

join

ISEG inner T064B

join

ISEG inner MAKT

join

ISEG-IBLNR&#12288;(Physical inventory document) =IKPF-IBLNR&#12288;(Physical inventory document)

ISEG-GJAHR&#12288;(Fiscal year)=IKPF-GJAHR&#12288;(Fiscal year)

ISEG-MATNR&#12288;(Material number) =MARA-MATNR&#12288;(Material number)

ISEG-MATNR&#12288;(Material number) =MARC-MATNR&#12288;(Material number)

ISEG-WERKS&#12288;(Plant)=MARC-WERKS&#12288;(Plant)

ISEG-BSTAR&#12288;(Stock type)=T064B-BSTAR&#12288;(Stock type)

T064B-SPRAS&#12288;(Language key)=SY-LANGU

MAKT-SPRAS&#12288;(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

2 REPLIES 2

Former Member
0 Kudos

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

Former Member
0 Kudos

SEND ME EXACT PROBLEM , IF POSSIBLE I WILL SOLVE IT

BYE REGARDS

NARESH