Posts

Showing posts with the label SQL Update & Delete Statement

BAPI for material storage location Add

 We can add material storage location plant wise using third party app or web. BAPI names : BAPI_MATERIAL_MAINTAINDATA_RT Import parameters: HEADDATA: Material Tables: STORAGELOCATIONDATA: Material: Plant: STGE_LOC:   STORAGELOCATIONDATAX: Material: Plant: STGE_LOC:   use below code after completing steps. CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.        

Update & Delete Query

UPDATE & Delete Statement Update Statement:  UPDATE statement is used to modify the existing records in a table.with We need to use Where Clause with Update statement to update the selected row,otherwise all the rows would be affected. The Update Statement look like : UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];     If anyone forget to use Where Clause then the total row will be updated. So use Where clause with Update statement.   Delete Statement: The Delete Statement use to delete the existing record in a table.We need to use Where Clause with Delete Statement,Otherwise all the rows would be affected. The Statement look like: DELETE FROM table_name WHERE condition ;