SAP Query

[Former Member]

Hi everyone,

I wanted to link tables VBRK, VBRP and BSIS thru SAP Queryu2026..Here i wanted to link SD billing data with FICO Accounting details...

Can any body please tell how to do the link???

Thanks & Regards,

Raj

[Former Member · Accepted solution]

HI

i think you can use this field to join the tables

BELNR ACCOUNTING DOCUMENT NUMBER

REGARDS

[Former Member · Accepted solution]

BELNR (Accounting Document Number) field is not available in talbe VBRP.

if any body provide other link then that would be useful.

Thanks,

Raj

[Former Member · Accepted solution]

Hi Raj,

Kindly Try to link with field WERKS (Plant).

Thanks & Regards,

Ratish

[Former Member]

Hi

You can join tables VBRK-VBELN & VBRP-VBELN with BSIS-XBLNR

Hope this will help you.

Regards,

Vijay

[Former Member]

Hi

You can use table BKPF and it can be joined with VBRP-VBELN and BKPF-AWKEY

Regards,

Nimit

[Former Member]

Hello Friend,

Approach 1:

Develop a SAP Query, Functional Area/Infoset, and User Group ( using T code :SQ03,SQ02,SQ01 respectively )

While developing Functional Area feed in these 2 tables (Table 1- equipment number (EQUNR) & work center (ARBPL) and Table 2 - work center (ARBPL) to main work center (GEWRK) with work center (ARBPL) as the Primary Key- bridge to join these 2 tables.

In SAP Query Development; you may take Plant as the Selection Field or any other field as per business requirement to make a search in the query.

Now when you execute this query, you will get a complete Download of (EQUNR),work center (ARBPL) and main work center (GEWRK) in one table.

For SAP Query, you may also approach your ABAP Team Member. This is a cleaner approach than the other one.

Approach 2:

Take SE16 download of the Table 1 and Table 2 and join them in Excel (using vlookup if required).This approach is however limited to the data volume that you have to process.

You can check the following Link

/people/shafiq.rehman3/blog/2008/06/16/sap-adhoc-query-sq01-sq02-sq03