topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Mon, 16 Jul 2007 06:12:22 GMT

Good mng to all viewers and thanks and reward also.(URGENT)

Q1. In one internal table have some field and data.

Lifnr (vendor no)

Belnr (document no)

wrbtr (amount)

budat (posting date)

umskz (sp GL indicator)

osl30 (outstanding less then 30 days)

osg30(outstanding grater then 30 days)

I am feel some problem for write the code for this process.

1.if the posting date is less then 30 days from input date . then list the amount (wrbtr) in colume osl30. if it is more then 30 days then in colume osg30(sub total and total).

Q2. how concatenate the two words.

Ram singh

Ramsingh.

REGARD : DEEP

Re: Report

Former Member — Mon, 16 Jul 2007 06:15:34 GMT

Data: l_text1(10) type c,

l_text2(10) type c,

l_text(20) type c.

l_text1 = 'Hello'.

l_text2 = 'World'.

concatenate l_text1 l_text2 into l_text

Make the data in one internal tale.

if posting date - sy-datum LT 30.

giving in osl30 .

endif.

if posting date - sy-datum GT 30.

giving in osg30 .

endif.

Message was edited by:

Sumi Vasu

Re: Report

Former Member — Mon, 16 Jul 2007 06:16:12 GMT

hi..

Data: STRING(25) VALUE ' Ram singh'.

CONDENSE STRING NO-GAPS.

WRITE: STRING.

Reward points if useful

Regards

Ashu

Re: Report

Former Member — Mon, 16 Jul 2007 06:16:25 GMT

hi,


data : v_char(3) value 'Ram', 
          v_char2(5) value 'singh',
          v_out(9) .

 concatenate v_char v_char2 into v_out.  " Ramsingh
 concatenate v_char v_char2 into v_out separated by space.  " Ram singh

Re: Report

Former Member — Mon, 16 Jul 2007 06:19:49 GMT

1. Your entered data on sel screen is date1

and the posting date is itab-budat

diff = date1 - itab-budat.

if dif > 30 .

itab-osl30 = itab-wrbtr.

elseif dif < 30 .

itab-osg30 = itab-wrbtr.

endif.

2. declare variables like

str1(9) = 'Ram singh'.

str2(8) = 'Ramsingh'.

str3(17).

concatenate str1 str2 into str3.

Reward points for useful Answers

Regards

Anji

Re: Report

Former Member — Mon, 16 Jul 2007 06:25:22 GMT

first declare a custom table and nternal tble with required fields.

then u enter vendor number amount date etc ibto the table.

in program u compare budat with sy-datem. if it is less than 30 days assign amount to osl.. else to osg.. ..

at last u find sum using at last control break statements..

data : text1 type string value 'ram',

text2 type string value 'singh',

text3 type string .

concatenate text1 text2 into text3.

reward if useful

Re: Report

Former Member — Mon, 16 Jul 2007 06:37:29 GMT

1. P_date is input date

wa_tab is workarea for your internal table

If P_date - t_tab-budat > 30

wa_tab-osg30 = wa_tab-wrbtr

Modify t_tab from wa_tab transporting osg30.

else

wa_tab-osl30 = wa_tab-wrbtr

Modify t_tab from wa_tab transporting osl30.

endif.

2. data : v_txt1(2) value 'Hi',

v_txt2(5) value 'Buddy',

v_out(9) .

concatenate v_txt1 v_txt2 into v_out.