topic Selecting data from BSEG in Application Development and Automation Discussions

Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:06:58 GMT

Hi,

I have selected the data from BKPF depending on the BUKRS & selecton screen dates.

Now I want to select data from BSEG depending on bukrs obtained in the above step & KUNNR which is in another internal T_CUST ... Will the select statement below ensure that the T_BSEG table will have the correct values of the documents no's corresponding to the customers in table T_CUST ??

Get BSEG data for all values in BKPF

IF NOT T_BKPF[] IS INITIAL.

SELECT BUKRS

BELNR

GJAHR

BUZEI

BUZID

BSCHL

KOART

SHKZG

DMBTR

KUNNR

INTO TABLE T_BSEG_TEMP

FROM BSEG

FOR ALL ENTRIES IN T_BKPF

WHERE BUKRS = T_BKPF-BUKRS AND

BELNR = T_BKPF-BELNR AND

GJAHR = T_BKPF-GJAHR.

ENDIF.

FORM GET_BSEG_DATA .

Get BSEG data for all customers

IF NOT T_CUST[] IS INITIAL.

SELECT BUKRS

BELNR

GJAHR

BUZEI

BUZID

BSCHL

KOART

SHKZG

DMBTR

KUNNR

INTO TABLE T_BSEG

FROM BSEG

FOR ALL ENTRIES IN T_CUST

WHERE KUNNR = T_CUST-KUNNR.

ENDIF.

ENDFORM. " GET_BSEG_DATA

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:10:26 GMT

Your code is alright.

What is your requirement.

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:10:26 GMT

hI sb

YES, THE SELECT STATEMENT WILL FETCH DATA FOR THE REQUIRED CUSTOMERS.

REGARDS

KISHORE

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:11:01 GMT

Hi SB,

It will work perfectly..

do you have any problem with the query..?

regards

satesh

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:12:07 GMT

Hi,

The data would be inconsistent, better way is to merge all into one final internal table and handle it appropriately.

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:20:40 GMT

My requirement is to get data from BSEG where bukrs = bkpf-bukrs and belnr= bkpf-belnr & knunnr = t_cust kunnr .. I was not sure about how to write a "single select statement" with "where conditions from two different tables" .... so only I split up the tables as t_bseg & t_bseg_temp and also split up up the where condition ... but then by splitting up the where condition I was not sure whether the right BELNR & BUKRS will be selected just by giving the condition where KUNNR = T_CUST-KUNNR ...

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:33:40 GMT

Hi SB,

Try to merge the two internal tables (bkpf and t_cust) into the 3rd internal table say t_temp and now you can write the select statement by using the 3rd internal table in FOR-ALL-ENTRIES option where bukrs = t_temp-bukrs and belnr = t_temp-belnr and kunnr = t_temp-kunnr.

Regards,

Phani.

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 06:36:14 GMT

Hi SB

MERGE THE TWO INTERNAL TABLE T_BKPF AND T_CUST INTO ANOTHER INTERNAL TABLE THEN USE FOR ALL ENTRIES FOPR THE SELECT STATEMENT.

REGARDS

KISHORE

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 07:15:45 GMT

hi SB,

We can Merge two Internal tables with the help of Innerjoins and collect the joined data in to third internal table and then use for all entries for the select statement ... but since BSEG is cluster table inner join shouldn't be used to merge cluster table data

.... So first with the help of one select statement merge the data of two internal tables in to third table and then use for all entries for the third internal table ..

hope this helps,

Regards,

Santosh

Re: Selecting data from BSEG

andreas_mann3 — Wed, 15 Mar 2006 07:43:38 GMT

hi,

your 2nd part is very bad for performance:

FOR ALL ENTRIES IN T_CUST
WHERE KUNNR = T_CUST-KUNNR

better select bsid and bsad

Andreas

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 11:46:58 GMT

Hi,

I am getting customer number with the help of account group ... Is there any table where I can get that the customer & account group as primary fields??

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 11:56:22 GMT

I am getting customer number with the help of account group and Company code ... Is there any table where I can get that the customer & account group & Company code as primary fields??

Ignore my previous msg.

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 11:59:09 GMT

hi SB,

look at KNB1 OR KNB2 TABLES ...

Regards,

Santosh

Re: Selecting data from BSEG

Former Member — Wed, 15 Mar 2006 14:35:31 GMT

Like Andreas said - BSID and BSAD. Definitely not BSEG.

Rob