Awards IT (0183)
Can I add new infotype in Adhoc Query. If yes, then how.
I want a report for the IT 0183(Awards).
Sikindar T replied
first go to Sq02
On the left hand side there is a field by the name of infoset.
Give any appropriate name. Then click on create button.
then a screen will appear , write the name. In data source field click on Logical Database . Here you have to select PNPCE, PAP, PNP according to your requirement.
If you want to create Query on anything related to applicant select PAP. If ur query is based on Master data select PNPCE.
After selecting click on tick mark (green in colour) which is given below. A screen with different folders of infotypes will appear. Select the required infotypes which you want accoridng to your requirement. Then click on tick mark again.
Then click on generate button (red & white in colour) (3rd button from the left). A screen will appear with the name
create object directory entry. Here you have to click on local object button.. you will now see that the system haas generated a Message saying "Infoset------- generated.
In sq02 there is a button with the name Role/User Group Assignment . Assign the user group out here.
Then go to SQ01, click on infoset query. Select ur user group. You can see the name of the query which you have created.