topic Re: ADD DATA in Application Development and Automation Discussions

ADD DATA

Former Member — Tue, 26 Dec 2006 04:41:32 GMT

I've created ZTABLE....

How do I append data to that tables thru 1)Report and using 2)Std Transaction....Waiting for your reply...Thank you.

Re: ADD DATA

Former Member — Tue, 26 Dec 2006 04:43:28 GMT

Hi,

1) REPORT

TABLES: ZTABLE.

ZTABLE-MANDT = SY-MANDT.

ZTABLE-KEY_FIELD = 'TEST'.

INSERT ZTABLE.

Thanks,

Naren

Re: ADD DATA

gopi_narendra — Tue, 26 Dec 2006 04:45:24 GMT

u cant append data to the tables thru any standard transaction.

u need to generate table maintenance for the table.

follow these steps

1. you need generate the table maintenance using the Menu Utilities->Table maintenance generator

2. give the authorization group, package, function group, overview screen number etc.

3.create the table maintenance

4. now go to se93

5. give custom tcode and say create

then enter description , and then

choose the radio button Transaction with parameters

6. now enter tcode as SM30 and check the check box skip intial screen

7. Check all gui support buttons

8. now go down and enter VIEWNAME from F4 help and value as table name

9. and add UPDATE(choose it from F4) and value as 'X'.

VIEWNAME ZTABLE

UPDATE X

and save it, now check the Tcode.

Regards

- Gopi

Re: ADD DATA

Former Member — Tue, 26 Dec 2006 05:08:56 GMT

1) REPORT

TABLES: ZTABLE.

ZTABLE-MANDT = SY-MANDT.

ZTABLE-KEY_FIELD = 'TEST'.

INSERT ZTABLE.

2) Inserting using standard transaction. U need to take help of Functional people. In configuration, there is a method where u can attach the Ztable. So, when the transaction is saved, the contents of the Ztable gets automatically populated.

Re: ADD DATA

Former Member — Tue, 26 Dec 2006 05:55:43 GMT

Thanx there for helpful answers...Could you explain in detail what we are doin in the report..as I am novice to ABAP...........

Re: ADD DATA

Former Member — Tue, 26 Dec 2006 15:59:17 GMT

Thanx there for helpful answers...Could you explain in detail what we are doin in the report..as I am novice to ABAP...........

Re: ADD DATA

Former Member — Tue, 26 Dec 2006 16:10:54 GMT

Hi,

REPORT AD_DATA " Report name

TABLES: ZTABLE.

ZTABLE-MANDT = SY-MANDT.

ZTABLE-FIELD1 = 'TEST'.

INSERT ZTABLE. " Inserting the values to the Table

ZTABLE-MANDT = SY-MANDT.

ZTABLE-FIELD2 = 'TEST1'.

INSERT ZTABLE. " Inserting the values to the Table

if you want to add the records through a transaction code, then follow the steps as GOPI described in the above

Regards

Sudheer

Re: ADD DATA

Former Member — Tue, 26 Dec 2006 17:10:35 GMT

Hi,

The following procedure is always followed when a table is updated using an ABAP report.

1. Check whether the user has authorization to perform the database updates. If the user is not authorised, then raise an exception.

Click the link below to know more about Authorization Concept in SAP.

Checking Authorizations

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3ba5358411d1829f0000e829fbfe/content.htm

Checking User Authorizations.

http://help.sap.com/saphelp_47x200/helpdata/en/9f/dbacbe35c111d1829f0000e829fbfe/content.htm

2. First of the table is locked. Each table in SAP can have lock. Before updating the table table should be locked. This allows the user to have complete/ exclusive access to the table. Click the link below to know more about Locks in SAP.

http://help.sap.com/saphelp_47x200/helpdata/en/41/7af4c5a79e11d1950f0000e82de14a/content.htm

http://help.sap.com/saphelp_47x200/helpdata/en/41/7af4c8a79e11d1950f0000e82de14a/content.htm

3. Use Database update commands INSERT, MODIFY or UPDATE to add entries in the table. Click the links below to know more about these commands.

INSERT

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a6d358411d1829f0000e829fbfe/content.htm

UPDATE

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3a94358411d1829f0000e829fbfe/content.htm

MODIFY

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3ac8358411d1829f0000e829fbfe/content.htm

4. Check the SY-SUBRC after above statements. If the data is inserted successfully, then the database should be committed. for COMMIT WORK command is used. If the database update is unsuccessful, the ROLLBACK the update by using ROLLBACK command.

Clikc the link below for more information.

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b64358411d1829f0000e829fbfe/content.htm

5.

After the database is updated unlock the table.

Click the link to know about Database locks.

Structrure of Locks http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eea5446011d189700000e8322d00/content.htm

LOCK MODE

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eeb2446011d189700000e8322d00/content.htm

Function module for Locks

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eebf446011d189700000e8322d00/content.htm

Lock Mechanism

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eed9446011d189700000e8322d00/content.htm