its really imp

[Former Member]

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]

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]

thank you very much

[Former Member]

sir,

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