topic Link Between Vbak and Bseg Table in Application Development and Automation Discussions

Link Between Vbak and Bseg Table

Former Member — Fri, 07 Dec 2007 04:17:36 GMT

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 — Fri, 07 Dec 2007 04:20:05 GMT

Hi,

Its not posible because BSEG is pool / cluster table.

Former Member — Fri, 07 Dec 2007 04:24:31 GMT

Hi,

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

Regards,

Sana.

Former Member — Fri, 07 Dec 2007 04:33:02 GMT

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 — Fri, 07 Dec 2007 04:46:36 GMT

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 Member — Thu, 05 Jul 2012 08:35:28 GMT

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