Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hello,
To add, use a query (SQ01) on the tables. If you want cash and not invoices then use the document type as a reference in the selection screen.
Note, there is a logical table that can show all this information, so you can use it in the query.
Lastly understand and review how the contents appear in BSEG. If you limit by vendor then only the vendor line will appear.
Mark as helpful.
Regards
Waza
| | | ---------------Original Message---------------
From: krisprashant
Sent: Wednesday, January 26, 2011 5:59 AM
Subject: Accounts Payable Data Extraction
Dear All
Thanks for reading and taking time to answer this question..
Unfortunately dictionary does not have a better word than thank you..so thank you all for helping me on this..
We are working on a spend analytic exercise and part of the objective is to extract the accounts payable data..what ever is spent in the last year or so and analyze that..we are working on SAP..
I am looking out for the below fields:
Document Number
Document Date
Posting Date
Document Type
ref
Posting Period
Clearing date
Document currency
Reference
Amount in doc. curr.
Terms of Payment
Account
Vendor Name
GL No
Cost Centre Code
Here is the challenge..i am using FBL1n and the report which comes out of the data has two issues 1. It is displaying GL and Cost Centers fields as blank..2. data is coming for the first line of the invoice (for example if the vendor has 10 invoice lines , only the first line is what we are getting as the output)..
Can anyone of you, please guide me as to how to resolve this...Accounts |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  wnash7658
SAP Logistics Material Management Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
