topic Re: Difference between table CAUFV and AUFK in Application Development and Automation Discussions

Difference between table CAUFV and AUFK

Former Member — Tue, 24 Nov 2015 04:09:34 GMT

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.

Re: Difference between table CAUFV and AUFK

sundaramoorthy_ramalingam — Tue, 24 Nov 2015 04:33:15 GMT

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.

Re: Difference between table CAUFV and AUFK

jogeswararao_kavala — Tue, 24 Nov 2015 16:05:05 GMT

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.