topic Re: sql , how to get cost elements in cost element group in sql statement ? in Application Development and Automation Discussions

sql , how to get cost elements in cost element group in sql statement ?

Former Member — Tue, 31 May 2011 10:12:37 GMT

sql , how to get cost elements in cost element group in sql statement ?

hello everyone.

i need some help.

i want to get data from bseg which have gl = cost element in cost element group

such as cost element group "promo_allo"

have cost element = 496362,496341,496335

i know that cost element group keep in table "setleaf"

in table "setleaf"

record 1

setname = "promo_allo"

valfrom = 0000496362 = gl

record 2

setname = "promo_allo"

valfrom = 0000496341

record 3

setname = "promo_allo"

valfrom = 0000496335

but i donot know how to get data from table bseg which have gl = cost element in cost element group

SELECT BUKRS BELNR BUZEI GJAHR LIFNR DMBTR MWSKZ SGTXT HKONT

INTO TABLE T_BSEG

FROM BSEG

FOR ALL ENTRIES IN T_DOC_HEADER

WHERE BUKRS = T_DOC_HEADER-BUKRS AND

BELNR = T_DOC_HEADER-BELNR AND

GJAHR = T_DOC_HEADER-GJAHR AND

LIFNR IN S_LIFNR

HKONT = ????????????????????????????????????????

please advice

Re: sql , how to get cost elements in cost element group in sql statement ?

Former Member — Tue, 31 May 2011 13:41:43 GMT

After you have the individual cost elements, put them in a range table and then include that in the SELECT.

Is that the question you are asking?

Rob

Re: sql , how to get cost elements in cost element group in sql statement ?

Former Member — Wed, 01 Jun 2011 02:32:02 GMT

thank you Rob.

please tell me how to put data in range table

Re: sql , how to get cost elements in cost element group in sql statement ?

Former Member — Wed, 01 Jun 2011 03:59:40 GMT

Hi,

Get all your entries from SETLEAF into an internal table.

ranges : r_HKONT for bseg-HKONT.

select * from SETLEAF into it_setleaf where setname = 'promo_allo' ...

loop at it_setleaf.

r_HKONT-sign = it_setleaf-VALSIGN.

r_HKONT-option = it_setleaf-VALOPTION.

r_HKONT-low = it_setleaf-VALFROM.

r_HKONT-high = it_setleaf-VALTO.

append r_HKONT.

clear r_HKONT.

endloop.

use this r_HKONT in your select ...

SELECT BUKRS BELNR BUZEI GJAHR LIFNR DMBTR MWSKZ SGTXT HKONT

INTO TABLE T_BSEG

FROM BSEG

FOR ALL ENTRIES IN T_DOC_HEADER

WHERE BUKRS = T_DOC_HEADER-BUKRS AND

BELNR = T_DOC_HEADER-BELNR AND

GJAHR = T_DOC_HEADER-GJAHR AND

LIFNR IN S_LIFNR

HKONT in r_HKONT.

Regards,

Srini.

Re: sql , how to get cost elements in cost element group in sql statement ?

Former Member — Wed, 01 Jun 2011 04:12:03 GMT

thank you for all.

i got solution