Find table of Invoice History
来源:互联网 发布:皮鞋销售软件 编辑:程序博客网 时间:2024/05/21 09:06
Find table of Invoice History
Posted By Ralph Klassen On Monday, January 19, 2004 at 11:03 AM from IT-Toolbox http://sap.ittoolbox.com
Q:
Does anyone know of a table holding logistics invoice documents other than the BSEG? I need to extract all invoices against purchase orders and am trying to find the most efficient way. Any help would be greatly appreciated.
A:
Start by selecting from EKBE where EBELN = your PO and EBELP = your PO item (if you have it). This will give you the PO history that you see in ME23N.
The field EKBE-VGABE identifies the type of document. I think you want to look for a '1' in this field for a goods receipt and a '2' for invoice receipts. Verify this by browsing EKBE using SE1/SE16 at the same time you are looking at a PO in ME23N. If all you are concerned with are the vendor postings then you can limit yourself to the invoice receipts. If you need to retrieve the expense side of the G/L coding then you need the goods receipts as well.
For each record that you retrieve from EKBE:
concatenate EKBE-BELNR and EKBE-GJAHR
if EKBE-VGABE = '1'
select from BKPF where AWTYP = 'MKPF' and AWKEY = (EKBE-BELNR and
EKBE-GJAHR)
if EKBE-VGABE = '2'
select from BKPF where AWTYP = 'RMRP' and AWKEY = (EKBE-BELNR and
EKBE-GJAHR)
I'm not sure if this will work for parked documents but my guess is 'yes it will'.
- Find table of Invoice History
- 96.Examine the structure of the INVOICE table.
- Sales order, Delivery and Invoice changes history tables
- History of Linux
- History of SMTP
- history of Ming dynasty
- History of Warcraft1
- The history of STL
- History of C++
- History of Unix Shells
- The history of Unix
- History of sudo
- History of C++
- History of Verilog HDL
- History of C++
- History of Programming
- The History of Email
- zabbix table -- History and Trends
- clock ()函数
- Oracle递归查询 start with..
- ctime ()函数
- difftime ()函数
- 解决php中Cannot send session cache limiter 的问题的方法
- Find table of Invoice History
- gmtime ()函数
- C#之Xml文件特定节点的读取
- localtime ()函数
- 自定义标签库
- 将屏幕坐标转换成客户区坐标
- Flex中数据绑定
- mingoe --实用的联系人管理网站
- Microsoft Visual C++ Guide(在window下用vc编译wxWidget)