Wednesday, December 1, 2010

SAP TechEd - Kicked Off

SAP Tech Ed Kicked off today morning. Power Packed sessions. V R Ferose started the session with a five minute talk with five slides. Small, but effective. SAP Executive keynote address was delivered by Dr Vishal Sikka, member of the SAP Executive Board leading Technology and Innovation.

SAP HANA Was introduced and was declared released to the market. More from Vishal Sikka’s key note address more in a later post.

TechEd can be watched live here  : Virtual TechEd


I attended the session ALM100 How Top Notch Customers Manage Their Application Lifecycles

Rajeev Gollapudi   did a good job .. It was an excellent session, with a good overview of Solution Manager and its importance as the central  ALM platform for SAP

Waiting for the next session SAP Mobile Strategy 

Community Club house is flooded and Solution Pads are always full with delegates. Information flow is overwhelming.  Soo good :)

Tuesday, November 30, 2010

SAP TechEd 2010, Bangalore

Dec 1st to 3rd, Bangalore witness the SAP TechEd 2010. this is the second time I am going to attend the TechEd. Last time I had visited as a delegate and this time as a speaker. And because of that, this time it’s a little bit different.

Too much of energy, and positiveness is what I find in the TechEd days. Also that effect will be with us for some days.

Today I had been there to collect the pass. Speaker queue was very less, hence was able to register it fast. Went inside to have a look at the arrangements. As soon as I enter I could feel that energy. Is this something which I feels . Don’t know whether anyone else will also feel so. May be I should ask this to some people when I meet them tomorrow.

Podiums were being setup. Club house was being painted. Stage for Demo Jam was being arranged. SAP TV colleagues were in full form. They had already started their job. Arranging everything and checking the last moment checks. The lecture halls were neatly placed and in some dry runs were happening.

A coffee stall was open, I went there and had a hot coffee. Mmm. .it was refreshing. Sipping the coffee, I again enjoyed the ambience.

http://sapteched.com/ -- Official website of SAP TechEd. It is SAP’s annual conference which happens in four locations – Berlin, Las vegas, Bangalore and Shanghai. The Berlin and Las Vegas TechEd is over. Tommorow (Dec 1st) the Bangalore TechEd will start. And it is where I am going to attend.

I am looking forward to the power packed presentation - Vishal Sikka’s key note address. Should deliver my session in the best possible manner. Should visit the exhibit and technology pods and attend as many sessions as possible. Will keep on updating my learnings and my experiences in my blog. Keep watching.

Wednesday, July 14, 2010

Warehouse Management

Imagine I have a storage room in my house where I have kept all my accessories like old books, stationary items, tools etc. All those are kept in cardboard boxes and I have arranged it neatly in shelves. When arranging the boxes, I knew which all boxes contain what all items. But after some days /months we tend to forget which box contain what all items.

Now one day, if we need something, say Glue stick, I go and search the store room boxes. I opened one box, it is not there .I opened another and another. I have forgotten that which box I have kept the glue stick. Pretty difficult situation.

This is the case even though the inventory is small. Imagine the situation of big companies where they have huge inventory and there is a need to manage it. “Warehouse Management” becomes a necessity in such scenarios. And “Warehouse Management systems” help the companies in managing their warehouse.


Let us first read the definitions of a Warehouse and a Warehouse Management System
A warehouse is a commercial building for storage of goods. Warehouses are used by manufacturers, importers, exporters, wholesalers, transport businesses, customs, etc. They are usually large plain buildings in industrial areas of cities and towns. They come equipped with loading docks to load and unload trucks; or sometimes are loaded directly from railways, airports, or seaports. They also often have cranes and forklifts for moving goods, which are usually placed on ISO standard pallets loaded into pallet racks.

A Warehouse Management System  is a system which control the movement and storage of materials within a warehouse and process the associated transactions, including shipping, receiving, putaway and picking. The systems also direct and optimize stock putaway based on real-time information about the status of bin utilization.

The objective of a warehouse management system is to provide a set of computerised procedures to handle the receipt of stock and returns into a warehouse facility, model and manage the logical representation of the physical storage facilities (e.g. racking etc), manage the stock within the facility and enable a seamless link to order processing and logistics management in order to pick, pack and ship product out of the facility.

Example Warehouse



A typical warehouse should contain all the above mentioned area.

Goods are brought inside the warehouse via the Door Inbound and kept in the Staging area. Here the inbound materials are sorted and consolidated. It is then moved to Storage.

When the material is to be shipped, it is moved to Packing area, where it is packed and labeled as per the details. The ready-to-ship goods are kept in Outbound Staging area from where it is taken by the shipment trucks via Door Outbound.

Advantages of using Warehouse Management Systems

• WMS gives you the ability to optimize several types of inventory transactions – such as receiving and putaway, warehouse replenishment, inventory control and cycle counting, and picking and shipping.

• A WMS assists operational personnel to complete tasks for inventory movement into the facility, direct movement of inventory, and manage order fulfillment tasks in a much efficient manner.

• Use of WMS maximizes the use of warehouse space through effective picking methodologies, location consolidation and cross docking.

• It optimizes put-away and uses automated technology, such as barcode scanners and RFID, to efficiently monitor product flow

• It provides valuable visibility reports about the status of product in the warehouse


Conclusion

Warehouse Management continues to be the most important factor in the supply chain execution strategy of any wholesale distributor. With the advent of new technologies like RFID, the way in which distributors manage their high volume warehouses can be redefined. Research is going on to make the warehouse management as automated as possible.

Even Robots are tuned to such an extent that they can make all the inventory movements instead of workers in the warehouse

Enjoy this youtube video where you can see Warehouse Robots at work.

Thursday, May 27, 2010

ABAP .. SELECT Statements

Select statements are used to fetch data from the database.
A simple statement can be written as

SELECT SINGLE * FROM MARA .

(MARA - Material Master Table)

If we need to give some condition, we can alter the query as

SELECT SINGLE * FROM MARA WHERE MATNR EQ ‘T-SHIRT’.

In case if you need to select more than one row, we should write the select statement

In SELECT …. END SELECT block


SELECT * FROM MARA INTO ITAB
WHERE MATNR LIKE ‘T-SHIRT%’.

* Here we should do the processing of the records fetched.
* Eg : APPEND ITAB

END SELECT.

ITAB Is the table declared of type MARA. Please note it should be with header line.

DATA : itab TYPE STANDARD TABLE OF mara WITH HEADER LINE.

So the program can be written as

*************************************************************
REPORT ZABAPTEST.

DATA : itab TYPE STANDARD TABLE OF mara WITH HEADER LINE.

SELECT * FROM mara INTO itab
WHERE matnr LIKE 'LN%'.
APPEND itab.
ENDSELECT.

LOOP AT itab.
WRITE : 'Matnr ', itab-matnr.
ENDLOOP.
*************************************************************

Now there is a second method of fetching via ARRAY FETCH. Which means that
All the database records will be fetched all together

SELECT * FROM MARA
INTO TABLE ITAB
WHERE MATNR LIKE ‘LN%’.

Note that there is no END SELECT block.

And the program can be written as

*************************************************************
REPORT ZABAPTEST.

DATA : itab TYPE STANDARD TABLE OF mara WITH HEADER LINE.

SELECT * FROM mara INTO TABLE itab
WHERE matnr LIKE 'LN%'.
LOOP AT itab.
WRITE : 'Matnr ', itab-matnr.
ENDLOOP.
*************************************************************

Of these two select statements, always try to use the second select statement. The first select statement will keep the database cursor open for a longer time till all the records are fetched from the database. The second select statement will do a single call to the database and in one stretch fetches all the records.

Thursday, May 13, 2010

Hasso On Hasso

A very interesting video where Hasso interviews Hasso

http://sapphirenow.com/video/hasso.html

Monday, January 11, 2010

SOA

Video which gives an introduction to SOA



SAP TV :What is Enterprise Service-Oriented Architecture?

Tuesday, August 5, 2008