topic Re: its really imp in Application Development and Automation Discussions

its really imp

Former Member — Fri, 23 May 2008 05:56:05 GMT

SELECT a_{erfmg a}lgort a_{matnr a}mblnr a_{werks b}budat INTO CORRESPONDING FIELDS OF

itab FROM mseg AS a INNER JOIN mkpf AS b ON

a_{mblnr = b}mblnr WHERE

a~werks = '1000' AND

a~mblnr IN ('4900000088','4900000086' ) AND

a~matnr = 'DC0018' AND

a~lgort = 'FGS' AND

a~bwart = '101' AND

b~budat IN period.

ENDSELECT.

in this code value of 4900000086 in not coming in the column how to get values of both the mblnr in one column plz help e with this code

Former Member — Fri, 23 May 2008 06:17:52 GMT

Hi,

Please try with the following query.

SELECT a_{erfmg a}lgort a_{matnr a}mblnr a_{werks b}budat INTO CORRESPONDING FIELDS OF

TABLE itab FROM mseg AS a INNER JOIN mkpf AS b ON

a_{mblnr = b}mblnr WHERE

a~werks = '1000' AND

a~mblnr IN ('4900000088','4900000086' ) AND

a~matnr = 'DC0018' AND

a~lgort = 'FGS' AND

a~bwart = '101' AND

b~budat IN period.

Regards,

Aravind JM.

Former Member — Fri, 23 May 2008 06:33:32 GMT

thank you very much

Former Member — Fri, 23 May 2008 06:41:31 GMT

sir,

is it possible that i can access erfmg in two diffrerent columns based on the posting date,movement,storage location.