table relationships for ca23

In the standard t-code CA23 ,we can display specific material's rate routing.In this blog i will show some tables which contain data in the control table of the CA23.

TABLES: MAPL,PLKO,PLPO,PLFL,PLAS,PLFH,CRHD.

Use these tables ,now we can trace standard t-code ca23.

1: Enter the t-code CA23.

2: Go to the first screen,now we can input the material number and plant.These two fields map to MAPL-MATNR and MAPL-WERKS. Leave other fields in the first screen default values.

3: After complete these two fields , chick 'Routing' button on the application toolbar.We can get the routing overview.In the header overview control table ,we can see several tasks of a product.These lines can be get by below SQL statement.
SELECT plnnr plnal FROM MAPL
                WHERE matnr EQ material  AND
                                werks EQ plant       AND
                                plnty    EQ 'R'           AND
                                loekz   NE 'X'.
OK,now we have obtain all tasks of a specific material.
^&^  If you want to get detail routing infomation, you access PLKO table use plnnr and plnal which we obtain just.

4: Select one item in the header overview control table,then click the 'Sequences' button.We will get the sequences of this selected task.Next,we will use below SQL statement to get the contents of 'Parallel Seqs' control table.
SELECT * FROM PLFL
                WHERE plnty EQ 'R'        AND
                                plnnr EQ plnnr  AND
                                plnal EQ selected plnal.

5: Select one line in the 'Parallel Seqs' control table ,click the 'Operations' button.we will get the detail infomation of this sequence.We use below SQL statement.
SELECT * FROM PLAS
                 WHERE plnty EQ 'R'                 AND
                                 plnnr EQ plnnr           AND
                                 plnal EQ plnal           AND
                                 plnfl  EQ plnfl.
SELECT * FROM PLPO
                 WHERE plnty  EQ 'R'               AND
                                 plnnr EQ plnnr          AND
                                 plnkn EQ plnkn.
SELECT arbpl FROM CRHD WHERE OBJTY EQ 'A' AND ARBID EQ PLPO-ARBID. " WORK CENTER
The result of the SQL statement are the same with the 'Operation overview' control table.

OK,that is all.

Next blog i will explain some steps that use BDC way to call CA22.