Out put problem in Ad hoc query reports

Advertisement
Hi Gurus,
I am tryting to generate a report through Ad hoc query in S_PH0_48000510 - Ad Hoc Query SAP/Query/HR_ADM - > Selected several options like personnel number / employee name / entry date / leaving date.
But when we select it shows the input details but when i try for output the entry date / leaving date even the names of the employees are not reflecting.
But the age/date of birth other fields are coming in output.
Kindly let me know the solution to get a out put. If there is any changes need to be done in the back end. Pls advice with the path details.
Thanks & Regards,
Pradeep Krishnamurthy
Advertisement

Replay

Hi Madhu,
Yes, I did but out put is not coming.
Regards,
Pradeep Krishnamurthy

XML PUBLISHER report in Excel out put problem

Hi Experts, I have developed one XML report which output type is EXCEL in Oracle Application. I am getting some -ve value in the report so I need to do the trailing sign Menace for example I got a value -8645 I need to display the value like (8645).

Problem with a Bex Query Report with Web Intelligence

Hello! I have a Bex query (with query Bex version 7.0) I'm connecting with Web Intelligence (4.0) but one of the attributes instead of displaying the description shows only the key, and it is strange because other cubes if given by the conversion. I

Time Out error problem when i run the report for the whole plant

Dear all, pls find the below coding, when i execute this report for the whole plant , it gives me time out error since it has to process huge database. pls suggest me in which part of my below coding i can improvise or any other better way to fetch t

Ad Hoc Query - reporting on both PA and OM data in same query.

Is it really not possible to report on both PA and OM in the same query?  Does the two different infosets prevent you from doing this?  As a workaround I can run two separate queries and just join the data using Excel.  However - I'm having some trou

Data load and out put problem

Hi Experts, Iam going through a peculiar problem.I have data flowing from R/3 to master data Info provider 0Requi. I have validated the data between R/3 and the master data info provider, it is found to be good. This data is being loaded from 0Requi

Problem in Ad Hoc Query displaying Personnel Number field

Hello, while creating a query through transaction S_ph0_48000510 I select for display the field "Personnel Number". However while running the query , in the results part , under the field "Personnel Number" , instead of the personnel n

I want to see out put of data  'plant wise' as  vertical left in ALV report

I want to see out put of data  'plant wise' as  vertical left in ALV report. Can anybody suggest me with coding. thanks nareshHiiii Sorry ...however could u be rather specific ..what u want ... unable to under stand ur requirement ... earlier also u

OC4J Report Server is not saving the PDF out put

Hi everybody, I have a master report running under OC4J.Under this master report 1000's of other reports are runninng by using the srw.run_report.Report name and other required parameters are taking from the database.My aim is to send all generated P

Ad-hoc query - excel problem

Hi, I am trying to run an ad-hoc query to generate previous employer's report.When I click on Hit - list, it shows me 2,195 persons listed.However, when I click on output, it generates only 234 employees in the excel sheet. Could anyone please help m

AAP and EEO Report by Ad Hoc Query

SAP Gurus, My client went live with basic modules of SAP Jan 2007. The problem is with AAP EEO Report. We will develop ABAP report later. For now we want to generate the AAP EEO report by using Ad Hoc Query. We are storing the EEO and AAP codes in IT

Can we use ad hoc query to get a temporary report of payroll result?

Hi,All can we use ad hoc query to get a temporary report of payroll result?or we have to get a report of payroll result by customizing and ABAP? and how can I customizing a report on the basis of standard SAP report for payroll?Hi As of my Knowledge

How to Save Background job report out put in local / Network Drive?

Hello Techies, How to Save Background job report out put in local / Network Drive. Actually we have option to send mail aftr complete but  i need to save in local drive or network drive .Hi , Background job runs in application server , and your local

Getting report out put in another language (other than english).

Hi all, can any one help me out in getting report out put in proper language (english). actually i am running my layout through wizard.it show in english at report level but when i publish with oracle application it showing the out in another fassion

In ALV Reports, i want to edit records manually in out put display

hello all, in ALV Reports, i want to edit records manually in out put display. how can i do that?*& Report  ZTEST1 REPORT  ztest1. TYPE-POOLS: slis. DATA:i_sbook TYPE STANDARD TABLE OF sbook INITIAL SIZE 0,      i_sbook1 TYPE STANDARD TABLE OF sbook

How to display the out put of the sql query in a text file using forms

I want to display the out put of the sql query in a text file using forms 6.0.Same could be done using spool command in sqlplus but i want it using forms....FiazHave a look at the text_io package: http://www.oracle.com/webapps/online-help/forms/10g/s

Incorrect leaving date in ad hoc query

Hi all Well I am running an ad hoc query for the numbers of leavers from the company and the reasons for it. This is working absolutely fine but its not showing the correct date of leaving for the employees. even if i have changed the period from 01.

Object selection on Ad-Hoc Query

One of our users has created an infoset based on LDB PCE and selecting PA and PD objects. If this is ran through Ad-hoc query there is the option to restrict selections using "persons along the org structure" which gives the tree repreesentation

HR PQAH (Ad hoc query) info-type filtering

Hi, in our company the users can use/create HR ad hoc queries (tcode PQAH) with which they can display almost all master data employees informations. Is it possible to use P_ORGIN authorizations in roles in order to filter info-types in ad hoc query

Ad Hoc Query Data Issue for Position Based Infoset

Experts, I've created an infoset that is based on the S object using the PCH database.  For this infoset, I've included several infotypes with focus on 1000, 1001, and 1028.  I've included the Address infotype (1028) as this is where we store our wor