How to join BALDAT & BALHDR

[Former Member]

Hi there!

I already wrote this question in the BI General Forum but perhaps here would be the right place to ask... (Or not?)

I am working on the reorganization of the basis tables of SAP and need to analyze the table BALDAT (Application Logs). I would like to know what years the data in BALDAT is from, but therefore I need to do a join.

But how to join these to tables? It can't be done directly...

Can anyone help me? Does anyone know?

[Former Member]

Hi there!

I already wrote this question in the BI General Forum but perhaps here would be the right place to ask... (Or not?)

I am working on the reorganization of the basis tables of SAP and need to analyze the table BALDAT (Application Logs). I would like to know what years the data in BALDAT is from, but therefore I need to do a join.

But how to join these to tables? It can't be done directly...

Can anyone help me? Does anyone know?

[Sandeep_Panghal]

You can use the filed LOG_HANDLE for join condition.

Edited by: Sandeep Kumar on Feb 3, 2009 1:35 PM

[Former Member]

Hi.

Use Inner join like this

select f1~baldat f2~baldat f1~balhdr into corresponding fields of table it
form baldat
inner join balhdr on ( baldat~log_handle = balhdr~log_handle ).

[Former Member]

Hi

Use the field LOG_HANDLE in join condition.

You can create a view with the above join condition using SE11.

Then you need to retrieve data from the view in your code wihout having to write the query.

Hope this helps

Regards,

Jayanthi.K

[Former Member]

Oh, I just thought too complicated... I thought I had to join over bal_indx or something like this...

Thanks a lot to all of you!