topic Need help in Application Development and Automation Discussions

Need help

Former Member — Tue, 20 Mar 2007 06:55:39 GMT

Hi,

I am new to MM Module. They have given me a task. but I don't have much idea.

My task is to write a interactive report based on purchase requisition number that displays material number, quantity and delivery date as basic list. Purchase detail as first list and price detail as second list.

I need the table name as well as field name to develop this report.

Please help me in doing this.

Regards...

Arun.

Re: Need help

Former Member — Tue, 20 Mar 2007 07:13:12 GMT

Check the tables EKKO, EKPO, MKPF, MSEG

Re: Need help

Former Member — Tue, 20 Mar 2007 07:13:57 GMT

Hi,

Use EBAN table for Purchase Requisition data to display the basic list.

Fields are clearly known by text, use them.

use EKKO,EKPO tables for purchase Order details and display them.

FOr pricing data you can fetch from KONV table by passing the EKKO-KNUMV field and application KAPPL field as 'M' and get the related prices (KBETR and KWERT fields) for each condition type.

reward if useful

regards,

anji

Re: Need help

Former Member — Tue, 20 Mar 2007 07:20:33 GMT

Purchase requisition Tcode is ME51

go there and find the fields you require and then press f1 ..

you will get a pop up where you have to press the HAMMER button..

it will give the name of the transparent table being used

hope it helps

award points if it helps

Re: Need help

former_member189631 — Tue, 20 Mar 2007 07:22:14 GMT

Hi Arun,

ISome mportanat Tables:

EKKO - Purchasing Document Header

EKET - Scheduling Agreement Schedule Lines

EBAN - Purchase Requisition

U can Use Eban Table for Purchase Requisition,

Some Important Fields In EBAN:

EBAN-BANFN --> Purchase Requisition Number

EBAN-bnfpo --> Item number of purchase requisition

EBAN-FRGKZ -->Release Indicator

EBAN-Matnr ---> Material Number

Regards,

Ramganesan K.

Re: Need help

naren112 — Tue, 20 Mar 2007 07:24:19 GMT

Hi Arun ,

Run The Transaction code ME51 and here you can find all the fields that you need .

And you can see the fields name and table name for individual fields .

if you hav doubt ask to me ..

Regards ,

Narender B <b></b>