Validation of data

[Former Member]

Hi experts

I have one doubt if you can clear

When we fill tables thru screens, it does all data validations using fk realationships, fixed values , format etc.

but if we add records from abap editor using internal tables.. does this validation take place ??

or then we can modify data in database tables without any vlidation

Thanks

[Former Member]

Hi Rashmi,

1. Ofcourse not !

2. No validations take place when

we directly try to put data into Table

using abap code or any other utility !

3. The only Validation which takes place is

or

REQUIRED Field

based upon the se11 properties of that table FIELD.

regards,

amit m.

[Former Member]

Rashmi,

The validations at a specific event and when you fill the data in the internal table and NOT on the screen the events do NOT fire and the validations do NOT happen.

I guess you understand the reason now.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

Hello Rashmi,

When u fill the data through the screens all the validations coded in the progra are performed, however when u add the data through the ABAP program using internal tables then there is no validation done unless u do it in the program.

[Former Member]

but then what about data intigrity??

if we can enter data without validations.. wont this create problem?? or then we need to take care of it

Thanks

[Former Member]

Rashmi,

That is something that you will have to take care of as a developer. And I don't see a reason why you would populate the internal table without validating the same.

Yes, if you do that, there is a potential of loosing the database integrity.

Regards,

Ravi

[Former Member]

Hi Rashmi,

The whole responsibility lies with the user who got the authorization for that table's maintenance genarator usage. And it may be one of the reasons why SAP has not given table maintenance generation for the standard database tables.

Thanks and Regards,

Bharat Kumar Reddy.V

[Former Member]

Hai Rashmi

Validations are 3 types

1) Automatic Field validations

2) field validations in Flow Logic

3) Field validations in ABAP(SE38 TCode)

Automatic Field validations: System handles this Checks when ever wrong entries are done by the user at input stage

these are 3 types

1) Required Entry Validation

declare a parameter like this

Parameters : P_matnr like mara-matnr obligatory.

if your not enter any value at runtime

system through an Error.

2) Format

Data : a type i.

a = 'ABC'.

this is datatype validations.

3) Check Table Validations

this is valid for dictionary fields

select-options : s_matnr for Mara-matnr .

when you are giving material No : '123'.

then the check table checks whether

this matrial No exist or not if it is

yes then the process will continue

otherwise it displays an error messge.

Thanks & regards

Sreenivasulu P