coding required

[Former Member]

Hi Please give the code for this

Code (BUKRS), Vendor (LIFNR), Vendor Name (ZNAME1), PO_Date (AEDAT), PO Creator (ERNAM) from EKKO table

2. For the corresponding PO number (EBELN) from EKKO table, get PO Item Text (TXZ01) from EKPO table

3. For the corresponding PO number (EBELN) from EKKO table, get PO_Iten_No(EBELP), from EKPO table

4. For the corresponding PO number (EBELN) from EKKO table get the GR_Posting Dt(BUDAT) from EKBE table when PO History cat (HCT-EKBE) is equal to “E” .

a) For getting the first GR Posting date and first Invoice posting date, sort the column (BUDAT) of table, get the 1st GR_Posting_dt(BUDAT) when PO History cat (HCT-EKBE) is equal to “E” AND get the 1st Inv_Posting_Dt(BUDAT) when PO when PO History cat (HCT-EKBE) is equal to “Q” For this corresponding invoice date (when when PO History cat (HCT-EKBE) is equal to “Q” ) get the invoice number (BELNR) .

b) IF 1ST GR_POSTING_DATE < 1ST INVOICE_POSTING_DATE, DO NOT DISPLAY THE RESULT

5. For the corresponding PO number (EBELN) from EKKO table and Invoice_No (BELNR) (from step4,a),get Inv_Creator (ERNAM), Inv_Amount(REEWR), Currency (WAERS) from EKBE table when PO History cat (Hct-EKBE) is equal to “Q”

[Former Member]

Hi,

Try using the following select queries:

Select ebeln lifnr zname1 aedat ernam

from ekko

into table i_ekko

where ebeln = p_ebeln.

****

select txz01 ebelp

from ekpo

into table i_ekpo

for all entries in i_ekko

where ebeln = i_ekko-ebeln.

********

select budat

from ekbe

into table i_ekbe

for all entries in i_ekpo

where ebeln = i_ekko-ebeln and

hct = 'E' and

hct = 'Q'..

*******

sort i_ekbe by budat.

read table i_ekbe index 1. "to get first invoice posting date

I'm sorry its time for me to leave i can help u tomm if possible.

<REMOVED BY MODERATOR>

regards,

kavitha

Edited by: Alvaro Tejada Galindo on Feb 6, 2008 4:48 PM