on 04-02-2015 9:06 PM
I am not sure if I am in the correct area. I currently am a user within my company using the financial parts PEU. I would like to query some data using ME2N & FBL1N. Is this possible?
Hi Sherri,
You will all vendor open items from tables BSIK and cleared items BSAK. Also you can get information from BKPF and BSEG tables. Within these tables you will get the information all you need.
Please check the fields and extract the data as per the requirement.
Regards,
Lokesh Earla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sherri,
I will try to explain you in simple terms to get the required information. Follow the belwo steps
Step 1: Go to SE16N Transaction code (you can extract all the information from tables)
You are looking for list of vendors by purchase order
Step 2:
within these two tables you will get the PO creator information and vendor details .
once you get the vendor details
Step 3: Go to FBL1N transaction code and provide the list of vendor which you want to get the cleared item details for the respective PO or vendor.
Regards,
Lokesh Earla
I am unable to get access t o the SE16 (SE16N) code however, and can get table specific codes. that is all I really need anyway.
Once I go into FBL1N, I want to extract the vendors by the creator. We share some vendors with other facilities and I want to avoid pulling their data.
So by having access to the following tables:
EKKO
EKPO
BSAK
BSIK
I should be good, or do I need:
BKPF
BSAS
BSEG
as well?
How can I get Payment information by Purchase order with a "Created by" Purchasing Document Header?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sherrik,
You want to know the payment information for particualr vendor or invoice, please follow the below steps:
you can get payment information details from vendor line items.
T.code: FBL1N
1) Provide the respective vendor and company code details and search in clearing documents list based on the dates.
Regards,
Lokesh Earla
Thank you.
What I am actually looking to do is to get a list of vendors by purchase order, but I want to select them by the PO creator. Then add my columns with the particular information I need. We are using a classic version of GUI. I have not had any luck getting this information directly from the system. I was wondering if it might be easier to extract the information from various T-codes, export to Excel and just query a report from that.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.