Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

View CAUFV

Former Member

‎2007 Jun 22 9:35 AM

0 Likes
1,480

Hi,

I have some doubt about standard view CAUFV. 


FIELDS     DTYPE    LENGTH   Short Description
*		0	                                                            
MANDT	CLNT	3	Client
AUFNR	CHAR	12	Order Number
AUART	CHAR	4	Order Type
AUTYP	NUMC	2	Order category
REFNR	CHAR	12	Reference order number
ERNAM	CHAR	12	Entered by 
-	NUMC	2	Status reached so far
-	CHAR	1	Phase "Order created"
-	CHAR	1	Phase "Order released"

The view appears like above.

1. what does that '*' and '-' means in the viewfields???

2. Now, when i am trying to see the entries in our client system it is giving Dump. but in other server it is not giving dump. What can be the reason???

Dump Description: SQL error in the database when accessing a table.

Missing Handling of System Exception
    Program                                 /1BCDWB/DBCAUFV

Trigger Location of Exception
    Program                                 /1BCDWB/DBCAUFV
    Include                                 /1BCDWB/DBCAUFV
    Row                                     548
    Module Name                             START-OF-SELECTION


524   concatenate '/1BCDWB/DB' 'CAUFV' into g_dbdatakey-eu_name.
525   g_dbdatakey-username = c_all.
526   import sort_NAME_TAB to %_TAB2_sort
527          field_name_tab to %_TAB2_field
528          from database dbdata(DB) id g_dbdatakey.
529   if sy-subrc = 0.
530     delete from dbdata
531           where relid    = 'DB' and
532                 eu_name  = g_dbdatakey-eu_name and
533                 username = c_all.
534     describe table %_tab2_field lines %_l_lines.
535     if not %_l_lines is initial.
536       %_TAB2[] = %_tab2_field[].
537     endif.
538   endif.
539 ENDIF.
540 CASE ACTION.
541   WHEN 'ANZE'.
542 try.
543 SELECT * FROM CAUFV                     "client specified
544                  APPENDING TABLE ICAUFV
545                  UP TO RSEUMOD-TBMAXSEL ROWS BYPASSING BUFFER
546    WHERE AUFNR IN I1.
547
>>>   CATCH CX_SY_DYNAMIC_OSQL_SEMANTICS INTO xref.
549     IF xref->kernel_errid = 'SAPSQL_ESCAPE_WITH_POOLTABLE'.
550       message i412(mo).
551       exit.
552     ELSE.
553       RAISE EXCEPTION xref.

Please help if any one has any pointer.

Thanks & Regards,

Abhishek Sarkar

Hi,

I have some doubt about standard view CAUFV. 


FIELDS     DTYPE    LENGTH   Short Description
*		0	                                                            
MANDT	CLNT	3	Client
AUFNR	CHAR	12	Order Number
AUART	CHAR	4	Order Type
AUTYP	NUMC	2	Order category
REFNR	CHAR	12	Reference order number
ERNAM	CHAR	12	Entered by 
-	NUMC	2	Status reached so far
-	CHAR	1	Phase "Order created"
-	CHAR	1	Phase "Order released"

The view appears like above.

1. what does that '*' and '-' means in the viewfields???

2. Now, when i am trying to see the entries in our client system it is giving Dump. but in other server it is not giving dump. What can be the reason???

Dump Description: SQL error in the database when accessing a table.

Missing Handling of System Exception
    Program                                 /1BCDWB/DBCAUFV

Trigger Location of Exception
    Program                                 /1BCDWB/DBCAUFV
    Include                                 /1BCDWB/DBCAUFV
    Row                                     548
    Module Name                             START-OF-SELECTION


524   concatenate '/1BCDWB/DB' 'CAUFV' into g_dbdatakey-eu_name.
525   g_dbdatakey-username = c_all.
526   import sort_NAME_TAB to %_TAB2_sort
527          field_name_tab to %_TAB2_field
528          from database dbdata(DB) id g_dbdatakey.
529   if sy-subrc = 0.
530     delete from dbdata
531           where relid    = 'DB' and
532                 eu_name  = g_dbdatakey-eu_name and
533                 username = c_all.
534     describe table %_tab2_field lines %_l_lines.
535     if not %_l_lines is initial.
536       %_TAB2[] = %_tab2_field[].
537     endif.
538   endif.
539 ENDIF.
540 CASE ACTION.
541   WHEN 'ANZE'.
542 try.
543 SELECT * FROM CAUFV                     "client specified
544                  APPENDING TABLE ICAUFV
545                  UP TO RSEUMOD-TBMAXSEL ROWS BYPASSING BUFFER
546    WHERE AUFNR IN I1.
547
>>>   CATCH CX_SY_DYNAMIC_OSQL_SEMANTICS INTO xref.
549     IF xref->kernel_errid = 'SAPSQL_ESCAPE_WITH_POOLTABLE'.
550       message i412(mo).
551       exit.
552     ELSE.
553       RAISE EXCEPTION xref.

Please help if any one has any pointer.

Thanks & Regards,

Abhishek Sarkar

Reply
1 REPLY 1
Read only

former_member219399
Active Participant

‎2007 Jun 26 5:09 AM

0 Likes
737

Hi

You can include a table in a view. In this case all the table fields become fields of the view. If fields are inserted in the included table or deleted from it, these fields are also inserted in or deleted from the view.

To include a table in the view, you must enter the character * for View field, the name of the table to be included for Table and again the character * for Field name.

You can also exclude certain fields from an included table. If you do not want to insert a field of the included table in the view, you must enter - for View field, the name of the included table for Table and the name of the table field for Field name.

with regards,

Vamsi