topic Re: SAPScript: How to sort address... in Application Development and Automation Discussions

SAPScript: How to sort address...

naimkhans_babi — Fri, 27 Jan 2006 10:23:35 GMT

Hi....

My problem is that Address in layout sets should be according to the address of from where it is created.. just like a mail merge...can any one help me in that regards to sort out this problem,,,,,

thanking you....

Re: SAPScript: How to sort address...

Former Member — Fri, 27 Jan 2006 10:29:48 GMT

Sort the data in the internal table and then process it in the sapscript.

Is that what you want.

Re: SAPScript: How to sort address...

Former Member — Fri, 27 Jan 2006 10:35:19 GMT

Hi,

The ADDRESS-ENDADDRESS command formats addresses according to the postal norms of the recipient's country, as defined in the country parameter.

/: ADDRESS DELIVERY PARAGRAPH AD

/: NAME &KNA1-NAME&

/: STREET &KNA1-STRAS&

/: POSTCODE &KNA1-PSTLZ&

/: CITY &KNA1-ORT01&

/: COUNTRY &KNA1-LAND1&

/: FROMCOUNTRY 'DE'

/: ENDADDRESS

Hope this helps.

Regards,

Sudheer

Re: SAPScript: How to sort address...

Former Member — Fri, 27 Jan 2006 11:53:30 GMT

What are you printing? How do you want to sort?

If you are using a standard program in SAP, some of them allow you to sort. Some have selection field parameters, some have configuration. Options could be by customer numbers, customer name, or zip code, or country/state/city.

If you are using a custom Z print program, you can sort the data in the program. As suggested, either in an internal table, or with an ORDER BY in the SQL statement.