Web Content Display Web Content Display

Options

Training Training

Options
I am doing industrial training in 8th semester from Indraprastha Gas Limited (IGL). 

Web Content Display Web Content Display

Options

STELA SARKAR                                                                                                                CSE-II, 8th SEM, 14100

 

 

       INTERNSHIP REPORT

 

 

ORGANIZATION NAME: Indraprastha Gas Limited (IGL)

 

ORGANIZATION ADDRESS: IGL Bhawan, plot no. 4, R.K Puram, Sector 9, New Delhi-110018

 

DEPARTMENT: ERP & IT

 

PROJECT MANAGERS NAME: Mr. S.K Behra

 

PROJECT MANAGERS PHONE NO: 9810191085

 

PROJECT MANAGERS EMAIL ID: skbehra@igl.co.in

 

PROJECT NAME: ASSET REGISTER

 

TECHNOLOGY USED: SAP

 

                             OVERVIEW OF INTERNSHIP

 

ABOUT ORGANIZATION:

It was incorporated in 1998, IGL took over Delhi City Gas Distribution Project in 1999 from GAIL (India) Limited.
The project was started to lay the network for the distribution of natural gas in the National Capital Territory of Delhi to consumers in the domestic, transport, and commercial sectors. With the backing of strong promoters – GAIL (India) Ltd. and Bharat Petroleum Corporation Ltd. (BPCL) – IGL plans to provide natural gas in the entire capital region.
The two main business objectives of the company are -

·        To provide safe, convenient and reliable natural gas supply to it's customers in the domestic and commercial sectors.

·        To provide a cleaner, environment-friendly alternative as auto fuel to Delhi's residents. This will considerably bring down the alarmingly high levels of pollution.

The transport sector uses natural gas as Compressed Natural Gas (CNG), the domestic and commercial sectors use it as Piped Natural Gas (PNG) and R-LNG is being supplied to industrial establishments.

 

Till now, I have learned the basics of SAP ABAP (Advanced Business Application Programming) which includes the following:-

 

  1. ABAP Workbench Tools
  2. ABAP Programming Properties
  3. ABAP Data Types: Complete, Incomplete, Local, Global
  4. Literals, Constants and Text Symbols
  5. Arithmetic Operations
  6. Conditional Branches and Logical Expressions
  7. Comparison Operators and Character Comparison
  8. Loops
  9. System Fields
  10. String Operations
  11. Modularization
  12. Data Encapsulation
  13. Data Transport, parameters and interface
  14. To access subroutines
  15. Structure
  16. Internal Table: Properties, Uses

I along with my mentor will be working further on the project named "ASSET REGISTER" in which starting from Asset Acquisitions, Depreciation, Unplanned depreciation, retirement, transfers and scrapping etc. all the processes and all the transactions generated during the life time of the asset is covered.

 

 

 

 

 

 

 

 

Submitted By:

Stela Sarkar

CSE-II, 8th Sem

14100

Web Content Display Web Content Display

Options

             dronacharya

           

       

         

                 TRAINING REPORT

       ON

"ASSET REGISTER"

     Undertaken at

                                                "Indraprastha Gas Limited(IGL)"

 

        Submitted in partial fulfillment of the requirement      

for the award of the degree

BACHELOR OF TECHNOLOGY

                         in

Computer Science

                                       Maharshi Dayanand University, Rohtak

 

Under the Guidance of :-                                                                      Submitted By:-

Mr. S.K Behra                                                                                         Stela Sarkar            

(Mentor of the Program)                                                                          Roll No.- 14100      

Indraprastha Gas Limited (IGL)                                                                     

 

                        SESSION 2011-2015

 

Dronacharya College of Engineering

Khentawas ,Farrukh Nagar,Gurgaon

 

 

 

CHAPTER 1

 

INTRODUCTION

 

 

 INTRODUCTION

SAP was founded in 1972 in Walldorf, Germany. It stands for Systems, Applications and Products in Data Processing. Over the years, it has grown and evolved to become the world premier provider of client/server business solutions. The SAP R/3 enterprise application suite for open client/server systems has established a new standards for providing business information management solutions.

The main advantage of using SAP as your company ERP (Enterprise Resource Planning) system is that SAP have a very high level of integration among its individual applications which guarantee consistency of data throughout the system and the company itself.

In a standard SAP project system, it is divided into three environments, Development, Quality Assurance and Production.

The development system is where most of the implementation work takes place. The quality assurance system is where all the final testing is conducted before moving the transports to the production environment.  The production system is where all the daily business activities occur.  It is also the client that all the end users use to perform their daily job functions.

To all company, the production system should only contains transport that have passed all the tests.

SAP is a table drive customization software.  It allows businesses to make rapid changes in their business requirements with a common set of programs.  User-exits are provided for business to add in additional source code.  Tools such as screen variants are provided to let you set fields attributes whether to hide, display and make them mandatory fields.

This is what makes ERP system and SAP in particular so flexible.  The table driven customization are driving the program functionality instead of those old fashioned hard-coded programs.  Therefore, new and changed business requirements can be quickly implemented and tested in the system.

In order to minimize your upgrading costs, the standard programs and tables should not be changed as far as possible.  The main purpose of using a standard business application software like SAP is to reduce the amount of time and money spend on developing and testing all the programs.  Therefore, most companies will try to utilize the available tools provided by SAP.

 

1.1 MOTIVATION OF THE PROJECT

Through this report the business would be in a position to determine the asset master details and the transactions that have taken place for the Assets. Moreover, the Business would be in a position to determine the location of the assets. Business User wants to View Asset Information which would provide them the details of the Assets.

Starting from Asset Acquisitions, Depreciation, Unplanned depreciation, retirement, transfers and scrapping etc. all the processes needs to be covered and all the transactions generated during the life time of the asset needs to be covered in this report.

Further, Business should also be able to view the report in a summarized version and in a detailed version transaction wise. The Objective of this report would be to provide the maximum information to the Business without execution of any individual query which would be cumbersome and to increase efficiency and time.

 

1.2 SCOPE

 

  • The SAP Enterprise Resource Planning (ERP) system, SAP R /3, is built as an integrated system where all functionality necessary to run an enterprise is provided by one system.
  • The main benefits of this approach are the workflow and seamless integration of the different business processes within an enterprise. The integration is what ensures the consistency of the business information.
  • The functionality within SAP R /3 is split into modules dedicated to the business functions in an enterprise. The core modules include hundreds of business processes to address the needs of an enterprise.
  • They can be categorized under financials, logistics, and human resources management. Each of these, in turn, consists of multiple sub-modules. For instance, logistics includes general logistics, material management, plant maintenance, and production planning, among others.

 

1.3 THEORETICAL AND TECHNICAL ASPECTS

The initial investigation points to the question whether the project is feasible. A feasibility is conducted to identify the best system that meets the all the requirements.

This includes an identification description, an evaluation of the proposed systems and selection of the best system for the job. The requirements of the system are specified with a set of constraints such as system objectives and the description of the out puts.It is then duty of the analyst to evaluate the feasibility of the proposed system to generate the above results. Three key factors are to be considered during the feasibility study.

 

 1.3.1 FEASIBILITY STUDY

The initial investigation points to the question whether the project is feasible. A feasibility is conducted to identify the best system that meets the all the requirements.

This includes an identification description, an evaluation of the proposed systems and selection of the best system for the job The requirements of the system are specified with a set of constraints such as system objectives and the description of the out puts. It is then duty of the analyst to evaluate the feasibility of the proposed system to generate the above results. Three key factors are to be considered during the feasibility study.

The feasibility study concentrates  on  the  following  area.

·         Operational  Feasibility

·         Technical  Feasibility

·         Economic  Feasibility

1.3.1.1 Operation Feasibility

An estimate should be made to determine how much effort and care will go into the developing of the system including the training to be given to the user. Usually, people are reluctant to changes that come in their progression. The computer initialization will certainly affected the turn over, transfer and employee job status. Hence an additional effort is to be made to train and educate the users on the new way of the system.

In this project user have provided functionality of viewing the details of asset master and transaction that have taken place for that asset, also user can determine the location of the asset.

1.3.1.2 Technical Feasibility

The main consideration is to be given to the study of available resources of the organization where the software is to be implemented. Here the system analyst evaluates the technical merits of the system giving emphasis on the performance, reliability, maintainability.

By taking the consideration before developing the proposed system, the resources availability of the organization was studied. The organization was immense computer facilities equipped with sophisticated machines and the software hence this technically feasible.

1.3.1.3 Economic Feasibility

Economic feasibility is the most important and frequently used method for evaluating the effectiveness of the proposed system. It is very essential because the main goal of the proposed system is to have economically better result along with increased efficiency. Cost benefit analysis is usually performed for this purpose. It is the comparative study of the cost verses the benefit and savings that are expected from the proposed system. Since the organization is well equipped with the required hard ware, the project was found to be economically.

 

 

 

CHAPTER 2

 

OBJECTIVES

 

 

OBJECTIVES

Business User wants to View Asset Information which would provide them the details of the Assets.

Through this report the business would be in a position to determine the asset master details and the transactions that have taken place for the Assets. Moreover, the Business would be in a position to determine the location of the assets.

Starting from Asset Acquisitions, Depreciation, Unplanned depreciation, retirement, transfers and scrapping etc. all the processes needs to be covered and all the transactions generated during the life time of the asset needs to be covered in this report.

Further, Business should also be able to view the report in a summarized version and in a detailed version transaction wise. The Objective of this report would be to provide the maximum information to the Business without execution of any individual query which would be cumbersome and to increase efficiency and time.

The selection screen of report have following inputs :

  1. Company Code
  2. Asset Number(From and To)
  3. Asset Class
  4. Created On(From and To)
  5. Acquisition Year
  6. Capitalization date

The Output the Business would like to have from this report

  1. Asset Number
  2. Sub. Nos
  3. Asset Class
  4. Created On
  5. First Acquisition On
  6. Capitalization Date
  7. Deactivation Date
  8. Supplier/Manufacturer of Assets
  9. Original asset Number
  10. Inventory Number
  11. Asset Description
  12. Asset Description 2
  13. Serial Number
  14. Asset Main Number Text(ANLH)
  15. Cost Center
  16. Plant
  17. Location
  18. Internal Order
  19. Maintenance Order
  20. KANSW-(Totals)-Cumulative acquisition and production Cost.
  21. KNAFA-(Totals)-Accumulated Ordinary Depreciation
  22. NAFAG-(Totals)-Ordinary Depreciation posted in Current year
  23. ABGAN-(Totals)- Retirements
  24. Asset Transaction type
  25. Asset Transaction

 

 

 

 CHAPTER 3

 

HARDWARE AND SOFTWARE REQUIREMENTS

 

 

 

HARDWARE AND SOFTWARE REQUIREMENTS

3.1 HARDWARE REQUIREMENTS

  • Pentium 4, 2.4 gigahertz (GHz) or faster (recommended Intel Core 2 Duo (2.4 GHz with a 1066 megahertz (MHz) front-side bus)
  • At least 1(GB) of RAM (2 GB recommended)

3.2 Network Requirements

3.2.1 Requirements by number of users

  • Small, trial: 1 mbps
  • Medium, 50 users: 2 mbps
  • Large, 100 users: 4 mbps
  • Extra large, 250 users: 10 mbps
  • XXL, 500 users: 20 mbps minimum

3.3 Supported Operating Systems/Browsers

  • Microsoft Windows XP (32 Bit):
    • Internet Explorer 8 or higher
    • Firefox
  • Microsoft Windows 7 (32 Bit and 64 Bit):
  • Internet Explorer 8 or higher
  • Firefox
  • Chrome
  • Internet Explorer 8 or higher
  • Firefox
  • Microsoft Windows 8:

3.4 Software Requirement

SAP Business ByDesign delivers additional software to be installed for specific business purposes and end-users.

3.4.1 Additional Software

In order to run Business ByDesign Web Application the following Software is required:

  • Microsoft Silverlight (minimum version 5.1)
  • Adobe Reader 8.1.3 or higher

 

 

CHAPTER 4

 

PROJECT DESIGN

 

 

 

PROJECT DESIGN

 

4.1 SYSTEM DESIGN

The SAP R/3 System has a three-tier client/server architecture. All data is stored in a database, and the data is processed in the application layer on the application servers. The SAPgui frontend (presentation layer) is the interface to the user. All three layers are connected to each other with networks. The following graphic depicts the client/server architecture of the R/3 System, and the communication requirements between the presentation and application layers and between the application and database layers.

 

http://help.sap.com/static/saphelp_46c/en/ea/2941373c1ede6fe10000009b38f936/Image317.gif

"Figure 4.1 SAP R/3System"

Depending on your requirements, you can distribute the services to different hosts:

4.1.1 Smaller applications keep the database and the R/3 application on the same host. The large volume of data that passes between the R/3 application and the database (SAP server communication) is processed locally and not through a network.

4.1.2 The presentation layer is usually made up of PCs on which the SAP GUI frontend is installed. The SAP GUI is not a terminal emulation but an application program that displays R/3 application data graphically. This means that there are no great demands placed on the connection between the SAP GUI frontend PCs and the R/3 application (access communication).

http://help.sap.com/static/saphelp_46c/en/ea/2941373c1ede6fe10000009b38f936/Image318.gif

"Figure 4.2 SAP Presentation Layer"

 

4.1.3 Higher processing demands on the R/3 application can be realized by additional application servers (application servers are hosts on which the R/3 application runs). Very high demands are made on bandwidth and delay time between the application servers and the database server. You need to set up a suitable network connection to meet these demands.

http://help.sap.com/static/saphelp_46c/en/ea/2941373c1ede6fe10000009b38f936/Image319.gif

"Figure 4.3 SAP Application Servers"

 

4.1.4 You can speed up and secure data throughput to the database by placing the database on a separate host. The database server host then communicates only with the R/3 application servers. By isolating the database completely from the rest of the corporate network, you prevent unauthorized access to sensitive data and ensure high performance. For data backup purposes you may need to connect the database server to a dedicated network (SAN = Storage Area Network).

http://help.sap.com/static/saphelp_46c/en/ea/2941373c1ede6fe10000009b38f936/Image320.gif

"Figure 4.4: SAP Database Server"

 

4.2 DETAILED DESIGN

Enterprise resource planning (ERP) is business management software—not typically a suite of integrated applications—that a company can use to collect, store, manage and interpret data from many business activities, including:

  • Product planning, cost
  • Manufacturing or service delivery
  • Marketing and sales
  • Inventory management
  • Shipping and payment

ERP provides an integrated view of core business processes, often in real-time, using common databases maintained by a database management system. ERP systems track business resources—cash, raw materials, production capacity—and the status of business commitments: orders, purchase orders, and payroll. The applications that make up the system share data across the various departments (manufacturing, purchasing, sales, accounting, etc.) that provide the data. ERP facilitates information flow between all business functions, and manages connections to outside stakeholders.

Enterprise system software is a multi-billion dollar industry that produces components that support a variety of business functions. IT investments have become the largest category of capital expenditure in United States-based businesses over the past decade. Though early ERP systems focused on large enterprises, smaller enterprises increasingly use ERP systems.

The ERP system is considered a vital organizational tool because it integrates varied organizational systems and facilitates error-free transactions and production. However, ERP system development is different from traditional systems development. ERP systems run on a variety of computer hardware and network configurations, typically using a database as an information repository.

 

http://upload.wikimedia.org/wikipedia/commons/thumb/1/12/ERP_Modules.png/500px-ERP_Modules.png

"Figure 4.5: ERP Module"

 

4.2.1 Functional Areas of ERP

An ERP system covers the following common functional areas. In many ERP systems these are called and grouped together as ERP modules:

  • Financial accounting: General ledger, fixed asset, payables including vouchering, matching and payment, receivables cash application and collections, cash management, financial consolidation.
  • Management accounting: Budgeting, costing, cost management, activity based costing.
  • Human resources: Recruiting, training, rostering, payroll, benefits, 401K, diversity management, retirement, separation.
  • Manufacturing: Engineering, bill of materials, work orders, scheduling, capacity, workflow management, quality control, manufacturing process, manufacturing projects, manufacturing flow, product life cycle management.
  • Order Processing: Order to cash, order entry, credit checking, pricing, available to promise, inventory, shipping, sales analysis and reporting, sales commissioning.
  • Supply chain management: Supply chain planning, supplier scheduling, product configurator, order to cash, purchasing, inventory, claim processing, warehousing (receiving, putaway, picking and packing).
  • Project management: Project planning, resource planning, project costing, work breakdown structure, billing, time and expense, performance units, activity management.
  • Customer relationship management: Sales and marketing, commissions, service, customer contact, call center support - CRM systems are not always considered part of ERP systems but rather Business Support systems (BSS).
  • Data services : Various "self–service" interfaces for customers, suppliers and/or employees.

4.2.2 Advantages

The fundamental advantage of ERP is that integrated myriad businesses processes saves time and expense. Management can make decisions faster and with fewer errors. Data becomes visible across the organization. Tasks that benefit from this integration include:

  • Sales forecasting, which allows inventory optimization.
  • Chronological history of every transaction through relevant data compilation in every area of operation.
  • Order tracking, from acceptance through fulfilment.
  • Revenue tracking, from invoice through cash receipt.
  • Matching purchase orders (what was ordered), inventory receipts (what arrived), and costing (what the vendor invoiced).

ERP systems centralize business data, which:

  • Eliminates the need to synchronize changes between multiple systems—consolidation of finance, marketing, sales, human resource, and manufacturing applications
  • Brings legitimacy and transparency to each bit of statistical data.
  • Facilitates standard product naming/coding..
  • Provides a comprehensive enterprise view (no "islands of information"), making real–time information available to management anywhere, any time to make proper decisions.
  • Protects sensitive data by consolidating multiple security systems into a single structure.

4.2.3 Disadvantages

  • Customization can be problematic. Compared to the best-of-breed approach, ERP can be seen as meeting an organization's lowest common denominator needs, forcing the organization to find workarounds to meet unique demands.
  • Re-engineering business processes to fit the ERP system may damage competitiveness or divert focus from other critical activities.
  • ERP can cost more than less integrated or less comprehensive solutions.
  • High ERP switching costs can increase the ERP vendor's negotiating power, which can increase support, maintenance, and upgrade expenses.
  • Overcoming resistance to sharing sensitive information between departments can divert management attention.
  • Integration of truly independent businesses can create unnecessary dependencies.
  • Extensive training requirements take resources from daily operations.
  • Due to ERP's architecture (OLTP, On-Line Transaction Processing) ERP systems are not well suited for production planning and supply chain management (SCM).
  • Harmonization of ERP systems can be a mammoth task (especially for big companies) and requires a lot of time, planning, and money.

Recognized ERP limitations have sparked new trends in ERP application development. Development is taking place in four significant areas: more flexible ERP, Web-enabled ERP, inter-enterprise ERP, and e-business suites.

4.2.4 Benefits

  • ERP can improve quality and efficiency of the business. By keeping a company's internal business processes running smoothly, ERP can lead to better outputs that may benefit the company, such as in customer service and manufacturing.
  • ERP supports upper level management by providing information for decision making.
  • ERP creates a more agile company that adapts better to change. ERP makes a company more flexible and less rigidly structured so organization components operate more cohesively, enhancing the business—internally and externally.
  • ERP can improve data security. A common control system, such as the kind offered by ERP systems, allows organizations the ability to more easily ensure key company data is not compromised.
  • ERP provides increased opportunities for collaboration. Data takes many forms in the modern enterprise. Documents, files, forms, audio and video, emails. Often, each data medium has its own mechanism for allowing collaboration. ERP provides a collaborative platform that lets employees spend more time collaborating on content rather than mastering the learning curve of communicating in various formats across distributed systems.

 

4.2.5 Assumptions and Dependencies

  •  Assumptions. You'll need to make a brief and clear-cut description of any project assumptions related to business, people, technology, expectations, or schedules. Then make a list of those assumptions and share it with the senior team for approval.
  • Constraints. You will need to make a description of the major limitations impacting the project. Your description must include timelines, resource availability, funding, and other important factors that affect project success.
  • Dependencies. It's important to determine a link between project assumptions and constraints and then set any major dependencies between the characteristics. Once it's done you'll need to make a full description of the dependencies and use it in developing the project plan.

 

4.2 Detailed description about the project

Step1 : Execute Transaction SE16à Table ANLA

Input Company Code (BUKRS) and Assets (ANLN1)

Result: From the output of the report we would get the following fields.

1. Asset Number

2. Asset Class

3. Created On

4. Acquisition year

5. First Acquisition on

6. Capitalization Date

7. Manufacturer of Assets

8. Inventory Number

9. Asset Description

10. Serial number

 

Step 2: Execute Transaction SE16à Table ANLH

Enter Company Code and enter the Same Asset Number used in ALNA table.

 

Result: We'll get text ANLHTXT

 

Step 3: Execute Transaction SE16à Table ANLZ

Enter the company code and Asset number and Click on execute.

Result: We'll get the Asset location Information.

The field Valid from (ADATU) should be Sort in descending and the last entry to be picked and report should be filled with the latest cost center/plant/Location/Maintenance Order etc.

 

Step 4:Execute Transaction SE16à Table ANLC

Input Company Code (BUKRS) and Asset (ANLN1) and click on Execute

Result: We will get Fiscal Year KANSW- Cumulative acquisition and production costs, KNAFA- Accumulated Ordinary Depreciation;NAFAP- Planned ordinary depreciation for the year,NAFAG- Ordinary depreciation posted in the current year,ANSWL-Transactions for the year affecting asset values, ABGAN- Total retirements and retiring transfers and NAFAL-Proportional ordinary depreciation for the year

[Note:]For Net Book Value [KANSW- Cumulative acquisition and production costs (-) KNAFA Accumulated Ordinary Depreciation]. We have to calculate the Net Book Value for the assets.

We need to access Table TABW and get the transaction types and description and put this information in an internal table.

In the Second report, we would include Asset information with transactions per line items and year.

Step 5:Execute Transaction SE16à Table ANEK

Enter the Asset Number and the Company Code and click on execute.

 

 

 

Result: We'll get the following Information for the document header.

Asset Number

Year

Reference Document Number

Document Date

Asset Value Date

 

Step 6:Execute Transaction SE16à Table ANEP

In Order to extract the Line Item wise information for the Same Asset we will use the Same Information (primary Keys) and extract the Line Item details. Please Note: Put a Sort on the document Number and subtotal on the year.

Result:We will get Amount posted, Transaction type, and Asset value date.

Step 7:Execute Transaction SE16à Table ANEK

Input the Company code and the Asset Number and click on execute

Result: We will get BELNR and AWORG

 

 

Step 8:Execute Transaction SE16à Table BKPF

Input the company code and the reference key.

We will have to concatenate BELNR and AWORG from ANEK table as this will be used as a reference field (AWKEY) in BKPF table.

Result:  We'll get the Document number (BELNR) and the document type.

Step 9:Execute Transaction SE16à Table BSIS/BSAD

Input the company code and the document number and click on execute

Result: We will get the FI Document number and Amount in LC.

 

Here we will only consider Document type AA, with posting key 40 –Debit. This shows Loss on Asset Retirement. With posting key 50-Credit we will show profit in asset retirement.

 

 

 

CHAPTER 5

 

FUTURE WORK

 

 

 

 

 

FUTURE WORK REQUIRED

No future work is required. All the best possible features have been implanted and satisfactory goals are achievable.