creating different spool requests based on sorting -part II

[Former Member]

hi folks,

Now I have added the group field to 'accitab' and as mentioned I have another itable (same as 'accitab') called 'final_accitab where I have the recrods for all the customers and their corresponding group types too.

something like this..

customernumber ........ sortgroup

1000001 1

1000001 1

1000001 1

1000012 1

1000012 1

1000112 1

.

.

.

.

10000002 2

10000002 2

10000002 2

.

.

.

.

10000003 3 and so on

Now I have to print the customers based on the sorting therefore I should be passing the records of all the customers that come under a common sort type into one spool request,( I think that way!!) and how to do that ?

ii)how to print separate statements for each customer

for the same sort within the same spool request.

Thanks in advance

Vinu

[Former Member]

let me explain :

for example to derive the value for parameter

Z_PAYMENT_TERMS = V_PAYMENT_TERMS

*----

---

*Payment terms

*----

---

types: begin of s_payment_terms,

zterm type knb1-zterm,

vtext type tvzbt-vtext,

end of s_payment_terms.

data: i_payment_terms type standard table of s_payment_terms

WITH HEADER LINE,

v_payment_terms type tvzbt-vtext.

select single * from tvzbt INNER JOIN knb1 ON tvzbt_{zterm = knb1}zterm

into corresponding fields of i_payment_terms

where knb1~kunnr = zzbusinesspartner.

v_payment_terms = i_payment_terms-vtext.

My question is if I declare it within the loop then this piece of code will be processed every time including for each record of the customer

like that I have separate piece of code for ZSCAN, ZADNAME, ZAGENCYNAME.. does it not create aperformance issue and take along time to execute.

What I thought is there a way when the T_customer[] gets updated with records for a customer then we can go ahead and perform this piece of code so that this entire peice of code is executed only once for each csutomer instead of executing the code every time...

Hope you got it...

Thanks

Santhosh

[Former Member]

Printer names are case sensitive. Have you checked that?

Srinivas

Message was edited by: Srinivas Adavi

Also, I see that you marked this as answered, but I don't see any points given to Max, who has helped you a lot on this issue. Please reward him for his efforts.

[Former Member]

Yes.

[Former Member]

Hi Vinu

I agree with Srinivas: check the name of device, are you sure it's Xerox1?

You can try to transfer the name of that printer by dialog (FM SSF_OPEN) and then check the name in debug.

Max

[Former Member]

Hi Vinu,

I saw that you rewarded Max for his effort. I apologize for missing it.

Regards,

Srinivas