topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Wed, 26 Mar 2008 09:28:33 GMT

HI,

I have to develop a report in which I have to deal with 2 tables MKPF and MSEG. Can you please tell me which should I start with in my select st. in the

Start-Of-Selection. event block.

Thanks .

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:31:28 GMT

Depends on what field you are using for the condition check . Usually posting dates so use MKPF. You may aswell inner join the two tables.

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:34:06 GMT

SELECT A_{MBLNR A}ERDAT A_{ERNAM A}XBLNR A_{BLDAT A}LIFNR A_{WERKS A}IVAL

A_{MATDOC A}SWERK A_{REV_DATE A}RCAN B_{MATNR B}GR_MADE B_{MBLNR B}MJAHR B~MENGE

FROM MKPF AS A INNER JOIN MSEG AS B

ON A_{G1SNO = B}G1SNO

INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE A~BUDAT IN ERDAT AND

A~LIFNR IN LIFNR AND

A~WERKS IN WERKS AND

B~MATNR IN MATNR.

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:35:23 GMT

you should start from MKPF

Regards

Aditya

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:36:14 GMT

Hi,

You can start with the Table mkpf , however it depends on where you are using the conditional checks

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:37:23 GMT

see the sample code....

select single mseg_{mblnr mseg}menge mseg_{dmbtr mseg}werks mseg~lgort

mseg_{bwart mseg}shkzg mseg_{ebeln mseg}ebelp

into corresponding fields of table

output2 from mseg inner join mkpf on ( mseg_{mblnr = mkpf}mblnr and mseg_{mjahr = mkpf}mjahr )

and mseg_{bwart = '351' and mseg}shkzg = 'S'

and mkpf~budat in s_date.

Regards

Sugumar G

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:39:41 GMT

HI,

First u should select from mkpf table that is master tabel

than based on u can selct the data from mseg table.

Please dont use join condition because we r using cluster table(MSEG) and pooled table.

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:42:44 GMT

I have this condition, to get the list of material with respect to the list from table mseg.....

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:42:58 GMT

hi ,

tables:mseg,MKPF.

data: begin of it_mseg occurs 0,

MBLNR like mseg-MBLNR,

MJAHR like mseg-MJAHR,

ZEILE like mseg-ZEILE,

end of it_mseg.

data: begin of it_mkpf occurs 0,

MBLNR like mkpf-MBLNR,

MJAHR like mkpf-MJAHR,

BLART like mkpf-BLART,

end of it_mkpf.

select-options:s_mblnr for mkpf-mblnr.

select MBLNR

MJAHR

ZEILE

from mseg

into table it_mseg

where mblnr in s_mblnr.

select MBLNR

MJAHR

BLART

from mkpf

into table it_mkpf

for all entries in it_mseg

where mblnr = it_mseg-mblnr.

regards,

venkat.

Re: Select statement

Nawanandana — Wed, 26 Mar 2008 09:47:55 GMT

its depend of the ur requirement....coz MSEG is the master table and MKPF hv posting date... better to do the inner join both of table

regatd

nawa

Re: Select statement

Former Member — Wed, 26 Mar 2008 09:50:43 GMT

hi,

START-OF-SELECTION.

  SELECT  
MSEG~EXBWR
'MSEG~EXVKW
MSEG~GRUND
'MSEG~KDAUF
MSEG~KDEIN
MSEG~KDPOS
MSEG~KOSTL
MSEG~KUNNR
MSEG~KZBEW
    INTO CORRESPONDING FIELDS OF TABLE ITAB
    FROM MKPF INNER JOIN MSEG
    ON    MKPF~MANDT = MSEG~MANDT
      AND MKPF~MBLNR = MSEG~MBLNR
      AND MKPF~MJAHR = MSEG~MJAHR
    FOR ALL ENTRIES IN MATNR
    WHERE MATNR = MATNR-LOW
      AND MSEG~AUFNR IN AUFNR
      AND MKPF~BUDAT IN BUDAT
      AND MSEG~BWART IN BWART
      AND MSEG~CHARG IN CHARG
      AND MSEG~DMBTR IN DMBTR
      AND MSEG~KUNNR IN KUNNR
      AND MSEG~LGORT IN LGORT
      AND MSEG~LIFNR IN LIFNR
      AND MKPF~MBLNR IN MBLNR
      AND MKPF~MJAHR IN MJAHR
      AND MSEG~SOBKZ IN SOBKZ
      AND MKPF~USNAM IN USNAM
      AND MKPF~VGART IN VGART
      AND MSEG~WERKS IN WERKS
      AND MSEG~XAUTO IN XAUTO
      AND MKPF~XBLNR IN XBLNR

Regards,

Ballack.

Reward Points if helpful.

Re: Select statement

Former Member — Thu, 27 Mar 2008 05:11:14 GMT

Hi,

Start-Of-Selection.

MSEG TABLE

select mblnr lgort ablad wempf menge from mseg into corresponding

fields of table t_mseg where

werks = '5900' and

bwart = '101' and

bwart = '102' and

wempf = wa_mseg-wempf.

LOOP AT t_mseg INTO wa_mseg.

*MKPF TABLE

select budat mblnr xblnr from mkpf into corresponding

fields of table t_mkpf where

budat ge pa_sdate and

budat le pa_edate .

endloop.

****************************************************************

Are my select st. correct?

Re: Select statement

Former Member — Thu, 27 Mar 2008 05:27:45 GMT

any ideas please.

Re: Select statement

jayanthi_jayaraman — Thu, 27 Mar 2008 05:45:32 GMT

Hi,

Try like this.

select mblnr lgort ablad wempf menge from mseg into corresponding

fields of table t_mseg where

werks = '5900' and

bwart = '101' and

bwart = '102' .

*MKPF TABLE

select budat mblnr xblnr from mkpf into corresponding

fields of table t_mkpf

for all entries in t_mseg

where mblnr = t_mseg-mblnr and

budat ge pa_sdate and

budat le pa_edate .