09-12-2007 6:14 AM
Dear All,
I need to display the staus of purcgase order, for example:-
<b>Po Qty, GR Qty, GR Value, IR Qty and IR Value.</b>
To fetch the fallowing required fields from the related tables by the selection criteria Material No and Posting dates.
<b>Selection Criteria</b>:- MATNR
BUDAT
<b>Layout whic need to display:-</b>
FieldName Table Name
WERKS Plant Layout MSEG
LIFNR Vendor accnt No. Layout EKKO
MATNR Material No. Layout MARC
EBELN Purchase Order No. Layout EKPO
MENGE Purchase Order Qty. Layout EKPO
SMBLN GR No. Layout MSEG
BSTMG GR QTY Layout MSEG
DMBTR GR Value Layout MSEG
LFSNR Del note no. Layout MSEG
BELNR Invoice No. Layout EKBE
BPRBM Invoice Qty Layout EKBE
REFWR Invoice value Layout EKBE
Need reporting for that.
Anybody please help me out.
Thanks.
Point will be rewarded for the best one.
09-12-2007 6:26 AM
WERKS Plant Layout MSEG
SMBLN GR No. Layout MSEG
BSTMG GR QTY Layout MSEG
DMBTR GR Value Layout MSEG
LFSNR Del note no. Layout MSEG
also select
MATNR and EBELN
from MSEG depends on MATNR from selection scren
LIFNR Vendor accnt No. Layout EKKO
EBELN Purchase Order No. Layout EKPO
MENGE Purchase Order Qty. Layout EKPO
depends on MSEG-EBELN
EBELN Purchase Order No. Layout EKBE
BELNR Invoice No. Layout EKBE
BPRBM Invoice Qty Layout EKBE
REFWR Invoice value Layout EKBE
BUDAT Posting Date in the Document EKBE
depends on MSEG-EBELN
and BUDAT = slection screen BUDAT
MATNR Material No. Layout MARC
depends on MSEG-MATNR
loop ate MSEG
Read values for output and move to final table from diffrent tables
Po Qty, GR Qty, GR Value, IR Qty and IR Value.
endloop
Rewards points if useful.......................
Minal