topic Re: Data Retrieval from Cluster Table - BSEG in Application Development and Automation Discussions

Data Retrieval from Cluster Table - BSEG

Former Member — Thu, 15 Dec 2005 08:56:36 GMT

Hi all,

I need to retreive data related to document line items from BSEG whose CLEARING DATE (AUGDT) is greater than a user given date for TWO COMPANY CODES (say 0010/0200).

as BSEG is a cluster table, it has huge data and taking large amt of time can anybody suggest a better way of retrieving data for the above conditions(fastly)

Thanks in Advance,

Lakshmi

Re: Data Retrieval from Cluster Table - BSEG

andreas_mann3 — Thu, 15 Dec 2005 08:59:24 GMT

hi,

use second. index tables:

customers: BSAD

vendors: BSAK

G/L acc.: BSAS

sample:


  SELECT (felder) FROM  bsad into TABLE stab
         WHERE  bukrs  = bukrs
         AND    kunnr  IN kunnr
         AND    gsber IN gsber
         AND    augbl  <>  space
         AND    hkont  IN akont
         AND    augdt GT p_date.

regards Andreas

Message was edited by: Andreas Mann

Re: Data Retrieval from Cluster Table - BSEG

Former Member — Thu, 15 Dec 2005 09:37:47 GMT

Hi Andreas,

First of all let me thank you for the informative reply.

As i need get only CLEARED DOCUMENTS for DOCUMENT TYPE KR AND KG only, will it be suffice if i extract data from BSAK(Secondary index for vendors).

What about if the payment is not one time but partial (using tcode FB60/FB65) even in that case will BSAK only help or i need to consider BSIK also?

Hope i am clear.

Thanks in advance,

Lakshmi

Re: Data Retrieval from Cluster Table - BSEG

suresh_datti — Thu, 15 Dec 2005 10:12:51 GMT

Hi Lakshni,

As you require only the line items whose CLEARING DATE (AUGDT) is greater thangiven date, it should be enough if you doa SELECT on BSAK. If you need to look for open items also then go for BSIK.

Regards,

Suresh Datti