I am working on an interface where I need to change the price of the PO's, and for this I will be getting an input file which will have the material no's and the price associated to those. I need to select PO's based on the following conditions:
document type = 'NB' and purchasing group = '111' and DCI = ' '. name of the requistner = 'ABC' and item_delivery date = 06/12/2007
and then once the PO is selected I need to update the price of the PO's for a specific material from the input file.
For this so far I have written the following code.
select ebeln into table it_ekko
where bsart = 'NB' and
ekgrp = 111.
select ebeln ebelp matnr netpr into table it_ekpo
for all entries in it_ekko
where elikz = ' ' and
afnam = 'ABC'
ebeln = it_ekko-ebeln.
select ebeln eindt into table it_eket
for all entries in it_ekpo
where eindt = '6/12/2007' and
ebeln = it_ekpo-ebeln.
can you please tell me is this is right and if this is right can you also tell me how to proceed further, I mean now I just need to change the netpr with the price that I have in my input table as per the matnr.