Forum
Current User: Guest Login Register
Please consider registering

Search 
Search Forums:


 




Home Forums MM How-To PO history

PO history
Page: 1
UserPost

12:10 pm
February 17, 2010


micheal_adly

Member

posts 4
1

Dears,

I need to create a report by using query to show the po and its histroy

please have a review on the table names and fields which i  used as below and tell me if it is ok or  not.
also , i need to know what is the tables for these  :
GRN amount , payment amount and payment date

PO # EKPO EBELN
Vendor EKPO LIFNR
Doc date EBAN BEDAT
Material code EKPO EMATN
Material Desc. EKPO MATNR
WBS EKPO DISUB_PSPNR
Quantity EKPO MENGE
Unit EKPO MEINS
Net price EBAN PREIS
Currency EKPO PEINH
Delivery Date EKPO UZEIT
GRN # EKPO INFNR
GRN amount    
Quantity Recived EKPO MENGE
Unit EKPO MEINS
Invoice # EKBE XBLNR
Invoice Amount EKBE WRBTR
Currency BKPF HWAER
Invoice Date EKBE BLDAT
Payment term EKKO ZTERM
Due on BSAK ZFBDT
Payment Amount    
Currency    
Payment Date    
Clearing Doc BSAK AUGBL
Page: 1


Reply to Topic: PO history

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 2 + 3        (Required)

Topic Reply:


 
Topic RSS 

About the SAP Forums forum

Currently Online:

1 Guest

Maximum Online: 25

Forums:

Groups: 4

Forums: 12

Topics: 14

Posts: 16

Members:

There are 67 members

There are 1 guests


sap expert has made 1 posts

Top Posters:

micheal_adly - 4

axim - 4

sapexpert - 2

nehakhale - 2

basseyroro - 1

Administrator: sap expert


© Simple:Press Forum - Version 3.1.4 (Build 357)