topic Need help in Application Development and Automation Discussions

Need help

Former Member — Wed, 12 Sep 2007 05:14:22 GMT

Dear All,

I need to display the staus of purcgase order, for example:-

Po Qty, GR Qty, GR Value, IR Qty and IR Value.

To fetch the fallowing required fields from the related tables by the selection criteria Material No and Posting dates.

Selection Criteria:- MATNR

BUDAT

Layout whic need to display:-

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.

Re: Need help

Former Member — Wed, 12 Sep 2007 05:26:37 GMT

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