Transparent Table for BSEC

[anss_shahid]

Hi Experts,

I am a Functional Financial Consultant and I am in process on developing a report using SQVI (Queries).

Within my report, I have joined the following tables:

• BKPF
• BSID
• BSIS

There is some data entered in table BSEC which is a cluster table and cannot be used in join.

I need your advice if you know what is the transparent table behind BSEC.

Looking forward to hear from you!

Regards,

Anss Shahid Essani

[matt]

Cluster tables do not have transparent tables behind them. You cannot access cluster tables via a query.

[anss_shahid]

BSEC table is used One-Time Account Data Document Segment. Basically I need to fetch BSEC-NAME1, BSEC-STCD3 and few other fields they are updated during the transaction.

Can you guide on how to approach towards it keeping in mind above tables I have used as well.

[Former Member]

You can use the FM READ_BSEC.

[anss_shahid]

It seems that we will be unable to prepare such report using SQVI as BSEC is a cluster table. However, we can get it prepared with the help of ABAPer.

Thank you all for your valuable suggestions.