Posts

Showing posts with the label DISTINCT Statement & Operator

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

SELECT DISTINCT Statement & OPerator

Image
Today I am talking about another Select Statement.That is Select DISTINCT Statement. The   SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values. The  SELECT DISTINCT statement is used to return only distinct (different) values. The statement look like : SELECT DISTINCT column1 , column2, column3,..... FROM table_name ;  Select statement likely : SELECT column1 , column2, column3,..... FROM table_name ;  For example I am showing you both of two queries. Hope it will help you to clear the concept. Difference between Select and Select DISTINCT : By using Select statement we get all the value if have any duplicate values in a table. On the other hand Select DISTINCT statement gives only single values.It's remove duplicate values. Query's are like:  SELECT Column name FRO...
Post a Comment
Read more