cancel
Showing results for 
Search instead for 
Did you mean: 

Control tables in SD

Former Member
0 Kudos

In the SD certification material , its said that various masters and control tables are used for processing the sales order .can any one explain me what is control table?

Rgds

Ramprasad

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Ram Prasad,

Please find below the information :

1) Screen tables

A table can be created in transaction. These tables, when designed on the screen are called as SCREEN TABLES.

These are of two types.

Table Controls and Step loops

These tables are treated as Loops.

2)Features of Table Controls

Data is displayed in the form of table.

Table control gives user the feeling of an actual table.

You can scroll through the table vertically as well as horizontally.

You can select rows and columns.

You can resize the with of columns.

You can have separator lines between rows and columns.

Automatic resizing of the table when the user resizes the window.

You can update information in the table control and it can be updated in the database table by writing code for it.

3)Steps for creating table control

Declaration of table control in module pool program.

Designing of table controls on the screen.

Passing data to table control in flow logic.

4)Declaration of TC in MPP

syntax:

controls <name of table control> type tableview using screen <escreen no.f>.

5)Designing Table control on screen

Click on Table in Control bar and place it on the screen. You can adjust the length and width of the Table Control.

Name the table control.(same name as given in data declaration).

From dictionary object OR from program fields select the fields and place them in the table control

6)Passing data to table control

Usually transfer of data from program to screen is automatic.

In case of TC, you need to explicitly transfer the data to table control.

ABAP/4 provides Loop statement, which is associated with flow logic to transfer the data.

7)Passing of data contd.

PBO.

Loop at <name of internal table> with control <name of table control> cursor <scroll variable>.

modulecc.

Endloop.

PAI.

Loop at < name of internal table>.Endloop.

8)Scroll variables

Top_line : the row of table where the screen display starts.

Current_line : the row currently being processed inside a loop.

9)Transfer of data from prg to TC.

With eLoop at cf statement, the first row is placed in the header of internal table.

If any module is specified between Loop and End loop, it will be executed. In this module, generally we will be assigning this internal table fields to table control screen fields.

The row in internal table is transferred to the TC as stated in the eLoop atc..f statement.

The system encounters the eEndloopf statement and control is passed back to the next line of internal table.

In the same way all the records of the internal table are passed to the TC.

Find the fallowing some tables avail in SD

SAP SD Tables

VBAK -


(SALES DOC HEADER)

VBAP -


(SALES DOC ITEM)

VBFA -


(SALES DOC FLOW)

VBUK -


(SALES DOC HEAD. STATUS)

VBUP -


(SALES DOC ITEM STATUS)

LIKP -


(DELIVERY HEAD DATA)

LIPS -


(DELIV ITEM DATA)

MSEG -


(MAT DOC SEGMENT)

MKPF -


(MAT.DOC)

VBRK -


(INV HEADER)

VBRP -


(INV ITEM)

BSEG -


(ACC DOC SEGMENT)

BKPF -


(ACC DOC HEADER)

KNA1 --- General Data in Customer Master

KNB1 --- Customer Master (Company Code Data)

KNVV --- Customer Master Sales Data

MARA --- General Material Data

MARC --- Plant Data for Material

MVKE --- Sales Data for Material

Please Reward If Really Helpful,

Thanks and Regards,

Sateesh.Kandula

Former Member
0 Kudos

hi

Simply i can say that Masters in scence Material master, Customer master and Pricing master. and coming to Control tables order types, item category and scheduling category types... i think so.............!

Former Member
0 Kudos

hi,

as per my idea it is ,

all the master records like MMR, CMR or CMIR or organisation structure,pricing and all master records ...so what ever data you maintain in these records gets stored in tables.

coming to sales order ,billing or delivery ,the data what ever you see in this will be copied from master records or master tables.

so in these process tha data get stored in structure (combination of tables) but not in the table.

finally what ever table you want to check at the time of SO system will show it in structures but not in tables.i think this is clear.

Edited by: MANI ROOPA SD/MM on Apr 23, 2008 1:25 PM