Cost Center Report (S_ALR_87013633) Auto Email

[Former Member]

Hello All,

We are trying to send this report automatically to our sales guys. I tried to do a BDC recording but this report does not support background processing.

Is there any way to send this report automatically to the sales guys every month schedulling a background job?

We have about 40 sales guys so this report will have to fill in each cost centers and send it to the corresponding sales guy. We don't want to send the same one to everyone.

I created a Ztable with the names, cost center numbers and email of the sales guys and Loop on it through bdc. It works in foreground but doesn't work in background. I understand that these kinds of reports cannot be simulated in the background.

Has anyone done this in their organization?

[ramakrishna_ailanani]

Hello,

Try to schedule the back ground job every month.

Program name is :GP4XN049MR92SDV91OAUH3EMB5R040

Create Variant as per business requirement.

Update the basis team to send the spool request to sales guy mail ID's. So once the job is finished, Spool automatically sent to there mail ID.

Thanks and Regards

A.Rama Krishna

[Former Member]

Thanks Rama,

Variant cannot be created for this program because we need dynamic variant. The period changes every month. When the program runs, it should run for the previous month and this report doesn't support dynamic variant for the "Period" field.

[Former Member]

Hi Basil,

Go to transaction code SM30 and enter for Table/View: TVARV.  Maintain the following under Parameter and Selection Options:

Name                  Val.

Z_PERIOD          06  (Previous Month)

One caveat though.  You would have to remember to change the value every month in this table.

Now go S_ALR_87013633 to create your variant.  Then look for period and use the drop-down menu to select the Selection Variable 'T' ( Table Variable from TVARVC).  Next under Name of Variable (Input Only Using F4), enter the name of the variable you created in table TVARV( Z_PERIOD).

Regards,

Elias

[Former Member]

Thats my point. We don't want to have to change the period manually every month. It should be automatic. No one is going to remember to be changing this every month.

Has anyone automate this report before?

[Former Member]

Hi Basil,

We have done the similar kind of set up. After creating Z variables in TVARV, we have developed a ABAP program which automatically updates this variables. We schedule this variable update job just before the actual report. Hope this helps

Regards,

RK

[Former Member]

Try program: RKAEP000.  The report S_ALR_87013633 is a RW, so I don't think you will be able to schedule based on its program.

RKAEP000 will give you only the actual costs even though it is the same program for transaction codes KSB1 and KSBP.  Use the transaction code KSB1 to set up the variant.  Don't try executing the program directly.  When you call up the program in SM36, should be able to bring the variant set up using KSB1.

Again you won't get exactly the same report you want using the transaction code you did specify.

A word of advise:  Next time try to read through the replies posted to a question for that matter yours before replying.  Try to follow the sequence of this particular question and answers; and you would realize why I gave you that option especially the point you raised before my answer.

Elias

[Former Member]

Hi  i think your requirement is possible to SAP ABAP work flow.So you will check the technical work flow guys.

foe ex: see this link  http://wiki.sdn.sap.com/wiki/display/ABAP/Send+an+External+mail++through+SAP+Business+Workflow+and+R...