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