cancel
Showing results for 
Search instead for 
Did you mean: 

How to link billing doc

Former Member
0 Kudos

Hi all,

We are transfering data from SAP to SQL. I am mapping the SAP fields with the SQL.

For linking the table I could not find out the fields which should be mapped.

Example: VBAK can be linked with VBAP by VBAK.VBELN= VBAP.VBELN

Simillary can you guys tell me how to link VBAK table with VBRK,VBRP,KNA1,KNB1,VBPA,VBFA,MARA,MVKE,VBKD,ADRC,KONV,TVSBT.

Please mention if there are 2 or more fields.

Thanks in advance.

Ravi

Accepted Solutions (1)

Accepted Solutions (1)

former_member204407
Active Contributor
0 Kudos

Hi Ravi Teja

just open VBAK table in SE11 click on display

open one more required screen that is (VBRK/VBRP/KNA1....)what ever you want

compare two screens with foreign key button(below the fields screen -key symbol)

it will display relation between tables in next screen.

Regartds,

Krishna.

Answers (0)