avoid invisible characters in Project coding Mask (SAP ECC, Project System)

[Vladimir_Z]

Hi,

Someone faced problem with WBS Coding mask with invisible characters, for example we have next masking - C.XX.XXX.XX.00.000.XXXXX

where C - capex, X - any character (alphabet/numeric), 0 -any numeric character?

Question - it is possible to restrict for X only alphabet character from A-Z and numeric from 0-9, to exclude (restrict for usage) any other symbol like space and , " ! @ # $ % ^ & * and other invisible characters from  character map, because some times peoples using data from excel and didn't check what they put to SAP.

Please advise.

Thank you,

Vladimir

WBS example.txt.zip

[himalya_vashistha · Accepted solution]

Hi Vladimir,

For avoiding Special character and blank space use project definition validation with data set.

In project definition validation (T.Code - OPSI)  Create a project definition validation (or for WBS validation as per your requirement ) like this -

Pre - requisite = TRUE

Check =

PROJ-PSPID IN ZPROJPSPID

Error = Throw a error if check false

Wrong Project Number.

Before creating Validation Create a Data Set for Project definition using T.Code - GS01

Here ZPROJPSPID is a data set name.

Hope it helps to you.

Thanks

[NathanGenez]

This is off topic but I'd highly recommend not using a single character as the key for your project mask.  It can be limiting when PS is rolled out to other entities or more types of projects are used.

[MTerence]

Hi Vladimir,

Do you use any upload program to load the data using the text or excel for upload ?

Regards

Terence

[Vladimir_Z]

Hi Terence,

No, usually excel is like initial form for future creation of Project..WBS.. and users who managing WBS creation using copy/paste..

Regards,

Vladimir

[MTerence]

Hi Vladimir,

To make it simple, you can also restrict the values in excel by using formulas, so you need to make use of excel without allowing them to edit the formulas. Excel experts or use Online help to develop like that.

Else, as advised by Paulo, you need to think about creating validations in OPSI.

Regards

Terence

[Vladimir_Z]

Hi Terence,

I more looking to implement restriction/validation from SAP side than Excel... it will more right.

Regards,

Vladimir

[MTerence]

Yep, that's a permanent solution, compared to excel stuff.

Regards

Terence

[Paulo_Vitoriano]

Hi Vlad,

You can add a master data validation for Project/WBS where every character can be validated for specific set of values.

Regards,

Paulo

[Vladimir_Z]

Hi Paulo,

Do you mean to add this kind of validation in OPSK?

Many thanks!

Regards,

Vladimir

[Paulo_Vitoriano]

Hi Vlad,

No, I mean OPSI.  You cannot do much in OPSK.

Regards,

Paulo