on 02-07-2012 2:14 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.