topic Re: Query on Primary Key in Application Development and Automation Discussions

Query on Primary Key

Former Member — Wed, 05 Mar 2008 22:40:55 GMT

Hi Abapers,

1] When we assign a field as primary key in data dictionary then why is it accepting a blank value.

2] And also do we have any inbuilt testing tools for SAP.

Can any one name couple of testing tools avaliable in SAP.

Regards,

Ranjith

Re: Query on Primary Key

Former Member — Wed, 05 Mar 2008 23:01:24 GMT

1) Because a blank is a value - a domain could be used to prevent this - but by default, a blank is a value and it is OK

2) Look at CATT in SAP

Re: Query on Primary Key

Former Member — Thu, 06 Mar 2008 03:49:36 GMT

Hai.

check the links for testing tools.

http://help.sap.com/saphelp_sm40/helpdata/EN/1b/e81c3b84e65e7be10000000a11402f/frameset.htm

http://www.thespot4sap.com/Articles/SAP_Testing_Lessons_Learned.asp

http://www.thespot4sap.com/Articles/SAP_Testing_Lessons_Learned_2.asp

http://www.quest.com/sap/

regards.

sowjanya.b

Re: Query on Primary Key

Former Member — Thu, 06 Mar 2008 03:55:32 GMT

SPACE is a value so it will accept no problem with that to primary key it only checks the reapeated things

testing in SAP

eCATT stands for extended Computer Aided Test Tool (eCATT) which is built is testing tool to test SAP system. By using testing tool we can test the entire business process, and we can also use this tool with a third party 15 testing tool (I am not covering this topic). Execution of every test script ends with a log, which explains the results of the test script.

By using eCATT we can do following operations,

· Test transactions, reports, and scenarios

· Call BAPIs and function modules

. Test remote systems

· Check authorizations (user profiles)

· Test updates (database, applications, GUI)

· Test the effect of changes to customizing settings

· Check system messages

For any further info. follow the below link:

http://www.erpgenie.com/sap/ecatt/

Re: Query on Primary Key

Former Member — Thu, 06 Mar 2008 05:01:15 GMT

hi Ranjit

A similar query was posted before also.

Check this link :

I am giving you a simple understanding about ecatt.

eCATT: extended Computer Aided Test Tool

Purpose:

Use extended Computer Aided Test Tool (eCATT) to create and execute functional tests for software based on R/3 technology. The primary aim is the automatic testing of SAP business processes. Each test generates a detailed log that documents the test process and results.

eCATT enables automatic testing in SAP GUI for Windows and SAP GUI for Java. In order to offer a complete test solution that covers other GUIs, eCATT has interfaces to third party tools.

Features

You can:

• Test transactions and reports

• Test remote systems

• Check authorizations (user profiles)

• Test database updates

• Set up customizing tables

• Test the effect of changes to customizing settings

• Perform load testing

• Check system messages

• Call BAPIs and function modules

eCATT runs in a system based on SAP Web Application Server 6.20 or higher

Test cases usually make R/3 System database changes. Therefore, you should not normally run them in productive systems.In general, do not use eCATT to manipulate data in a productive system: eCATT is a test tool. Only use eCATT in a productive system if you know exactly what will happen.

You may get doubt is sapsyem no and host no......

Let me explain it to you before hand.

when you log in , you will be in session manager screen (i.e SAP Easy Access) there, click on

System --->Status,

you will get all the details,

here is the site of ecatt tutorial , where you can find examples also

http://help.sap.com/saphelp_nw04/helpdata/en/a3/aa413b54a6d73de10000000a114084/frameset.htm

Hope you have a clear idea about Ecatt,

if not tell i will send u material and links on ecatt (step by step).

by the way you already got many link in the above posts. Go through them also.

Kindly reward is helpful,

Regards,

Eswar

Re: Query on Primary Key

Former Member — Thu, 06 Mar 2008 21:25:02 GMT

Hi,

Could you please explain how exactly a domain can be used to block a blank value.

Is there any way where we can assign auto increment option for a field.

Regards,

Ranjith