Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


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

from ekko

where bsart = 'NB' and

ekgrp = 111.

select ebeln ebelp matnr netpr into table it_ekpo

from ekpo

for all entries in it_ekko

where elikz = ' ' and

afnam = 'ABC'

ebeln = it_ekko-ebeln.

select ebeln eindt into table it_eket

from ekrt

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.



Not what you were looking for? View more on this topic or Ask a question