Skip to Content
0
Former Member
Aug 10, 2006 at 08:02 AM

DOUBT IN HR REPORTING

29 Views

HI GUYS,

there is a doubt in reporting of hr.

actually we have to print the data from 4 tables,

1. VIQMEL

2. VIQMMA

3. AFRU

4. PA0001

VIQMEL CONTAINS THE FIELD

QMNUM

ERDAT

BUKRS

AUFNR

VIQMMA CONTAINS THE FIELDS

QMNUM

MNGRP

MNCOD

AFRU CONTAINS THE FIELDS

PERNR

AUFNR

ISMNW

PA0001 CONTAINS THE FIELDS

PERNR

SNAME

FIRST AND SECOND TABLE IS CONNECTED WITH THE FIELD QMNUM.

FIRST AND THIRD TABLE IS CONNECTED WITH THE FIELD AUFNR.

THIRD AND FOURTH TABLE IS CONNECTED WITH FIELD PERNR.

like this 4 tables are connected.

THERE ARE 4 SELECT-OPTIONS IN SELECTION SCREEN I.E

PERNR(EMP PERSONAL NO)

ERDAT(DATE OF JOINING)

BUKRS(COMPANY CODE)

AUFNR(NO OF SERVICE ORDERS)

NOW I WANT THE REPORT AS

IF WE ENTER THE PERSONAL NO

THEN THE O/ P COLUMNS SHOULD BE LIKE THIS

1. SNAME(EMP NAME)(FROM 4TH TABLE),

2 PERNR(EMP PERSONAL NO)(FROM 3RD AND 4TH TABLE)

3 COUNT THE NO OF AUFNR FOR EACH PERNR.

4 SUM THE ISMNW FOR EACH PERNR.

IN THE MNGRP COLUMN OF VIQMMA TABLE THERE ARE 4 TYPES OF ENTRIES LIKE FMJS,FMJF,FMCS,FMST AND THEIR CORRESPONDING VALUES IN MNCOD COLUMN OF VIQMMA TABLE

5 NOW I WANT THE 4 COLUMNS WITH SUM OF FMJS,FMJF,FMCS,FMST FOR EACH PERNR IN THE REPORT.

FINALLY THE REPORT SHOULD BE LIKE THIS.

SNAME PERNR COUNT OF AUFNR SUM OF ISMNW SUMOF FMJS SUMOF FMJF SUMOF FMCS SUM OF FMST.

KINDLY DO THE NEEDFUL.

THANKS IN ADVANCE.