topic smart forms in Application Development and Automation Discussions

smart forms

Former Member — Tue, 19 Sep 2006 11:07:39 GMT

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 — Tue, 19 Sep 2006 11:15:01 GMT

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 — Tue, 19 Sep 2006 11:17:13 GMT

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