topic Re: Joining Tables 2 in Application Development and Automation Discussions

Joining Tables 2

Former Member — Wed, 23 May 2007 14:11:46 GMT

I want to join BKPF and CDHDR and they can be joined through the OBJECTCLAS field in CDHDR and a combination of MANDT BUKRS BELNR GJAHR in the BKBF table, so

OBJECTCLAS = MANDT & BUKRS & BELNR & GJAHR

im not sure how to do this, can anyone help please

Thanks in adavance

Re: Joining Tables 2

alex_m — Wed, 23 May 2007 14:14:47 GMT

There is no fields to relate both a table, so u cant join both the table. Atleaset one key field should in both the table.

Re: Joining Tables 2

Former Member — Wed, 23 May 2007 14:19:02 GMT

Do you have to join on a key?

it looks like OBJECTCLAS is made up of MANDT + BUKRS + BELNR + GJAHR

so i could join that way

Re: Joining Tables 2

Former Member — Wed, 23 May 2007 14:31:09 GMT

I am brand new to this by the way, i am writing my first abap program so sorry if my questions are basic

Thanks for your help

Re: Joining Tables 2

Former Member — Wed, 23 May 2007 14:40:26 GMT

> Hi

> I am brand new to this by the way, i am writing my

> first abap program so sorry if my questions are

> basic

> Thanks for your help

Don't worry, we are all here to learn -;)

Actually, you can do a JOIN like that....

TABLE1_{FIELD1 = TABLE2}FIELD1 + TABLE2_{FIELD2 + TABLE2}FIELD3

What you will need to do is gather data from each table and then use some LOOP and READ TABLE statements....

Greetings,

Blag.