topic Re: Need Help to Create Report in Application Development and Automation Discussions

Need Help to Create Report

Former Member — Thu, 13 Mar 2008 10:25:56 GMT

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

Re: Need Help to Create Report

Former Member — Thu, 13 Mar 2008 10:32:50 GMT

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.

Re: Need Help to Create Report

Former Member — Thu, 13 Mar 2008 10:34:55 GMT

Check in EKBE table.(PO History)

Re: Need Help to Create Report

Former Member — Thu, 13 Mar 2008 10:36:11 GMT

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

Re: Need Help to Create Report

Former Member — Thu, 13 Mar 2008 10:40:50 GMT

Tables:

ekko-purchase document header

ekpo-purchase document item

eket-delivery schedules

ekkn-account assignmet in purchasing Document

Re: Need Help to Create Report

Former Member — Thu, 13 Mar 2008 10:44:32 GMT

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

Re: Need Help to Create Report

Former Member — Thu, 13 Mar 2008 10:46:41 GMT

HI ,

Consider the followiing tables,

ekko,ekpo,eket and ekbe

thanks,

rajesh