topic Re: hi in Application Development and Automation Discussions

hi

Former Member — Mon, 05 May 2008 16:13:14 GMT

kindly tell me examples of transparent tables

Re: hi

Former Member — Mon, 05 May 2008 16:14:15 GMT

hi,

VBAK, VBAP, LIPS are transparent tables..

Transparent Table

A transparent table is created automatically on the database when it is activated in the ABAP Dictionary. At this time, the database-independent description of the table in the ABAP Dictionary is translated into the language of the database system used.The database table has the same name as the table in the ABAP Dictionary. The fields also have the same names in both the database and the ABAP Dictionary. The data types in the ABAP Dictionary are converted to the corresponding data types of the database system.

The order of the fields in the ABAP Dictionary can differ from that of the fields on the database. This permits you to insert new fields without having to convert the table. When you add a new field, adjust the order of the fields by changing the database catalog (ALTER TABLE). The new field is added to the database table.

ABAP programs can access a transparent table in two ways. One way is to access the data contained in the table with OPEN SQL (or EXEC SQL). With the other method, the table defines a structured type that is accessed when variables (or more complex types) are defined.

You can also create structured types in the ABAP Dictionary for which there are no corresponding objects in the database. These types are called structures. Structures can also be used to define the types of variables.

Regards,

Santosh

Re: hi

Former Member — Mon, 05 May 2008 16:17:51 GMT

Transparent Table : Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

MARA - General Material Data

KNA1 - General Data in Customer Master

KNVV - Customer Master Sales Data

Re: hi

Former Member — Mon, 05 May 2008 16:26:12 GMT

Hi Ashwani,

One Sincere advise from my end would be .....

Before you post your questions in SDN try to search the forum first.

Go to the page where you are posting the questions there you will see search forum just click on that then it will take you to the next page there just type what ever u r looking for. U will get lot of similar threads all these basic questions discussed before many times.

Y I am saying this to u means it will save lot of time for you. Rather than posting the question and waiting for the replies from someone u can directly search the forum in this way u can save lot of time and u can search more.

This is an advise if you feel bad sorry to say..............

Re: hi

Former Member — Mon, 05 May 2008 16:28:41 GMT

Hi Ashwani,

A transparent table is a table that stores data directly. You can read these tables directly on the database from outside SAP with for instance an SQL statement.

Transparent table is a one to one relation table i.e. when you create one transparent table then exactly same table will create in data base and if is basically used to store transaction data.

some more examples

VBAK ---> Sales Document: Header Data

VBAP ---> Sales Document: Item Data

MARC ---> Plant Data for Material

MARD ---> Storage Location Data for Material

Best regards,

raam

Re: hi

Former Member — Mon, 05 May 2008 16:28:45 GMT

hi,

I appreciate Naveen's approach ....Please do that in order to save time and to avoid repeatitive questions ...

Regards,

Santosh

Re: hi

Former Member — Mon, 05 May 2008 16:32:36 GMT

Hi Ashwani,

Transparent Table : Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

A transparent table is a table that stores data directly. You can read these tables directly on the database from outside SAP with for instance an SQL statement.

Transparent table is a one to one relation table i.e. when you create one transparent table then exactly same table will create in data base and if is basically used to store transaction data

Transparent tables are a representation of the way SAP R/3 interacts with the DBMS that actually stores the data, such as Oracle. This is just the manner in which data is made available to an ABAP/4 program by the R/3 Basis System and is NOT a user-defined or controlled specification.

The database table has the same name as the table in the ABAP/4 Dictionary. The fields also have the same names in both the database and in the ABAP/4 Dictionary. The data types in the ABAP/4 Dictionary are converted to the corresponding data types of the database system.

Beginning with Release 3.0, the sequence of fields in the ABAP/4 Dictionary can vary from the sequence of fields in the database. This allows you to insert new fields without having to convert the table by performing a physical reorganization. When adding new fields, the adjustment is made by changing the database catalog (ALTER TABLE). A new field is appended to the database table, regardless of its position in the ABAP/4 Dictionary.

Pls reward if useful.

Thanks,

Sirisha.