Re: [sap-log-mm] PO paid or not
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by mic_solution_inspector (Accountant) on Feb 20 at 10:10 PM |  Mark as helpful |
Dears,
Nobody can help with this ?
On Fri, Feb 19, 2010 at 11:04 AM, mic_solution_inspector via sap-log-mm <
sap-log-mm@groups.ittoolbox.com> wrote:
> Posted by
> mic_solution_inspector (Accountant)
> on Feb 19 at 12:40 PM
>
> Hi,
> 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 .
> So , i want to get the PO# , vendor name and number , PO quantity with the
> unit of order and date of PO.
> 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
> Then i want to get the invoice # , invoice date, amount in invoice, payment
> term
> and at last , i want to know the clearing payment if paid , and the amount
> paid
>
> Note : these are the tables whichi used :EKKO , EKPO , EBAN ,EKBE , BKPF ,
> BSAK
>
> ---------------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
__.____._ Nobody can help with this ?
On Fri, Feb 19, 2010 at 11:04 AM, mic_solution_inspector via sap-log-mm <
sap-log-mm@groups.ittoolbox.com> wrote:
> Posted by
> mic_solution_inspector (Accountant)
> on Feb 19 at 12:40 PM
>
> Hi,
> 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 .
> So , i want to get the PO# , vendor name and number , PO quantity with the
> unit of order and date of PO.
> 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
> Then i want to get the invoice # , invoice date, amount in invoice, payment
> term
> and at last , i want to know the clearing payment if paid , and the amount
> paid
>
> Note : these are the tables whichi used :EKKO , EKPO , EBAN ,EKBE , BKPF ,
> BSAK
>
> ---------------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
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
_.____.__ 
