Posts

Showing posts with the label Insert Into

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

INSERT INTO Statement

After Creating Table successfully we need to insert value in the existing table.So,I am showing you how to insert value in a row. The INSERT INTO Statement is used for insert value in a table as a row wise. There are two basic syntax.I am giving both of them. INSERT INTO TABLE_NAME (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN); and the other one is : INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);   If we create a table for Customers then the query looks like:       INSERT INTO Customers(Cust_Id, Cust_Name, Cust_Addr,Cust_Phone) VALUES (1001, Harish, Park Street,+9178999999);   Similarly we can use the other one.Here we just put the value directly. never break the sequence , otherwise you 'll get wrong values.
Post a Comment
Read more