Posts

Showing posts with the label Create Table

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'.        
Post a Comment
Read more

SQL Create Table

Create a new table: The CREATE TABLE Statement is used for creating a new table.Where define the table name and also define its column name with each columns Data types. The statement looks like :   CREATE TABLE table_name (     column1 datatype,     column2 datatype,     column3 datatype,    .... nth column datatype,  PRIMARY KEY( one or more columns )  ); The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).
Post a Comment
Read more