Difference between table CAUFV and AUFK

[Former Member]

Hi all -

I would like to make a query about the difference between WO data retrieval from tables CAUFV(View "Order Headers PP/CO") and AUFK(Order master data). Since CAUFV is a view table, it is taking more time to retrieve rather than retrieving from AUFK.

However, if I take from AUFK I am afraid I will get inconsistent data since CAUFV has some checks with other tables. All the field values I need in CAUFV are actually in table AUFK as well.

a. Is there any impact if I change from CAUFV to AUFK?

b. Please also advise if I can do the same for tables VIQMEL and QMEL.

[sundaramoorthy_ramalingam]

Hi,

     The data base view CAUFV contains only the common data that are present between the two tables the order header table AFKO and AUFK

it uses the join condition for the field AUFNR(AFKO) to retrieves the data this condition happens internally in the view so this takes time to retrieve the data.

Hope this helps.

[jogeswararao_kavala]

a) When you say you are getting all fields in AUFK, then there is no impact when you switch to AUFK table from CAUFV.

b) Similarly if you have all your fields in QMEL, there is not impact of you prefer QMEL to VIQMEL.