Adım adım SAP Query oluşturma (Hızlı ALV raporu)
Adım SAP Query adımı kullanılması.
amaç
Adım SAP Query adımı kullanarak hızlı bir şekilde basit bir rapor yapmak.
1. Create Infoset
Go to transaction code: SQ02 >> Choose Tab Environment >> Choose Query Areas >> Choose Standard Client ( Client Specific ) – If you want test on current client and then transport to others client.
Fill infoset field name: ZPP_R001 >> Click Create
Fill Title of Infoset, authorization group (if it’s necessary)
- Choose Direct read of table (if data of report need only from single table)
- or choose Table join using basis table (if data of report need join from multiple tables)
>> Enter
Choose Include all table fields (Recommend)
2. Editor Infoset
Select necessary field for report by double – click on field. >> Editor information of field. Example: Long text, Header text, … etc … Remove unnecessary field by hold on Ctrl and Left-Click then Right-Click to choose Delete Field (s) from Field Group
Or Additional ABAP code into infoset by Click on Extras >> Choose Tab Code
In this screen is position of ABAP code in program generate. (Ignore if you don’t want insert ABAP code)
Example: insert abap code authorizatiion check below START-OF-SELECTION
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 |
*&---------------------------------------------------------------------* *& Include ZCAN_AUTHORIZATION_CHECK *&---------------------------------------------------------------------* DATA: gv_subrc LIKE sy-subrc, gv_msg(100) TYPE c. CONSTANTS c_msgty VALUE 'E'. "Message type *----------------------------------------------------------------------- * &1 Object name to be checked - SINGLE VALUE - Plant, sales org., etc. * &2 Object value to be checked - SINGLE VALUE * &3 Activity (ACTVT) - SINGLE VALUE - See CONSTANTS Declaration *----------------------------------------------------------------------- DEFINE macro_atz_error_message. gv_subrc = sy-subrc. if gv_subrc ne 0. case &3. when '03'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'DISPLAY data for' &1 &2. when '02'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'MAINTAIN data for' &1 &2. when '01'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'CREATE data for' &1 &2. when '04'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'PRINT data for' &1 &2. when '05'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'REPRINT data for' &1 &2. when '16'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'EXECUTE data for' &1 &2. endcase. endif. END-OF-DEFINITION. DEFINE macro_atz_error_message_flag. gv_subrc = sy-subrc. if gv_subrc ne 0. case &3. when '03'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'DISPLAY data for' &1 &2. when '02'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'MAINTAIN data for' &1 &2. when '01'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'CREATE data for' &1 &2. when '04'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'PRINT data for' &1 &2. when '05'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'REPRINT data for' &1 &2. when '16'. message id 'ZAB' type c_msgty number 000 with 'You are not authorized to' 'EXECUTE data' &1 &2. endcase. endif. END-OF-DEFINITION. *----------------------------------------------------------------------- * &1 Plant (WERKS) - SINGLE VALUE * &2 Activity -> SINGLE VALUE * &3 Document Number -> SINGLE VALUE *----------------------------------------------------------------------- DEFINE macro_atz_single_werks. if &3 is not initial. clear gv_msg. concatenate &3 '-' &1 into gv_msg separated by space. condense gv_msg. endif. authority-check object 'Z_WERKS' id 'WERKS' field &1 id 'ACTVT' field &2. if &3 is initial. macro_atz_error_message 'Plant' &1 &2. else. macro_atz_error_message 'Document - Plant' gv_msg &2. endif. END-OF-DEFINITION. *----------------------------------------------------------------------- * &1 Sales Organization (VKORG) - SINGLE VALUE * &2 Activity -> SINGLE VALUE * &3 Document Number -> SINGLE VALUE *----------------------------------------------------------------------- DEFINE macro_atz_single_vkorg. if &3 is not initial. clear gv_msg. concatenate &3 '-' &1 into gv_msg separated by space. condense gv_msg. endif. authority-check object 'Z_VKORG' id 'VKORG' field &1 id 'ACTVT' field &2. if &3 is initial. macro_atz_error_message 'Sales Org' &1 &2. else. macro_atz_error_message 'Document - Sales Org' gv_msg &2. endif. END-OF-DEFINITION. DEFINE macro_atz_single_vkbur. if &3 is not initial. clear gv_msg. concatenate &3 '-' &1 into gv_msg separated by space. condense gv_msg. endif. authority-check object 'Z_VKBUR' id 'VKBUR' field &1 id 'ACTVT' field &2. if &3 is initial. macro_atz_error_message 'Sales Office' &1 &2. else. macro_atz_error_message 'Document - Sales Office' gv_msg &2. endif. END-OF-DEFINITION. *----------------------------------------------------------------------- * &1 Company Code (BUKRS) - SINGLE VALUE * &2 Activity -> SINGLE VALUE * &3 Document Number -> SINGLE VALUE *----------------------------------------------------------------------- DEFINE macro_atz_single_bukrs. if &3 is not initial. clear gv_msg. concatenate &3 '-' &1 into gv_msg separated by space. condense gv_msg. endif. authority-check object 'Z_BUKRS' id 'BUKRS' field &1 id 'ACTVT' field &2. if &3 is initial. macro_atz_error_message 'Company Code' &1 &2. else. macro_atz_error_message 'Document - Company Code' gv_msg &2. endif. END-OF-DEFINITION. *----------------------------------------------------------------------- * &1 Company Code (BUKRS) - SINGLE VALUE * &2 Activity -> SINGLE VALUE * &3 Document Number -> SINGLE VALUE *----------------------------------------------------------------------- DEFINE macro_atz_single_flag. if &3 is not initial. clear gv_msg. concatenate &3 '-' &1 into gv_msg separated by space. condense gv_msg. endif. authority-check object 'Z_FLAG' id 'Z_FLAG' field &1 id 'ACTVT' field &2. if &3 is not initial. macro_atz_error_message_flag '' &1 &2. else. macro_atz_error_message_flag '' gv_msg &2. endif. END-OF-DEFINITION. |
Click on Check Code and Save Code (Ensure system message ‘No syntax errors found’) >> Click on button Save and click Generate infoset.
3. Role/User Group Assignment
Assign this infoset with user group exists or maintain new user group.
In screen, click on Role/User Group Assigment. Example, assign for ZPP – PP user group ( Can assign for multiple user group ) >> Click Save
Go to transaction code: SQ02 >> Choose Tab Environment >> Choose Query Areas >> Choose Standard Client ( Client Specific ) >> Choose again Tab Environment >> Choose User Groups
Click Create >> Fill description of User Group and Click Save.
4. Create SAP Query for recently Infoset.
Go to transaction code: SQ01 >> Click Others User Group
Choose user Group ZPP
Fill name of query >> Click Create
Fill Title Notes of Query, List format, Standard Variant, Output format …etc…
5. Design Layout for Report
Check to Choose Parameter Field ( Field will appearing on the selection-screen )
Check to Choose Fields displayed in list ( Fields will appearing on the result report )
List Field Color by Click on field in Layout then Choose color of list field. >> Apply
>> Save >> Back to Screen Create Query >> Click Test to test Report.
6. SAP Query Transaction Code Assignment
There are two methods to assign SAP query with Transaction Code.
Method 1 (Recommend)
Go to transaction code: SE93
Fill name of Transaction Code. Example: ZPP_R001 >> Click Create >> Choose Program and selection screen (report transaction) >> Enter
Fill Transaction Text, Program: START_REPORT, Selection Screen: 1000, Check GUI support for HTML, Java, Windows.
Save on request and package and insert default values
| D_SREPOVARI-REPORTTYPE | AQ |
| D_SREPOVARI-REPORT | ZPP |
| D_SREPOVARI-EXTDREPORT | ZPP_R001 |
Method 2
In screen Query, Choose tab Query >> More functions >> Display Report Name
Go to transaction code: SE93
Fill transaction text, Paste program generated from query. Selection screen: 1000, …
Save on request and package to finish
Note: If this transaction code transport to difference client. Program will regenerated automatically and it’s not like old program >> Error when exucute transaction code.
