Need help

[Former Member]

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.

[Former Member]

Check the tables EKKO, EKPO, MKPF, MSEG

[Former Member]

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

[Former Member]

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

[former_member189631]

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.

[naren112]

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>