‎2008 Apr 18 5:43 AM
Hi Experts,
I would like to know if ECATT can be used to load the data from the text file.
I was trying to do BDC as well as BAPI for MI04.
Nothing is working fine.
I m always ending up with error.
Could you please suggest some ideas.
Thnx in advance
J.
‎2008 Apr 18 5:49 AM
use ''BAPI_MATPHYSINV_COUNT' bapi...
u have to fill all the structures or ITAB which are mandatory. Then pass them to this BAPI. after that use BAPI_TRANSACTION_COMMIT to update the database
and how to create .txt file to upload data to this transaction.
the text file should contain all the fields which are necessary to pass to bapai structures /ITABs
better , u can run the corresponding trn.. to know all mandt fields
U can use GUI_upload to upload the flat file.
BDC:
Reward if useful
‎2008 Apr 18 5:48 AM
‎2008 Apr 18 5:49 AM
use ''BAPI_MATPHYSINV_COUNT' bapi...
u have to fill all the structures or ITAB which are mandatory. Then pass them to this BAPI. after that use BAPI_TRANSACTION_COMMIT to update the database
and how to create .txt file to upload data to this transaction.
the text file should contain all the fields which are necessary to pass to bapai structures /ITABs
better , u can run the corresponding trn.. to know all mandt fields
U can use GUI_upload to upload the flat file.
BDC:
Reward if useful
‎2008 Apr 18 5:51 AM
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.
http://www.erpgenie.com/sap/ecatt/
http://www.sap-press.de/katalog/buecher/htmlleseproben/gp/htmlprobID-54
http://www.sap-img.com/sap-catt.htm
http://sap.ittoolbox.com/documents/popular-q-and-a/catt-procedure-1795
http://www.thespot4sap.com/Articles/CATT.asp
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCATTOL/BCCATTOL.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCATTOL/CACATTOL.pdf
http://help.sap.com/saphelp_nw04/helpdata/en/78/535b736b899f468e2bf0912aa93680/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/1b/e81c3b84e65e7be10000000a11402f/frameset.htm
http://www.qsands.com/qsands_eCATT_step_by_step.pdf
http://www.saptechnical.com/Tutorials/eCATT/eCATTMain.htm
Kindly reward is helpful,
‎2008 Apr 18 5:56 AM
Hi Murali..
I have done all this.
I have written a BAPI program.
I have tested that BDC pROGRAM..and its throwing lots of error.
Evn BAPI is throwing some type of error.
here goes my BAPI.
tH MAIN PROBLEM IS WITH SERAIL NO REQUIREMENT.
&----
*& Report ZBAPI_MI041
*&
&----
*&
*&
&----
REPORT ZBAPI_MI041.
DATA: PHYSINVENTORY TYPE IKPF-IBLNR,
FISCALYEAR TYPE IKPF-GJAHR,
COUNT_DATE TYPE IIKPF-ZLDAT,
ITEMS LIKE BAPI_PHYSINV_COUNT_ITEMS OCCURS 0 WITH HEADER LINE,
RETURN LIKE BAPIRET2 OCCURS 0 WITH HEADER LINE,
SERIELNUMBERS LIKE BAPI_PHYSINV_SERIALNUMBERS OCCURS 0 WITH HEADER LINE.
CLEAR: ITEMS, SERIELNUMBERS.
MOVE '0100000052' TO PHYSINVENTORY.
MOVE '2008' TO FISCALYEAR.
MOVE '20080416' TO COUNT_DATE.
move '001' to ITEMS-item.
MOVE 'GOLDCOIN-9' TO ITEMS-MATERIAL.
MOVE '1' TO ITEMS-ENTRY_QNT.
move 'EAC' TO ITEMS-ENTRY_UOM.
move '0000000001' to items-batch.
APPEND ITEMS.
MOVE '001' TO SERIELNUMBERS-ITEM.
MOVE 'GOLD-001' TO SERIELNUMBERS-SERIALNO.
APPEND SERIELNUMBERS.
CALL FUNCTION 'BAPI_MATPHYSINV_COUNT'
EXPORTING
PHYSINVENTORY = PHYSINVENTORY
FISCALYEAR = FISCALYEAR
PERCENTAGE_VARIANCE =
COUNT_DATE = COUNT_DATE
TABLES
ITEMS = ITEMS
RETURN = RETURN
SERIALNUMBERS = SERIELNUMBERS.
LOOP AT RETURN.
WRITE:/ RETURN-TYPE,
RETURN-ID,
RETURN-NUMBER,
RETURN-MESSAGE,
RETURN-LOG_NO,
RETURN-LOG_MSG_NO,
RETURN-MESSAGE_V1,
RETURN-MESSAGE_V2,
RETURN-MESSAGE_V3,
RETURN-MESSAGE_V4,
RETURN-PARAMETER,
RETURN-ROW,
RETURN-FIELD,
RETURN-SYSTEM.
ENDLOOP.
CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
WAIT =
IMPORTING
RETURN =
.
‎2008 Apr 18 5:59 AM
Hi Jaya,
Can u let us know of the errors.
Please specify the errors in detail, so that we can help you out.
Kiran
‎2008 Apr 18 6:06 AM
Hi Kiran,
Here goes the error messge when I m running BAPI
18.04.2008 RER 1
-
E M7 724
No data changed
000000
0 EC1CLNT400
E IO 206
Item ****** requires exactly 0 serial numbers for the asset
000000 ****** 0
1
And when running BDC i M GETTING ERROR AS BACKGROUND PROCESSING NOT POSSIBLE FOR MATERAIL WITH SERRAIL NUMBER REQUIREMENT
Pleasse help me to rectify this problem
‎2008 Apr 18 6:24 AM
Hi Jaya,
Generally Serial numbers would be generated by the system and are produced dynamically. We provide the system generated serial numbers to the FM that we are using.
In your case you are providing a hardcoded serial number to the system.
I do not think this case is acceptable. I suppose you should be using another FM to generate a serial number and then should provide the obtained serial number to the BAPI.
Try doing this and I am sure your problem would be solved.
Reward points if this helps,
Kiran
‎2008 Apr 18 6:33 AM
Hi Kiran,
Thanks a lot for your reply.
Please tell me whether I should create a function module or what i need to do for that.
I am not clear with what I have to do.
Regards
J.
‎2008 Apr 18 6:41 AM
Hi Jaya,
Ask the question of FM for serial numbers in a new thread as a new posting, as it would be helpful for others SDN members too.
Please close this thread and reward points. I shall specify about the FM for serial numbers in that new thread.
Thank You.
Rewards points inorder to thank us,
Kiran
‎2008 Apr 18 5:50 AM
Use extended Computer Aided Test Tool (eCATT) to create and execute functional tests for software. 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.
Implementation Considerations
Test cases usually make 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. Instead, use techniques such as Batch Input.
Integration
eCATT can be used with the Test Workbench.
You can migrate test cases from Computer Aided Test Tool (CATT) to take advantage of the better features of eCATT.
eCATT is also integrated with the Object Navigator (SE80).
Features
You can:
· 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
Constraints
eCATT runs in a system based on SAP Web Application Server 6.20 or higher. However, you can use this system to test systems with Release 4.6C or higher.
Reward if helpful.
Jagadish
‎2008 Apr 18 5:53 AM
Hi Jaya,
Ideally ECATT is a tool for testing as you might be already knowing.
But we also could upload data using ECATT, using its core strength of providing the transaction with multiple amounts of data.
There are many limitations though.
Uploading through ECATT could be done if the data is simple and straight. That is if the data need not be changed either in its format or its form and if the data need not have to be validated.
I would suggest you to go ahead with either BDC or better BAPI by solving the problems that you are facing currently.
Reward points if this info helps,
Kiran