How to Add infotype 0491 to PNPCE LDB

[Former Member]

Hello Guys,

is there any way we can add infotype 0491 to an adhoc query, I created an infoset with PNPCE but it is not showing infotype 0491.

Idea is to use IT 491 as part of adhoc query to select some non standard SAP data are required by an outsourced payroll system.

S.

[jagan_gunja]

Usually standard infotypes would be in an infoset provided by SAP.  Or it is in the list of infotypes in tge infoset but not selected.

To make changes in an infoset

1. In txn SQ02, it lists infosets available.  Select the infoset to be changed; click 'change' icon or press F6.

2. If it gives in a message 'Due to changes in data dictionary some fields in the infoset are different to fields in data dictionary. Use the 'Adjust' function.  Do want to maintain infoset adjusting it first?'   with options Yes or No.  it is standard practice to adjust first (you can navigate on the SQ02 initial screen -> Infoset->More functions->Adjust).

3. Else or if you opt 'Yes' in step 2, it lists infotypes included.

4. To include an infotype

4.1  Go to Edit->Change infotype selection.

4.2  It lists nodes for each infotype group; expand the node to see the group's infotypes.  IT 461 should be in one of PA groups for your molga's tax or in Further infotypes.

It is easier to find the relevant infotype by pressing the Find icon and entering say 461.

4.3  If your infotype is not selected (the check box should be clicked), select it and press enter.

4.4  The infotype is shown in the list for the infoset.  Expand each node under the infotype.

4.5  Check if the required fields for any of your queries are assigned a field group.

4.6  If not, assign a field group, as below

4.6.1 select the relevant one from the field groups listed on the right side,

4.6.2 select the field, (or for multiple fields, hold Ctrl key on key board and select the fields).

4.6.3 right mouse click, select option 'Add field to field group' 

or at the top 2nd line of icons, click the icon or button for 'Insert field((s) in the group' (which looks like a branch on a tree).  Now you can see the selected fields in the field group (when the node is expanded).

4.6.4 If any field does not have a 'Long text' or text for 'Header' (which is used for queries field selection or list from running a query),  enter both.

4.6.5 By clicking 'Extras' icon, you can add code for each field or include an enhancement.

4.6.6 You may add additional fields which have names like SYHR_Axxxx by selecting Extras.

5. Save the changes (click save or press Ctrl+S) in a transport request.

6. Generate infoset ((navigate by Infoset->Generate or press Shift+F6).

7. It lists any errors in generation; correct the same and repeat steps 5, 6.

Now you can go to SQ02 (query), select the infoset which shows the new infotype and fields assigned with a group.

A. For a field already in an infoset's infotypes, it is possible that it may not have been assigned a field group (in which case it is not available for query).  If required in a query,

A.1, go through above steps  4.5 to 7.

Hope this helps.

br, JG