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: 

how to combine bseg and bkpf?

Former Member
0 Kudos

Friends ,

i just wanna know as 2 how can we conmine bseg and bkpf tables.

since bkpf is a transparent table and bseg is a cluster table.

regards

Essam

essamsaud@yahoo.co.in

6 REPLIES 6

Former Member
0 Kudos

You can not use join on these tables.

you will have to use internal tables for bkpf and bseg and then combine them...as required.

Former Member
0 Kudos

HI..

Check in SQVI...for JOIN COndition after giving table names:

bseg and bkpf..

relevant conditions will be shown .

Thanks .

Praveen

Former Member
0 Kudos

u cannot use joins for cluster table..

So what u can do is u can select the data from BSEG table and store in one internal table...then

SELECT data FROM BKPF into itab1

for all entries in itab

where bukrs = itab-bukrs and

belnr = itab-belnr and

GJAHR = itab-GJAHR.

REWARD if HELPFULL.

0 Kudos

Hi Essam,

First let me know where do u want to join these 2 tables if u r trying in SQVI then it is not possible to join with cluster table BSEG.

If u want to join in ABAP program then u can do one thing first select the data from BKPF into internal table.

Then based on this data u can select the data from cluster table BSEG.I think in this way u can proceed.

If anything else required then plz let me know.

If it is helpful then plz reward the points.

Regads,

Rajesh Akarte

Former Member
0 Kudos

hi

try to use for all entries concept.....

Former Member
0 Kudos

hi essam khan....

Follow this...it might help you in some way...

-


You have to retrieve the data from each table separately, e.g.,

select * into corresponding fields of table it1 from table1

where conditions.

loop at it1 into wa1.

move-corresponding wa1 to wa_join.

select * into corresponding fields of wa_join from table2

where table2-key = it1-key.

append wa_join to it_join.

endselect.

endloop.

it_join contains the same records as if you had been able to join the

tables.

Reward points if contents are useful...

Regards

Mandeep.