how to fetch data data from cluster table and transparent table

Updated May 18, 2018

I need to join one cluster table(bseg) with transperent table(BKPF)
using into internal table.

key fields : bseg-belnr = bkpf-belnr.

How can I do.

Thanks and best regards.

Comments

22 May 2013 8:04 am Rohit Mahajan Best Answer
If you want to extract data you must have to increase the transaction log sizes, if you don’t have rights you can easily increment the system temporary and regular table space size.
For this you have to work on the below steps:
If you want to increase the database’s primary and secondary log files, you must have to have run the below commands, at the same time you must have to replace the database name with the database name you are using to gain performance.
UPDATE DATABASE CONFIGURATION FOR [db_name] with the help of LOGPRIMARY 10
UPDATE DATABASE CONFIGURATION FOR [db_name] with the help of LOGSECOND 2
Every one of the transaction log file must be 10 MB, by using all these commands, only 10 primary log files are assigned all the time and secondary log files are assigned and removed as required, there must be a maximum of two files.
Next you have to run the below commands using the proper names and directories you must have to upsurge the system temporary and regular table space page sizes up to 32 KB
• GENERATE BUFFERPOOL [bufferpool name 1] SIZE 8000 PAGESIZE 32K
• GENERATE REGULAR TABLESPACE [regular tablespace name] PAGESIZE 32 K ACCOMPLISHED BY
• SYSTEM with the help of ('[directory 1]') BUFFERPOOL [bufferpool name 1]
• GENERATE BUFFERPOOL [bufferpool name 2] SIZE 8000 PAGESIZE 32K
• GENERATE SYSTEM TEMPORARY TABLESPACE [temporary tablespace name] PAGESIZE 32K
• ACCOMPLISHED BY SYSTEM with the help of ('[directory 2]') BUFFERPOOL [bufferpool name 2]
Let us have an example how the commands will work
• GENERATE BUFFERPOOL ORGAUDIT_POOL SIZE 8000 PAGESIZE 32K
• GENERATE REGULAR TABLESPACE ORGAUDIT_SPACE PAGESIZE 32 K MANAGED BY SYSTEM USING ('ORGAUDIT_SPACE') BUFFERPOOL ORGAUDIT_POOL
• GENERATE BUFFERPOOL ORGAUDIT_POOL_TEMP SIZE 8000 PAGESIZE 32K
• CREATE SYSTEM TEMPORARY TABLESPACE ORGAUDIT_32K PAGESIZE 32K MANAGED
• BY SYSTEM USING ('ORGAUDITSMS_32K_1') BUFFERPOOL ORGAUDIT_POOL_TEMP

Hope this article might help you to understand the above issue.