Joining Tables 2

[Former Member]

Hi

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

[alex_m]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

> 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.