Skip to Content
author's profile photo Former Member
Former Member

BSET related tables

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

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 04:48 PM

    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^

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 28, 2008 at 07:37 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 11:43 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.