Wednesday, November 11, 2020

COMMIT-WORK Statement

 Q-What is COMMIT-WORK Statement ? Why it is used ? What if we don't Use it?

A- COMMIT-WORK statement is used to updated the database base changes .Suppose you write 

statement without commit statement like 

modify ZTEST FROM WA_TEST .

Here in this statement ZTEST table will get modify implicity .Means SAP Update the table but it is not visible to user .

But if we write 

modify ZTEST FROM WA_TEST .

COMMIT-WORK .

Here we are explicity defining to update the database table .

So if in nut shell ,if we want to perform series of changes like after one table update second table must update otherwise no table should get update ,we use COMMIT-WORK Statement .


No comments:

Post a Comment

Procure to PAY Cycle

  SAP Tcodes in Procure to Pay ( P2P ): In the Procure-to-Pay (P2P) process in SAP ECC several transaction codes (T-codes) are commonly used...