Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Link Between Vbak and Bseg Table

Former Member
0 Kudos
3,007

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

5 REPLIES 5

navin_khedikar2
Contributor
0 Kudos
471

Hi,

Its not posible because BSEG is pool / cluster table.

Former Member
0 Kudos
471

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
0 Kudos
471

Hi,

connect vbak & bseg using kna1-kunnr.

ie.

vbak inner join kna1 on vbakkunnr = kna1kunnr.

bseg inner join kna1 on bsegkunnr = kna1kunnr.

Former Member
0 Kudos
471

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
Participant
0 Kudos
471

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