Link Between Vbak and Bseg Table

[Former Member]

Hi all

I have to create a report for the overdue of payments at sales office for which I need link between vbak and bseg table..

Plz Reply soon

Thnx and Regards

Pradeep Singh

[Former Member]

Hi all

I have to create a report for the overdue of payments at sales office for which I need link between vbak and bseg table..

Plz Reply soon

Thnx and Regards

Pradeep Singh

[Former Member]

Hi,

Its not posible because BSEG is pool / cluster table.

[Former Member]

Hi,

check theses links u may get an idea abt relationship.and might be somewht helpful to u.

http://www.erpgenie.com/abap/tables_sd.htm

Regards,

Sana.

[Former Member]

Hi,

connect vbak & bseg using kna1-kunnr.

ie.

vbak inner join kna1 on vbak_{kunnr = kna1}kunnr.

bseg inner join kna1 on bseg_{kunnr = kna1}kunnr.

[Former Member]

Hi

u can't link directly.

instead u can do by linking vbak to bkpf.

den bkpf to bseg.

eg.

first jus fetch belnr from bkpf where passing AWTYP = "VBAK"

latr u vil link bseg- vbak.

like associative property.

a=b, b=c.

den a=c.

thats vil give best performance...

reward if useful.

[former_member767623]

Hi pradeep,

step1) Pass vbrk-vbeln to bkpf-awkey get belnr from bkpf

step2) put belnr in bseg-belnr get what u want from bseg

Thanks & Regards,

Radhakrishna.Ette