Posts

Showing posts with the label Create Table

Using BAPI upload excel file for t-code AS02 in SAP

Using BAPI " BAPI_FIXEDASSET_CHANGE " create a zprogram to upload excel file for mass change fixed asset in SAP. REPORT  ZAS02_ASSET_CHANGE_UPLOAD . TYPE-POOLS :  truxs . " Structure for Excel data TYPES :  BEGIN  OF  ty_excel ,          anln1  TYPE  anln1 ,          bukrs  TYPE  bukrs ,          kostl  TYPE  kostl ,          werks  TYPE  werks ,          prctr  TYPE  prctr ,         END  OF  ty_excel . DATA :  lt_excel     TYPE  TABLE  OF  ty_excel ,       ls_excel     TYPE  ty_excel ,     ...
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