topic Re: selection-screen and data retrieval in Application Development and Automation Discussions

selection-screen and data retrieval

Former Member — Fri, 04 Jul 2008 17:16:08 GMT

I need to design the screen based on following points:

i. date1: fdsb-datum, single value, mandatory, parameter.

ii. date2: fdsb-datum, single value, mandatory, parameter.

iii. account1: fdsb-bnkko, ranges of values/single values, managed through selection variant, if blank then do not perform the extraction for the account range. Set balance = 0.

iv. account2: fdsb-bnkko, ranges of values/single values, managed through selection variant, if blank then do not perform the extraction for the account range. Set balance = 0.

v.Company code: fdsb-bukrs, single value.default value XYZ.

vi.ACCOUNTA \ ACCOUNTB: fdsb-ebene, radio button, boolean, mandatory:at least one value should be set.

================================================================

the data retrieval logic for account2(while currency is usd$):

company code: fdsb-bukrs = XYZ.

value date(Datum<=user entered date1).

fdsb-ebene='F0' is retrieved if the radio button ACCOUNTA is selected by the user.

fdsb-ebene<>'F0' is retrieved if the radio button ACCOUNTB is selected by the user.

GL account currency(SKB1-WAERS) =USD$.

the data retrieval logic for account2(while currency is non-usd$):

company code: fdsb-bukrs = XYZ.

value date(Datum<=user entered date1).

fdsb-ebene='F0' is retrieved if the radio button ACCOUNTA is selected by the user.

fdsb-ebene<>'F0' is retrieved if the radio button ACCOUNTB is selected by the user.

GL account currency(SKB1-WAERS) =Non-usd$.

================================================================

kindly help.

Re: selection-screen and data retrieval

Former Member — Fri, 04 Jul 2008 17:30:30 GMT

Hi,

data:

w_acc type fdsb-bnkko.

selection-screen : begin of block b1 with frame title text-001 .

parameters:

p_date1 type fdsb-datum obligatory,

p_date2 type fdsb-datum obligatory,

p_bukrs type fdsb-bukrs default 'XYZ'.

parameters: accounta as radiobutton group B1 default 'X',

accountb as radiobutton group B1,

select-options:

s_account1 for w_acc,

s_account2 for w_acc.

selection-screen: end of block b1.

at selection-screen on s_account1.

// if this doeswnt work we can modify the screen. First check this out if any proble reply me.

if s_account1-low and s_account1-high is initial.

s_account1-low = 0.

elseif if s_account2-low and s_account2-high is initial..

s_account2-low = 0.

endif.

You can aslo refer to Tcode ABAPDOCU where we can find examples.

Reward if helpful.

Regards

Chandralekha

Re: selection-screen and data retrieval

Former Member — Fri, 04 Jul 2008 19:01:35 GMT

Thanks chandralekha i've got idea on the selection-screen design.

Please help me on the data retrieval logic now.

Data retrieval logic: The report will retrieve data from the fdsb table by fdsb-bukrs, fdsb-datum, fdsb-bnkko, skb1-waers, fdsb-ebene.

Amount needs to be retrieved from: FDSB-WRSHB is selected if currency of selected record is equal to USD.FDSB-DMSHB is selected if currency of selected record <> USD.

Now we have to calculate cash for account2(both for us$ and non-us$ separately):

company code: fdsb-bukrs = XYZ.

value date(Datum<=user entered date1).

fdsb-ebene='F0' is retrieved if the radio button ACCOUNTA is selected by the user.

fdsb-ebene<>'F0' is retrieved if the radio button ACCOUNTB is selected by the user.

GL account currency(SKB1-WAERS) =USD$.

Kindly help on this data retrieval logic.

==================================================================