topic Re: ABAP Report in Application Development and Automation Discussions

ABAP Report

Former Member — Thu, 24 Aug 2006 11:32:45 GMT

hi everybody,

could u plz help to write code for the following description.the below description is a little bit confusion for me.

Select the Material Document Number (MKPF-MBLNR) from the table MKPF where the Batch Number (MSEG-CHARG) equals the Batch Number provided by the user in the selection screen. Once the Material Document Number (MKPF-MBLNR) has been selected, select the Goods Receipt Date (MKPF-BUDAT) from the table MKPF where the Material Document Number(MKPF-MBLNR) equals the Material Document Number (MSEG-MBLNR).

regards

hridhayanjili.

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 11:38:54 GMT

paramter : p_charg like mseg-charg.

start-of-selection.

select mkpf-mblnr mkpf-budat

into itab

from mkpf inner join mseg on mkpf-mblnr = mseg-mblnr

where mseg-charg = p_charg.

Regards

Anurag

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 11:40:44 GMT

DATA:BEGIN OF i_data OCCURS 0,

mblnr TYPE mkpf-mblnr,

mkpf TYPE mkpf-budat,

END OF i_data.

PARAMETER: p_charg LIKE mseg-charg.

SELECT a_{mblnr a}budat INTO TABLE i_data

FROM mkpf AS a INNER JOIN mseg AS b

ON a_{mblnr = b}mblnr

WHERE b~charg = p_charg.

IF sy-subrc = 0.

*Proceed

ELSE.

*Message

ENDIF.

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 11:40:45 GMT

Hi,

try this code

tables:mkpf.

data:begin of itab occurs 0,

mblnr like mkpf-mblnr,

charg like mkpf-charg,

end of itab.

data:begin of itab2 occurs 0,

budat like mkpf-budat,

mblnr like mkpf-mblnr,

end of itab2.

select-optins:s_charg for mseg-charg.

parameters:p_charg like mseg-charg.

select mblnr from mkpf into table itab

where charg in s_charg. ""charg = p_charg

select budat from mkpf into table itab2

for all entries in itab

where mblnr = itab-mblnr.

Regards,

Sowjanya

Message was edited by: sowjanya suggula

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 11:45:51 GMT

hi,

As MBLNR and MJAHR are key fields you need to have both of them in your final internal table.

parameter : p_charg type mseg-charg.

data : begin of itab occurs 0,
            mblrn type mkpf-mblnr,
            mjahr type mkpf-mjahr,
            budat type mkpf-budat,
       end of itab.
select b~mblnr 
       b~mjahr
       a~budat
  into table itab
  from mkpf as a inner join mseg as b
    on b~mblnr = a~mblnr and 
       b~mjahr = a~mjahr 
 where b~charg = p_charg.

Regards,

Richa

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 11:57:32 GMT

thanx friens

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 11:57:49 GMT

thanx friens

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 11:58:19 GMT

thanx friends

hridhayanjili

Re: ABAP Report

Former Member — Thu, 24 Aug 2006 12:00:08 GMT

thanx friends