topic Re: Data not getting selected in Background. in Application Development and Automation Discussions

Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 04:49:18 GMT

Hi Freinds

I have written a program which select the invoice data hourly basis and download it into a text file. Everything is file when I run the program in the foreground. (Interactvely). My issue is when I schedule this using SM36 to run in the background, it is not running properly. That means it is not picking up tha data and not giveing me spool report.

Whith here I am atttaching the program code for u'r reference. Pls help to solve this out. What do I have to do..? I am behind my schedile time pls help.

Regards

Thanura

REPORT ZTM_DOWNLOAD_INVDATA.

TYPES : BEGIN OF wa,

bukrs LIKE vbrk-bukrs, "Company Code

vbeln LIKE vbrk-vbeln, " Invoice No

posnr LIKE vbrp-posnr, " item no

fkdat LIKE vbrk-fkdat, " Date

kunag LIKE vbrk-kunag, " Sold to party Customer

matnr LIKE vbrp-matnr, " Material

fkimg LIKE vbrp-fkimg, " Billed qty

charg LIKE vbrp-charg, " expiry

knumv LIKE vbrk-knumv, "Number of the document condition

KWERT LIKE konv-KWERT, " invoice price

KWERT1 LIKE konv-KWERT, " invoice discount

END OF wa.

TABLES: vbrk.

DATA : it_sales TYPE STANDARD TABLE OF wa,

wa_sales TYPE wa.

RANGES : r_bwart FOR konv-kschl.

----

INITIALIZATION *

----

INITIALIZATION.

----

At selection screen *

----

PERFORM f001_getdata.

----

END-OF-SELECTION *

----

*&----

*& Form F001_GETDATA

*&----

FORM f001_getdata .

DATA: w_time(2) TYPE n,

w_timestr(6) TYPE c.

Data: p_bukrs LIKE vbrk-bukrs,

p_fkdat LIKE vbrk-fkdat.

w_time = sy-uzeit(2).

w_time = w_time - 1.

CONCATENATE '%' w_time '%' INTO w_timestr.

Discount condition list - 3100

r_bwart-sign = 'I'. r_bwart-option = 'EQ'. r_bwart-low = 'ZKMC'.

APPEND r_bwart TO r_bwart.

r_bwart-sign = 'I'. r_bwart-option = 'EQ'. r_bwart-low = 'ZKMG'.

APPEND r_bwart TO r_bwart.

r_bwart-sign = 'I'. r_bwart-option = 'EQ'. r_bwart-low = 'ZMGN'.

APPEND r_bwart TO r_bwart.

r_bwart-sign = 'I'. r_bwart-option = 'EQ'. r_bwart-low = 'ZCMG'.

APPEND r_bwart TO r_bwart.

r_bwart-sign = 'I'. r_bwart-option = 'EQ'. r_bwart-low = 'ZCDP'.

APPEND r_bwart TO r_bwart.

p_fkdat = sy-datum.

p_bukrs = '3100'.

SELECT a_{bukrs a}vbeln b_{posnr a}fkdat a_{kunag b}matnr b_{fkimg b}charg

a~knumv

FROM vbrk AS a

INNER JOIN vbrp AS b ON b_{vbeln = a}vbeln

INTO CORRESPONDING FIELDS OF TABLE it_sales

WHERE

a~bukrs = p_bukrs AND

fkdat = p_fkdat

AND a~erzet LIKE w_timestr.

DATA :w_KWERT LIKE konv-KWERT,

w_KWERT1 LIKE konv-KWERT.

LOOP AT it_sales INTO wa_sales.

Invoice price

SELECT SINGLE KWERT INTO w_KWERT

FROM konv

WHERE knumv = wa_sales-knumv

AND kschl = 'PR00'

AND kposn = wa_sales-posnr.

wa_sales-KWERT = w_KWERT.

MODIFY TABLE it_sales FROM wa_sales

TRANSPORTING KWERT.

invoice discount

SELECT SINGLE KWERT INTO w_KWERT1

FROM konv

WHERE knumv = wa_sales-knumv

AND kschl IN r_bwart

AND kposn = wa_sales-posnr.

wa_sales-KWERT1 = w_KWERT1.

MODIFY TABLE it_sales FROM wa_sales

TRANSPORTING KWERT1.

CLEAR wa_sales.

w_KWERT = 0.

w_KWERT1 = 0.

ENDLOOP.

DATA f_filename TYPE string.

DATA: rec(950) TYPE c,

v_line LIKE LINE OF it_sales,

w_fkimg TYPE string,

w1_kbetr TYPE string,

w2_kbetr TYPE string.

f_filename = '/usr/sap/DBI/INVD.txt'.

OPEN DATASET f_filename FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc = 0.

LOOP AT it_sales INTO wa_sales.

Clear rec.

rec(950) = v_line(56).

w_fkimg = wa_sales-fkimg.

w1_kbetr = wa_sales-KWERT.

w2_kbetr = wa_sales-KWERT1.

Concatenate wa_sales-bukrs ',' wa_sales-VBELN ',' wa_sales-kunag ','

wa_sales-fkdat ',' wa_sales-matnr ',' w_fkimg ',' w1_KBETR ','

wa_sales-charg ',' w2_kbetr

into rec.

Write rec.

TRANSFER rec TO f_filename.

ENDLOOP.

ENDIF.

CLOSE DATASET f_filename.

ENDFORM. " F001_GETDATA

Re: Data not getting selected in Background.

jayanthi_jayaraman — Mon, 08 Oct 2007 04:55:31 GMT

Hi,

Just use JDBG in the command bar in Sm37 Background after selecting the job and find out in debugging mode, where the problem is happening.

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 04:58:40 GMT

After write rec

try this.

For Spool request to be Generated

NEW-PAGE.

COMMIT WORK.

NEW-PAGE PRINT OFF.

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:00:40 GMT

Hi,

i have used this and debug the program. When it is debuging it is running perfectly and giving me the spool. My issue is when it is running in the normal senario.

Regards

Thanura

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:04:30 GMT

Hi,

Is this going to create a new page after every record, then it's not going to work. Because of the performance, I have to run this program every hour and it will directly effect to our server performance.

Regards

Thanura

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:05:10 GMT

So when you are executing in bg spool is not getting generated and file is not getting created right

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:12:18 GMT

HI,

Yep, That's my problem.

The way written the program is to overwrite the text file each and every time the programs runs. But when it is runnign it in bg it is not happenning.

Regards

thanura

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:15:40 GMT

Assuming you have posted your full code, your problem may be because of 'initialization' event.

Just comment the line INITIALIZATION and try again.

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:22:02 GMT

hi,

No it wont create a new page after every record.Each time when you execute the program,these commands can be used for creating spool.once the page is full,a new page will be opened.spool gets generated for every execution

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:23:28 GMT

HI,

Yes, I have attached the full code. Nothing to hide.

Can't get the medicing from the doctor hinding the problems. Give me 10 min , I will let u whether it is working or not.

Regards

Thanura

Re: Data not getting selected in Background.

Former Member — Mon, 08 Oct 2007 05:36:12 GMT

Hi,

No it is not working. It is not creating or overwriting the text file when it is running in bg. Pls help

Regards

Thanura

Re: Data not getting selected in Background.

Former Member — Fri, 29 Feb 2008 04:50:33 GMT