topic Re: diffucult report in Application Development and Automation Discussions

diffucult report

Former Member — Tue, 15 Apr 2008 13:39:07 GMT

Dear Experts!

A report must be written with the below stated fields.

The goal is output via ALV-Grid a list. It's a tough challenge

for me to implement this requirement.

To create the alv list for outputting is not the problem

but to create the "select statement" is quite diffucult in this case.

First of all I don't really know which SAP table are the

appropriate table to get these information.

Can you pls help me ?

Regards

sas

SELECT-OPTIONS:  s_kat     FOR    ccihs_ialhiot-ialid,
                 s_katart  FOR    ccihs_ialhiot-iatype,
                 s_stat    FOR    ccihs_ialhiot-iashstatnam,
                 s_date    FOR    ccihs_ialhiot-evdat.
PARAMETERS       p_week    TYPE   bkk_kdate_week.
SELECT-OPTIONS:  s_rep     FOR    ccihs_ialhiot-iarephdflg,
                 s_dead    FOR    ccihs_ialhiot-ialdeadflg,
                 s_utyp    FOR    CCIHS_IPEVAIOT-IALPCAT,
                 s_per     FOR    T500P_ABA-PERSA,
                 s_ptb     FOR    T001P_ABA-BTRTL.
PARAMETERS       p_orgeh   TYPE   orgeh .
SELECT-OPTIONS:  s_verlet  FOR    CCIHS_IPEVINJIOT-INJURY,
                 s_kteil   FOR    CCIHS_IPEVINJIOT-BODYPART,
                 s_babwes  FOR    CCIHS_IPEVAIOT-IPABSBEGDAT,
                 s_eabwes  FOR    CCIHS_IPEVAIOT-IPABSENDDAT,
                 s_atabw   FOR    CCIHS_IPEVAIOT-IPABSDAYS,
                 s_apalt   FOR    CCIHS_IPEVAIOT-IALPEXP,

                 s_palter  FOR    CCIHS_IPEVAIOT-IPAGE,
                 s_ursach  FOR    CCIHS_IPEVAIOT-IACAUS,
                 s_ausl    FOR    CCIHS_IPEVAIOT-IAOBJ,
                 s_tdverl  FOR    CCIHS_IPEVAIOT-IPACT,
                 s_bewver  FOR    CCIHS_IPEVAIOT-IPMOV.

Re: diffucult report

Former Member — Tue, 15 Apr 2008 13:43:04 GMT

Hi,

truly seems to be challenging, atleast by its sheer number of parameters and select-options.

don't u have any functional specification which explains the business logic of which table contains which sort of data.

your functional consultant would be able to help you in this regard. sit with him and discuss about his requirement. he should be able to feed you with the information necessary.

<REMOVED BY MODERATOR>

Kiran

Edited by: Alvaro Tejada Galindo on Apr 16, 2008 1:41 PM

Re: diffucult report

Former Member — Tue, 15 Apr 2008 13:59:55 GMT

hi do like this...

select ialid,

iatype,

iashstatnam,

evdat

iarephdflg

from ccihs_ialhiot

into corresponding fields of table itab

where ialid in s_kat

and iatype in s_katart

and iashstatnam in s_stat

and evdat in s_date

and iarephdflg in s_rep

and ialdeadflg1 in s_dead .

select

IALPCAT

INJURY

BODYPART

IPABSBEGDAT

IPABSENDDAT

IPABSDAYS

IALPEXP

IPAGE

IACAUS

IAOBJ

IPACT

IPMOV

from CCIHS_IPEVINJIOT

into corresponding fields of table itab1

where INJURY in s_verlet

and BODYPART in s_kteil

and IPABSBEGDAT in s_babwes

and IPABSENDDAT in s_eabwes

and IPABSDAYS in s_atabw

and IALPEXP in s_apalt

and IPAGE in s_palter

and IACAUS in s_ursach

and IAOBJ in s_ausl

and IPACT in s_tdverl

and IPMOV in s_bewver

select single persa from t500p_aba into v_persa where persa in s_per .

select single btrtl from t001p-btrtl into v_btrtl where btrtl in s_ptb .

get the data and use the coding for ur req

regards,

venkat.

Re: diffucult report

Former Member — Wed, 16 Apr 2008 15:07:28 GMT

Hi,

I thank you for your replies.

I need the table names from where I can obtain this iinformation regarding these select options and

paramters fields (see above) .

Some of the information are e.g. available in the table "CCIHT_IAL".

What is about the other fields. In which tables are they ?

Regards

sas