Skip to Content
avatar image
Former Member

report

plz guide me regarding this report.what r the fields & tables should i take in this report.its urgent.

if i take EKKO & EKPO tables what fields should i take.

a report to list the materials with respective vendors and to make a price comparison between the current price and the last price in the previous year.

Message was edited by:

asha anjana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 17, 2007 at 04:56 AM

    if you want report to deal with material and vendor then why are you going for EKKO & EKPO?

    use MARA and LFA1...

    do you wish to give the comparision of values based on PO?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2007 at 09:32 AM

    From EKPO you can get material No, based on the purc. doc no. from EKKO you can get the vendor no.

    You can find current prices in table MBEW. Field VPRSV says, if you find moving avg. in column VERPR or the standard price in STPRS. Currency is company code currency.

    In table MBEWH you find historical values - which are only inserted in case of price changes - so missing periods have same value as last entry before.

    Printing issue in payslip

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      what is the logic to make price comparison between the current price and the last price in the previous year.