RE: [sap-log-mm] PO paid or not
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Dave Thornburgh on Feb 19 at 9:09 PM |  Mark as helpful |
Wasim -
Nothing starting with a Y or Z from your system is going to exist in other
systems, so they really can't help people here.
Dave
From: wasim-abidi via sap-log-mm [mailto:sap-log-mm@Groups.ITtoolbox.com]
Sent: Friday, February 19, 2010 11:35 AM
To: Dave Thornburgh
Subject: Re: [sap-log-mm] PO paid or not
Posted by wasim-abidi
on Feb 19 at 2:36 PM
<http://it.toolbox.com/api/ContentVote/3319891/1/1/> Mark this reply as
helpfulMark as helpful
hi.this cycle is called VIV (vendor invoice verification). there is a report
in sap, transaction code is zmppgn.
most of the time it is inhouse developed.
if not then go through transaction y_d11_22000001, it will give you all
info you requested.
Thanks
wasim abidi
________________________________
From: mic_solution_inspector via sap-log-mm
<sap-log-mm@Groups.ITtoolbox.com>
To: wasim abidi <mewasi2000@yahoo.com>
Sent: Fri, 19 February, 2010 8:04:16
Subject: RE:[sap-log-mm] PO paid or not
Posted by mic_solution_inspector (Accountant)
on Feb 19 at 12:40 PM Mark as helpful
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
__.____._ Nothing starting with a Y or Z from your system is going to exist in other
systems, so they really can't help people here.
Dave
From: wasim-abidi via sap-log-mm [mailto:sap-log-mm@Groups.ITtoolbox.com]
Sent: Friday, February 19, 2010 11:35 AM
To: Dave Thornburgh
Subject: Re: [sap-log-mm] PO paid or not
Posted by wasim-abidi
on Feb 19 at 2:36 PM
<http://it.toolbox.com/api/ContentVote/3319891/1/1/> Mark this reply as
helpfulMark as helpful
hi.this cycle is called VIV (vendor invoice verification). there is a report
in sap, transaction code is zmppgn.
most of the time it is inhouse developed.
if not then go through transaction y_d11_22000001, it will give you all
info you requested.
Thanks
wasim abidi
________________________________
From: mic_solution_inspector via sap-log-mm
<sap-log-mm@Groups.ITtoolbox.com>
To: wasim abidi <mewasi2000@yahoo.com>
Sent: Fri, 19 February, 2010 8:04:16
Subject: RE:[sap-log-mm] PO paid or not
Posted by mic_solution_inspector (Accountant)
on Feb 19 at 12:40 PM Mark as helpful
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
Dave ThornburghSAP Logistics Material Management Enthusiast
Contributed 100 posts 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
_.____.__ 
