cancel
Showing results for 
Search instead for 
Did you mean: 

Linkage of net price

Former Member
0 Kudos

Hello All,

We are working on a custom report which shows the invoice and PO data in output of report and vendor number and company code as input data.

Problem comes here when let say user enter vendor number 1234 then output will show him invoice data and PO data related to vendor 1234. Just for info logic we used for it was from vendor number we will look into BSEG table and then EKPO table.

We need to show net price also in output. But if there are multiple line items in PO then how system will sellect the net price as net price must be set for say 5 line item. How system will know that from which line item i need to select the price.

Regards

Himanshu

Accepted Solutions (1)

Accepted Solutions (1)

kailas_ugale
Active Contributor
0 Kudos

Hi,

first try t-code ME80FN and execute report and select change view icon and select PO history you will get Po-GRn-MIRo report

OR

Now ,you will get net price for item from table EKPO and invoice from table EKBE or invoice table RSEG and RBKP

If you want FI document for Invoice BKPF table

Regards

kailas Ugale

Answers (2)

Answers (2)

former_member197616
Active Contributor
0 Kudos

Hi,

You can follow as above said by the moderator .

How ever for the PO total price you can look into the header of the PO for the tab status and here you can get the the field total net order value of the entire PO and can take this field .

If not , take down all the item net order values into excel output and and you can sum through coding ,,, the sumed value can be outputted into the excel through coding .

Regards,

JL23
Active Contributor
0 Kudos

just for performance reasons I would try to avoid reading the BSEG table.

you can get almost everything from the PO itself.

having the company code, you can look into table T001K to get all plants to this company.

then you select the POs from table EKKO for the entered vendor, and read the PO items according to the plants that belong to the entered company code.