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

Group By & Difference between WHERE and HAVING clause

Group By:

In SQL Server we have got lot of aggregate functions. Likes:
1. Count()
2. Sum()
3. avg()
4. Min()
5. Max()

 Group by clause is used to group a selected set of rows into a set of summary rows by the values of one or more columns or expressions. It is always used in conjunction with one or more aggregate functions.
Syntax look likes : SELECT COUNT(Column name), column name1
FROM table name
GROUP BY column name1;

Filtering Groups:
 
WHERE clause is used to filter rows before aggregation, where as HAVING clause is used to filter groups after aggregations. The following 2 queries produce the same result.

 Filtering rows using WHERE clause, before aggregations take place:
Select Column name, SUM(column name)
from table name
Where column name= condition
group by column name (By which we want to filter our result)

 Filtering groups using HAVING clause, after all aggregations take place:
Select Column name, SUM(column name)
from table name
group by column name (By which we want to filter our result)
Having column name= condition

 From a performance standpoint, you cannot say that one method is less efficient than the other. SQL server optimizer analyzes each statement and selects an efficient way of executing it. As a best practice, use the syntax that clearly describes the desired result. Try to eliminate rows that you wouldn't need, as early as possible.

 We can use both  WHERE and HAVING in a same queries.It seems to be:
Select Column name, SUM(column name)
from table name
Where Column name= condition
group by column name (By which we want to filter our result)
Having column name= condition



 Difference between WHERE and HAVING clause:
1. WHERE clause can be used with - Select, Insert, and Update statements, where as HAVING clause can only be used with the Select statement.
2. WHERE filters rows before aggregation (GROUPING), where as, HAVING filters groups, after the aggregations are performed.
3. Aggregate functions cannot be used in the WHERE clause, unless it is in a sub query contained in a HAVING clause, whereas, aggregate functions can be used in Having clause. 

Comments

Post a Comment

Popular posts from this blog

New commodity code create in SAP S/4 Hana

Image
Commodity codes are internationally recognized reference numbers. A code describes a specific product when importing or exporting goods. You will use this code on any customs declarations and can find them in the Trade Tariff tool. Before S/4 Hana we can create commodity code by using GUI but from S/4 Hana need to use fiori interface to create commodity code. Let's explore it.   T-Code: /UI2/FLP Launchpad is opening and then select Manage commodity codes Tile. After that need to provide No. Scheme contend and click Go button and then need to click add button. Give commodity code and Description with valid from date to valid To date. After that press save button. That's it, your commodity code is created and now need to assign it against material number. Check /SAPSLL/CLSNR table for commodity code added or not.  Check MARC table stawn field to confirm material level assigned or not.
Read more

BAPI to Change STO PO/ PO Delivery date in SAP

Image
 In SAP, a BAPI (Business Application Programming Interface) serves as a standardized method to allow external applications or custom code to access and interact with data and processes within SAP business objects, essentially providing a way to "call" specific business functions within the SAP system from outside applications, ensuring data integrity and proper business logic execution through a defined interface. Function: BAPIs enable external applications to read, create, update, or delete data within SAP by interacting with the underlying business object model. Implementation: BAPIs are implemented as function modules in the SAP system, which can be called remotely using the Remote Function Call (RFC) protocol. Business Object Repository (BOR): BAPIs are defined as methods of SAP Business Object Types, which are stored and managed within the BOR.  Benefits:     Standardized Access: Provides a consistent way for external applications to interact with SAP fun...
Read more

Decimal remove in a smartforms report

In smart forms this is a common problem in our daily task.Here I am providing you my own experience.I am facing this problem and solve using below step. First of all we remove decimal value for QUAN data type. first one is simple, just using below format. &work_area-field_name(C,0)& Hope this will work. Another way is we need to define variable in Smartforms>Global Definitions. Give a variable name, type and associated type like: XYZ  TYPE P decimals 0. Also need to create a program logic following steps :right click > Create>Flow logic>Program logic. In program logic page we provide our logic and assign variable in our required fields. Clear: variable. XYZ = wa_items-total_val. Also need to assign Input & output parameters in General attributes. Input Parameter                              ...
Read more