Skip to Content
avatar image
Former Member

What is S_ALR_87012087 & how to do changes in it

Hi,

What is S_ALR_87012087 & how to do changes in it ??

i want to do below changes in it.

Please revise the Vendor Address Report S_ALR_87012087 as follows:

- Add State

- City field - adjust to pick up the City. Currently the field indicates a state or country, but not the city.

- What is the 'Location' pulling from? Currently the field indicates the city, state or country.

Thank you.

Edited by: Ankesh Jindal on Apr 14, 2010 11:17 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 14, 2010 at 09:27 AM

    Hi Ankesh,

    S_ALR_87012087 is a wrapper transaction for SAP Query F1 defined in the Global Area (Cross-client) User group /SAPQUERY/FK.

    The SAP Query can be access via transaction SQ00.

    You need to have knowledge about SAP Query development concepts to make the required additions. Please go through the documentation for details on SAP Query.

    http://help.sap.com/saphelp_47x200/helpdata/en/b7/26ddebb1f311d295f40000e82de14a/frameset.htm

    Also go through the below link for SAP recommendation for modifying SAP standard ABAP queries.

    http://help.sap.com/saphelp_40b/helpdata/ru/12/ef2c7dd435d1118b3f0060b03ca329/content.htm

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2010 at 01:17 PM

    I am having question on SAP Query :-

    1) Is SAP Query is just like another transport object , we create it in development and via transport we moved to quality n production or we directly make Query in production

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ankesh,

      Please refer to my first post to find answer to your question. Also find below a simplified guide for basic ABAP query development concepts. You will find some more useful documentation in SDN / Google.

      http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40bec8da-4cd8-2910-27a9-81f5ce10676c?language=en

      It will not be possible for anyone to take you through all basics on this topic via this forum. Please spend some time to try the various options available on the transaction screen of SQ00.

      Some tips:

      1. Do not change the Standard Queries directly. Copy them to create a custom query and apply the required modifications.

      2. Query Areas - You can change the query area by using the path: Environment -> Query Areas. Choose between

      Standard Area(Client-dependent) or Global Area (Cross-client). For your case, Choose Global Area for

      your current requirement.

      3. User Group - You can change the user group using the path : Edit -> Other User group. Choose the required user group

      from the list displayed. Choose /SAPQUERY/FK for your current requirement.

      Thanks and Regards,

      Harish