topic Re: Doubt in Application Development and Automation Discussions

Doubt

Former Member — Mon, 21 Apr 2008 12:11:44 GMT

HI all.

I need to do the calculation for KBETR based on KSCHIL .all fields from KONV table.

Formula

If internal table it_ KONV-KSCHIL has YDIS

it_ KONV-KBETR = (KONV-KSCHIL) - (KONV-KSCHIL + KONV-KSCHIL + KONV-KSCHIL)

pls refer example internal table values.

ie) it_ KONV-KBETR = (2000 for YDIS) - (10 for YINP + 150 for YICP +40 for JMAN)

Result is KBETR = 1800.

I need to sum KBETR field if the field KSCHIL has value like YDIS.

Eg: KNUMV KSCHIL KBETR

6789999 YDIS 2000

6789999 YINP 10

6789999 YICP 150

6789999 JMAN 40

Pls give me logic.

<REMOVED BY MODERATOR>

Regards.

Jay

Edited by: Alvaro Tejada Galindo on Apr 21, 2008 3:13 PM

Re: Doubt

Former Member — Mon, 21 Apr 2008 12:20:06 GMT

Loop at i_KONV.

if i_KONV-KSCHIL CA 'YDIS'.

v_sum = v_sum + i_KONV-KBETR.

else.

v_others = v_others + i_KONV-KBETR.

endif.

at end of KNUMV.

v_total = v_sum - v_others.

clear : v_total , v_sum , v_others.

endat.

endloop.

Re: Doubt

Former Member — Mon, 21 Apr 2008 12:31:19 GMT

HI Srinivas.

take this example

Eg: KNUMV KSCHIL KBETR

6789999 YDIS 2000

6789999 YINP 10

6789999 YICP 150

6789999 JMAN 40

6789999 JXXX 40

Now i want sum only which has YINP,YICP and JMAN.

then i need to Subtract the YDIS value from above total.I dont want consider all records what are available in internal table. so i will not go to consider 5th record ie JXXX.

pls give me logic fot this.

<REMOVED BY MODERATOR>

Regards.

jay

Edited by: Alvaro Tejada Galindo on Apr 21, 2008 3:14 PM

Re: Doubt

Former Member — Mon, 21 Apr 2008 12:36:52 GMT

Loop at i_KONV.

if i_KONV-KSCHIL CA 'YDIS'.

v_sum = v_sum + i_KONV-KBETR.

elseif i_KONV-KSCHIL = 'YINP'

or i_KONV-KSCHIL = 'YICP'

or i_KONV-KSCHIL = 'JMAN'.

v_others = v_others + i_KONV-KBETR.

endif.

at end of KNUMV.

v_total = v_sum - v_others.

clear : v_total , v_sum , v_others.

endat.

endloop.

Re: Doubt

Former Member — Mon, 21 Apr 2008 12:39:53 GMT

Hi,

Check this code.

Declare the variables appropriately.



Read table itab with key kschl = ydis binary search transporting knumv  kbetr.
if sy-subrc = 0 .
var_knumv = itab-knumv
var_ydis = itab-kbetr.
endif.

delete from itab where sy-index = sy-tabix.

Read table itab with key kschl = yinp binary search transporting kbetr.
if sy-subrc = 0 .
var_yinp = itab_kbetr.
endif.

delete from itab where sy-index = sy-tabix.

Read table itab with key kschl = yicp binary search transporting kbetr.
if sy-subrc = 0 .
var_yicp = itab_kbetr.
endif.

delete from itab where sy-index = sy-tabix.

Read table itab with key kschl = jman binary search transporting kbetr.
if sy-subrc = 0 .
var_jman = itab_kbetr.
endif.

delete from itab where sy-index = sy-tabix.

Now you will have the appropriate values, so do your calculations as reqd.

Incase you dont want to use the delete statement, copy the internal table to another internal table and do the process.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 21, 2008 3:14 PM

Re: Doubt

Former Member — Mon, 21 Apr 2008 14:23:29 GMT

Hi Raj

iam using global structure in selct quary like

SELECT * FROM konv

WHERE konv~mandt = sy-mandt AND

knumv = vbrk-knumv AND

kposn = vbrp-posnr.

how can i manage? iam not using Internal table ,pls give me solution.

Regards.

Jay

Re: Doubt

Former Member — Mon, 21 Apr 2008 14:24:49 GMT

Hi Srini.

iam using global structure ,how can replace iternal table.

pls guide me,

regards,

jay