Labour register report

[Former Member]

hai experts,

i had an requirement to develop an alv report for labour register report the functional consultant gave me the following tables BSEG BKPF BSIK LFA1 EKBE PROJ PRPS EKKO EKPO so i want to know which table i had to fetch first and second, third and so on.

thanks & regards,

karthik.

[Former Member · Accepted solution]

hi,

this is to inform you that,

it depends on the fields, like out of the fields which field value should populate first in the report.

it depends on which criteria he wants to filter the data.

take that table first and follow on.

given answer as per my knowledge.

regards,

balajia

[Former Member · Accepted solution]

Hai, Balaji

thanks for your reply actually the selection screen of my program is as shown below

SELECT-OPTIONS : s_bukrs FOR bsis-bukrs OBLIGATORY, " Comapny code

s_hkont FOR bsis-hkont OBLIGATORY," G/l accont

s_gjahr FOR bsis-gjahr, " Fiscal Year

s_belnr FOR bsis-belnr, " Doc No

s_budat FOR bsis-budat, " Posting Date

s_lifnr FOR lfa1-lifnr. " Vendor

PARAMETERS : p_pspnr LIKE proj-pspnr. " Project

and now from which table i had to fetch the data first.

in some sites they mentioned that fetch the data from master table first, in the other they mentioned that fetch index table first

regards,

karthik

[Former Member]

Hi

Then try with BKPF and BSEG

regards

Prashanth

[Former Member]

Hi

What is the Selection criteria fields which you want so as to run the report.

Based on that you can fetch the data from that table first.

regards

Prashanth

[Former Member]

Hai, Prashanth

thanks for your reply actually the selection screen of my program is as shown below

SELECT-OPTIONS : s_bukrs FOR bsis-bukrs OBLIGATORY, " Comapny code

s_hkont FOR bsis-hkont OBLIGATORY," G/l accont

s_gjahr FOR bsis-gjahr, " Fiscal Year

s_belnr FOR bsis-belnr, " Doc No

s_budat FOR bsis-budat, " Posting Date

s_lifnr FOR lfa1-lifnr. " Vendor

PARAMETERS : p_pspnr LIKE proj-pspnr. " Project

and now from which table i had to fetch the data first.

in some sites they mentioned that fetch the data from master table first, in the other they mentioned that fetch index table first

regards,

karthik