on 05-05-2006 12:27 PM
Hi Again
I guess we can not maintain standard tables thorugh table maintainance generator
so how do we do changes if any ..we want to do in standard tables??
do we need to use all those data transfer methods if we want to modify, update or insert data in standard tables?? is this only option available for maintaining std tables??
if so what could be the reason SAP has not given the facility of maintaining std table through table maintainance generator??
Thanks in advance
Hi,
Every standard table is linked to a standard transaction,
Let us say for example if you want to update MARA table, you should not do so. You will be inserting new records with the help of a standard transaction or any data transfer technique through programatically.
For a Z custom table its quiet possible to insert update or modify records with the help of Table maintenance generator.
Cheers,
Sampath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the replies
Actually i was thinking why we cant maintain std tables through table main generator..
yaa now its clear to me that in any case, whether thrugh business transaction or though data transfer methods, standard code do updations in SAP standard tables..
SAP doesnt allow this to do manually (due to data integrity and data consistency reasons)
Really very Intresting
Thanks to all again
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rashmi,
Never ever update standard tables.
Whenever, you execute a business transaction the standard tables will get updated and that is the way it should be.
If you want to upload the data, you should use one of the methods discussed in the other thread of yours.
Regards,
Ravi
Note : Please mark the helpful answers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rashmi,
1. First of all , the standard tables are said to be std., only because they are fixed and remain same for everyone. That is why, SAP has not given the facility of maintaining std table through table maintainance generator.
2. To make any changes in the standard table, I think we need to have an access key for that , which is given by SAP.
3. If at all we need to do any modifications or enhancements , say for customer purpose, we make use of User -Exits or BADIs.
Regards,
Kunal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Rashmi,
Its not possible that we can insert, update or modify the data in the standard table.
That can only be done if and only if you have the right access key.
One another thing is why one needs to change or update the data of a std table. The SAP does not allow this to happen .
You yourself think , if anyone can do so, then there might be inconsitencies , and irregularities coming up in the std table. Also there might be unnecessary data also. So modifications or insertions or updations are not possible.
what we can do if it is really needed , we can create customized table , say , zzmzra which is the same as mara , the std . table and then we can modify the data in that for our pupose.\
Regards,
Kunal.
Rashmi,
BDC's run through the transaction screens just like a user does and let the standard code handle the updations.
Similary, LSMW uses either the BDC way/ BAPI method / IDOC ways where the standard code will finally do the database updates.
No where we are manually updating the data in the tables.
Regards,
Ravi
Note :Please mark the helpful answers
Hi rashmi,
1. Very rare case.
2. But it happens once in a while that
there is some OSS note in sap,
due to which, the functional consultant
tells us to
DIRECTLY UPDATE A STANDARD SAP TABLE
FIELD(S)
3. It happend in our case in FI Module.
4. A program was made to update
one field in one table (for all records)
based upon some condition and value.
5. In that case, we specifically took signature
of the functional consultant !
regards,
amit m.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.