NEW VENTURE CREATION -- business plan Essay Example | Topics and Well Written Essays - 2500 words

NEW VENTURE CREATION -- business plan - Essay Example ation of business ideas making an analysis of uniqueness of product, analyzing its sale growth, customer availability, and products and services availability is crucial; and this can be made possible by conducting situational analysis. This report aims to conduct feasibility analysis for a Marvelous Hair Salon and to analyze that either the concept is marketable and valid, does the idea proves the marketability and visibility, should the salon take a start, will the project be according to the budget, quality and schedule, and are the goals of the business will be attainable in creative and consistent manners (Kaiser, 2008). In order to achieve this objective, a report has been divided into five sections. The First section gives the general description of the business with its vision and mission; second section consists of the description of products and services and unique selling point. In the third section, detailed market analysis has been performed. Fourth section is based on the market plan that discuss the tactics to get the product and services to customers and to attract customers. The Fifth section is based on financial implications. Businesses can take place in the market through making alliances, joint ventures, and partnerships (Trost, 2013; Miller and Cross, 2013). Marvelous Hair Salon is a small start-up business that will be initiated by making partnership. Salon will provide all hair related treatments, and the focus of business would be particularly on hair related treatments from cutting and styling to hair transplantation. A good vision statement is written as a future state and mission statement is a guide to company (Shattock 2010; Castleberry 2010; Knapp, 2013) Provide memorable and unique experience for the mission to be constant provider of fresh ideas and styles through keeping up the salon’s partners (employees) with current trends and educating them best practices; all is to exceed the expectations by maintain the highest standards

The United Nations and Colombia Essay Example | Topics and Well Written Essays - 2000 words

The United Nations and Colombia - Essay Example The Republic of Colombia, which achieved independence from Spain in 1810 and became recognized in 1819, joined the UN on 5th October 1945 (Borda & Castillo 3). It is among the present member states and is located on South America’s northwestern coast. The country has Ambassador Maria Emma Mejia as its permanent representative to the UN. This paper will research on how Colombia started in the UN, how it has maintained itself over the years as a member, its relations with the organization, and the past and current projects it has had with it. Briefly describing the UN, its system is basically structured on five key organs which include the General Assembly, the International Court of Justice, the Security Council, the Secretariat and the Economic and Social Council (Fasulo 14). The General Assembly resolves non-compulsory recommendations to countries and makes decisions on the admission of new member states after the Security Council’s proposal. The Secretariat, chaired by the UN Secretary General, provides administrative support to the other bodies, while the International Court of Justice decides and settles disputes between countries that acknowledge its opinions and jurisdiction. The Security Council’s key responsibility is maintaining international security and peace, and the Economic and Social Council coordinates social and economic affairs globally (Fasulo 15). To become a member state of the UN as well as a member of the UN General Assembly, the organization’s main deliberative assembly of w hich all member states are, Colombia fulfilled the obligations stipulated by the Charter. Part of the requirements state that although membership is open to all states, such states must be sovereign, peace-loving and willing to observe all obligations as contained in the Charter. Further, in conformity with the provisions of Article 4, Chapter 2 of the UN Charter, Colombia was subjected to the General Assembly’s decision after the

A Study Of The City Of Jaipur Environmental Sciences Essay

A Study Of The City Of Jaipur Environmental Sciences Essay The city of Jaipur, nestled in the rugged hills of Aravallis, popularly known as the Pink City, was founded in 1727 AD by one of the greatest rulers of the Kachhawaha clan, the astronomer king Sawai Jai Singh. The pink colour was used at the time of making to create an impression of red sandstone buildings of Mughal cities and repainted in 1876, during the visit of the Prince of Wales. The city is remarkable among pre-modern Indian cities for the width and regularity of its streets which are laid out into sectors separated by broad streets. Jaipur which means the city of victory was built exactly 273 years back and is 262 km by road from Delhi (Capital of India). A strong wall encircles the old city and even today has a suggestion of formidable strength; its function of protecting all within is obvious.   The plains of Rajasthan of which Jaipur is the capital once thundered and echoed with clash of swords and the drums of wars, Built in 1727 by Sawai Jai Singh-II, Jaipur was the first planned city of its time (the earlier planned city in northern India having been built near Taxila sometime in the 2nd century BC). Source: www.mapsofindia.com Jaipur was planned by Vidhyadhar Bhattacharya, a Bengali architect, who gave shape to the ideas of Sawai Jai Singh in a grid system with wide straight avenues, roads, streets and lanes and uniform rows of shops on either side of the main bazaars, all arranged in nine rectangular city sectors (chokris), planned on the basis of principles of `Shilp Shastra`. The city itself is an attractive creation worthy of universal admiration. The population size of the city is 2.5 million, as per Census 2001. The Municipal body was recognised in 1926 and a Municipal Act was in place in1929. Recently, it achieved the status of a Municipal Corporation and its jurisdiction spread over 64.75 sq.kms. The old city occupies 9.8 sq.kms. The average density of population works out at 38610 persons per sq km. amongst all the mega cities of the country, Jaipur ranks 11th with a total population of 2.3 million. It is one of the fastest growing mega cities of the country with an annual average growth rate of 4.5% whereas the national urban growth rate is only 2% as per Census of India, 2001. With its current growth trend, it is likely to supercede many other cities. Jaipur is thus a vibrant city. Earlier it was Urban Improvement Trust (UIT) who deals with the planning and maintenance part of the city but now it is Jaipur Development Authority (JDA) who deals with the planning and maintenance of the city. Historical Background: This section describes the spatial growth of Jaipur city since the time it was founded. The spatial growth pattern of Jaipur city is divided into four distinct phases which will enable us to understand the growth of city phase wise about the growth trends better. Phase I: 1727-1850 AD : The city was founded by Maharaja Sawai Jai Singh II in 1727 A.D, is one of the few planned cities of its times based on the principles of ancient town planning doctrine of Shilpa Shastra. The city conformed to the traditional walled city concept with the encircling wall and 9 entry gates. Jaipur walled city evolved as a grid-iron plan with the main road running almost east west along the ridge in the centre and the palace complex at the core. The buildings were built following a strict Architectural guideline. By 1734, the main markets of the town including various bazaars had been built. Hawa Mahal, the principle street of Jaipur, c. 1875Phase II: 1850-1930: During this phase, the city grew out of the confines of the walled city. The establishment of railway line in 1868 A.D fueled the growth of the city. During the Rajasthan Famine of 1868-69, Ramniwas Garden was constructed as part of the famine relief work. Modern water Works and Gas Works for lighting the city streets was also established during this phase. Phase III: 1930-1970 : In 1930s, five development schemes, Fateh Tiba, area south of Ramniwas Bagh, Ashok Nagar, New Colony in Jalu pura and Bani Park commonly known as A, B, C, D, E respectively were conceived to provide residential plots, land for public institutions and other amenities for the increasing population. Civil Lines area was developed primarily to house the Senior Government servants. Mirza Ismail (MI) Road was constructed as a ceremonial highway from Ajmer Road to Moti Doongri Road in the early 1940s. The Rajasthan University was inaugurated in 1947 thereby opening opportunities for the southward growth of the city. A sudden increase of population after partition was seen that was mainly due to the influx of refugees during this time. Jaipur then became the capital of Rajasthan leading to further attraction of administrative and economic activities. These factors led to increased development of residential areas to cater to the growing population. For instance, Bapu Nagar and Gandhi Nagar residential areas were developed towards south of the city. Development towards the Northwest of the city took place in the early sixties with the establishment of the Jhotwara Industrial Estate. Phase IV: Post 1970s: During the last 3 decades, the major growth direction has remained largely the same i.e., towards the southwest and northwest of the city. Spatial Integration of Jaipur city: The spatial integration of Jaipur city will be determined by the city land use assessment method changes in it can be analysed and the spatial planning tools techniques, which are responsible for the development also can be analysed. The land use assessment method will analyse the development and growth patterns in past as well as future direction of it. The land use of Jaipur city in 1971 has been compared with the existing land use in 1991 to find out the spatial analysis. Figure: 4.2.1 Landuse, 1971 Landuse, 1991 Source: Census of India, 1971 and 1991 Due to the lack of latest landuse data of city, the assessment is confined uptil the year 1991. There is a very sharp change in the some land uses like residential, public and semi public, and industrial sectors etc. The area under residential increased upto 62% in year 1991 while it was 51% in year 1971, under public semi public is decreased 17 % (1971) to 8 % (1991), also under circulation decreased from 17% (1971) to 12% (1991) but the area under governmental uses remains constant. In case of recreational area, also further decreased by 1% from 1971 to 1991, the area under industrial (7% to 10%) and commercial has an increase of 1%. JDA Land use constituentsThere are also 3 different constitutes in the Jaipur city named as: Walled city, the rest of Jaipur Municipal Corporation (JMC), and rest of Jaipur Development Authority (JDA) area. The largest proportion of all the developed land uses is concentrated in the JMC area and large proportion of undeveloped land is in the rest of JDA area  [1]  . In order to achieve spatial planned development, JDA prepared two master plans for the JDA area till now as a spatial planning tool. 1st Master Plan (1971-1991): The first master plan for 1971-1991 came into effect in May, 1976. It was prepared by the Town Planning Department under the Rajasthan Urban Improvement Act (1959). The master plan defines the objectives of the comprehensive development of the city along new 125 revenue villages Jaipur was proposed to be developed as major tourist destination for the horizon of 1991 and later it was extended for next years i.e.: till 1996. The proposals were made as follows: The Walled city Area: The population density was recommended as 700 persons per ha and other proposals were like tourist facilities, five star hotel in the Jal Mahal Lake shift of some industries from walled city area. Jaipur Nagar Nigam Area (JNN): The proposals were prepared for the additional areas in the periphery along the existing urbanized area and the proposals were prepared for residential, commercial, industrial and parks open spaces. There were also detailed proposals to develop whole sale markets industrial development by size, nature of the industries. Land use Analysis Existing vs ProposedThe proposals given in 1st master plan were not attained in various sectors. The variations in the proposed land use and actual land use which came up later can be seen. The area under residential sector was proposed as 52% but it increased up to 62% and there were decrease in the area under other sectors. There were other proposals which were proposed but the actual situation was totally different from them, are as followed: Due to the development of walled city as a CBD, the attraction of people to the central area increased traffic and congestion and pressure on CBD as well. The colonies and housing societies on outer skirts of the Jaipur city developed by private developers were lacking in proper infrastructure, amenities and the quality of services as RHB and UIT could not meet the housing stock. The concept of `working-living area relationship` and `Residential Area` couldn`t maintained in the city due to this fragmented development by private housing co-operative societies. Some of the commercial schemes could not implement due to the lack of suitable land acquisition and non-acceptance of organised commercial activities in the city. The industrial development could not attain according to the proposals due to land acquisition and presence of other activities like forest, redevelopment schemes etc. The principle of hierarchical development of residential, commercial and other facilities couldn`t achieved as per the plan due to haphazard development, violation of rules and regulations etc. The other proposals for facilities like medical, educational, recreational and tourism were also under same situation due to lack of land availability and acquisition, shift in the proposed locations etc. The next actions such as preparation of various plans like zonal development plans, functional plans, zoning and building regulations etc could not finalize due to the lack of successful implementation of 1st Master Plan. The analysis shows that there are serious gaps in the proposed and actual situation during year 1991. The reason for the wide gaps between them is a total violation of the proposals. There are several main factors which were also responsible for the non-implementation of the plan, are indicated below: Non availability of land with the Local Authorities (JDA and UIT) Lack of coordination among various departments in the city especially in case of UIT. As a result, it opened the doors for private co-operative societies and developers to handle the situation. Time delays in planning process like land acquisition by JDA due to the provisions of agricultural land conversion rules, ULCAR Act, 1976 etc. After the analysis, calculation of deviations between actual and proposed plan, JDA prepared the 2nd Master plan, to cover all those wide gaps and to achieve sustainable development of the Jaipur city for the horizon of 2011. 2nd Master Plan (1991-2011): The second Master Plan was conceived for 2011 for the Jaipur region and now its under proposals for the revision for the year 2021. This Master Plan was prepared in 1995 and came into force from 1998 under JDA Act, 1982. It covers the entire Jaipur region including new 6 satellite towns along with the Jaipur city. The total area of the Jaipur region is 1464 sq.km. the proposal of inner towns between Jaipur city and satellite tows to develop to accommodate the total projected population 42.2 lakhs by 2011. The proposed Master Plan proposed Jaipur region into 3 categories as: Rural Area, Ecological Zone and Urbanizable Area. Proposed Master Plan- 2011 Spatial Strategies for walled city: The second master plan has come up with strategies for each of the constituents of the JDA region. The spatial strategies for Walled City are described as:- No permission to be given for commercial complexes, shopping areas etc inside the walled city area. New building bylaws proposed for the walled city to reduce the density. Shifting of wholesale activities, traffic generating and intensive activities to areas outside. Parking would not be allowed inside the walled city on the main roads. The other tools and techniques like Rajasthan (State) Building Bye Laws, Rajasthan Urban Housing and Habitat Policy- 2006 and Rajasthan Conservation and Heritage Byelaws, 1961 etc were used in the spatial development of the Pink city. After the migration of people to suburbs/outer skirts which can be explained as a spatial contiguity, the concept of satellite towns becomes a spatial planning tools for the local authorities to integrate the spatial development of the `Pink City`. According to Master Development Plan-2011, there were 32 urban nodes which were catering the urban functions so 12 of them which were under Jaipur Urbanizable area, identified and selected as Satellite Towns and Inner Ring Towns to accommodate future population (7 Lakhs as per MDP-2011). These towns will function as urban nodes of Jaipur region and primarily characterised by principle activity like commercial, industrial and recreational etc. The new spatial planning tools and techniques like Zoning codes by introduction of Zonal Development Plans to achieve the most appropriate development of land in the context of development policies and land use proposals given in the Master Development Plan, Land use plan -2011 for Jaipur region (Urbanizable area). After the land use assessment of Jaipur city, the following section describes the aspects like housing, traffic transportation and heritage management to explore problems/issues arise in these aspects and other spatial planning tools techniques which were used in the spatial development of the city. Housing: This section assesses the housing situation of the city specifically in the walled city (Old Area) to understand the spatial integration in terms of housing. If we look at the housing scenario of the city, the number of houseless population has increased in the past ten years thereby indicating a housing gap. The data given in table below shows the clear picture as: Table: 4.2.2 Housing Scenario Source: Census of India, 2001. JMC Housing Stock: On the total housing stock the most predominant use is residential (75%) of the total houses and others are like shops and offices (15%), rest have very minor proportion in account of total proportion. The occupancy rate in the city was 7.2 % in the past decade while it has been seen that it was more in walled city and in the other areas of municipal boundary while it was less in JDA area. But now in days, occupancy rate is high at the periphery of the city because of migration of people from the inner area to the new area, townships, new developments etc. There are various factors behind the migration are like easier availability of land at periphery with different options like big plots, location etc, too much congestion in the walled city area and municipal area, land prices are very high in the central core etc. Housing Type Condition: The city overall has a relatively flatted development but within the walled city, only G+2 structures are predominant. Now in days multi-storeyed buildings can be seen in JMC and other areas of JDA. The housing conditions vary within the city. A qualitative analysis of housing conditions has been done for the walled city is described as: Table: 4.2.3 Housing Condition Source: CDP, Jaipur Source: CDP, JaipurHousing Supply: -The housing development in the whole city can be categorised into 4 types i.e. traditional housing, Formal housing and informal housing. The housing in the walled city is a type of traditional housing. The houses are around 100 to 150 years old and are built in typical Rajasthani architecture style. Mostly, the houses are two storied with decorated doors, windows and chhajjas (projections) etc. Housing Stakeholders: The total housing supply in the Jaipur is through six sources : JDA  [2]  , Rajasthan Housing Board (RHB), Private Developers, the Co-Operative societies, the traditional houses in the walled city the slums (kacchi bastis). In case of walled city, most of the houses come under traditional housing. The proportion of housing supply provided by all of these sources is given below as: New Developments in Housing: In the light of Rajasthan Urban Housing and Habitat Policy- 2006  [3]  , there are new developments which can be categorized as: group housing schemes, redevelopment schemes, flats of RHB and new townships at the outskirts of the city. In case of walled city, redevelopment schemes are taking place, and under these schemes individuals are allotted plots of an area 40 sq.mts  [4]  while JMC and JDA are responsible for the implementation process of redevelopment schemes. Problems/Issues in Walled City: There are various problems/issues related with housing in the walled city which are major concern for the authorities. These are listed as: Most of the houses are very old like built around 100-150 years back and they are in dilapidated condition especially in the market area which are occupied by lower income groups (LIG`s). Most of the area of walled city is facing poor infrastructure facilities. Due to high population density, the houses are overcrowded with families leads to unhealthy living environment. Most of the housed occupied by Middle Income groups (MIG`s) and Lower Income groups (LIG`s) have no open spaces, houses are semi-pucca or kaccha, some of them are without toilets and electricity connections. Water supply is only through public taps or old wells only and the ventilation in the houses in not adequate. Missing of unique character (Pink Colour) in new housing developments of the `Pink City`. The housing problems/issues are also becoming prime concern in spatial integration of the Jaipur city especially in the walled city. The increase in housing demand and lack in housing supply by local authorities, use of spatial planning tools such as redevelopment/regeneration schemes in old (Walled city) areas, neighbourhood planning on the outer skirts through private developers, incoming development of slums (Kacchi Bastis) etc are creating a big threat for the spatial character of the `Pink City`. Traffic and Transportation: Traffic and transpiration is also an integral part of the spatial integration of the Jaipur city. As Jaipur is one of the metropolitan cities in the country with a population of over 2.5 million and is observed to be growing at very fast rate. Besides being the capital city of Rajasthan, the city of Jaipur is a major tourist centre in the country as well. Major portions of economic activities of the city are located in walled city area, spreading over 9.8 sq.kms. This area is, besides having heavily concentrated activities, a very important tourist centre and attracts tourists from all over the globe. The economic activities in the form of wholesale trade, commerce, household industries, administration and tourist spots generate heavy traffic to and from these areas. The limited road space of the area is congested with vehicular and pedestrian traffic. The shopkeepers and vendors also occupy the sidewalks and carriageways. Consequently the traffic in these areas is facing acute conge stion, bottlenecks and hazards. The environmental pollution as well as physical and visual intrusions are also some of the other problems increasingly faced by the residents and the visitors to the area. In case of transportation facilities, only bus service is operated throughout the city by public sector and the other modes are like private taxis, auto-rickshaws, animal driven vehicles, rickshaws, private mini buses etc are used as transport facility. The situation of parking in the walled city is also in haphazard condition. Parking demand in the walled city area is met mainly by roadside parking along all major roads and there is no major off-street parking facility. With the ever increasing parking demand the vehicles are parked in two rows on carriageways. Footpaths are also filled with parked vehicles. While there is heavy demand for parking, the limited enforcement of regulatory measures fails to control and manage the parking problems. The following pictures will describe the nature and extent of traffic, parking problems in the walled city. On street parking on the major roads of walled city Animals are very common for transportation of goods on Jaipur roads causes congestion slow traffic Street Hawkers/vendors along the roads in the walled city Mixed Traffic Problems/Issues in the Walled City: The pressure on the roads of walled city can be easily observed due to encroachments by on street parking, hawkers/vendors and excessive commercialization and mixed vehicular movement. There is a lack of proper traffic management system in the old area as well as in the whole city like no regulations on mixed traffic, no maintenance of signals junctions, animals are moving freely in the daily traffic etc. The public transport facility is also inadequate due to insufficient number of vehicles like buses etc. for transportation. Parking is also a major issue in the walled city due to lack of parking spaces and due to this, leads to other issues like on street parking, encroachments on the roads etc. The through traffic of National Highway (NH) -8 is creating problems in the city in terms of congestion, air noise pollution, The traffic and transportation system in the Jaipur city is still facing number of problems although various departments like JDA, PWD, Transport Department, RSRTC, JNN etc are in coordination with each other to solve the issues/problems related with it. The proposals in the layout of grid-iron pattern development as ring roads, bye-pass, Mass Rapid Transportation System (MRTS), terminals for buses and trucks etc are still in pipeline but Bus Rapid Transit System (BRTS) under JNNURM scheme as a spatial planning tool is a main achievement to the date to address the traffic problems in the city. Heritage Management: Heritage is a word which expresses the character of Jaipur city. The city is known as the `Pink City` which is very rich famous for its heritage culture. Due to rapid urbanisation, the new developments are coming but still the city has fascinating heritage from its earlier times. In Jaipur, all the historical buildings are described into three classes as: royal palaces forts, temples and museums. Each heritage building has different history and different characteristics. Most of the buildings are situated in the walled city area and others are in municipal area. The historical Buildings which are situated in the city are as: Walled City Area JMC Area City Palace Complex Amber Fort Hawa Mahal Amber Palace Jantar Mantar Jaigarh Nawab Sahib Ki Haveli Nahargarh Swargasuli or Isar Lat Motidoongari Maharani Ki Chhatri Jal Mahal Place Ram Niwas Garden Rambagh Place Albert Hall Gaitor Jagat Shiromani Temple Ghat Ki Guni So, there are 8 buildings which are situated in the walled city and 10 buildings are in JMC area. There are other historical components which has unique values. These includes like bazaars (Commercial area), water tanks, small temples and chabutras. These are 100-250 years old built. Besides this, JDA has identified total 300 historic buildings into the various parts in the walled city and categorized into different levels as per their area. The existing situation of the walled city is assessed on the basis of current status and condition of these historical monuments. The JMC bye laws are violated and traditional planning system has no use in the present time in the walled city. An existing situation analysis  [5]  shows it very clearly as follows: The Rajasthan Conservation and Heritage Byelaws, 1961 also guides about the conservation of historical properties and many agencies (Governmental, Private and NGO`s) are working towards conservation of those historical monuments but somehow these rules and regulations are also violated which threats to the unique historical character of the `Pink City`. Problems/Issues in the Walled City: Due to excessive commercialization, it leads to the major traffic congestion in the streets and the irregular construction of shops in streets; Chhajas (projections) in front of shops have disturbed the fabric of historical streets. The encroachments on streets also spoiled the character image of streets and led to congestion in traffic movement too. Due to lack of sufficient parking spaces, the on street parking becomes a major problem for the loss of cultural fabric of street traffic congestion. The maintenance and Lack of infrastructure facilities like water supply, sewerage, garbage collection and solid waste management in the inner streets also creates unhealthy environment which may disturb the character of inner areas. Due to the lack of rules and regulations for heritage walkways, they have lost their historical image. The maintenance of heritage buildings under private ownership is not adequate, and some of them have converted into modern buildings. The conservation rules regulations are violated in the walled city due to lack of co-ordination among different departments. Heritage buildings are treated as only commercial spots without the proper conservation and protection. As `Pink City` is famous for its rich heritage and historical background but due to lack of attention and awareness by local authorities and people, it is facing number of problems related to its heritage. Somehow planning officials included the conservation of historical monuments and developments of significant tourist spots as a planning policy and principle in the Landuse Plan-2011 but still there are other number of concerns regarding the heritage and cultural character of the city which should be addressed as well.

Technology Enhanced Classrooms Essay -- Internet Learning Papers

Technology Enhanced Classrooms The era of The Information Age is upon us as educators to access, explore, utilize, and implement the use of the Internet. as a wonderfully innovative and valuable tool to use in the classroom for the purpose of teaching our students through the exploration of a vast territory of endless information, experiences, interactions, and unlimited ideas known as the Internet. Purpose: The purpose of this paper is to present a variety of computer and Internet techniques that can be utilized into the Information Age classroom and curriculum as a tool for teaching and learning in modern educational systems. Technology Enhanced Classrooms The era of The Information Age is upon us as educators to access, explore, utilize, and implement the use of the Internet as a wonderfully innovative and valuable tool to use in the classroom for the purpose of teaching our students through the exploration of a vast territory of endless information, experiences, interactions, and unlimited ideas known as the Internet. The purpose of this paper is to present a variety of computer and Internet techniques that can be utilized into the Information Age classroom and curriculum as a tool for teaching and learning in modern educational systems. In order to effectively use the Internet, one needs to grasp basic computer techniques that will enable the transition from traditional classroom practices to that of technology enhanced methods that will be exciting for educators and students alike. As educators endeavor to follow standards, core content, lesson objectives, and the like, we often get caught up in the routine methods of presenting lessons. The Internet offers more data than could ever be obtained... ... continue to be presented concerning Internet skills. Using the Internet to enhance your classroom is a direction that will create an entirely alternate method of teaching. Utilizing the implementation of Internet skills into subject plan will increase the interest atmosphere within the classroom thus resulting in a higher-level of comprehension as a result of students actually being a part of their educational experience. References Barksdale, K. (1999). Internet concepts & activities. Cincinnati: South-Western Educational Publishing. Cashman, T. J. (1995). Learning to use microcomputer applications. Danvers: International Thomson Publishing. Maran, G. (1995). Internet and World Wide Web simplified. Foster City: IDG Books Worldwide, Inc. Weixel, S. (1997). Personal computing essentials. Indianapolis: Labreque Publishing Services.

Principles of Banking and Finance Essay

What does Sub-Prime Crisis means? Sub Prime lending which is also known as near-prime, non-prime and second chance lending, means lending to people who might have trouble repaying the loan due to income ability or credit ratings which previously would not have been available to them. Credit ratings that might be not favorable to them with the standards set up initially by Financial Institutions slowly dwindle to less strict under-writing of loans. which could also due to an influx of foreign capital making lending easier to these group of people, the investment banks that sold the repackage mortgages to the consumers which is one of the way to fund for capital, and the Housing Urban Development of America policy to ensure that its citizens has access to mortgage loans easily. The cheaper interest rate packaged by the Financial Institutions which seems more affordable for the consumer for the first 1 to 5 years and the thereafter interest rate would have jumped significantly. The loan s here generally referred to mortgage loans. The Crisis started or snowball into what it was in 2007 in my opinion was due to greed. Greed into thinking that the property boom would continue in perpetuity so that the borrowers could cash out more from their current property market valuation, with this cash out in terms of personal loan they could fund or finance their lifestyle be it buying a new property for investment purposes, to flip or for rental. For the luxury in life they choose to enjoy now, spending future money. As the economy slowed, jobs are being taken away from corporation in America to other countries which have a cheaper source of overhead expenses and manpower. People are being retrenched thus causing them to start defaulting on their loan repayments. A statistic done has shown that the American households do not have any savings but was laden with debt instead. The housing bubble burst, the market does not have that much capital as it used to have to continue to push property prices up anymore, thus causing the market to slow overall, foreclosures of their properties was happening. Consumers was also unable to obtain a refinancing which they had planned previously to lower their interest rate again when it went up, as financial institutions feel the pinched and controlled its lending. How did the Financial Institutions played a part in this? In the past banks have financed their mortgage lending activities through the deposits they receive from their customers. This has confined the amount of mortgage lending they could do. In recent years, banks have designed a new model where they repackage these mortgages to be sold to the bond markets. This has made it a lot easier to fund additional borrowing from the investors and interest rate was low. But it has also led to abuses as banks no longer have the incentive to check carefully the mortgages they issue to the lenders. The failure to check and curb lending in return for the possibility of profit was one of the causes. The first sign of the sub-prime crisis was as early as 2007 when HSBC Finance which is part of the banks north American subsidiary has to write off 880 million in sub-prime lending. The business has become unsustainable as borrowers started to default. The new model which we have come to know is known either as Mortgaged backed Assets or Collateral Debts Obl igations. The repackage mortgages are being sold to the bond markets, before they can be sold, credit rating agency will determine and give the model a rating. A credit rating for an issuer takes into consideration the issuer’s credit worthiness example its ability to pay back a loan, and affects the interest rate applied to the particular security being issued. These MBS or CDOs as it has come to know are usually marketed to countries which has a surplus in its balance sheet as it was generally known that Asians believe in savings rather than spending future money thus the products were usually marketed in Asia, It is allege that the rating agencies experienced from conflicts of interest, as they were paid by investment banks and other firms that organize and sell these structured securities to investors. If there are not to give favorable ratings to these products they risk the underwriter of these securities to another rating agency. It would be hard to sell these products if they are not being given a rating to begin with. Once they are sold the banks have in a way diverted part of the risk to the consumers. Investors should not rely too heavily on these ratings agencies opinions but instead carry out their own homework in the safeness of debt level as well as others related securities. Probably the opinions of the agencies enable them to get a conclusion, however based on past decade of event, it can only be consider as off base when it comes to the risk of credit event. Investors should try to put themselves in the shoes of the product pushers, asking themselves very important points like, why do you need to sell these products? Do you own any of these products yourself? If it is as good as you mention have the private investors bought and participated a substantial amount of their savings in it? Perhaps there need to be some form of intermediaries whereby no conflict of interest will affect their opinion and report of these products. A case study in Singapore itself which has made headlines during this crisis was the minibond saga which was being sold in Singapore by a couple of Financial Institutions. The originator of this series of structured products was the now defunct Lehman Brothers. The Minibond was being illustrated to the local consumer as a bond which is not the case it is actually a Collateral Debts Obligations. The relationship managers in banks are eager to sell the product because of the high commission and the consumer who are eager to buy because the returns are much higher than the fixed deposit being offered by the banks. An estimated of 500 million Singapore dollars was purchased for the Minibonds by consumers. It stirred a series of conflicts with the Financial Institutions that sold these products, the consumers cried fouled into being mis-sold of it, some of the consumers managed to get back part of their investment and vowed not to touch these structured products ever again. We can take a look back into the 1990s where one of the policy set up and enforce by the Housing and Urban Development of America, was one of the cause of the sub prime crisis. With the support of the government, HUD has less mortgage restriction requirements on its borrowers. The mandate was that Fannie Mae and Freddie Mac which was regulated by HUD, was to generate up to 8 million more homeowners in America. It was known as the â€Å"National Homeownership Strategy†. No down payment was required, 100% financing for the property was the norm. This was partly possible due to the influx of cheap money in the market, wit h this cheap money consumers speculated with the market, they kept buying new homes thus the good years of where the appreciation of the property keep going up. Financial Institutions dare to lend due to the market confidence that it can only keep going up, borrowers confidence that the market too can only keep going up. A check with HUD official website, apparently the US government is still supporting home ownership program without first addressing a stable income issue. Only with a stable income can a person make regular commitment to his or her housing loan commitment. Kudos to the Singapore government for taking appropriate actions during the last few years when their economy was recovering, the measures taken to prevent over speculation of the property market in Singapore. Homebuyers with the extra cash were snapping up properties, either for owner’s occupation or for investment purposes. The government either learned from the Sub-prime crisis or foreseen that if it continues the way it is going, a market crash might be imminent or the crash will be too fast and hard, no soft landing for the consumers. As they knew that property market have its up and down. Steps was taken, it used to be 90/10. Whereby the buyer have to come up with 10% cash and the remaining 90% can be financed through a financial institutions regardless of the number of property they currently owned. It was changed to 80/20 rule, 20% of which is the owner’s own cash an 80% through financing. Surprisingly it did not deter the consumers, the market still kept soaring. The next rule implemented was the 80/20 rule for first time buyers, meaning buyers without any current mortgage loan, for buyers with an existing mortgage which was not yet paid up; they are only eligible for 60/40. 60% financing for their new property and an increased in the stamp duty to be paid for to the government if it was their 3rd property for Singaporean. The hardest hit was the foreigners who are seeking to invest their money in Singapore properties as they have to pay additional 10% stamp duty which is likely to deter most of them. P rices still kept going up, the latest ruling was much more complex than the previous few. If one is looking at 80% financing one can only borrow up to the age of 65 years old and tenure of not more than 30 years. Which was not the case previously, in previous scenario it was dependent on different Banks guideline in Singapore, they could lend up to the age of 70, 75 or 80. They stepped in and put a cap at 65 as they believe that is the retirement age. If you want to extend your loan tenure your financing amount will drop to either 60% or 40%. I believe the government did this as they knew that the US is going ahead with Quantitative Easing 3, they want to prevent too much hot money from landing in Singapore shore. To sum up, we learned from our mistakes and grow not to make the same mistake twice. A healthy economy is based on real economic goods with value. Hopefully US can still continue to create innovative products like Apple and keep their manufacturing production in US soil, get employment rate up. The citizens have to maintain their expectations in terms of salary wise and spend within their means. Tighten up their way of lending and controlling Banks to a certain extent, a culture that is profit driven but with ethnics. Can heed the investment guru jim roger’s advice to focus on farming as there will be a food shortage in time to come. Induce good saving habits in everyone to save up for a rainy day. http://www.ethicalquote.com/docs/SubprimeMortgageCrisis.pdf http://news.bbc.co.uk/2/hi/business/7073131.stm http://en.wikipedia.org/wiki/Government_policies_and_the_subprime_mortgage_crisis http://www.washingtonpost.com/wp-dyn/content/article/2008/06/09/AR2008060902626.html http://www.thetruthaboutmortgage.com/mortgages-with-no-money-down/ http://www.telegraph.co.uk/finance/markets/2816291/HSBC-hit-by-sub-prime-crisis.html

Abap Data Dictionary

The ABAP Dictionary centrally describes and manages all the data definitions used in the system. The ABAP Dictionary is completely integrated in the ABAP Development Workbench. All the other components of the Workbench can actively access the definitions stored in the ABAP Dictionary. The ABAP Dictionary supports the definition of user-defined types (data elements, structures and table types). You can also define the structure of database objects (tables, indexes and views) in the ABAP Dictionary. These objects can then be automatically created in the database with this definition.The ABAP Dictionary also provides tools for editing screen fields, for example for assigning a field an input help (F4 help). Type definitions Structure Database objects Table DB table Data element Table type Tools Poss. values Screen F4 The most important object types in the ABAP Dictionary are tables, views, types (data elements, structures, table types), domains, search helps and lock objects. April 2001 9 BC – ABAP Dictionary ABAP Dictionary SAP AG ABAP Dictionary Purpose Data definitions (metadata) are created and managed in the ABAP Dictionary.The ABAP Dictionary permits a central description of all the data used in the system without redundancies. New or modified information is automatically provided for all the system components. This ensures data integrity, data consistency and data security. You can create the corresponding objects (tables or views) in the underlying relational database using these data definitions. The ABAP Dictionary therefore describes the logical structure of the objects used in application development and shows how they are mapped to the underlying relational database in tables or views.The ABAP Dictionary also provides standard functions for editing fields on the screen, for example for assigning a screen field an input help. What Information is Stored in the ABAP Dictionary? The most important object types in the ABAP Dictionary are tables, vie ws, types, domains, search helps and lock objects. Tables [Page 13] are defined in the ABAP Dictionary independently of the database. A table having the same structure is then created from this table definition in the underlying database. Views [Page 97] are logical views on more than one table. The structure of the view is defined in the ABAP Dictionary.A view on the database can then be created from this structure. Types [Page 136] are used in ABAP program. The structure of a type can be defined globally in ABAP programs. Changes to a type automatically take effect in all the programs using the type. Lock objects [Page 209] are used to synchronize access to the same data by more than one user. Function modules that can be used in application programs are generated from the definition of a lock object in the ABAP Dictionary. Different fields having the same technical type can be combined in domains [Page 161].A domain defines the value range of all table fields and structure compon ents that refer to this domain. The ABAP Dictionary also contains the information displayed with the F1 and F4 help for a field in an input template. The documentation about the field is created for a data element [Page 138] that describes the meaning of the contents of a table field. The list of possible input values that appears for the input help is created by a foreign key [Page 19] or a search help [Page 172]. Integration in the ABAP Development Workbench The ABAP Dictionary is completely integrated in the ABAP Development Workbench.The R/3 System works interpretatively, permitting the ABAP Dictionary to be actively integrated in the development environment. Instead of the original objects, the interpreters see only internal representations of these objects. These internal representations are adjusted automatically when the system finds that changes have been made in the ABAP Dictionary. This ensures that the screen and ABAP interpreters, input help, database interface, and dev elopment tools always access current data. 10 April 2001 SAP AG BC – ABAP Dictionary ABAP DictionaryThe following ABAP program lists the airline carriers (see Flight model [Page 302]) and carrier IDs contained in table SCARR. DATA: SCARR_TAB TYPE SCARR. SELECT * INTO SCARR_TAB FROM SCARR. WRITE: / SCARR_TAB-CARRID, SCARR_TAB-CARRNAME. ENDSELECT. Only structure SCARR_TAB is declared in the program. All the information about this structure, such as the field names, data types and field lengths, are copied from table SCARR, which is defined in the ABAP Dictionary. This information about table SCARR is called from the ABAP Dictionary when the program is generated.This means that the source text of the program need not be adjusted when a change is made to table SCARR, for example when the length of a table field is changed. The next time the program is called, the system automatically determines that the structure of table SCARR has changed. The program is simply regenerated, ther eby retrieving up-to-date information about table SCARR from the ABAP Dictionary. ?Development environment ? Development environment ABAP Tools Data Modeler Screen Painter ABAP Dictionary ABAP Interpreter Dialog Control Interfaces Screen InterpreterRuntime environment of the application Runtime environment of the application When you work on development projects, objects of the ABAP Dictionary can be changed any number of times before being activated [Page 237] and made available to the operative components of the system. Objects can have both an active and an inactive version in the ABAP Dictionary at the same time. Inactive ABAP Dictionary objects have no effect on the runtime system (ABAP processor, database interface). This permits greater changes to several objects without impairing the April 2001 11 BC – ABAP Dictionary ABAP DictionarySAP AG executability of the system. The objects can only be activated together when they have all been changed. 12 April 2001 SAP AG BC à ¢â‚¬â€œ ABAP Dictionary Tables Tables Tables can be defined independently of the database in the ABAP Dictionary. The fields of the table are defined with their (database-independent) data types and lengths. When the table is activated, a physical table definition is created in the database for the table definition stored in the ABAP Dictionary. The table definition is translated from the ABAP Dictionary to a definition of the particular database.Database-independent Definition of the Tables in the ABAP Dictionary T1 T2 T3 †¦ Tn Activation program and DB UTILITY DB Definition of the tables in the database T1 T2 T3 Tn A table definition in the ABAP Dictionary contains the following components:  ·  ·  ·  · Table fields [Page 14] define the field names and data types of the fields contained in the table Foreign keys [Page 19] define the relationships between the table and other tables. Technical settings [Page 30] control how the table should be created in the database. In dexes [Page 61]: To speed up data selection, secondary indexes can be created for the tableThe customer can modify SAP tables with append structures [Page 69] and customizing includes [Page 68]. This kind of modification ensures that the customer enhancements are automatically merged with the new versions of the SAP tables when there is a release upgrade. See also: Creating Tables [Page 72] Making Changes to Tables [Page 83] April 2001 13 BC – ABAP Dictionary Table Fields SAP AG Table Fields You must define the following for a table field in the ABAP Dictionary:  ·  ·  ·  ·  ·  · Field name: The field name can have a maximum of 16 places and may contain letters, digits and underscores.The field name must begin with a letter. Key flag: determines whether the field should belong to the table key. Field type: data type of the field in the ABAP Dictionary. Field length: number of valid places in the field. Decimal places: number of places after the decimal point, spec ifying numeric data types. Short text: short text describing the meaning of the field. You can also include [Page 16] the fields of a structure in the table. Assignment of the Data Type, Field Length and Short Text You can assign the data type [Page 242], length and short text in different ays:  ·  · You directly assign the field a data type, field length (and if necessary decimal places) and short text in the table definition. You can assign the field a data element [Page 138]. The data type, field length (and decimal places) are determined from the domain of the data element. The short description of the data element is assigned to the field as a short text. Other Assignment Options  ·  ·  · Check table: An input check for the field can be defined with a foreign key [Page 19]. This input check appears on all the screens in which the field is used. Search help assignment: A search help [Page 172] can be assigned to a field.This search help defines the input help flow on a ll the screens in which the field is used. Reference field and reference table [Page 15]: You must specify the table field in which the corresponding unit of measure or currency can be found for fields containing quantities (data type QUAN) or currency amounts (data type CURR). See also: Creating Tables [Page 72] 14 April 2001 SAP AG BC – ABAP Dictionary Reference Fields and Reference Tables Reference Fields and Reference Tables You must specify a reference table for fields containing quantities (data type QUAN) or currency amounts (data type CURR).This reference table must contain a field with the format for the currency key (data type CUKY) or unit of measure (data type UNIT). This field is called the reference field of the output field. The reference field can also reside in the table itself. A field is only assigned to the reference field at program runtime. For example, if a field is filled with currency amounts, the corresponding currency is determined from the assigned reference field, that is the value entered in this field at the moment defines the currency. Table Field 1 T1 Field 3 Field 2 (CURR)Reference table Field 4 Field 5 (CUKY) T2 Field 7 Field 6 Reference field Runtime T1-Field 2 1,500. 00 T2-Field 5 DEM Table SBOOK in the flight model [Page 302] contains all the flight bookings made by customers. Field FORCURAM contains the price of the booking in the customer’s currency. Field FORCURKEY of table SBOOK contains the corresponding currency key for this price. SBOOK is therefore the reference table for field FORCURAM and FORCURKEY is the reference field for field FORCURAM. April 2001 15 BC – ABAP Dictionary Reference Fields and Reference Tables SAP AGIncludes In addition to listing the individual fields, you can also include the fields of another structure in tables [Page 13] and structures [Page 144]. Individual fields and includes can be mixed as required. Structure includes Table F1 F2 F3 F4 F5 F3 F4 F1 F2 F3 F4 F5 Databa se When an include is changed, all the tables and structures that include it are automatically adjusted. Structure A was included in table B. A new field is inserted in structure A. When structure A is activated, table B is adjusted to this change, that is the new field is also inserted there.You can assign the include a group name [Page 148] with which the group of fields in the include can be addressed as a whole in ABAP programs. Includes can also be nested, that is structure A includes structure B which in turn includes another structure C, etc. The maximum nesting depth is limited to nine. The maximum length of a path of nested includes in a table or structure is therefore nine (the table/structure itself not included). 16 April 2001 SAP AG BC – ABAP Dictionary Reference Fields and Reference Tables Table/structure U1 Include U1 U2Include U2 U3 Maximum depth = 9 Include U8 U9 Include U9 Only flat structures [Page 144] can be included. In a flat structure, every field eith er refers to a data element or is directly assigned a data type, length and possibly decimal places. Only structures may be included in a table. Tables, structures and views may be included in a structure. The length of the field names is more restricted in tables than in structures. In a table, a field name may not have more than 16 places, but in a structure up to 30 places are allowed for the field name.A structure therefore can only be included in a table if none of the field names of the structure are longer than 16 places. The path of nested includes may only contain one table. Table TAB1 includes structure STRUCT1, which in turn includes structure STRUCT2. The path of the nested includes here only contains table TAB1. It is also possible to include TAB1 in a further structure STRUCT0, but no other table TAB2 may be included in TAB1 since in this case a path of nested includes would contain two tables (TAB1 and TAB2). See also: Inserting an Include [Page 85] April 2001 17 BC à ¢â‚¬â€œ ABAP Dictionary Named Includes SAP AGNamed Includes If an include [Page 16] is used to define a database table or structure, a name can be assigned to the included substructure. The group of fields in the include can be addressed as a whole in ABAP programs with this name. In ABAP programs, you can either access the fields directly with – or analogously with –. You can access the fields of the group as a whole with -. Structure PERSON includes structure ADDRESS with the name ADR. ADDRESS has a field CITY. With PERSON-ADR you can address all the fields in structure ADDRESS. The included field CITY can also be addressed with PERSON-CITY or PERSON-ADR-CITY.You can include a structure more than once (e. g. in a period group). Since direct access by field name should be permitted here, the included field names must be renamed to ensure that they are unique. A suffix can be assigned to each group, extending the names of the group fields. The fields can then be addres sed in ABAP programs with – or –. Structure PERSON includes structure ADDRESS twice. An address is the private address with suffix H and name ADRH. The other address is the business address with suffix W and name ADRW. You can access field CITY in the private address with PERSON-CITYH or PERSON-ADRH-CITY.The functionality of the named includes in the ABAP Dictionary corresponds to the ABAP construction INCLUDE TYPE †¦ AS †¦ RENAMING †¦ . 18 April 2001 SAP AG BC – ABAP Dictionary Foreign Keys Foreign Keys You can define the relationships between tables in the ABAP Dictionary by creating foreign keys. Using foreign keys, you can easily create value checks for input fields. Foreign keys can also be used to link several tables in a view [Page 97] or a lock object [Page 209]. Field Assignment in the Foreign Key A foreign key links two tables T1 and T2 by assigning fields of table T1 to the primary key fields of table T2.Foreign key fields Foreign key t able T1 Field 1 Field 2 Field 3 Field 4 Primary key Check table Field 5 Field 6 T2 Field 7 Primary key Table T1 is called the foreign key table (dependent table) and table T2 the check table (referenced table). The pair of fields for the two tables must have the same data type and length. One field of the foreign key table therefore corresponds to each key field of the check table. This field is called the foreign key field. A foreign key permits you to assign data records in the foreign key table and check table.One record of the foreign key table uniquely identifies one record of the check table using the entries in the foreign key fields. Check Field and Value Check One of the foreign key fields is marked as the check field. This means that the foreign key relationship is maintained for this field. April 2001 19 BC – ABAP Dictionary Foreign Keys SAP AG When an entry is made in the check field, there is a check whether the check table contains a record with the key defined by the values in the foreign key fields. If this is so, the entry is valid. Otherwise the system rejects the entry.Input template for foreign key table T1 Field1 Field2 Field3 Field4 1 3 Field5 1 1 2 3 3 3 4 4 Check table T2 Field6 1 3 1 1 2 3 1 2 Field7 Text 1 Text 2 Text 3 Text 4 Text 5 Text 6 Text 7 Text 8 Input is valid since there is a corresponding record in the check table In this example the entry Field2 = 2 and Field4 = 2 would be rejected since T2 does not contain a record with the key Field5 = 2 and Field6 = 2. If you do not want to check against all the key fields of the check table, you can exclude fields of the foreign key table from the assignment of the fields to the check table with generic and constant foreign keys [Page 22].How the Input Check Works A SELECT statement is generated from the definition of the foreign key. If an entry is made in the check field, this SELECT statement is submitted. If a suitable record of the check table is found, the entry is valid. Otherwise the entry is rejected. The corresponding SELECT statement has the following form for the foreign key table shown in the above graphic: SELECT * FROM T2 WHERE T2-FIELD5 = T1-FIELD2 AND T2-FIELD6 = T1-FIELD4. A screen entry for check field Field2 is therefore only valid if the check table contains a record with the entries made in the screen for Field2 and Field4 as key.Table SBOOK in the flight model [Page 302] contains the customer’s flight bookings for a carrier. The flight bookings can be made by a travel agency or directly at the carrier’s sales counter. If the booking was made at a counter, its number is stored together with the booking in field COUNTER in table SBOOK. 20 April 2001 SAP AG BC – ABAP Dictionary Foreign Keys You must make sure that only correct counter numbers can be entered. All the counters are entered in table SCOUNTER. The necessary value check can be defined by creating a foreign key for check field COUNTNUM. Foreign key fields Foreign key table SBOOKMANDT CARRID CONNID FLDATE CUSTOMID †¦ COUNTER †¦ CANCELED Check field Check table SCOUNTER MANDT CARRID COUNTNUM AIRPORT Key fields See also: Multi-Structured Foreign Keys [Page 29] Semantic Attributes of Foreign Keys [Page 24] Creating Foreign Keys [Page 75] April 2001 21 BC – ABAP Dictionary Generic and Constant Foreign Keys SAP AG Generic and Constant Foreign Keys It is not always advisable to check a foreign key against all the key fields of the check table. This is true for example for time-dependent check tables and for check tables whose version number is a component of the key.You can use generic foreign keys in these cases. Fields are excluded from the assignment to the key fields of the check table here. The check is only against the remaining key fields. You can also assign a constant value to a key field of the check table. In this case you only have to check against the specified constant. You can use this check if only records o f the check table which contain a constant value in this key field are valid. Foreign key table FTAB Field 6 Field 7 Field 8 Field 9 Generic * Constant K Check table PTAB Field 1 Field 2 Field 3 Field 4 Field 5Primary key The corresponding SELECT statement for the screen check has the following form for the foreign key definition in the graphic: SELECT * FROM PTAB WHERE PTAB-FIELD1 = FTAB-FIELD6 AND PTAB-FIELD3 = FTABFIELD8 AND PTAB-FIELD4 = ‘K’. An entry is only valid in check field Field6 if a record of check table PTAB exists containing the input value for Field6 in PTAB-Field1, the input value for Field8 in PTAB-Field3 and constant K in PTAB-Field4. 22 April 2001 SAP AG BC – ABAP Dictionary Generic and Constant Foreign KeysInput template for foreign key table FTAB Field 6 Field 7 Field 8 Field 9 3 30 1 B Check table PTAB Field 1 Field 2 Field 3 Field 4 Field 5 1 1 2 3 3 3 4 4 1 1 1 2 1 2 1 2 1 3 1 1 2 3 3 4 A B A K A A C C Text 1 Text 2 Text 3 Text 4 Text 5 T ext 6 Text 7 Text 8 Input is valid since Field 7 and Field 9 were removed from the assignment The values entered on the screen for Field7 and Field9 are meaningless when checking against the check table. An entry with Field6 = 1, Field8 = 3 and Field9 = B would not be valid in this case since there is no record with PTAB-Field1 = 1, PTAB-Field3 = 3 and PTAB-Field4 = K in the check table!April 2001 23 BC – ABAP Dictionary Semantic Attributes of Foreign Keys SAP AG Semantic Attributes of Foreign Keys A foreign key describes a relationship between two tables. You can define this relationship more precisely by specifying the cardinality [Page 25] and type of foreign key fields [Page 26]. This information is optional and is primarily for documentary purposes. In particular, the definitions of the cardinality and type of the foreign key fields are not used in the value check for the foreign key. The definition of the semantic attributes is only sed in the following cases:  · If K ey fields of a text table is selected as the type of the foreign key fields, the foreign key table is considered to be the text table [Page 27] for the check table. If a screen field is checked against a table, the key entries of the check table are normally displayed in the input help (F4 help) for this field. If there is a text table for the check table, each key entry displayed is enhanced with an explanatory text (contents of the first character-like field of the text table) in the user’s logon language.Tables can only be included in a help view [Page 115] or maintenance view [Page 117] if they are linked with a foreign key. It only makes sense to create such a help or maintenance view if for each record in the primary table of the view there is no more than one corresponding record in each secondary table of the view. The system therefore checks if the foreign key with which the tables were linked in the view have suitable cardinalities when it creates a maintenance or h elp view. See also Restrictions for Maintenance and Help Views [Page 119]. The foreign key between tables SBOOK and SCOUNTER ensures that only existing counters can be entered in field COUNTER (counter at which the flight was booked). See the example in Foreign Keys [Page 19] . A booking can be made at either a travel agency or at the carrier’s sales counter. If the booking is made at a travel agency, the field COUNTER of table SBOOK remains empty. The foreign key fields do not have to be filled, that is the left side of the cardinality is C. Any number of bookings may be made at each counter.There may therefore be any number of entries (bookings) in foreign key table SBOOK for each record of the check table SCOUNTER. The right side of the cardinality is therefore CN. Of course several bookings can be made for the same carrier at a counter. These bookings do not differ in their foreign key fields (MANDT, CARRID, COUNTER). The entries in the foreign key fields therefore do not uniquely identify an entry in the foreign key table SBOOK (a booking). The foreign key fields therefore have the type No key fields/candidates. 24 April 2001 SAP AG BC – ABAP Dictionary Cardinality CardinalityThe cardinality (n:m) describes the foreign key relationship with regard to the number of possible dependent records (records of the foreign key table) or referenced records (records of the check table). The left side (n) of the cardinality is defined as follows:  ·  · n=1: There is exactly one record assigned to the check table for each record of the foreign key table. n=C: The foreign key table may contain records which do not correspond to any record of the check table because the foreign key field is empty. This can occur for example if the field of the foreign key table is optional, in which case it does not have to be filled. =1: There is exactly one dependent record for each record of the check table. m=C: There is at most one dependent record for each record of the check table. m=N: There is at least one dependent record for each record of the check table. m=CN: There may be any number of dependent records for each record of the check table. The right side (m) of the cardinality is defined as follows:  ·  ·  ·  · April 2001 25 BC – ABAP Dictionary Type of Foreign Key Fields SAP AG Type of Foreign Key Fields The Type of foreign key fields describes what the foreign key fields in the foreign key table mean.The following types of foreign key field can be defined:  · No key fields/candidates: The foreign key fields are neither primary key fields of the foreign key table nor do they uniquely identify a record of the foreign key table (key candidates). For this reason, the foreign key fields do not (partially) identify the foreign key table. Key fields/candidates: The foreign key fields are either primary key fields of the foreign key table or they already uniquely identify a record of the foreign key table (key candidates). The foreign key fields therefore (partially) identify the foreign key table.Key fields of a text table: The foreign key table is a text table [Page 27] for the check table, that is the key of the foreign key table only differs from the key of the check table in that it has an additional language key field. This is a special case of the type Key fields/candidates.  ·  · 26 April 2001 SAP AG BC – ABAP Dictionary Text Tables Text Tables Table A is a text table of table B if the key of A comprises the key of B and an additional language key field (field of data type LANG). Table A may therefore contain explanatory text in several languages for each key entry of B.To link the key entries with the text, text table A must be linked with table B using a foreign key. Key fields of a text table must be selected here for the type of foreign key fields (see Semantic Attributes of Foreign Keys [Page 24]). Table B Key fields K1 and K2 K1 †¦ 1 1 †¦ K2 †¦ 1 2 †¦ F1 à ¢â‚¬ ¦ XX YY †¦ F2 †¦ YY XX †¦ Text table A for B Key fields K1, K2 and L (type LANG) K1 †¦ 1 1 1 1 †¦ K2 †¦ 1 1 2 2 †¦ L †¦ DE EN DE EN †¦ TEXT †¦ Text 1 (German) Text 1 (English) Text 2 (German) Text 2 (English) †¦ Text foreign keyIf table B is the check table of a field, the existing key entries of table B are displayed as possible input values when the input help (F4) is pressed. The explanatory text (contents of the first character-like non-key-field of text table A) is also displayed in the user's logon language for each key value in table B. April 2001 27 BC – ABAP Dictionary Text Tables SAP AG Hit list if user logs on in English K1 †¦ 1 1 K2 †¦ 1 2 †¦ Text †¦ Text1 (English) (English) Text2 (English) (English) †¦ Maintenance screen Field 1 Field 2 †¦ Call the input help Field is checked against table BOnly one text table can be created for table B! The system checks this when you atte mpt to activate a table with text foreign keys for B. 28 April 2001 SAP AG BC – ABAP Dictionary Multi-Structured Foreign Keys Multi-Structured Foreign Keys When you define a foreign key, a field of the work area that is not contained in the foreign key table can also be assigned to a check table (for example a field of another table). This is possible for all fields except for the check field. Table T2 is the check table of foreign key table T1. Field F of the work area is assigned to key field Field6 of check table T2.Foreign key table T1 Field 1 Field 2 Field 3 Field 4 Primary key Field F of work area Check table T2 Field 5 Field 6 Field 7 Primary key The corresponding SELECT statement for the input check is then: SELECT * FROM T2 WHERE T2-FIELD5 = T1-FIELD2 AND T2-FIELD6 = F. If an entry is made in field T1-Field2 (check field), this SELECT statement will be submitted. If a corresponding record is found, the entry is valid; otherwise it is rejected. If a field that is not contained in the foreign key table is assigned to a field of the check table, this field must be filled at the time of the input check.Otherwise the check always fails, and no values can be entered in the check field. April 2001 29 BC – ABAP Dictionary Technical Settings SAP AG Technical Settings The technical settings of a table define how the table will be handled when it is created in the database, that is whether the table will be buffered and whether changes to data records of the table will be logged. The most important parameters are:  ·  · Data class: The data class [Page 31] defines the physical area of the database (tablespace) in which the table should be created. Size category: The size category [Page 32] defines the size of the extents created for the table.When the table is created in the database, the required information about the memory area to be selected and the extent size is determined from the technical settings.  ·  · Buffering permission: The b uffering permission [Page 33] defines whether the table may be buffered. Buffering type: If the table may be buffered, you must define a buffering type (full, singlerecord, generic). The buffering type [Page 34] defines how many table records are loaded into the buffer when a table entry is accessed. Logging: This parameter defines whether changes to the table entries should be logged.If logging [Page 41] is switched on, each change to a table record is recorded in a log table.  · The Convert to transparent table flag (transparent flag [Page 42]) is also displayed for pooled tables or for tables which were converted into transparent tables earlier on with this flag. See also: Maintaining Technical Settings [Page 77] Buffering Database Tables [Page 43] 30 April 2001 SAP AG BC – ABAP Dictionary Data Class Data Class If you choose the data class correctly, your table is automatically assigned to the correct area (tablespace or DBspace) of the database when it is created.Each d ata class corresponds to a physical area in which all the tables assigned to this data class are stored. There are the following data classes:  ·  ·  · APPL0 (master data): Data which is seldomly changed. An example of master data is the data contained in an address file, such as the name, address and telephone number. APPL1 (transaction data): Data that is frequently changed. An example of transaction data is the goods in a warehouse, which change after each purchase order. APPL2 (organizational data): Customizing data that is defined when the system is installed and seldomly changed.An example is the table with country codes. Two further data classes, USR and USR1, are provided for the customer. These are for user developments. The tables assigned to these data classes are stored in a tablespace for user developments. Tables in the ABAP Dictionary Master data Table 1 Table 3 Organizational data Table 2 Transaction data Table 4 Table 7 System data Table 5 Table 6 Tablespace m aster data Table 1 Table 3 Tablespace Org. data Table 2 Tablespace Trans. data Table 4 Table 7 Tablespace System data Table 5 Table 6 Database April 2001 31 BC – ABAP Dictionary Size Category SAP AG Size CategoryThe size category defines the expected space required for the table in the database. You can choose a size category from 0 to 4 for your table. Each category is assigned a certain fixed memory size in the database, which depends on the database system used. When a table is created, initial space (an Initial Extent) is reserved in the database. If more space is required at a later time due to data entries, additional memory will be added depending on the selected size category. Technical settings Size category TABA 1 3 4 TABB TABC Initial First Second Extent Extent Extent TABA TABB TABC †¦ †¦ †¦Database Selecting the correct size category prevents a large number of very small extents from being created for a table. It also prevents space from being waste d if extents which are too large are created. 32 April 2001 SAP AG BC – ABAP Dictionary Buffering Permission Buffering Permission You must define whether and how a table is buffered in the technical settings for the table. There are three possibilities here:  · Buffering not permitted: Table buffering is not permitted, for example because application programs always need the most recent data from the table or the table is changed too frequently.Buffering permitted but not activated: Buffering is permitted from the business and technical points of view. Applications which access the table execute correctly with and without table buffering. Whether or not table buffering will result in a gain in performance depends on the table size and access profile of the table (frequency of the different types of table access). Table buffering is deactivated because it is not possible to know what these values will be in the customer system. If table buffering would be advantageous for th e table size and access profile of the table, you can activate it in the customer system at any time.Buffering activated: The table should be buffered. In this case you must specify a buffering type [Page 34].  ·  · See also: Buffering Database Tables [Page 43] Which Tables Should be Buffered? [Page 53] April 2001 33 BC – ABAP Dictionary Buffering Types SAP AG Buffering Types The buffering type defines which table records are loaded into the buffer of the application server when a table record is accessed. There are the following buffering types:  ·  · Full buffering [Page 35]: All the records of the table are loaded into the buffer when one record of the table is accessed.Generic buffering [Page 37]: When a record of the table is accessed, all the records having this record in the generic key fields (part of the table key that is left-justified, identified by specifying a number of key fields) are loaded into the buffer. Single-record buffering [Page 39]: Only the re cords of a table that are really accessed are loaded into the buffer.  · See also: Buffering Database Tables [Page 43] 34 April 2001 SAP AG BC – ABAP Dictionary Full Buffering Full Buffering With full buffering, either the entire table is in the buffer or the table is not in the buffer at all.All the records of the table are loaded into the buffer when one record of the table is read. In this example, a program reads the record highlighted in red from table SCOUNTER. If the table is fully buffered, all the records of the table are loaded into the buffer. Database table SCOUNTER MANDT CARRID COUNTNUM AIRPORT Buffer contents 001 001 001 001 001 001 001 001 001 001 001 001 001 001 AA BA BA BA BA LH LH LH LH LH LH LH LH UA 00000001 00000001 00000002 00000003 00000004 00000001 00000002 00000003 00000004 00000005 00000006 00000007 00000008 00000001 ACA ACE BER LCY LHR BER DEN FRA LCY LGW LHR MUC RTM HAM 01 001 001 001 001 001 001 001 001 001 001 001 001 001 AA BA BA BA BA LH LH L H LH LH LH LH LH UA 00000001 00000001 00000002 00000003 00000004 00000001 00000002 00000003 00000004 00000005 00000006 00000007 00000008 00000001 ACA ACE BER LCY LHR BER DEN FRA LCY LGW LHR MUC RTM HAM Application server SELECT * FROM SCOUNTER WHERE MANDT = ‘001’ AND CARRID = ‘LH’ AND COUNTNUM = ‘00000004'. The buffered data records are sorted in the buffer by table key. Accesses to the buffered data can therefore only analyze field contents up to the last specified key field for restricting the dataset to be searched.The left-justified part of the key should therefore be as large as possible in such accesses. For example, if you do not define the first key field, the system has to scan the full table. In this case direct access to the database can be more efficient if the database has suitable secondary indexes [Page 61]. When Should you Use Full Buffering? When deciding whether a table should be fully buffered, you should take into account the size of the table, the number of read accesses, and the number of write accesses. Tables best suited to full buffering are small, read frequently, and rarely written.Full buffering is recommended in the following cases: April 2001 35 BC – ABAP Dictionary Full Buffering  · SAP AG Tables up to 30 KB in size. If a table is accessed frequently, but all accesses are read accesses, this value can be exceeded. However, you should always pay attention to the buffer utilization. Larger tables where large numbers of records are frequently accessed. If these mass accesses can be formulated with a very selective WHERE condition using a database index [Page 61], it could be better to dispense with buffering.Tables for which accesses to non-existent records are frequently submitted. Since all the table records reside in the buffer, the system can determine directly in the buffer whether or not a record exists.  ·  · 36 April 2001 SAP AG BC – ABAP Dictionary Generic Buffering Generi c Buffering With generic buffering, all the records in the buffer whose generic key fields match this record are loaded when one record of the table is accessed. The generic key is a part of the primary key of the table that is left-justified. In this example, the record highlighted in red is read by a program from table SCOUNTER.If the table is generically buffered, all the records read whose generic key fields (MANDT and CARRID) agree are loaded into the buffer. Database table SCOUNTER MANDT CARRID COUNTNUM AIRPORT Buffer contents 001 001 001 001 001 001 001 001 LH LH LH LH LH LH LH LH 00000001 00000002 00000003 00000004 00000005 00000006 00000007 00000008 BER DEN FRA LCY LGW LHR MUC RTM 001 001 001 001 001 001 001 001 001 001 001 001 001 001 AA BA BA BA BA LH LH LH LH LH LH LH LH UA 00000001 00000001 00000002 00000003 00000004 00000001 00000002 00000003 00000004 00000005 00000006 00000007 00000008 00000001ACA ACE BER LCY LHR BER DEN FRA LCY LGW LHR MUC RTM HAM Application server Generic key SELECT * FROM SCOUNTER WHERE MANDT = ‘001’ AND CARRID = ‘LH’ AND COUNTNUM = ‘00000004'. When Should you Use Full Buffering? A table should be buffered generically if only certain generic areas of the table are normally needed for processing. Client-specific, fully-buffered tables are automatically generically buffered since normally it is not possible to work in all clients at the same time on an application server. The client field is the generic key. Language-specific tables are another example where generic buffering is recommended.In general, only records of one language will be needed on an application server. In this case, the generic key includes all the key fields up to and including the language field. How Should you Define the Generic Key? In generic buffering, it is crucial to define a suitable generic key. April 2001 37 BC – ABAP Dictionary Generic Buffering SAP AG If the generic key is too small, the buffer will contain a few very large areas. During access, too much data might be loaded in the buffer. If the generic key is too large, the buffer might contain too many small generic areas.These can reduce buffer performance since there is an administrative entry for every buffered generic area. It is also possible that too many accesses will bypass the buffer and go directly to the database, since they do not fully define the generic key of the table. If there are only a few records in each generic area, it is usually better to fully buffer the table. Only 64 bytes of the generic key are used. You can specify a longer generic key, but the part of the key exceeding 64 bytes is not used to create the generic areas. Access to Buffered DataIt only makes sense to generically buffer a table if the table is accessed with fully-specified generic key fields. If a field of the generic key is not assigned a value in a SELECT statement, it is read directly from the database, bypassing the buffer. If you access a generic area that is not in the buffer with a fully-specified generic key, you will access the database to load the area. If the table does not contain any records in the specified area (â€Å"No record found†), this area in the buffer is marked as non-existent. It is not necessary to access the database if this area is needed again. 8 April 2001 SAP AG BC – ABAP Dictionary Single-Record Buffering Single-Record Buffering With single-record buffering, only the records that are actually read are loaded into the buffer. Single-record buffering therefore requires less storage space in the buffer than generic and full buffering. The administrative costs in the buffer, however, are greater than for generic or full buffering. Considerably more database accesses are necessary to load the records than for the other buffering types. In this example, the record highlighted in red is read by a program from table SCOUNTER.If single-record buffering is selected for the table, onl y the record that was read is loaded into the buffer. Database table SCOUNTER MANDT CARRID COUNTNUM AIRPORT Buffer contents 001 LH 00000004 LCY 001 001 001 001 001 001 001 001 001 001 001 001 001 001 AA BA BA BA BA LH LH LH LH LH LH LH LH UA 00000001 00000001 00000002 00000003 00000004 00000001 00000002 00000003 00000004 00000005 00000006 00000007 00000008 00000001 ACA ACE BER LCY LHR BER DEN FRA LCY LGW LHR MUC RTM HAM Application server SELECT SINGLE FROM SCOUNTER WHERE MANDT = ‘001’ AND CARRID = ‘LH’ AND COUNTNUM = ‘00000004'.When Should you Use Single-Record Buffering? Single-record buffering should be used particularly for large tables where only a few records are accessed with SELECT SINGLE. The size of the records being accessed should be between 100 and 200 KB. Full buffering is usually more suitable for smaller tables that are accessed frequently. This is because only one database access is necessary to load such a table with full buffering, whereas several database accesses are necessary for single-record buffering. Access to Buffered Data All accesses that are not submitted with SELECT SINGLE go directly to the database, bypassing the buffer.This applies even if the complete key is specified in the SELECT statement. April 2001 39 BC – ABAP Dictionary Single-Record Buffering SAP AG If you access a record which is not yet buffered with SELECT SINGLE, there is a database access to load the record. This record is marked in the buffer as non-existent if the table does not contain a record with the specified key. This prevents another database access when accessing the table at a later time with the same key. 40 April 2001 SAP AG BC – ABAP Dictionary Logging Logging Using the logging flag you can define whether changes to the data records of a table should be logged.If logging is switched on, each change to an existing data record (with UPDATE, DELETE) by the user or application program is recorded in the data base in a log table (DBTABPRT). ABAP Dictionary Log TAB Application transaction TAB Change a record Field 1 Field 2 Field 3 System profile †¦ rec/client =ALL †¦ TAB Field 1 Field 2 Field 3 Log table Database To switch on logging, the R/3 System must be started with a profile containing parameter rec/client. This parameter defines whether all clients or only selected clients should be logged. The parameter can have the following values: rec/client = ALL Log all clients. ec/client = 000[,†¦ ] Log the specified clients. rec/client = OFF Do not log. Logging slows down accesses that change the table. First of all, a record must be written in the log table for each change. Secondly, a number of users access this log table in parallel. This can cause lock situations although the users are working with different application tables. Logging is independent of the update. The existing logs can be displayed with Transaction Table History (SCU3). April 2001 41 BC – ABAP Dic tionary Converting Pooled Tables to Transparent Tables SAP AG Converting Pooled Tables to Transparent Tables