topic Re: Transparent Table for BSEC in Application Development and Automation Discussions

Transparent Table for BSEC

anss_shahid — Fri, 02 May 2014 07:20:37 GMT

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

Re: Transparent Table for BSEC

matt — Fri, 02 May 2014 08:42:53 GMT

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

Re: Transparent Table for BSEC

anss_shahid — Fri, 02 May 2014 09:16:46 GMT

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.

Re: Transparent Table for BSEC

Former Member — Fri, 02 May 2014 09:31:17 GMT

You can use the FM READ_BSEC.

Re: Transparent Table for BSEC

anss_shahid — Mon, 05 May 2014 04:18:38 GMT

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.