please any one can tell me modifytable keyword used in DDIC?
what is a basic diffrence between modify table and update key
word?
Answers were Sorted based on User's Feedback
Answer / nigesh
Update statement updates only the existing records if the
key matches.
Modify statement also acts like update statement, but in
addition to it if the primary key does not match then new
record will be inserted to database.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sap
Modify statement acts like both modify and update, becos
modify statment changes the existing record and also
inserts the new records to the table.Where as the Update
statment only inserts the new records into the table.
Hope this is help full!
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / anju
Modify statement insert one or more records in database
table.whereas update statement modify existing records of
data base.
Is This Answer Correct ? | 4 Yes | 5 No |
Answer / apoorv sharma
Both modifies DDIC table but the Difference btwn modify
table and update table is :
Suppose u write modify <DDIC Table > from <work area>
then it will modify the row with same primary key value as
that of work area. But if it donot find any row then it will
NOT insert the work area row in DDIC table,
whereas,
update statement will insert a new row at last in DDIC Table.
Is This Answer Correct ? | 2 Yes | 7 No |
After transferring of data from flat file to application server i found that it is showing wrong data .Say i had currency in flat file as 1000.00 USD. After transferring i found it is showing as 100.000 in the application server. How will you handle this case?
What is a type-pool?
I have 10 records in flat file. In that 7th record is error record. I want to update to data base. If i used Call transaction method what about 7 record and what about 8,9,10 records. If i used Session method what happen. Is it updated or stop at 7th record?
What is the difference between BAPI and RFC?
Which is the event trigger last?
There is a Database Table of Student Details with Fields Student Id, Student Name, Class ID and Rank. Now how to fetch the first three students with highest ranks from all Classes.
how can i find which report(abap program) assign to which sap script? or how can we find sap script is assign to which progam?
What is the difference between getting and get late?
can any one tell me the following question's answer 1. How can we create PUSH Botton in presentation layer. 2.How can we print the record. 3.If database has nor records & if we write 'for all entries' in select statement then what will be happen.
What are ranges? What are number ranges?
is there any tping conversions in abp.and list them
What does an exec sql statement do in abap?