help on views

Former Member · ‎06-30-2007

could any body help on creating classification view basically please send some code ....

i am new in sap

if possible help me on the below issue

i have done bdc recording for mm01 and mm02 for creating or updating material number into sap system .. there is a column called division in legacy system for that column division three values are there. they are 009,004,001.. they might have created classification view for division 009 materials.

how to find if there is any classification view created for division 004 materials .

now i was asked to create classification view for 001 and 004 division materials ...

Former Member · ‎07-02-2007

Hi

Data about an application object is often distributed on several tables. By defining a view, you

can define an application-dependent view that combines this data. The structure of such a view is

defined by specifying the tables and fields used in the view. Fields that are not required can be

hidden, thereby minimizing interfaces. A view can be used in ABAP programs for data selection.

Four different view types are supported. These differ in the way in which the view is implemented

and in the methods permitted for accessing the view data.

1. Database views are implemented with an equivalent view on the database.

2. Projection views are used to hide fields of a table (only projection).

3. Help views can be used as selection method in search helps .

4. Maintenance views permit you to maintain the data distributed on several

tables for one application object at one time.

Example:

Travel agencies often have to check what customer is booked on what flights (see the Flight Model The corresponding data is distributed on several tables:

1. SCUSTOM: Customer data such as the customer number, name, address.

2. SBOOK: Booking data such as the carrier, flight number, passenger (customer number).

3.SPFLI: Flight data such as the city of departure and destination.

You can get an overall view of all existing bookings by creating a view on tables SCUSTOM,

SBOOK and SPFLI.

You can determine all the bookings in table SBOOK for a customer number (ID) for the customer

number in table SCUSTOM. Using the carrier ID (CARRID) and the flight number (CONNID), the

flight information can be read from table SPFLI for a booking that is found.

This results in the following join conditions for the view:

SBOOK-MANDT = SCUSTOM-MANDT

SBOOK-CUSTOMID = SCUSTOM-ID

SPFLI-MANDT = SBOOK-MANDT

SPFLI-CARRID = SBOOK-CARRID

SPFLI-CONNID = SBOOK-CONNID

MANDT CARRID CONNID FLDATE BOOKID CUSTOMID ... SBOOK

MANDT CARRID CONNID ...CITYFROM ...CITYTO ... SPFLI

001

MANDT ID NAME CITY ... SCUSTOM

001 122356 Smith New York ...

122356

...

001

New York

Berlin Tokyo

AA Berlin

AA

LH

48

324

48

...

3689

3690

...

The join conditions can also be derived from the existing foreign key relationships between the tables of the view