control break events

[Former Member]

Hi sdn,

using control break events i grouped materials under same invoice.

EX: o/p.

date adder invoice materials

05.08.2008 abc street 10 tomato

xyz city

state

malaysia

apple

grape

orange

in above example the problem is gap b/w first material and second,

because address having about 10 to 15 fields.

i want to squeeze that gap even the page is change.

please tell me the solution.

Thanks

[Former Member]

Hi sdn,

using control break events i grouped materials under same invoice.

EX: o/p.

date adder invoice materials

05.08.2008 abc street 10 tomato

xyz city

state

malaysia

apple

grape

orange

in above example the problem is gap b/w first material and second,

because address having about 10 to 15 fields.

i want to squeeze that gap even the page is change.

please tell me the solution.

Thanks

[Former Member]

Hi Phani.

Use condense as mentioned in code....

IF NOT tb_output[] IS INITIAL.

LOOP AT tb_output INTO wa_output.

wf_temp = wa_output-z_net_amnt.

wf_temp1 = wa_output-z_amnt.

wf_temp2 = wa_output-z_opt_amnt.

• wf_temp3 = wa_output-z_opt_amnt.

wf_temp4 = wa_output-z_disc_amnt.

wf_temp5 = wa_output-z_misc_amnt.

wf_temp6 = wa_output-z_vat_amnt.

wf_temp7 = wa_output-z_margn_amnt.

CONDENSE wf_temp NO-GAPS.

CONDENSE wf_temp1 NO-GAPS.

CONDENSE wf_temp2 NO-GAPS.

CONDENSE wf_temp4 NO-GAPS.

CONDENSE wf_temp5 NO-GAPS.

CONDENSE wf_temp6 NO-GAPS.

CONDENSE wf_temp7 NO-GAPS.

*

• SHIFT :

• wf_temp LEFT DELETING LEADING space,

• wf_temp1 LEFT DELETING LEADING space,

• wf_temp2 LEFT DELETING LEADING space,

• wf_temp4 LEFT DELETING LEADING space,

• wf_temp5 LEFT DELETING LEADING space,

• wf_temp6 LEFT DELETING LEADING space,

• wf_temp7 LEFT DELETING LEADING space.

CONCATENATE wa_output-z_vhvin

wa_output-z_commnos

wa_output-z_license_date

wa_output-z_license_no

wa_output-z_kunnr

wa_output-z_vhusg

wa_output-z_offer_typ

wa_output-z_vbeln

wa_output-z_doc_date

wa_output-z_fkart_flag

wf_temp

wf_temp1

wf_temp2

• wf_temp3

wf_temp4

wf_temp5

wf_temp6

wf_temp7

wa_output-z_deli_date

wa_output-z_geo_area

INTO wa_output1

SEPARATED BY co_tab.

Mohinder

[Former Member]

Hi Phani,

You can use CONDENSE Statement to remove the gaps inbetween.

Check this link:

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb33e6358411d1829f0000e829fbfe/content.htm

Regards,

Chandra Sekhar