topic Re: Regarding Logical Database in Application Development and Automation Discussions

Regarding Logical Database

Former Member — Sat, 07 Feb 2009 14:16:15 GMT

Hi i have copied one standard report(Application program) and i have modified it acoording to my

requirement. now i got a problem with Logical DataBase.

comming to my requirement , i want to modify the parameter as select-option which is in

logical database.How i retrieve the data using that select-option ..?.

Edited by: sateesh c on Feb 7, 2009 3:17 PM

Re: Regarding Logical Database

Former Member — Sat, 07 Feb 2009 14:34:45 GMT

Hi Sateesh,

for changing the parameter into select-options

refer to this link

and coming to the logical data base, what ever the syntax you are using for the normal ABAP that can be used for the selct-options in the logical database.

hope these points are useful to you.

Regards!

Re: Regarding Logical Database

Former Member — Sat, 07 Feb 2009 21:19:48 GMT

hi,

LDB provides a standard selection screen...

if you want to change a parameter to select option ...........you have to first hide that parameter..either by loop at screen command at selection screen output....or u have to make a custom report category for that.....see following link to make report category:

now you have to explicetly make a new select option in program....however...ldb wont filter data on its basis and in your program you have to write logic to filter data on its basis.....

also wherever the paramer is used you have to change it with select option..specially if there are any select statement

Re: Regarding Logical Database

Former Member — Sun, 08 Feb 2009 14:48:34 GMT

Hi Thanks for u r reply ..

i have modified the parameter as select-option.But

in this program Every function modules has taken only HIgher value(SELECT_OPTION-HIGH) .

so can i pass the lower and higher values of the select-options to the function modules.

The select-option is one Date field(ERDAT).

I have entered two dates in select-option field.

i need to find how many months are there in between those two dates.

Edited by: sateesh c on Feb 8, 2009 3:58 PM

Re: Regarding Logical Database

Former Member — Sun, 08 Feb 2009 15:44:58 GMT

yes you can do that.....

se the below FM to be used ...but which FM currently ur program is using....

Also why you have opened this new thread????

please close one of the thread.....as you have asked same question in previous thread:(

CALL FUNCTION 'HR_HK_DIFF_BT_2_DATES'

EXPORTING

DATE1 = P_EDATE----high

DATE2 = P_SDATE-----low

OUTPUT_FORMAT = '05'

IMPORTING

YEARS = V_YEARS

MONTHS = V_MONTHS

DAYS = V_DAYS

EXCEPTIONS

INVALID_DATES_SPECIFIED = 1

OTHERS = 2.

Re: Regarding Logical Database

Former Member — Wed, 11 Feb 2009 12:50:48 GMT

Hi.

can anybody please tell me

How can i calculate the depreciation cast for assets .

Below function module is allows only one date parameter(l_datbis)

according to my requirement , instead of parameter i have used select-options in date field.

so i want to pass from date and to date.

is possible to any function module for my requirement.

CALL FUNCTION 'DEPR_RECALCULATE'

EXPORTING

I_ANTS = ANTS

I_PERBIS = L_PERBIS

I_DATBIS = L_DATBIS

I_FEHLER = CON_X

I_FUNCTION = 'N'

I_CAL_CLOSED_FYEARS = CON_X

TABLES

T_ANLB = XANLB

T_ANLC = XANLC

T_ANLZ = XANLZ

T_ANEA = XANEA

T_ANEP = XANEP

T_ANFM = YANFM.

Regards,

sateesh

Re: Regarding Logical Database

Former Member — Wed, 11 Feb 2009 12:52:53 GMT

Hi .

How can i calculate the depreciation cast for assets .

Below function module is allows only one date parameter(l_datbis)

according to my requirement , instead of parameter i have used select-options in date field.

so i want to pass from date and to date.

is possible to any function module for my requirement.

CALL FUNCTION 'DEPR_RECALCULATE'

EXPORTING

I_ANTS = ANTS

o I_PERBIS = L_PERBIS

I_DATBIS = L_DATBIS

I_FEHLER = CON_X

I_FUNCTION = 'N'

I_CAL_CLOSED_FYEARS = CON_X

TABLES

T_ANLB = XANLB

T_ANLC = XANLC

T_ANLZ = XANLZ

T_ANEA = XANEA

T_ANEP = XANEP

T_ANFM = YANFM.

Regards,

sateesh