cancel
Showing results for 
Search instead for 
Did you mean: 

validation

Former Member
0 Kudos
83

hello expert !

how to check if the row is uploaded with amount equal to zero or more 0 ?

the idea is to force users to upload even if the amount = 0.

thanks a lot

S.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Sonia,

AFAIR, it is solvable if:

1 - validation for each row

2 - use the function (do not have a system at hand - so by memory) CONDITION.

Former Member
0 Kudos

hi expert !

i tried function CONDITION () but it does'nt work. The definition of the function tells that Only the characteristics of the following roles are checked:

Since i need to check the fs item ( if the the amount is empty ot not) i can't use CONDITION ().

is it possible to do this check ?

thanks a lot !

S

Former Member
0 Kudos

CONDITION function DOES work, but for manual adjustments.

For validation of data during flexible upload I would recommend BAdI.

Former Member
0 Kudos

Hi Sonia,

Please use the "Group by" option and include the FSI and other mandatory items like ORU as applicable.

This will ensure that, the condition is checked for each combination of data that is loaded for FSI and ORU.

Thanks

Premnath

Former Member
0 Kudos

thanks for your help but it's not possible, it doesn't work.

Former Member
0 Kudos

Hi Sonia

  Try VAL_YTD( fs_item ) = 0 or VAL_PER( fs_item ) = 0

Regards

A.Bharath

former_member211095
Contributor
0 Kudos

Hi Sonia,

If your upload data through document please follow Dan Sullivan instruction.

If data is uploaded through flexible upload method then create a validation method and assign it on Version combination.  This method is applicable for entire version and data.

Regards

Rajesh SVN

Former Member
0 Kudos

yes data are uploaded through flexible upload.

i already create method and validation but the function is_initial( selection) doesn't work

any idea why it doesn't work?

thanks

dan_sullivan
Active Contributor
0 Kudos

Sonia,

If the upload is for documents, a validation may be defined and assigned to the document type in the document type configuration.

If not for documents (reported data posting level 00), then the task log will display the source and target records, but the standard logic will not, as far as I know, load zero records.

Former Member
0 Kudos

hi Dan,

yes it for PL 00 i created an other question :

the steps are in UCWB:

I  added a new validation rule into the method.

insided the validation rule I created a selection condition wich it contains fs_item to be check and the posting level 00. Then the formula is : IS_INITIAL( condition)

then I created the error message.

When i executed the validation task it display green without error but the fs_item doesn't exist so the result must be error message.

thanks for your help