Error while uploading Journal with wbs element - SAP Community

Hi SAP Folks,

I am trying to upload journal through a customized transaction.

The journal line item has wbs elements in it.

While uploading journal it is showing the below error only when I am using a particular cost element from XXXX Cost element group.

For other cost element from ZZZZ cost element group, it is not showing any error.

ERROR: This G/L Code is only valid for Capital Projects (C-WBS elem.

Is there any transaction code which will link the cost elements to the project codes.

Please help.

Thanks in advance.

SAP Managed Tags:
PLM Project System (PS)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (10)

Answers (10)

Hi all,

Thanks for the inputs.

The problem was with the flat file.

Issue is resolved now.

Regards,

Sophia.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Paulo,

Thanks for the inputs.

I have a query here.

how do I check whether the given cost element hierarchy is linked to wbs element x.1.15.010.1 and the project.

Is there any transaction code to check this.

I hope this might solve my problem.

Regards,

Sophia.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sophia,

Standard system does not restrict and does not establish any relation between cost elements and wbs.

It can be done through validation, exactly as it is done in your example.

Regards,

Hi Paulo,

Thanks for your inputs.

Is there any probable solution for this error??

Regards,

Sophia

You need to understand where it is coming from as a starting point. Based on your master data set and simulation it should not come from your set of master data.

Same message can be used in another validation step. I would change the message to include variables. GL account, WBS, Network, Order. That would help to understand the set of master data for which the message is shown.

Hi Paulo,

Could you please elaborate. I dint understand your statement.

Please help to sort out this error.

Regards,

Sophia

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Based on the simulation result system should not issue the error message for that combination of master data.

That means either the same message is coming from another validation step or from another set of master data.

For the message you can analyze it with Where Used button to understand if it can come from several validation steps.

Hi Paulo,

After clicking on Validation --> simulate. It asked for values.

After entering the values I clicked on execute.\

Against 002 validation it is showing as

condition - TRUE

Check - TRUE

How do I analyze this screen??

Please help.

Regards Sophia

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sophia,

This is basically a test tool to check the validation logic based on certain entry data. There should be no error message issued for this set of input data.

Regards,

sorry

Message Class ZCO

It is matching with the error message no.

How do I proceed further??

Please help

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Sophia,

The validation rule is working exactly as intended by whoever set it up. It is stopping you from posting to an incorrect account. It is not a SAP rule, it is put in by the customer. You will need to choose a different account.

Or you will need to change the validation rule if it is checking the wrong thing.

You can't get around it with what you are trying to post.

Good Luck.

Sophia,

If it is production system there is nothing you can do, since this validation logic is hard-coded, not a best practice. Best practice is to use sets, so you can manipulate it by changing the master data.

Based on your example I do not see the reason for the message, WBS is within the range and GL account is also within the range.

Regards,

My other thought is that the way the WBS is specified in the check. Looks like they are including the periods which are usually part of the coding mask and not really in PRPS-POSID.

Look in SE16N for PRPS but look at the results without conversion. Click Extras, Change Settings, click on Output without Conversion Exit.

WBS elements are tricky when programming, they are not what they appear.

Agree with Ken, good point about use of coding mask. You can test the validation in GGB0 by selecting from the menu Validation -> Simulate.

Hi,

This G/L code is only valid for Capital Projects (C-WBS elem

Message no. ZCO002

Prerequisite

CO Area = 'XXXX'

AND G/L >= '10000' AND G/L <= '19999'

Check

( WBS Element >= 'x.1' AND

WBS Element <= 'x.9.99.999.9.9.9' )

OR

( Network >= 'x1' AND

Network <= 'xZZZZZZZZZZZ' )

OR

( Order >= '700000000000' AND

Order <= '799999999999' )

"----------------------------------------------------------"

"| PM Orders can use Capital GL codes for Capital Works |"

"----------------------------------------------------------"

Message

message type - E

message no. - 002

Message class - ZC

message text - This G/L code is only valid for Capital Projects (C-WBS elem

Do i need to change anything.

Thanks in advance

Regards,

Sophia

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi all,

Many thanks for the inputs.

Yes, there is a validation in GGB0 - controlling

COBL-KOKRS = "XXXX"

AND PRPS-POSID >=X.1 AND

PRPS-POSID <= X.9.99.999.9.9

Can any one tell me what does this mean???

journal is uploaded with wbs element starting with x.2.15.010

XXXX is a controlling area

POSID is field and PRPS is a table for wbs element.

Does the above validation mean that wbs with only x.1 and x.9 should be used.?

or this is a range from x.1 to x.9.??

Please help

thanks in advance

Regards,

Sophia.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sophia,

You are missing some more info from the validation step, it must have both Prerequisite and Condition as boolean statements, and I can see only one boolean statement.

Thanks,

Hi Paulo,

( G/L >= '10000' AND G/L <= '19999' )

OR ( G/L >= '1' AND G/L <= '999' ) OR

G/L = ' '

We are using the G/L of 14140.

Are you asking for this condition??

Regards,

Sophia

The Prerequisite is TRUE, the Check is also TRUE, so I do not think this validation step is the reason.

Please check the error message number and compare it with the message number on the validation step.

Sophia,

Validations are business rules that the client implements because they want things to work a certain way. You are getting this error because your posting is violating a business rule. It is working exactly as intended. Apparently you are using an incorrect account or you are posting to an incorrect WBS element.

The POSID is the WBS element and the G/L is the account. Your WBS is in the range and so is your account.

In the validation there are 3 parts, the prerequisite, the check, and the message. If your situation passes the prerequisite, the check will run and if that passes you will receive the message.

Check with the accounting department for an explanation of all the rules.

Good Luck.

Hi Paulo,

This G/L code is only valid for Capital Projects (C-WBS elem

Message no. ZCO002

Prerequisite

CO Area = 'XXXX'

AND G/L >= '10000' AND G/L <= '19999'

Check

( WBS Element >= 'x.1' AND

WBS Element <= 'x.9.99.999.9.9.9' )

OR

( Network >= 'x1' AND

Network <= 'xZZZZZZZZZZZ' )

OR

( Order >= '700000000000' AND

Order <= '799999999999' )

"----------------------------------------------------------"

"| PM Orders can use Capital GL codes for Capital Works |"

"----------------------------------------------------------"

Message

message type - E

message no. - 002

Message class - ZCO

message text - This G/L code is only valid for Capital Projects (C-WBS elem

Do i need to change anything.

Error message no. ZCO002 is matching with the message of Validation.

How do I proceed further??

Thanks in advance

Regards,

Sophia

Paulo,

If TRUE and TRUE, then receive the message. It passes the check so you will get the error message.

Hi Ken,

No, if TRUE and FALSE then the message... Prerequisite is met and check is NOT fulfilled.

I can see that the check is fulfilled for the master data.

My mistake, you are correct. Got my Boolean logic backwards.

Hi Sophia,

It is 99% coming from a validation, either in FI or CO document line items. Looks like you are using GL account intended only for CAPEX WBS-elements, but on a non-CAPEX WBS.

So, Ken is exactly right

Nothing to do with OPSI, but GGB0.

Cheers,

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sophia,

In tcode OPSI, check if there is any validation in place which allows you to post to certain GL codes based on the project types/project profiles.

In your case, i believe, you are allowed to use only certain GL codes when you post to Capital projects.

Check and let us know.

Thanks,

Gokul

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Sophia,

What is the error message number you are receiving. This sounds like a validation error which is not a SAP error but a business process error.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

103

14

10

5

4

3

3

3

3

3