RE:[sap-log-mm] PO paid or not
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by ha_tran (Senior SAP Supply Chain Business Analyst) on Feb 20 at 10:39 AM |  Mark as helpful |
Hi,
If the entire purchase-to-pay report is customized, then the following sets of table shall be taken into account -
1) EKKO/EKPO (PO)
2) MKPF/MSEG (GR document). In this particular case, you can alternatively use EKBE table;
3) RBKP/RSEG (Invoice Receipt)
4) BSAK/BSIK (Payment document).
Cheers,
HT
---------------Original Message---------------
From: mic_solution_inspector
Sent: Friday, February 19, 2010 12:45 PM
Subject: PO paid or not
> Hi,<br/>Actually, i am very confused with all these tables .i wanna to give you a brief of what i want to achieve .I want o go through PO cycle to reach to the payment cycle .<br/>So , i want to get the PO# , vendor name and number , PO quantity with the unit of order and date of PO.<br/>Then i want to view the GR information like GRN # , GRN amount , and date of GRN with the material code and disc. , How many quantity recived and to be recived<br/>Then i want to get the invoice # , invoice date, amount in invoice, payment term<br/>and at last , i want to know the clearing payment if paid , and the amount paid<br/><br/>Note : these are the tables whichi used :EKKO , EKPO , EBAN ,EKBE , BKPF , BSAK
__.____._ If the entire purchase-to-pay report is customized, then the following sets of table shall be taken into account -
1) EKKO/EKPO (PO)
2) MKPF/MSEG (GR document). In this particular case, you can alternatively use EKBE table;
3) RBKP/RSEG (Invoice Receipt)
4) BSAK/BSIK (Payment document).
Cheers,
HT
---------------Original Message---------------
From: mic_solution_inspector
Sent: Friday, February 19, 2010 12:45 PM
Subject: PO paid or not
> Hi,<br/>Actually, i am very confused with all these tables .i wanna to give you a brief of what i want to achieve .I want o go through PO cycle to reach to the payment cycle .<br/>So , i want to get the PO# , vendor name and number , PO quantity with the unit of order and date of PO.<br/>Then i want to view the GR information like GRN # , GRN amount , and date of GRN with the material code and disc. , How many quantity recived and to be recived<br/>Then i want to get the invoice # , invoice date, amount in invoice, payment term<br/>and at last , i want to know the clearing payment if paid , and the amount paid<br/><br/>Note : these are the tables whichi used :EKKO , EKPO , EBAN ,EKBE , BKPF , BSAK
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
ha_tranSAP Logistics Material Management Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
