topic Re: Reading cluster table BSEC in Application Development and Automation Discussions

Reading cluster table BSEC

Former Member — Thu, 22 Aug 2013 17:27:55 GMT

Hello,

I want to read data from BSEC table which is a cluster table. I found a FM READ_BSEC that will read the data but it need all the key field data to be filled in. In my case I need to read data based on the name and company code.

Can you please suggest what will be the best approach to do this?

Thanks.

Re: Reading cluster table BSEC

Former Member — Thu, 22 Aug 2013 17:55:17 GMT

You can get all of the key fields from BKPF except BUZEI. I know that's not much help, but there you are.

Neal

PS: When you say name, which name are you referring to? Customer, Vendor, Both? Do you know what tables like BSID and BSAD are for?

Re: Reading cluster table BSEC

Former Member — Thu, 22 Aug 2013 18:06:14 GMT

Hi Neal,

My requirement is to get the document number i.e. BELNR from BSEC based on the one time vendor name i.e. NAME1. Table BKPF doesn't store the name of the one time vendor.

Thanks,

Rajat

Re: Reading cluster table BSEC

Former Member — Thu, 22 Aug 2013 18:18:44 GMT

try open sql statement if you worrying about performance issue.

Rgds

Re: Reading cluster table BSEC

kabil_g — Fri, 23 Aug 2013 04:38:59 GMT

Hi Rajat Garg,

In the Select query Pass the Condition

Add your one time vendor to your Corresponding Transaction

Where Vendor Name = 12.

Regards,

Kabil

Re: Reading cluster table BSEC

Former Member — Mon, 26 Aug 2013 18:07:26 GMT

any more suggestion please...

Re: Reading cluster table BSEC

Former Member — Mon, 26 Aug 2013 18:08:03 GMT

Hi Kabil,

I need to read table BSEC based on the vendor name and not on the vendor number.

Thanks,

Rajat

Re: Reading cluster table BSEC

Former Member — Mon, 26 Aug 2013 18:47:35 GMT

SO read lfa1 to bsak / bsik.

Then in a second step read that intermediat itab to bsec.

Neal