cancel
Showing results for 
Search instead for 
Did you mean: 

Adhoc Query

Former Member
0 Kudos

Hi ,

Iam working on pulling report from IT0014 and IT0015 in production. Though i can pull the report using SE16 there are couple of fields for which i have to use adhoc query. Can any one tell me how to create infoset query and cofigure various info types to pull the data.

Thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Trythis out

u can use sqvi query for reading infotype 0014 and 0015

steps involved

1.SQVI

2.Logical data base Input PNPCE

3.Select the infotypes 0001,0002 and 00014 in first set

4.Select the appropirate fields u wish to get output and selection

5.Execute

same can be repeated for 00015

all the best

u can see the details in any interval for particular PA,PSA,ESG,Orgunit

using this query and also time period

with regards

partha

Former Member
0 Kudos

Hi Partha,

I tried this but then i need information for a particular severance wage type. Is there a way to do this.

Former Member
0 Kudos

Also where can we define the country grouping in the sense it pulled the entire data . But then if i want to use it for one particular country and LGART also for one WT where do we defince that.

sikindar_a
Active Contributor
0 Kudos

Firstly let us know do u want to Pull the data from LDB or RT tables

if u want to Pull from LDB Adhoc Query will suffice you Reqirment

Check the SDN Wiki for more

https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=30083

If u want to Pull from clusters that is RT that you have take help from the Technical Person