smart forms

[Former Member]

hi friends,

could u please tell me how to do this

Header – Purchase Order Number Get EBELN from MSEG where MSEG-MBLNR (material document) = LQUA-WENUM.

Header – Goods Receipt Date LQUA-WDATU

Header – ID Number LQUA-MATNR

Item – Batch Number LQUA-CHARG

Item – Inspection Lot Number LQUA-QPLOS

i have little bit confusion

help me how to do

regards

siri

[Former Member]

select b_{ebeln a}wdatu a_{matnr a}charg a~qplos

into table itab

from lqua as a inner join mseg as b

on a_{wenum = b}mblnr.

[Former Member]

Hi,

Follow below logic

select mseg~ebeln

LQUA~WDATU

LQUA~MATNR

LQUA~CHARG

LQUA~QPLOS from mseg inner join

lqua on mseg-mblnr = lqua-WENUM

into table i_mseg

where mseg-mblnr in...

Regards

Amole