tables

[Former Member]

hi friends,

what is the use of knowing tables for a functional consultant???

how can i analyse the tables ???

tell me the right way of learning SD with Tables??

thanks

raj

[Former Member · Accepted solution]

Hi Raj,

Tables are the heart of SAP.

1) Suppose you need to develop a report for the business for example customer and material combination report .Then what will you do without knowing the tables?

You need to tell the ABAPer from where he need to get the data from ie from which table so that he can develop a report according to the requirement.

Ex:

Select kunnr form kna1 into table itab where kna1 = p_kunnr.

In the above statement kna1 is the customer master table where kunnr( customer number) will be there , so the ABAPer will use the above statement to get the data ie customer number and then displays in the report.

2)suppose you want to see the list of customers created in the company code , then how you will get that?

For this answer pls look at this thread.

3) Important tables in sd

http://www.sap-img.com/sap-sd/important-tables-for-sap-sd.htm

4)suppose you want to see the sales order created by you then what will you do?

Maybe you will go to va05 etc.

but simple way is goto table vbak , and here input your name , sales org , date of creation , sales doc type etc , you will see the sales order.

5) For developing the bdc programs you need to tell to the ABAPer the field names to upload the data .

There is much more to say about tables , so if you till have any more queries pls feel free to ask ,

Regards,

Vvieks

[Former Member]

Dear Rajan,

One aspect:

Knowing Tables & Structures, help a Functional Consultant, in order to guide ABAPer (also the BASIS with Object types, Info types etc..), whenever some Customization/ Development requires, to meet Clients' requirement, which can't be ful-filled with Standard.

In one of the recent post, I have refered one such link - SD Tables and Structures.

[SD Tables and Strucutres|https://www.sdn.sap.com/irj/scn/wiki?path=/display/erplo/sd%252brelated%252btables%252band%252bstructures]

To view & understand the Tables, You may use SE11/ SE16

Best Regards,

Amit

[Former Member]

hi,

if we go se11 or se16 can we change data or only analyse the data???

regards

raj

[Former Member]

Dear Rajan,

With T. Code: SE16, can't be changed.

With t. Code: SE11, you need to have Access-Key, for Create/ Changes.

Best Regards,

Amit

[Former Member]

Hi Raj,

We cannot change the data with se11 and se16, anyway you wont get the authorization for se11 it is used by ABAPers , you will get se12 and se16

SE11 -> For creation of the table

SE12 -> To display the table fields ( like kunnr , vkorg , spart , burks etc)

SE16 -> To display the table contents.

SM30 -> With this we can insert the data.

There are two ways of inserting the data into the table.

1) Through ABAP program insert statements ( and bdc programs , lsmw and bapis for multiple tables at a time)

2)Through table maintenance generator

Table maintanance Generator is used to manually

input values using transaction sm30.The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator

Regards,

Vvieks