Reading cluster table BSEC

[Former Member]

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.

[Former Member]

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?

[Former Member]

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

[Former Member]

try open sql statement if you worrying about performance issue.

Rgds

[kabil_g]

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

[Former Member]

Hi Kabil,

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

Thanks,

Rajat

[Former Member]

any more suggestion please...

[Former Member]

SO read lfa1 to bsak / bsik.

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

Neal