Settlement of wbs automatically i.e. posting of Expenses to AUC settlement entry automatically

[former_member327433]

Dear All,

In case of capex booking, end user post transaction MIGO/FB60 for Expenditure booking against WBS element. Here expenditure is booked in respective cost element with WBS element assigned in PO. At the month end, end user has to do settlement of that wbs element using T-code CJ88 i.e. expenditure transferred to AUC.

This is monthly activity as per our business process. But many times, end user forget to do this CJ88 activity at month end and it will affect MIS report of that month.

We have already tried option of background process in t-code CJ8G. In t-code CJ8G, we have created variant With WBS value as “*”. At the time of execution of CJ8G, In background job, system run all the available wbs elements in system irrespective of status of wbs element and amount posted in given period or not.

Background job result contains error for such as wbs locked, wbs closed and sender value not maintained. Etc. even though for that WBS element for given period no accounting was done.

So please guide how to automate cj88 activity in month end centrally.

Thanks & Regards,

Manjusha c.

[coleti]

Dear Manjusha,

According to the How To OSS Note 2397711 - CJ88 does not have a background option, SAP says that the background option is not needed in CJ88. Create a selection variant in CJ8G which can be run in backgound.

The program for background set up is the RKO7CJ8G.

Best regards,

Gabriel Coleti

[former_member327433]

Dear Sir/Madam,

Thanks for your update. we will try to run CJ8G in background using set up RKO7CJ8G.

at the time of background run, system selects all the wbs elements available in system at the time of run.

Not only System considers closed /lock wbs element for background job but also wbs elements on which transactions not done . due to this job result contains huge errors such wbs closed/locked,sender value not maintained etc. even though for that WBS element for given period no accounting was done.

So please guide, in background process ,how to select only those wbs elements on which for given period accounting is done.

Thanks & Regards,

Manjusha c.

[coleti]

Dear Manjusha,

You can create a status profile in transaction BS42 defining all status to be included and not included and use this status in the Selection Variant:

Chec below the SAP Documentation about the use of the selection profile:

Define Selection Profiles

In this menu option you define selection profiles that you can use to specify status combinations for selecting objects (for example, orders or operations). A selection profile is especially useful if you select a large number of objects repeatedly according to the same selection conditions (for example, orders for printing shop papers, for collective release, or for creating order valuations).

Selection procedure

The selection conditions are evaluated top-down. Here the following rule applies:

• Several lines following one another that are linked by an OR are combined and evaluated together. From the block at least one selection condition must be fulfilled.

• AND links blocks or individual conditions. All the blocks or individual conditions linked with AND must be fulfilled. An order is no longer part of the evaluation as soon as a block or individual condition is not fulfilled. That means that with every freshly inserted AND a bracket is inserted around the preceding expressions (conjunctive normal form). To select the desired status combinations a reforming of the selection conditions is necessary.

• In general one can say that OR links more strongly than AND!

Example

You want to define a selection profile with which orders with the following status combinations are selected:

• REL (released)

• CRTD UND MACM (created and material committed)

To do this formulate:

REL OR (CRTD AND MACM)

But the system interprets:

(REL OR CRTD) AND MACM

Orders with the following status combinations are selected:

• REL AND MACM

• CRTD AND MACM

Thus the original formulation must be reformulated by "multiplying out" to:

(REL OR CRTD) AND (REL OR MACM)

Status 'active', 'inactive', or 'never active'

You can also define the state of a status according to which a selection is to be made:

• If you set the state active the system searches for objects where the given status is presently active.

• If you set the state inactive the system searches for objects where the status entered is presently inactive.

• If you set the state never active the system searches for orders where the status entered was never active.

Example

The following is an example of a selection profile that should select all released orders that either have a missing material or a missing PRT.

link status state

REL (released) active

AND MMAT (missing material availability) active

OR MPRT (missing PRT availability) active

The selection is carried out in two steps:

• First, all released operations are selected (that is, orders with the active status 'REL').

• Out of this group the system selects all the orders with missing material or PRT availability (that is, orders with the active status 'MMAT' or 'MPRT').

All the orders are selected with the following status combinations:

• RELEASED and MMAT

• RELEASED and MPRT

• RELEASED and MMAT and MPRT

Indicator 'not'

With this indicator you can reduce the effort required when maintaining selection conditions in particular cases. Many status conditions can be represented more simply by setting the indicator 'not'.

Example

Selection conditions without 'not' indicator:

link not state

<Status> _ inactive

OR <Status> _ never active

Same selection condition with indicator 'not':

link not state

<Status> X inactive

Recommendation

For performance reasons, conditions that limit the selection strictly should be placed at the start of the selection profile.

System status/user status

You can enter both system status and also user status in a selection profile. If you want to select objects according to user status, you must enter the appropriate status profile.

If you have maintained a status profile in the status selection profile, you have to assign this status profile to all objects. Selection is restricted via the status selection profile only if you have assigned the status profile to the objects. If you enter a system status in addition to entering a status profile, the system will ignore it unless it has been assigned to the status profile.

The status profile is assigned to the objects via

• the project profile for the project definition and the WBS elements

• the network type for the network header and the activities

Language dependence of a selection profile

If a selection profile has been created in a language then it can be used in all languages defined in the system. If user statuses are defined in a selection profile then you should make sure that the user statuses are translated in the corresponding status profile. If no translation exists then you must enter the user status in the language in which it was created.

Action

Define your own selection profiles if necessary.

Further notes

Selection profiles are used for selection purposes in the information system and to trigger predefined milestone functions.

I hope this could helps you.

Best regards,

Gabriel Coleti

[former_member327433]

Dear Sir/Madam,

Thanks for your reply.

We are working on the solution given by you in consultation with Ps team.

Best Regards,

Manjusha C.