Looking for assistance using PEU Production Global AFS

[Former Member]

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?

[former_member191070]

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

[Former Member]

Now I am lost.  Let me tell you that I have had no training on this software.  I am learning as I go.  I have no idea what a BSIK table is or any of those others are.  Maybe it is just a difference in the terms used.

How do I find a BSIK, BSEG, or BKPF table?

[Former Member]

These are table names. You can view them using transaction SE16.

[former_member191070]

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:

• Give the table EKKO for purchase order details
• Table EKPO- for line item

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

[Former Member]

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?

[former_member191070]

Hi Sherri,

If you get access for SE16N transaction code you will able to access all tables.

Regards,

Lokesh Earla

[Former Member]

How can I get Payment information by Purchase order with a "Created by" Purchasing Document Header?

[former_member191070]

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

[Former Member]

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.