2008 Aug 08 3:26 AM
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
2008 Aug 08 4:11 AM
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
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
2008 Aug 08 4:11 AM
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
2008 Aug 08 4:48 AM
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
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |