04-09-2010 11:24 AM
Hi All,
We are developing purchase history report [ invoice based]. In that we are fetching values from RBKP table to display the netprice + duty & VAT. Our PO has 2 line items, Since RBKP is not having EBELP field, it is adding the duty and VAT and giving wrong calculations. How to bifurcate the values to two lines ? Any logic for this ?
Regards,
Moderator message: please use a more meaningful subject line next time!
Edited by: Thomas Zloch on Apr 10, 2010 11:00 PM
04-09-2010 11:35 AM
Have you checked the table RSEG?
It is the Item level data for incoming invoice (But not sure all the fields are available or not as per your need).
Regards
Shiba Prasad Dutta
04-10-2010 8:17 PM
Hi,
I think, It is not possible to get Purchase Line item wise net price & Taxes during invoice verification. RSEG doesnt store itemwise net amount and taxes. Even if you extract data from follow-on financial documents, you will not get purchase line itemwise amount details.
Regards
Vinod
04-20-2010 1:24 PM
u can get ur req, by setting a logic with tables ekbe, ekbz, rbkp, rseg, bkpf and bset
Edited by: Azeem Ahmed Matte on Apr 20, 2010 2:24 PM