STO 'S REPORT

[spandana_babu]

HI

Guru's..

i need a report on sto's , in my requirement

using transactions me21n " create for stand transfer P.O number.

vl10g, " delivery

migo. " goods receipt

suggest me how to approach to resolve this & send me tables

and fields to solve this...

Regards........

Anand.N

[Former Member]

Hey you can use FM's to create STO, delivery etc... search for those. otherwise can go for BDC recording..

Tables involved.. EKKO, EKPO, LFA1..etc

[Former Member]

selecting STO

SELECT ekko~ebeln

ekko~bsart

ekko~lifnr

INTO TABLE tl_ekko

FROM ekko INNER JOIN

ekpo ON ekko_{ebeln = ekpo}ebeln INNER JOIN

ekpv ON ekpo_{ebeln = ekpv}ebeln AND

ekpo_{ebelp = ekpv}ebelp

WHERE ekko~bsart EQ 'UB'

AND ekpo~werks IN r_werks

AND ekko~unsez IN p_unsez

AND ekko~ekgrp IN p_ekgrp

AND ekpv~lprio IN p_lprio

AND ekpo~matnr IN p_matnr

AND ekko~ebeln IN p_ebeln

and ekpo~loekz ne c_x

AND ekpo~elikz NE c_x.

for GR access table EKBE