Tables

[Former Member]

Hai,

1. In SE 11 we get to know about the tables. But what information we will try to know from these tables. For what purose we refer to these tables?

2. how we will check the orders that were partially delivered?

3. What is the diffrnce between creating vendor in XK01 and v-11?

Regards,

Keyur

[Former Member · Accepted solution]

Hi Keyur,

1) Better go with T.Code SE16 to know the value of the fields in the table. T.Code se11 gives you the list of fields relating to the particular table, which is of very less use for a consultant. If we are interested in knowing for a particular field of a particular table then we use SE11. But we get all the values of the fields in table SE16 only. Just for better understanding, goto T.Code se16 and give the table name VBAK and in the selection screen give some selection option and execute. you will understand.

2) to chek the orders that are partially delivered goto T.Code VA05 and press enter give the sales area, and in status field, the value B refers that the order is partially delivered.

3) falls strictly under MM module so, not sure......

cheers,

anil.

[Former Member]

Hello keyur,

http://help.sap.com/saphelp_nw04/helpdata/en/76/489d39d342de00e10000000a11402f/content.htm

A table is a set of rows. Each row in a table has the same number of columns and contains a value for each column. A system table is a base table that contains system information (information about the database objects, states, statistics, monitor data; loader system ...etc. The SAP DB database system contains a series of system tables that contain information about the database objects and their connection to each other, statistics system tables, and monitor system tables.

Table Types

Base table: System tables and all tables containing application data are base tables. Base tables are saved permanently

Result table: The database system creates unnamed result tables when a SELECT statement is executed and then deletes them at the end of the session.

The database system creates named result tables when a DECLARE CURSOR statement is executed.

Join table: A join table is a special result tables that the database system creates when two or more tables are linked.

System table: A system table is a base table that contains system information (information about the database objects, states, statistics, monitor data; loader system tables).

Temporary table: A temporary table is a special base table that the database system deletes at the end of the session. Temporary tables belong to the TEMP schema.

View table: A view table is derived from a base table and its definition is saved permanently. View tables themselves contain no data, they only provide a view of the data.

Look out this link and se if this helps you

http://help.sap.com/saphelp_nw04/helpdata/en/76/489d39d342de00e10000000a11402f/content.htm

Hope this helps you

<b>***reward if this helps**</b>

Regards

AK

[Former Member]

hi,

answering your second question, to check orders with partial deliveries we can look the order header status and it would be partially delivered.

Now this piece info is actually stored in VBUK- document header status. this answers your first question. So tables provide us with the connecting info say when we want to create some reports.

we have std. t.code VA05 to check open orders ( they are nothing but partially delivered orders). The information is pulled from the tables.

Hope this helps. Pl reward if useful.

Thanks,

Sadhu Kishore

[Former Member]

1) we know abt wat data stored in wat tables.. and their relationship with tables and fields...

2)in delivery list we know wat are all partial delivered.

[Former Member]

Hello Keyur,

Question 1:

SE11 is basically used to create, change or display the contents of a table (with proper authorisation.

The transactional data after processing a transaction is stored in the form of fields in a table. for example - VBAK (sales header), VBAP (item level) etc.

Through SE11 you can see what values are being stored during a transaction process in a particular table.

Question 2:

You can use Transaction VA05 (open orders) to see partially delivered sales orders.

<b>Reward if helps</b>

Regards

Sai