cancel
Showing results for 
Search instead for 
Did you mean: 

Table link between KONA, VBAK, VBRP and S060?

Former Member
0 Kudos

Hi Experts,

How can i link the below tables to prepare 1 single report??

Agrment Type ECC KONA-BOART

Agreement ECC KONA-KNUMA

Status ECC KONA-BOSTA

Description of agreement ECC KONA-BOTEXT

Reb.recip. ECC KONA-BONEM

Matl f. settl. ECC KONP-BOMAT

Amount ECC KONP-KBETR

Unit ECC KONP-KONWA

per ECC KONP-KPEIN

UoM ECC KONP-KMEIN

Accruals ECC S060-RUWRT_K

CdCur ECC ??

Rebate payments ECC S060-AUWRT_K

CdCur ECC ??

Accruals reversed ECC S060-RRWRT_K

Sales Doc. ECC VBAK-VBELN

SaTy ECC VBAK-AUART

Net value ECC VBAK-NETWR

Bill.Doc. ECC VBRK-VBELN

Billing Date ECC VBRK-FKDAT

Net Value ECC VBRK-NETWR

regards

venuscm

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

Yes as already indicated, SQVI will not work for this requirement. Take the help of ABAPer and develop a zee report.

thanks

G. Lakshmipathi

Answers (2)

Answers (2)

reazuddin_md
Active Contributor
0 Kudos

Hi Venu,

To add to the above inputs,

You can either go for new ABAP report or use Tx:SQ01 to write a query. Because SQVI query have its limitations.

in SQVI you cant include ABAP coding where as in SQ01- you can.

Regards,

Reazuddin MD

Former Member
0 Kudos

hi,

please check SQVI.

if you are not able to link it with SQVI then,

you can find intermediate table between the two tables and link it in sqvi.

regards,

balajia.