Cluster tables in SAP

[Former Member]

Hi all,

what are cluster tables other than bseg , bsec.

And how fine out all cluster tables in SAP .

Regards

Suresh.D

[amit_khare]

Check the links -

Regards,

Amit

Reward all helpful replies.

[Former Member]

HI,

DD06L

DDIPCLCHK

DDTCCT

Regards

Sudheer

[Former Member]

hi

[Former Member]

Hi Suresh,

In Transaction SE84 , select <i>ABAP Dictionary Database Tables</i> then the <i>All Selections</i> button. You will see an option to select types of tables, turn off Transparent and Pool, then run - there are not many.

[Former Member]

hi

[Former Member]

hI,

Cluster Tables

Should be accessed via primary key

Cluster table means that,

In abap dictionary there are many tables (cluster tables),

2. But They all are linked to only one database table (actual physical table in database).

3. Eg. BSEG is in abap dictionary.

BSEG won't be there in actual database, instead,

they corresponding table name is RFBLG

which has the corresponding fields

MANDT CLNT 3

BUKRS CHAR 4

BELNR CHAR 10

GJAHR NUMC 4

PAGENO INT2 5

TIMESTMP CHAR 46

PAGELG INT2 5

VARDATA RAW 3800

All the data of BSEG fields, is stored in

VARDATA in encoded format. The primary keys are also saved.

Cluster tables usage is a lot in HR-ABAP Programming

PCL1 - Database for HR work area; (long text, etc)

PCL2 - Accounting Results (time, travel expense and payroll); (payroll results)

PCL3 - Applicant tracking data;

PCL4 - Documents, Payroll year-end Tax data (change logs, etc)

Database Tables PCLn

in SE11 , goto table DD02L , there one field will be there to differentiate types of tables , u can filter on that i guess the field description is object class

Regards

[Former Member]

hi

thank you

[Former Member]

hi

thank you