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 17 at 7:09 PM |  Mark as helpful |
Hi,
The payment amount, payment date can be found in RBKP (Invoice Receipt header) table while GR amount can be found also in EKBE table.
Cheers,
HT
---------------Original Message---------------
From: mic_solution_inspector
Sent: Tuesday, February 16, 2010 3:50 PM
Subject: PO paid or not
> Dears,<br/>I would like to make a customized report to show whether the PO is paid or not , and what is the details of this PO like goods receipt number ,Amount received , quantity recieved and other things related to payment too.<br/>As shown below is a report which i need to create with the table name and field names too.<br/>Please i need your help to review the table names and field names , also i have missing table names for some FI,please help<br/><br/>PO paid or not <br/>Selection Table name Field name<br/> PO # EKKO EBELN<br/> Vendor EKKO LIFNR<br/> Project EBAN LGORT<br/> Company code EKKO BUKRS<br/> <br/>Data <br/> PO # EKKO EBELN<br/> Vendor EKKO LIFNR<br/> Doc date EBAN BEDAT<br/> Material code EBAN EMATN<br/> Material Desc. EBAN MATNR<br/> WBS EBAN DISUB_PSPNR<br/> Quantity EBAN MENGE<br/> Unit EBAN MEINS<br/> Net price EBAN PREIS<br/> Currency EBAN PEINH<br/> Delivery Date EBAN UZEIT<br/> GRN # EBAN INFNR<br/> GRN amount <br/> Quantity Recived EBAN MENGE<br/> Unit EBAN MEINS<br/> Invoice # BSAK XBLNR<br/> Invoice Amount BSAK WRBTR<br/> Currency BKPF HWAER<br/> Invoice Date BSAK BLDAT<br/> Payment term BSAK ZTERM<br/> Due on <br/> Payment Amount <br/> Currency <br/> Payment Date <br/> Clearing Doc BSAK AUGBL
__.____._ The payment amount, payment date can be found in RBKP (Invoice Receipt header) table while GR amount can be found also in EKBE table.
Cheers,
HT
---------------Original Message---------------
From: mic_solution_inspector
Sent: Tuesday, February 16, 2010 3:50 PM
Subject: PO paid or not
> Dears,<br/>I would like to make a customized report to show whether the PO is paid or not , and what is the details of this PO like goods receipt number ,Amount received , quantity recieved and other things related to payment too.<br/>As shown below is a report which i need to create with the table name and field names too.<br/>Please i need your help to review the table names and field names , also i have missing table names for some FI,please help<br/><br/>PO paid or not <br/>Selection Table name Field name<br/> PO # EKKO EBELN<br/> Vendor EKKO LIFNR<br/> Project EBAN LGORT<br/> Company code EKKO BUKRS<br/> <br/>Data <br/> PO # EKKO EBELN<br/> Vendor EKKO LIFNR<br/> Doc date EBAN BEDAT<br/> Material code EBAN EMATN<br/> Material Desc. EBAN MATNR<br/> WBS EBAN DISUB_PSPNR<br/> Quantity EBAN MENGE<br/> Unit EBAN MEINS<br/> Net price EBAN PREIS<br/> Currency EBAN PEINH<br/> Delivery Date EBAN UZEIT<br/> GRN # EBAN INFNR<br/> GRN amount <br/> Quantity Recived EBAN MENGE<br/> Unit EBAN MEINS<br/> Invoice # BSAK XBLNR<br/> Invoice Amount BSAK WRBTR<br/> Currency BKPF HWAER<br/> Invoice Date BSAK BLDAT<br/> Payment term BSAK ZTERM<br/> Due on <br/> Payment Amount <br/> Currency <br/> Payment Date <br/> Clearing Doc BSAK AUGBL
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
