Need Help to Create Report

[Former Member]

Hi Frds

Consider 1 PO and 1 Line Item and for that i have Multiple GRs and IR GRs.

I wants to write code for these ,can anyone help me which are tables and fields ,give me some tips .

its urgent

Thanks

Pari

[Former Member]

Hi Frds

Consider 1 PO and 1 Line Item and for that i have Multiple GRs and IR GRs.

I wants to write code for these ,can anyone help me which are tables and fields ,give me some tips .

its urgent

Thanks

Pari

[Former Member]

Hi,

EKKO is the Purchasing Document Header Table

and

EKPO is the Purchasing Document Item.

Could you please specify what do you mean by ...

Multiple GRs and IR GRs.

Reward if helpful.

Regards.

[Former Member]

Check in EKBE table.(PO History)

[Former Member]

Hi,

Tables Fields

EKKO(Purchasing Doc EBELN,EBELP

Header) (EKPO-EBELN =EKKO-EBELN)

EKPO(Purchasing Doc EBELN

Item)

GR:

Tables Fields

MKPF(Header: Material Document) MBLNR,MJAHR

MSEG(Document Segment: Material) MBLNR,MJAHR,ZEILE

Please Reward points if useful.

Regards

rose

[Former Member]

Tables:

ekko-purchase document header

ekpo-purchase document item

eket-delivery schedules

ekkn-account assignmet in purchasing Document

[Former Member]

hi,

Use the FM me_read_history

input the PO number and it would give u the values of GRs and IRs

if you look at the table parameter xekbe will give you the value of GR and IR

In this if you pass the value to an internal table IT_EKBE like ekbe

the field bewtp can be use to read values of GR and IR for the po the lines for which the value is E are GR and R for IR

you can also do a select from tne table directly based on the above logic

Regards,

Himanshu Verma

[Former Member]

HI ,

Consider the followiing tables,

ekko,ekpo,eket and ekbe

thanks,

rajesh