BSET related tables

[Former Member]

Can anybody tell me how to find the transparent tables belonging to BSET?

Thanks in advance.

[raymond_giuseppi]

BSET "Tax Data Document Segment" is cluster table, the cluster table is RFBLG "Cluster for accounting document".

Tables in this cluster are

BSEC One-Time Account Data Document Segment

BSED Bill of Exchange Fields Document Segment

BSEG Accounting Document Segment

BSES Document Control Data

BSET Tax Data Document Segment

Regards

[Former Member]

You can run ST05 with a program that reads a record from bset and sql

analysis turned on. You'll get the real table name doing this way.

But.... Bset as bseg are cluster tables. These aren't stored as simple

tables with a field structure. The relevant information (not the primary

key) is stored as a stream in a single big field. If you visit the

knowledge base of the group you'll find some discussions about bseg

(which is almost the same)

They can be quite inefficcient even if you specify a few fields in the

select clause.

regards,

satish.

[Former Member]

hi

good

BSET is not directly linked to EKPO.

BSET is linked to BKPF/BSEG.

Pass on the EKPO-EBELN to BSEG-EBELN and get BSEG-BELNR.

Pass the BSEG-BELNR to BSET-BELNR and retrieve the information.

Hope this helps.

thanks

mrutyun^