Link table for integration

[Former Member]

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 VBPA ,MVKE,MARC,KNA1,KONP,ADRC,CDHDR.

Please mention if there are 2 or more fields.

Thanks in advance.

Ravi

Edited by: raviteja8 on Sep 9, 2011 6:12 PM

[Former Member · Accepted solution]

Hi Ravi,

The tables VBAK, VBAP, VBPA are transaction data and are linked by VBELN. In table CDHDR, for changedoc object = VERKBELEG, the sales document VBELN = OBJECTID.

For the customer in VBAK, you can link with KNA1 and for ADRNR in VBAK link with ADRC.

And the VBAP-MATNR+ VBAP-WEKRS links with MARC

VBAP-MATNR+VBAK-Sales area links with MVKE.

Regards

Raghu.

[madhu_vadlamani]

Hi Raviteja,

Welcome to scn.What is the business requirement. Instead of linking tables you can use function modules and get the data. My suggestion is get the exact requirement and find that fm which gives that data.If you need help please post.

Example:Sales order data, material data,customer data.

Regards,

Madhu.

[Former Member]

Thanks rag and prashanth. I am new to SAP SD and they asked me to write the fuctional spec for sales order mapping with SQL. They already told me which field of SAP should map with which field of SQL. My work is to just find the field which can join these tables and write a functional spec. Really I could not understand your way of solving of the problem as i am 1 week old in SAP. Madhu, If you can explain little more I will try to figure it out.

Thanks,

Ravi

[Former Member]

Ravi, what Madhu is trying to say is what is the business requirement? if you post that we would help you with solutions..maybe there's a report already in SAP that meets your requirement.

I would suggest check reports in the area menu SAP1 and SAP2.

Regards,

Raghu.

[Former Member]

Can you give me the link for SAP1 ,SAP2

[Former Member]

They are area menus in SAP..i.e. as soon as you login..just enter SAP1 or SAP2 in the menu and press enter..

it'll show up all the available reports in SAP.

Regards

Raghu.

[Former Member]

HI

how to link VBAK table with VBPA ,MVKE,MARC,KNA1,KONP,ADRC,CDHDR.

VBAK-VBELN = VBPA-VBELN is the link

VBAP-MATNR = MARC-MATNR, VBAP-MATNR = MVKE-MATNR,

VBPA- KUNNR where PARVW=SP in KNA1_KUNNR

For conditions

Get VBAK-KNUMV = KONP-KNUMH for KSCHL is condition types.

For Address

KNA1 -ADRNR = ADRC-ADDRNUMBER

For change History

in CDHDR table u can enter the tcode ,

regards

Prashanth