Hi,
1. First create a User Group T-Code SQ03 - Enter the relevent name in User Group field and click on Create button, Enter the Description of the User Group in Pop-Up window and save. During saving the system ask for object, save as local object, if you dont want to create a transport request.
2. Now use T-Code SQ02 to create infoset, Enter the relevent infoset name in InfoSet field and press Create button. One Pop-Up window appear, just enter the name description of the infoset in Name field, check the "Table join using basis table" and enter the table name you want to join. Example VBAK. Now another screen appear with VBAK table. If you want to join another table, click on inseart table button, enter the another table in Table field, Example VBEP. Now save and go back, you can see the both table name in left side, expand it. Now whatever field you want in your querry, just drag it and put it in the right side directory written as 01 sales document header data or 02 sales document Schedule Line data. Last you assign the Use Group to this infoset, click on Role/User Group Assignment button search for your user group you created in first step and mark it flag (tick). save and go back.
3. Again go to T-Code SQ03 and created User Group and click on Assign users and InfoSets.another screen will appear, here if you want to restrict the user, then just enter the SAP login name. If you keep it blank then querries is open for all SAP users. Save it.
4. Now enter the T-Code SQ01, select the Query or InfoSet from list you created and click on Infoset Query, another window appear, here you can see the tables and fields you selected earler. Mark the Selection field as user have to enter in selection screen and Mark the Output field user would like to see the Output on screen. Now you save and execute the Querry, enter the relevent data in selection screen and again click on execute button.
For document send me your ID. If you need any supprot, feel free to contact me.
Thanks,
AKT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.