Connection between COBL sturture and VBRK/VBRP tables

[bojani]

Hello everyone,
I have a task to create custom report that will list the documents from VBRK table. In selection screen I have several parameters. Now I need to add one more parameter that should filter the search by a data that is on the Account assignment car of the sales order for that document. However, that data is in COBL-AUFNR field. Since COBL is not a table, I cant get the data from it. Do you have any suggestions on how can I get the COBL-AUFNR data for any of the documents.

The main question: In other words how to find out what actual table (THAT I CAN LINK/JOIN TO VBRK/VBRP TABLES) contains that data.

I may not be clear so here's an example:

I have a sales order with Order ID: 3809

In every line item in card Account assignment there is a field labeled "Order": PS3938 (when I go F1 I see that's the COBL-AUFNR field)

There is a document with ID number 90007876 that I can connect to Sales document 3809 since there is a column that contains that data.

I now need to put a parameter in selection screen where someone will enter "PS3938" and get 90007876 document (along with all the other documents that in their sales order have PS3938 in any of the lines of the sales order) listed in the report. That's why I need to find what actual table contains that data, and I have to be able to connect that table with VBRK or VBRP tables.

Hopefully I was clear enough and there is a good soul that will help me find the solution.

Best regards to all!

[Neeraj_Jain · Accepted solution]

Hello bojani,

The AUFNR field already placed in VBAP table and you can get order# itself from VBAP table and build your logic.

Let me know if any question on it.

Regards,

Neeraj Jain

[bojani · Accepted solution]

Dear neeraj.jain16,
thanks for the help. VBAP was the table I was looking for. I managed to solve my problem.

BR.