Budget Report Creation

[Former Member]

hi,

I am creating Budget for the month report. i am getting details from BPBK and BPJA Tables.

In BPBK creation date is there, In BPJA budget amount is there , but there is no primary key to link, kindly give me the suggestion to link the tables or tell me the table name which contains data and budget amount.

Thanks

R.vijai

[Former Member]

hi

check for any common column from both the table and use inner join on that colum

for eg

select * into itab from bpbk as a inner join bpja as b on (common column) where ....

if there are no common fields den only way is to get all the data and select wat u required

shiva

[Former Member]

Hi,

You can do it in 2 ways.

Either use the mathod of inner join on the common fields of two tables.

Or just fetch the data invidually from two tables in a common internal table.

and then write it into a database table containig both the fields.

Hope it will help u.

Thanks

Rajesh Kumar

[Former Member]

Hi Alagan,

Here is the way to find out relationshhips between tables. Just follow this, you will get to know the relation.

1. Use SQVI transaction,

2. Create a View

3. Enter title,

4. Choose the Data source as Table Join

5. Now use Insert table option.

6. And insert the tables which you want. It will propose the relation between them.

Hope this will help you.

Thanks

NItesh